Cloud Connect — import JSON columns into map fields

Cloud Connect can now import a warehouse JSON or OBJECT column into a map-typed Lytics field. Key-value data in your BigQuery, Snowflake, or other supported warehouse now lands on the profile as a proper map you can use in audiences and activation — instead of a flat string blob of JSON.

How it works

• Create the destination field in your schema with the right map data type — map[string]string, map[string]int, map[string]number, map[string]bool, or map[string]time.
• In your Data Model's Field Mappings, map the JSON/OBJECT source column to that map field. Lytics parses the object and coerces each value to the field's value type.

Scope

• Available through Field Mappings only. Activated Fields auto-create their schema fields from the query columns and can't produce a map type, so the map field must already exist and be mapped explicitly.
• map[string]value and map[string]intsum are not supported as import destinations.

See Data Models & Queries for the full Data Model setup.