Query basics - Lambda

Qualify each view with reporting, as shown below.

List shipments

SELECT shipment_id, business_key, transport_mode,
       origin_code, destination_code, total_revenue
FROM reporting.shipments
ORDER BY business_key
LIMIT 25;

One row is one current shipment.

List one-off quotes

SELECT quote_id, business_key, is_approved,
       origin_code, destination_code, total_revenue
FROM reporting.one_off_quotes
ORDER BY business_key
LIMIT 25;

One row is one current one-off quote.

Find a scalar XML field

Use source_fields when a business view does not contain the field you need.

SELECT semantic_path, raw_value, owners
FROM reporting.source_fields
WHERE semantic_path ILIKE '%/RequestedField%'
LIMIT 25;

Use raw_value as source evidence. The typed columns, such as numeric_value and timestamp_value, are available when Analytics can infer the value type.

⌘I