Query Tilores using Snowflake external functions with flatten table function

PHOTO

Tue Feb 28 2023 13:33:58 GMT+0000 (Coordinated Universal Time)

Saved by @Tilores

SELECT "id" AS search_id, tilores.entity:id::STRING AS entity_id, record.value:data:id::STRING AS entity_record_id, record.value:data:first_name::STRING AS first_name, record.value:data:last_name::STRING AS last_name, record.value:data:name::STRING AS name
  FROM (SELECT "id" FROM orders LIMIT 1),
  LATERAL (SELECT tilores_entity_by_record_id("id") AS entity) AS tilores,
  LATERAL FLATTEN (INPUT => entity:records) AS record;

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

Tilores Snowflake Integration

@Tilores

Create Snowflake newsletter table Create Snowflake database and orders table Export Snowflake data to csv file Sample JSON for Tilores rule simulation 1 Sample JSON for Tilores rule simulation 2 Sample JSON for Tilores rules simulation 3 Ingest data from Snowflake to Tilores Query Tilores using Snowflake external functions Query Tilores using Snowflake external functions with flatten table function Advanced Snowflake query to Tilores to gather data insights Create test table in Snowflake for identity resolution test Setup automatic entity identification in Snowflake testing Snowflake identity resolution automation Adding a customer with spelling mistakes to Snowflake Showing identity resolution on fuzzy data in Snowflake

Browse more snippets >>