Quick guideExport data from Snowflake to Google Sheets with Amigo Data:
1. Install the Amigo Data add-on and launch it
2. Connect Snowflake to Google Sheets
3. Select the metrics to export
4. Export the data to Google Sheets
How to export data from Snowflake to Google Sheets – Video
Snowflake is a cloud-based data-warehousing service that offers cloud-based data storage and analytics services such as data integration, business intelligence, and advanced analytics amongst other things. It is fully cloud-based which makes it highly scalable and easily accessible allowing customers to integrate quickly, load, analyse, and securely share data.
However, the convenience of storing data entirely in the cloud comes with certain disadvantages. The custody of your data is wholly on the data-warehousing entity and you may not have much control over it and therefore less freedom with what you can do with it. And it doesn’t provide the flexibility of data analysis.
Why export data from Snowflake to Google Sheets?
Snowflake is great for data storage but that cannot be said of data analysis. If want to make something of the data, say, to gain insights into the data by visualisations of the data, Snowflake offers us few options. And the few options that are available are complex making them unsuitable for most.
We can circumvent these limitations by integrating Snowflake with Google Sheets. And then export data from Snowflake to Google Sheets. And not just that but automate exports from Snowflake to Google Sheets so that Snowflake and Google Sheets are synchronised.
Here are some other reasons to export data from Snowflake to Google Sheets:
- Ease of use: Google Sheets is easy to use and user-friendly that can be used by just about anybody to create data visualisations.
- Collaboration: Multiple users can access the same document simultaneously and edit and view the document enabling team members to collaborate.
- Flexibility: There are plenty of charts, graphs, and other visualisations options making it a great tool for data analysis.
- Integration: Google Sheets can easily be integrated with other platforms such as Salesforce, Stripe, Facebook Ads and Shopify for advanced analysis and reporting.
- And not to mention, it is: Free.
How to export data from Snowflake to Google Sheets
You may not be salivating with the above-mentioned reasons to pull Snowflake data to Google Sheets but are nonetheless wondering how to export data from Snowflake to Google Sheets, you have a bunch of options.
Some common ones include running SQL queries to retrieve Snowflake data, adding a script that pulls data from Snowflake to Google Sheets, or using Snowflake API to create scripts to export data from Snowflake to Google Sheets.
Or you could use Amigo Data, a Snowflake-Google Sheets integration tool that connects Snowflake to Google Sheets and automatically exports data from Snowflake to Google Sheets. It does all this without requiring you to write a single line of code or read pages of Snowflake API documentation. And it as flexible and versatile as any complex method or tool out there.
So, let us learn in this tutorial how to connect Snowflake to Google Sheets and export data from Snowflake to Google Sheets using Amigo Data.
Install the Amigo Data add-on
In order for us to proceed with the tutorial, we’ll need to install the Amigo Data Google Sheets add-on. You can either install it from the Google Workspace Marketplace. Click the link given below to install the extension in your Google Sheets.
You can also install it from Google Sheets itself. To install it from Google Sheets, open a spreadsheet. Then go to Extensions→Add-ons→Get add-ons. Search for Amigo Data and click Install.
Once the installation and set-up is complete, we can proceed with connecting Google Sheets to Snowflake and then export data from Snowflake to Google Sheets.
Connect Snowflake to Google Sheets
Open a new document on Google Sheets and click Extensions. Here you should see Amigo Data installed. Launch Amigo Data by clicking Connect.
A sidebar will appear on the right of the screen in a moment and you’ll be presented with different database sources to pull data from. Select Snowflake→Import from Tables. Fill in the Snowflake database details and click Connect to connect Snowflake to Google Sheets.
Well done! You have successfully connected Snowflake to Google Sheets. Let us now export data from Snowflake to Google Sheets.
Export data from Snowflake to Google Sheets
Follow the steps given below to export data from Snowflake to Google Sheets.
Step 1: Select the data table to export from Snowflake to Google Sheets
When you click Import from Tables, a new window will appear titled Create Report where you’ll see different Snowflake data tables from which you can retrieve data and export to Google Sheets. Select a Snowflake data table to export data to Google Sheets.
Tip: If you have accidentally selected a wrong data table, you can simply click on the title of the data table you’ve selected and it’ll take you back to the Create Report window.
Step 2: Choose the metrics export from Snowflake to Google Sheets
On selecting a data table, you’ll be presented with all the data points that are stored in the database. You can select (or unselect) the ones you want to export (or avoid). If you want all the data exported, check the Select All option.
Step 3: Filter and sort the data to export from Snowflake to Google Sheets (optional)
You can also filter and sort the Snowflake data to export to Google Sheets and specify the number of rows before you export them to Google Sheets.
Click the Filter option and specify the parameters. Likewise select ASC if you want to sort the data in ascending order and DESC for descending order, and select the data metric according to which the data is to be sorted. Apply as many filters and sorting options as you may wish.
Step 4: Specify the rows of data to export
Specify the number of rows of the data to be exported from Snowflake to Google Sheets from the limit option. This is an optional step.
Step 5: Export the data from Snowflake to Google Sheets
Once the above steps have been completed, click IMPORT. The Snowflake data will be exported to Google Sheets in a moment.
Automate data exports from Snowflake to Google Sheets
You can also set a refresh schedule so that the data are updated automatically and periodically–hourly, daily, weekly, or on certain days of the week.
Set the time and period to automate the data refresh and click Yes, set the refresh timing. Any changes in your Snowflake data will be automatically reflected in the Google Sheets document without any further input.
And if you want to be alerted with the updated data, Amigo will do that too. Add the medium you want to receive the alert–email and/Slack–by adding all the email addresses or Slack channels that you want to receive the alerts from the Alerts option.
You and your team members will be alerted whenever an update has been made. And you can immediately see any changes in the data via email or Slack.
Conclusion
Amigo Data lets you easily connect Snowflake to Google Sheets and seamlessly move data from Snowflake to Google Sheets within minutes without codes. It also updates the data automatically and periodically whenever any changes occur in the source data so that you always have accurate, up-to-date data ensuring that you are never behind your data–and lets you stay ahead.
FAQs
Can you connect Snowflake to Google Sheets?
Yes, you can create a Snowflake and Google Sheets integration and connect Snowflake to Google Sheets. The process generally involves some coding or writing custom scripts. With Amigo however you can connect Snowflake to Google Sheets with only a couple of clicks without a line of code.
To connect Snowflake to Google Sheets, follow these steps:
- Get the Amigo Data addon and launch it.
- Select Snowflake from the source to connect.
- Select the “Import from tables” option.
- Enter the Snowflake credentials.
- Click “Connect” to create a connection.
How do I pull data from Snowflake to Google Sheets?
To move data from Snowflake to Google Sheets seamlessly, you first need to connect Snowflake to Google Sheets. After creating a connection, Snowflake data can not only be easily retrieved but automated so that subsequent retrievals do not require any input.
How to automatically move data from Snowflake to Google Sheets?
To automate the data transfer from Snowflake to Google Sheets, set a refresh schedule to update the data at regular interval. Google Sheets will then be populated with fresh data from Snowflake.
Some recommended articles:
Connect Salesforce to Google Sheets and automate data exports