In this article:

How to Import Snowflake Data to Google Sheets

May 8, 2024

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.

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.

To optimize your workflow, we recommend checking out our template for an address book in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->