How to Import Snowflake Data to Google Sheets

Snowflake, one of the most popular cloud database platforms today, contains much of your important data. This tutorial will show you how to import that data into Google Sheets so that you can analyze it and find important trends and metrics.

Table of contents
  1. Snowflake account information
  2. Import Snowflake data using Google Sheets add-ons
  3. Import Snowflake data using Google Apps Script
  4. Import Snowflake data using our newest spreadsheet, Lido
5 Minutes

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.
Snowflake URL. The name of the account is included in the URL, but it is erased in this photo for security purposes.
  • 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.
Left sidebar. Data, Databases.

  • 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

Button appears on main toolbar.

A pop-up will appear asking the name of the sheet into which you want to post the data.

Prompt for sheet where the data will be posted.

Another pop-up will appear asking you to specify the table you want to import.

Prompt for the table to pull the data from.

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.

Lido app. 

Step 2: A sidebar will appear, listing the different sources you can use. Scroll down and click Snowflake.

Lido app. Data sidebar. Services listed. 

Step 3: Input your account information such as the account name, database name, and the username and password. 

Lido app. Data sidebar. Snowflake option selected. Textboxes for account information. 

You can check if the account information is correct by clicking Test connection first. 

Lido app. Data sidebar. Snowflake option selected. Test connection button and Connect button. 

A message saying You’re connected to Snowflake will appear when you successfully connect to the Snowflake database. You can then click Connect.

Prompt showing that Lido successfully connected to Snowflake. 

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.

Lido app. Dataset Editor. 

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. 

Lido app. Dataset Editor. Select data window.

The columns will be shown, and you can select which columns to import. Click Save once you are done.

Lido app. Dataset Editor. Select data window. Data loaded with columns selected.

Step 6: You will be brought back to the Dataset Editor, now including the data you want to load. Click Save dataset & add view.

Lido app. Dataset Editor. Selected data loaded.

You can now use normal spreadsheet commands on your data, but you can also build simple apps and dashboards to easily present your data :

Lido app. Data from Snowflake loaded.

Interested? Click here to get started.

Enter Your Email Below to Try Lido for FREE!

Experience all of the benefits of the classic spreadsheet with much more powerful features that save users time!
  • One Click Data Imports From Anywhere
  • Transform Spreadsheets into Software in Seconds
  • Pre-built & Custom Templates
  • Visualize Real-Time Data in Centralized Dashboards
100% FREE - No Credit Card Required
MORE RESOURCES
Blog
Tutorials
Templates
eCommerce Metrics
Marketing Metrics