city_name
column in the source data contains surrounding whitespace, you can normalize the column by
adding it as a hidden attribute and creating a calculated attribute to remove the whitespace:city_name
column as _city_name_raw
attribute, set as hidden.city_name
with the expression TRIM(entity._city_name_raw)
SELECT * FROM table
custom SQL source.LATERAL FLATTEN
join to flatten a JSON object.When using LATERAL FLATTEN
, each key in the JSON object becomes a separate row with a key and a value,
which can alter the granularity of the entity. If this behavior is desired, use the SEQ
column,
which provides a unique sequence number, as part of the entity key to maintain consistency and avoid issues with key duplication.name
: Name of source tabledisplay_name
, owner
, description
, labels
, folder
, hidden
: Metadatadataset_type
: Choose if a table, a SQL query or a virtual entitysql
: The name of table (when type is a table) / the base entity (virtual table) / SQL query (custom sql)attributes
: List of attributes to bring from the source, with optional renaming