I want to set up a connected spreadsheet to Snowflake ETL worfklow so I can extract data from Snowflake, transform it in the spreadsheet, and load it back into Snowflake.
How do I build a spreadsheet to Snowflake ETL pipeline? Do I need to be on an Enterprise account?
Row Zero makes this easy. Here’s how to build a spreadsheet to Snowflake ETL workflow in Row Zero using the built-in Snowflake connector:
Connect to Snowflake - in any Row Zero workbook, click the Data button in the top right, click add connection and enter your connection details.
You can connect via OAuth, key pair, or user name/password. Click ‘test connection’ to verify success. Once connected, you can import data from Snowflake or export data to Snowflake from the spreadsheet. Here’s documentation for connecting to Snowflake if you need help.
Query Snowflake from the spreadsheet - You can query Snowflake data with SQL directly from the spreadsheet by inserting a connected table.
Extract your Snowflake data - Write your query and click ‘Run’ to import the queried Snowflake data into your spreadsheet
Transform your Snowflake data - The Snowflake data imports directly into a connected table. From here, you can transform your data with functions, pivot tables, data cleaning tools like remove duplicates, etc. Here’s tips for working with connected spreadsheets in Row Zero.
Load your spreadsheet data to Snowflake - At any time you can export spreadsheet data to Snowflake by selecting the data, right clicking, and selecting “Export to”.
The example above walks through a simple Snowflake to spreadsheet to Snowflake ETL, but there are endless variations of spreadsheet ETL pipelines you can build in Row Zero. Here are some examples:
You can also leverage:
Here’s a video tutorial of building Snowflake connected spreadsheets in Row Zero:
