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.
Snowflake account information
In accessing the data in Snowflake databases, you need the following:
- Account - the account name. This can be accessed from the URL of your Snowflake database. You also input it first when logging in your Snowflake database for the first time in the computer you are using.
- Database name - the name of the specific database you want to access. In Snowflake, you can set up several databases to sort data coming from different sources. You can access the databases by clicking Data, then Databases on the list on the left sidebar.
- Username and password are what you use to log in to the Snowflake platform.
Import Snowflake data through Google Apps Script
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.
Import Snowflake data using our newest software, Lido
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 :