Omnata Product Documentation
  • Omnata Sync for Snowflake
    • What is Omnata Sync for Snowflake?
    • How it works
      • Terminology
      • Branching Mode
      • Sync Directions and Strategies
        • Outbound
        • Inbound
      • Rate Limiting
      • Access Control
      • Notifications
      • Security and Privacy
      • Internal tables
      • Internal Stored Procedures
      • FAQ
    • Step-by-step guides
      • 1. Install the Omnata Sync Engine
      • 2. Install the Omnata Plugin
      • 3. Configure the Plugin
      • 4. Create a connection
      • 5. Create a sync
    • Apps
      • Aerobotics
        • 📘Release History
      • Airtable
        • 📘Release History
      • Amazon Ads
        • Privacy Notice
      • ApprovalMax
        • 📘Release History
      • Bamboo HR
        • 📘Release History
      • Clockify
        • 📘Release History
      • Contentful
        • 📘Release History
      • GitHub
        • 📘Release History
      • Github
      • Google Ads
        • 📘Release History
      • Google Sheets
        • 📘Release History
      • HubSpot
        • 📘Release History
      • Hubspot
      • Infor Data Lake
        • 📘Release History
      • Jira
        • 📘Release History
      • LinkedIn Ads
        • 📘Release History
      • Mailgun
        • 📘Release History
      • Marketo
        • 📘Release History
      • Meta Marketing
        • 📘Release History
      • Microsoft Ads
        • 📘Release History
      • Microsoft Dynamics 365 Business Central
        • 📘Release History
        • 📘Release History
        • 📘Release History
        • 📘Release History
        • 📘Release History
      • Microsoft Entra ID
        • 📘Release History
        • 📘Release History
        • 📘Release History
        • 📘Release History
      • Microsoft Excel
      • Microsoft SQL Server
        • 📘Release History
      • Monday.com
        • 📘Release History
      • MRPeasy
        • 📘Release History
      • PayHero
        • 📘Release History
      • Pinterest Ads
        • Privacy Policy
      • PostgreSQL
        • 📘Release History
      • Salesforce
        • Salesforce Permissions needed
        • Formula Fields
        • How we use the Salesforce APIs
        • 📘Release History
      • Salesforce Marketing Cloud
        • OAuth for APIs, SFTP for file transfer with GPG on outbound
        • OAuth for APIs, SFTP for file transfer
        • OAuth for APIs, Cloud Storage for file transfer
        • 📘Release History
      • Shopify
        • Outbound sync data structures
        • 📘Release History
      • Slack
        • 📘Release History
      • Tiktok Ads
        • Privacy Policy
      • Typeform
        • 📘Release History
      • Wise
        • 📘Release History
      • Xero
        • 📘Release History
      • Zendesk Support
        • 📘Release History
        • 📘Release History
    • Plugins
      • Anatomy of a Plugin
      • Example Plugins
        • Example Plugin: Slack
        • Example Plugin: Zoho CRM
      • Creating Plugins
      • Advanced Plugin topics
        • Advanced rate limiting / concurrency
        • Custom Jinja filters
        • Custom Record Transformers
        • Dynamic Configuration Forms
        • Test case generation
    • Branching
      • Inbound Sync branching
      • Outbound Sync branching
    • Integrations
      • dbt
        • Validation Tests (coming soon)
    • 📘Release History
  • Omnata Connect for Salesforce
    • Overview
    • Getting Started
      • Install the Salesforce App
      • Connect to your data warehouse
        • Snowflake
        • BigQuery
        • Rockset
        • Firebolt
        • SingleStore (previously MemSQL)
      • Deciding which mode to use
    • Omnata with Salesforce Connect (External Objects)
      • Object Configuration
      • View your data in a list
      • Link to other objects
      • Use in a Report
      • Database schema changes
      • Writing to External Objects
    • Omnata with Salesforce Lightning Components
      • Object Configuration
      • View your data in a list
      • Link to other objects
      • Using the Lightning Component on a page
      • Assigning Permissions
    • Advanced Features
      • Row Level Filtering
      • Multi-Currency handling
        • About Multi-Currency
        • Support in Omnata Connect
        • Apex Features
    • Integrations
      • Datadog
    • Omnata with Salesforce Apex
    • Security
    • Use cases
      • Linked object drill-downs
      • Global Search
      • ERP and historical data
      • Embedded product metrics
    • Best Practices
      • Global Search
      • Change Management
      • Snowflake table design
      • Salesforce page layout
      • Salesforce Caching
Powered by GitBook
On this page
  • V1.20
  • V1.19
  • V1.18
  • V1.17
  • V1.16
  • V1.15
  • V1.14
  • V1.13
  • V1.12
  • V1.11
  • V1.10
  • V1.9
  • V1.8
  • V1.7
  • V1.6
  • V1.5
  • V1.4
  • V1.3
  • V1.2
  • V1.1
  • V1.0
  • PUBLIC_PREVIEW.7
  1. Omnata Sync for Snowflake
  2. Apps
  3. Google Sheets

Release History


V1.20

Created: 2025-02-21

  • Inbound sync configuration form now requires a spreadsheet selection before rendering the list of streams


V1.19

Created: 2025-02-19

  • Fixed an issue where API discovery broke after Anaconda starteed providing the google sheets package


V1.18

Created: 2025-02-18

  • If json-schema cannot be generated for a sheet, it is logged as an error and skipped


V1.17

Created: 2024-11-02

  • LIST_SPREADSHEETS function now exposes extra search parameters

  • In sync configuration, "Show spreadsheets shared with me" now defaults to false and "Search all shared drives" defaults to true


V1.16

Created: 2024-09-16

  • Fixed an issue where empty values in numeric columns would cause errors in the normalized view

  • Migrated consumer UDFs to new convention


V1.15

Created: 2024-08-31

  • Fixed an issue caused by the previous release, where consumer UDFs errored when invoked


V1.14

Created: 2024-08-30

  • Added new Google Drive search options to outbound sync form

  • The WRITE_SHEET consumer UDF now accepts a plugin_connection object result instead of a connection slug, as a workaround for a Snowflake UDTF nesting bug


V1.13

Created: 2024-07-31

  • The inbound configuration form now provides checkboxes to better control the Google Drive search options

  • Improved handling of dates and timestamps in the normalized views


V1.12

Created: 2024-07-23

  • When listing Spreadsheets, items from all Drive types will now be shown. For Service Accounts, this will also include the sharedWithMe flag


V1.11

Created: 2024-07-19

  • Pinned some Anaconda dependencies to reduce package size


V1.10

Created: 2024-07-19

  • Fixed an issue where not all visible spreadsheet files were shown in the dropdown list

  • Fixed an issue where empty rows in the sample of 200 would cause an error in the stream lister


V1.9

Created: 2024-07-10

  • Inbound syncs now operate with a concurrency of 1, to avoid being blocked by the Google Sheets API.

  • Sheets containing invalid metadata are now excluded from the streams list instead of causing an error. A warning will be logged in the event table.


V1.8

Created: 2024-07-09

  • Improved handling of invalid sheet metadata responses


V1.7

Created: 2024-07-02

  • Provided an alternate parameter set for consumer UDFs


V1.6

Created: 2024-06-27

  • Removed ROW_NUMBER parameter from the WRITE_SHEET consumer UDTF as there was limited practical use for it


V1.5

Created: 2024-06-21

  • Provided four initial consumer UDFS: LIST_SPREADSHEETS, LIST_SPREADSHEET_SHEETS, READ_SHEET and WRITE_SHEET


V1.4

Created: 2024-05-30

  • Fixed an issue where columns with semi-structured data types caused outbound syncs to fail


V1.3

Created: 2024-05-23

  • Inbound syncs now support composite primary keys


V1.2

Created: 2024-05-18

  • Fixed issue where Service Account connections would error when syncing


V1.1

Created: 2024-04-04

  • Pinned all dependencies


V1.0

Created: 2024-04-03

  • Add Service Account as a connection method


PUBLIC_PREVIEW.7

Created: 2024-04-02

  • Use latest plugin runtime

  • Built with omnata-plugin-devkit==0.3.17 which includes pinned stored proc dependencies


PreviousGoogle SheetsNextHubSpot

Last updated 2 months ago

📘