Connect Google Sheets to Snowflake

Connect Google Sheets to Snowflake

About Snowflake

Snowflake is a cloud-based data warehouse system founded in 2012. It is a columnar-stored relational database and works well with Tableau, Excel and many other tools familiar to end-users. Snowflake automatically handles infrastructure, optimization, availability, data protection, and more, so you can focus on using your data, not managing it.

Integrate Snowflake

The easiest and fastest way to connect your Snowflake data warehouse to Google Sheets. With Castodia, you can test the limits by analyzing stored data from relational databases, running and scheduling queries, and auto-refreshing data from a yearly basis down to a 1-minute frequency. LEARN MORE

[Update: December 2020] Users will no longer need to individually share each sheet with the Castodia service account as described in the video. Users will instead be required to authenticate with their Google Account only once and this will automatically enable auto-refresh for any sheet.

How to Connect Snowflake Data Warehouse to Google Sheets

Castodia lets you pull data from your Snowflake data warehouse directly into Google Sheets.

To connect your Snowflake data warehouse, follow the steps below:

Step 1: Install the Castodia GSuite Marketplace Database Connector

Step 2: Create a Google Sheet and click "Add-Ons" within the toolbar section to access the Castodia Database Connector

Step 3: Two options will appear when you hover over the add-on: launch and settings. Click "Settings."

Step 4: Type in a name to help identify your data warehouse

Step 5: Click the drop-down menu to access the Snowflake data warehouse

Step 6: Gather and enter your data warehouse connection information. There are a few components needed, some mandatory and some optional depending on your Snowflake setup.

  • Account Name
  • Username
  • Password
  • Database (optional)
  • Schema (optional)
  • Warehouse (optional)
  • Role (optional)

Step 7: Click the "Test" button to run the data warehouse and verify your credentials

Step 8: Click the "Save" button once a green notification pops up, indicating that the add-on was successfully installed.

And that's it! Enjoy running your queries.

Use Case

Scenario

Suppose the manager of business intelligence is looking to prepare a report evaluating the recent installation of a new accounting system. The system launched two weeks ago and the company has been managing all the data for transactional sources. The IT team wants to know if the implementation has been effective during the upcoming bi-weekly meeting.

The manager of business intelligence wants to answer three questions:

  1. What was the actual spend to what the IT team budgeted at the beginning of the project?
  2. What is the profit and revenue of the software implementation to date?
  3. What is the spread of stakeholder satisfaction conducted through surveys?

Solution

Rather than manually exporting CSV files to derive insightful analytics, the manager of business intelligence can use Castodia's Database Connector to connect their Snowflake data warehouse to Google Sheets, run and save important queries, and auto-refresh their data every two weeks based on their custom schedule.

To get started, install the Castodia GSuite Add-On and access a new Google sheet. Once you have connected your Snowflake data warehouse, you can begin to run SQL queries.

Castodia also gives users the freedom to create custom schedules for databases. The manager of business intelligence can also set a schedule to auto-refresh data on a bi-weekly basis for future meetings.


Accounting system Snowflake

Now let's answer the three questions:

1. What was the actual spend to what the IT team budgeted at the beginning of the project?

Using data from the Snowflake data warehouse, the manager of business intelligence can create a graph to visualize the difference in budget vs. actual spend on the software implementation. With the pink line indicating the budgeted spend, and the green line indicated the actual spend, it is clear that the actual spend was 2% higher. However, this value is relatively low, suggesting a successful implementation.


Budgeted vs actual spend - Snowflake Google Sheets

2. What is the profit and revenue of the software implementation to date?

There is high promise for the success of the software implementation. Within two weeks, there has been an increase of profits, which is extremely early within the stage of inception. This is great news that the manager of business intelligence can report to the IT team at the meeting.


Revenue and profit - Castodia Google Sheets connector for Snowflake


3. What is the spread of stakeholder satisfaction conducted through surveys?

Through compiling the survey results, the manager of business intelligence can report to the IT team the successful findings. Overall, the software implementation was executed with little to no flaws, resulting in a high success rate and negative skew.


Customer Rating Scale



Connectors

All Castodia Database Connector Features

1 minute auto-refresh

1 Minute Auto-Refresh

Set refresh frequency to every day, every few hours, or every few minutes. Down to once every 1 minute

Advanced scheduling

Advanced Scheduling

Auto refresh data daily, weekly, monthly or yearly with fully customizable schedules

Intuitive UI Castodia

Intuitive UI

Run, save and schedule queries all from within Google Sheets using a clean and intuitive interface

Long query run time

Long Query Time

Run long/complex queries that take minutes to run. Fearlessly run large queries without unexpected errors

Append vs overwrite

Append and Overwrite

Choose how to auto-refresh data on your spreadsheet. Smart Overwrite prevents calculations intact

Direct SQL query

Direct SQL Query

Paste any SQL query and run them directly from Google Sheets. If it runs on your editor it will also run here

Start free trial

Try Castodia free for 14 days, no credit card required.