Snowflake Connector for Google Analytics Raw Data release notes¶

Behavior changes¶

Not applicable.

New features¶

• Migrated to telemetry v2.

Bug fixes¶

• Data stream ingestions, which failed due to the Out of Memory errors, are now retried sooner.

Behavior changes¶

Not applicable.

New features¶

• Improved ingestion scalability.

Bug fixes¶

Not applicable.

Behavior changes¶

Not applicable.

New features¶

• Added support for combinations of DAILY, INTRADAY, USERS, and PSEUDONYMOUS_USERS export types.

• Added support for multi-cluster warehouses.

• Performance and stability improvements.

Bug fixes¶

Not applicable.

Behavior changes¶

Not applicable.

New features¶

• Historical data ingestion for new properties ingests in reverse chronological order, starting from the date on which the Google Analytics property was enabled, while the current data is ingested in parallel.

Bug fixes¶

Not applicable.

Behavior changes¶

Not applicable.

New features¶

Not applicable.

Bug fixes¶

Not applicable.

Behavior changes¶

Not applicable.

New features¶

Reloads of user data tables are now scheduled automatically after 72 hours.

Bug fixes¶

• To prevent failures for a large number of properties, we’ve increased the timeout period on the view refresher task from 1 hour to 23 hours.

• Fixed issues related to identifier migration.

• Fixed the state of properties that got suspended due to an issue related to a race condition between refreshing the sink table views and disabling inaccessible Google Analytics properties.

Behavior changes¶

Not applicable.

New features¶

Not applicable.

Bug fixes¶

• Updated to Snowpark version 1.13.2 to address ERROR_ON_NONDETERMINISTIC_UPDATE error.

Behavior changes¶

Not applicable.

New features¶

• Connectors now support the ingestion of the USERS and PSEUDONYMOUS_USERS export types.

Bug fixes¶

• Fixed a race condition between the property cleaner and the view refresher.

Behavior changes¶

Not applicable.

New features¶

• Added the RESET_CONFIGURATION procedure.

Bug fixes¶

• Corrected missing parameters on dispatcher subprocess tasks.

Behavior changes¶

Not applicable.

New features¶

• Added support for identifiers in a worksheet format.

Bug fixes¶

Not applicable.

Behavior changes¶

Not applicable.

New features¶

Not applicable.

Bug fixes¶

• Fix for issue causing PAUSE and RESUME procedures to fail.

Behavior changes¶

Not applicable.

New features¶

Not applicable.

Bug fixes¶

Not applicable.

Behavior changes¶

Not applicable.

New features¶

• Added flattened event_params and user_properties columns in the sink table views.

• Enabled change tracking on sink tables.

• Sink table views are now refreshed with the copy grants statement.

Bug fixes¶

• Application upgrade fix for certain customers.

Behavior changes¶

Not applicable.

New features¶

Not applicable.

Bug fixes¶

• Application upgrade fix for certain customers

Behavior changes¶

Not applicable.

New features¶

• Sink table views are now refreshed automatically.

• Data is now synced sooner for timezones ahead of UTC.

• Improved scalability of scheduling ingestions for large number of properties.

Bug fixes¶

Not applicable.

Behavior changes¶

Not applicable.

New features¶

• New REFRESH_VIEWS procedure, which allows recreating flattened data view.

Bug fixes¶

Not applicable.

Behavior changes¶

Not applicable.

New features¶

• Reloads are now scheduled automatically for all properties.

• Added UPDATE_INGESTION_OPTIONS procedure which allows customizing the ingestion settings for certain properties supporting two parameters:

  • EXCLUDE_NULLS - do not ingest fields containing nulls values, which can increase performance.

  • DISABLE_AUTO_RELOADS - disable the auto reload mechanism for certain properties.

Bug fixes¶

Not applicable.

Behavior changes¶

Not applicable.

New features¶

• This release introduces the “reload property” feature. There are three new procedures for triggering reload:

  • RELOAD_PROPERTY('<property id>')

  • RELOAD_PROPERTY('<property id>', <first date>, <last date>)

  • RELOAD_PROPERTY('<property id>', '<export type>', <first date>, <last date>)

• There is one new procedure for canceling ongoing reload:

  • CANCEL_RELOAD_PROPERTY('<load id>')

• And a new view for observing ongoing reload:

  • PUBLIC.ONGOING_RELOADS

Bug fixes¶

Not applicable.

Behavior changes¶

• Ingestion tasks are scaled based on warehouse size. Ingestion time for larger warehouses should be decreased.

• Additional optimizations in ingestion and ingestion scheduling. These updates could result in slightly lower credit consumption, as well as increased ingestion throughput.

New features¶

Not applicable.

Bug fixes¶

Not applicable.

Behavior changes¶

• Disabling property which is ingesting incremental intraday data will remove currently ingested day if ingestion was not fully completed.

• Introduced managed task to check and report its health back to Snowflake for Connectors installed before version 1.0.0. See the Snowflake Connector for Google Analytics Raw Data health check cost for details.

New features¶

Not applicable.

Bug fixes¶

• Fixed issue with Pausing/Resuming Connector which left Connector state in intermediate state PAUSING/ STARTING.

Behavior changes¶

Not applicable.

New features¶

Not applicable.

Bug fixes¶

• Dispatcher task was adjusted to never automatically suspend. See SUSPEND TASK AFTER FAILURES for details.

• Ingestion worker tasks have prolonged timeout to 6h hours. This will override account level parameter settings.

Behavior changes¶

• Logging level is now set to INFO which should significantly decrease the amount of entries into the event table.

• The connector now runs a small, managed task to check and report its health back to Snowflake. See the Snowflake Connector for Google Analytics Raw Data health check cost for details.

New features¶

• New procedure PUBLIC.UPDATE_CONNECTION allows re-authenticating a running connector by providing a new set of external access and secret objects. See re-authentication of the connector for details.

• Re-installing the connector, and configuring it over an existing set of destination tables, will now automatically re-enable their related Google Analytics properties for ingestion. This should make reinstalling the connector much faster.

Bug fixes¶

• Tasks created by the connector now have a fixed set of properties, mostly related to AUTOCOMMIT and date-time formats, required for these tasks to work correctly. These will override account-level properties.

  Operating on the connector by explicitly calling its functions or procedures still requires certain default values, as described in Snowflake Connector for Google Analytics Raw Data known limitations.

Behavior changes¶

Not applicable.

New features¶

Not applicable.

Bug fixes¶

• Fixed an issue with refreshing OAuth access tokens that was causing long-running ingestions to fail.

Behavior changes¶

Not applicable.

New features¶

• A new procedure PUBLIC.UPDATE_WAREHOUSE is now available to replace the warehouse used by the connector.

• Scheduling ingestions should now be much faster, especially for instances configured with large numbers of Google Analytics properties.

Bug fixes¶

Not applicable.

Behavior changes¶

Not applicable.

New features¶

• The procedure UPDATE_CONNECTION_CONFIGURATION was introduced. It can be used for re-authentication purposes. Connector has to be paused to use this procedure. Currently it is only available from the worksheet and takes one argument type of VARIANT composed of fields: external_access_integration, security_integration and secret.

Bug fixes¶

Not applicable.

Behavior changes¶

Not applicable.

New features¶

Not applicable.

Bug fixes¶

• Fixed an issue with disrupted scheduling of ingestions during execution of dispatcher task.

Behavior changes¶

Not applicable.

New features¶

Not applicable.

Bug fixes¶

• Fixed an issue where changing the ingestion schedule while the dispatcher task was running could lead to temporary duplication of the dispatcher task.

Behavior changes¶

• The connector now requests permission to EXECUTE MANAGED TASK. This is in preparation for internal monitoring features that will help us discover and address issues earlier.

New features¶

Not applicable.

Bug fixes¶

• Fixed an issue where changing the ingestion schedule while the dispatcher task was running could corrupt the internal state of the connector so that it would not be able to schedule further ingestions.

Behavior changes¶

Not applicable.

New features¶

• A number of optimizations made to scheduling ingestions and ingesting itself. This should result in slightly lower credit consumption, as well as increased ingestion throughput, especially on tables with fewer than one million records.

• The connector now supports mixed-case and lowercase secret names.

Bug fixes¶

• Ingestions should no longer fail due to issues with refreshing the access token. This may very rarely still occur for particularly large tables, but will always be re-tried by the connector automatically.

• Added validation to prevent enabling the same Google Analytics property ingestion from multiple Google Cloud Platform projects.

• Enabling multiple properties at once is now more resilient against issues with BigQuery connectivity. It will only fail the properties for which it couldn’t connect to BigQuery, and successfully enable all the others.

Behavior changes¶

• Several stored procedures, meant specifically for early user interface, access were removed. These stored procedures were generally not documented, and not part of our public API, but they may have been visible when listing procedures exposed by the connector. There’s no change in how the connector works, or how it should be operated.

• The procedure CONFIGURE_CONNECTION now requires an additional parameter security_integration with the name of the security integration created for the connector. This applies only for worksheet-based setups. If you’re setting the connector up via the user interface, this change is transparent to you.

New features¶

• Updated links to the connector’s documentation.

Bug fixes¶

• Improved reading tables available in BigQuery to ensure we only look at Google Analytics export tables, and filter out similarly-named tables. This issue could sometimes cause enabling new properties, or ingesting enabled properties to fail.

Behavior changes¶

Not applicable.

New features¶

Not applicable.

Bug fixes¶

Not Applicable