No-Code Snowflake Update: A Step-by-Step Guide

Last Modified: January 30, 2024 - 5 min read

Julian Alvarado

Updating Snowflake can be a challenge. The available options often involve navigating complicated GitHub repositories or relying on unreliable workarounds.

But there’s a better way.

This guide introduces a straightforward, no-code method to import data into Snowflake, and set it on a refresh schedule if you’d like. Discover a hassle-free way to keep your data in sync directly from your Connected Spreadsheet.

Let’s dive in!

How to Update Snowflake Without Code? Use Coefficient.  

Coefficient is a no-code add-on that seamlessly integrates live data from various business solutions and databases directly into Connected Spreadsheets: Excel or Google Sheets.

As a Snowflake Technology Partner, Coefficient makes it safe and easy to connect to Snowflake to import your desired data. This frees you and your team from countless hours of moving your Snowflake data to your spreadsheets manually without sacrificing peace of mind.

Any update on your connected Snowflake data automatically syncs with your Google Spreadsheets in real time, so you always work with the latest information.

Plus, Coefficient allows you to upload data to Snowflake from any of the other systems we connect with like Tableau or Salesforce.

Let’s walk through the complete process of loading data to Snowflake with Coefficient to see how easy it is.

Push Data to Snowflake: A Step-by-Step Guide

Step 1: Install Coefficient

Note: In this tutorial, we will use Google Sheets.

Start by opening up a new spreadsheet.

Navigate to the top menu and click Extensions> Add-ons > Get add-ons.

Navigating to Get Add-ons in Google Sheets for Coefficient installation

This will direct you to the Google Workspace Marketplace.

Type in “Coefficient” in the search bar and select the Coefficient app.

Searching for Coefficient in the Google Workspace Marketplace

Accept the prompts to install.

accepting the prompts to grant coefficient access to google account

 Once installation is finished, return to Extensions on the Google Sheets menu.

You’ll see that Coefficient is now available as an add-on.

Launch Coefficien to continue.

Launching Coefficient with Import from option highlighted

Step 2: Import Snowflake Data

Launch Coefficient and click ‘Import from…’

clicking import from... in the coefficient menu

Select Snowflake as your data source.

selecting snowflake as the data source

If this is your first time connecting to Snowflake, you will have to authorize Coefficient to access your Snowflake database.

Follow the prompts to continue.

following the prompts to authorize coefficient to access snowflake

Once connected, select the Snowflake data you want to import.

Selecting 'From Tables & Columns' in Coefficient

Coefficient allows you select and import your Snowflake Tables in a visual editor. You can also write a custom SQL Query.

Pro-tip: Use Coefficient’s GPT SQL Builder to help you create a custom query with a simple prompt.

For the purpose of this example, we’ll select ‘From Tables & Columns.’

This will open Coefficient’s Import Preview window.

navigating coefficient's import preview window

Select the table you want to import from the left-hand column of the Import Preview menu.

customizing your import by selecting and unselecting columns from the menu.

From here, you can customize your import by selecting and unselecting columns from the menu.

Click ‘Import’ when you’re finished.

waiting for your Snowflake data will automatically populate your Google spreadsheet

Within a few seconds, your Snowflake data will automatically populate your Google spreadsheet without a single line of code!

Snowflake data will automatically populating your Google spreadshee

The true power of Snowflake lies in being the single source of truth for live data.

Coefficient’s Auto-Refresh feature allows anyone to access this real-time data in their Connected Spreadsheets.

Choose your update frequency – hourly, daily, or weekly. Coefficient takes care of the rest.

choosing auto-refresh schedule

Step 3: Upload data to Snowflake

Now, let’s focus on how you can edit your data extract and import it back to Snowflake.

After importing data into Google Sheets with Coefficient, you have the flexibility to edit it as needed. This could involve adjusting sales figures, updating customer information, or refining data sets for analysis.

Coefficient Excel Google Sheets Connectors
Try the Free Spreadsheet Extension Over 314,000 Pros Are Raving About

Stop exporting data manually. Sync data from your business systems into Google Sheets or Excel with Coefficient and set it on a refresh schedule.

Get Started

Once your edits are complete, navigate to the top of your import and click ‘Open Sidebar.’

Opening the sidebar in Coefficient after completing edits.

To upload data to Snowflake, scroll down the Coefficient sidebar until you see the the ‘Export to Snowflake’ option.

Export to Snowflake option in Coefficient sidebar

Click ‘Configure…’ 

Configuring export settings in Coefficient for Snowflake update

Note: You can also do this by returning to the Coefficient menu > Export to… > Snowflake. This approach is particularly beneficial when you need to upload CSVs to Snowflake that are not part of Coefficient imports

Next, identify the data you wish to export.

Select the specific tab and the header row for your Snowflake export using the drop-down menus.

Selecting specific tab and header row for Snowflake export in Coefficient

Click ‘Next’ to continue to select your destination.

Open the drop-down under ‘Table’ and select the appropriate Snowflake table.

Choosing the appropriate Snowflake table in Coefficient

Next, open the Action drop-down menu . You’ll notice three options:

  • Update: Updates data for existing records
  • Insert: Creates a NEW ID and inserts data
  • Delete: Deletes data for existing records  

Select ‘Update’ and click ‘Next’ to continue.

Selecting 'Update' option for Snowflake data in Coefficient

The final step to loading data to Snowflake is to verify that the columns in your spreadsheet are mapped correctly to their respective fields in Snowflake.

Verifying column mappings to Snowflake fields in Coefficient

If adjustments are needed, simply click the pencil icon to edit or the ‘x’ icon to delete a mapping.

editing a mapping from the coefficient menu

In this example, there is no need to update fields. Simply click ‘Save’ at the bottom of the menu to proceed.

saving field mappings from coefficient

Verify your selections in the next menu. If everything is correct, click ‘Export…’

Verifying column mappings to Snowflake fields in Coefficient

Coefficient will ask you to choose which rows to update.

Selecting all rows for Snowflake update in Coefficient

Select ‘All rows on sheet’ and click ‘Next…’  

When prompted, press the button to confirm one final time.

Final confirmation button in Coefficient for Snowflake data push

Wait a few moments while Coefficient pushes data to Snowflake.  

 Coefficient pushing data to Snowflake database

Afterward, return to your spreadsheet to confirm the update in Columns H-J in your spreadsheet.

Confirming data update in Columns H-J in Google Sheets

Congratulations! You’ve successfully updated Snowflake without a single line of code.

Writeback Data to Snowflake with Coefficient

Why manually update Snowflake if you don’t have to?

Coefficient’s Snowflake integration allows you to seamlessly import, update, and push back data to Snowflake without ever leaving your spreadsheet.

Get started for free today to try Coefficient for yourself!

Set Spreadsheet Data on Refresh

Try the Spreadsheet Automation Tool Over 300,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 300,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Julian Alvarado Content Marketing
Julian is a dynamic B2B marketer with 8+ years of experience creating full-funnel marketing journeys, leveraging an analytical background in biological sciences to examine customer needs.
Google icon
300,000+ users on Google Marketplace
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies