Export Snowflake data to csv file

PHOTO

Tue Feb 28 2023 13:25:59 GMT+0000 (Coordinated Universal Time)

Saved by @Tilores

(SELECT "id", "first_name", "last_name", NULL AS "name", "email", "payment_default" FROM orders LIMIT 1)
UNION
(SELECT "id", NULL AS "first_name", NULL AS "last_name", "name", "email", NULL AS "payment_default" FROM newsletter_subscriptions LIMIT 1);

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 >>