Table of Contents
Connect Row Zero to Snowflake
Row Zero supports connecting to Snowflake using username and password or Snowflake OAuth. Visit our documentation to read about Snowflake OAuth. To connect with username and pass word, continue reading. In Row Zero click on the 'connections' icon in the upper right-hand corner and then click the button to '+ Add connection.'
The connection requires 5 pieces of information defined below.
- Name - This field can be anything that helps identify the data source being connected. (e.g. "Production Data" or "Product Metrics")
- Account name - This is the Snowflake account name. It can be found and copied from Snowflake as identified in the image below. When it is copied and pasted from Snowflake into Row Zero, it will paste with a decimal between the two alphanumeric identifiers. The decimal must be replaced by a hyphen ( - ). For example, "HW97234.DV88430" should be modified to "HW97234-DV88430" when pasted into Row Zero. See the image below. See the image below.
- Username - The username used to log into your Snowflake account.
- Password - The password used to log into your Snowflake account.
Once all the information is entered, hit 'Test connection' to ensure the information is correct. If the test returns green, you will be asked to select the 'Warehouse' and 'Role' before you can '+ Add Source.'
Write a query to import data
Now that Snowflake is connected to your spreadsheet in Row Zero, write a SQL query to pull data into the spreadsheet. First select the 'Database' and 'Schema' from the two drop downs. Write a query in the query editor. The easiest query to write is the 'select *' statement, which pulls in the entire table. Example:
select * from TABLENAME
Row Zero spreadsheets are equipped to handle large data sets and will easily ingest the entirety of a table. Write more complicated queries to pull in various subsets of data stored in Snowflake. All results will be displayed in the 'connected data table' in the spreadsheet.
Save Your Spreadsheet to Snowflake
With a connected Snowflake account, you can export data sets from Row Zero to your cloud data warehouse. Once you've defined the data you would like to save to Snowflake, right click on the data table or selected range and navigate to 'Export > Snowflake Data' in the context menu.
The export to Snowflake modal will pop and ask you to select the database, schema, and specify a table name. New table names are forced to start with 'rz_' to avoid overwriting any tables already in the Snowflake cloud data warehouse. Hit export and Row Zero will create a new table in Snowflake and import all the data. When the export is complete, you will see a notification in the upper right-hand corner.
To verify your table is in Snowflake, you can use either of the commands below.
show tables
select * from rz_TABLENAME
You're connected to the world's fastest spreadsheet!
Now that Row Zero is connected to Snowflake, you can easily export Snowflake data to a spreadsheet in Row Zero. Row Zero is powerful enough to pull in entire Snowflake tables, so you can create live pivot tables, build models, and run your favorite spreadsheet fuctions on top of your Snowflake data without writing complex SQL queries. Easily adjust your query or refresh to get the latest data from Snowflake without overwriting your work. You can also automate a scheduled data refresh.