One of the popular cloud database platforms today is Snowflake. Snowflake boasts thousands of customers, including multinational companies such as Allianz, KraftHeinz, and Western Union. In this tutorial, we will learn methods to import data stored in Snowflake to Google Sheets.
In accessing the data in Snowflake databases, you need the following:
You can import Snowflake data through a Google Apps script. One custom script is shared by CData. Follow the instructions on the page in order to set up the script.
After adding the script, an additional item named Snowflake Data will appear in the main toolbar. Click it. A short drop-down list will appear. Click the only item labeled Write table data to a sheet.
A pop-up will appear asking the name of the sheet into which you want to post the data.
Another pop-up will appear asking you to specify the table you want to import.
It takes some time to make the script work, but it is a good option if you don’t want to use a third-party add-on to import your Snowflake data.
Of course, this is the right time to give you a glimpse of how Lido works. One of the main selling points of Lido is that it has a built-in tool to import data from a wide variety of sources, including Snowflake. You no longer have to worry about setting up an add-on or tweaking codes available online to access your data!
If you are a bit skeptical, here are the steps in importing Snowflake data to Lido so you can compare it with the first two methods we highlighted.
Step 1: Click Data on the upper-left corner of Lido.
Step 2: A sidebar will appear, listing the different sources you can use. Scroll down and click Snowflake.
Step 3: Input your account information such as the account name, database name, and the username and password.
You can check if the account information is correct by clicking Test connection first.
A message saying You’re connected to Snowflake will appear when you successfully connect to the Snowflake database. You can then click Connect.
Step 4: The Dataset Editor pops up. A list of databases are included on the upper-left corner of the editor. Select the database from the list, then click Open Data Explorer.
Step 5: Another window will pop up, labeled as Select data. A list of tables associated with the selected database appears on the left side. Look for the table you want to import.
The columns will be shown, and you can select which columns to import. Click Save once you are done.
Step 6: You will be brought back to the Dataset Editor, now including the data you want to load. Click Save dataset & add view.
You can now use normal spreadsheet commands on your data, but you can also build simple apps and dashboards to easily present your data :
We hope this article has helped you and given you a better understanding of how to import Snowflake data to Google Sheets. You might also like our articles on how to export Airtable to Google Sheets and how to import SQL to Google Sheets.