Google Sheets

Google Sheets is a spreadsheet program included as part of the free, web-based Google Docs Editors suite offered by Google.

Authentication methods

OAuth (User Created)

This method uses your own Google Project to authorize access, and is the most secure method since your own OAuth credentials are used.
To generate credentials:
  1. 2.
    Click "Create Credentials" and choose "OAuth Client ID" as the type
  2. 3.
    Choose "Web Application" as the application type
  3. 4.
    Add a redirect URI of the form https://apps-api.c1.<region>.<cloud-vendor>
If you're unsure what value to for the redirect URI, the following Snowflake query will construct it for your account: select 'https://'||t.value:host::varchar||'/oauth/complete-secret' as URI from table(flatten(input => parse_json(system$allowlist()))) as t where t.value:host::varchar LIKE 'apps-api%';
  1. 5.
    Click Create, and use the generated Client ID and Secret during Omnata connection creation.
  1. 6.
    In the Omnata App, Create a Connection and follow the instructions to create and authorise the integration.

Inbound Syncs

For each inbound sync, a single spreadsheet is selected and multiple sheets can be included in the sync.

Supported Sync Strategies

  • Full Refresh

Outbound Syncs

Supported Targets

With the Google Sheets app, you copy the contents of a Snowflake table/view into a Google Sheet.

Supported Sync Strategies

  • Replace (a full replacement of sheet contents)