Snowflake Connector for Google Analytics Aggregate Data release notes¶

Bug fixes¶

• The IMPORT_STATE procedure now grants SELECT privilege to the application roles ADMIN and DATA_READER.

Bug fixes¶

• Export process faile. Scoped temporary tables could not be created in the destination schema.

Behavior changes¶

• The connector creates additional tables in destination schema. The tables are used to store the configuration of the connector. The tables have _SFSDKEXPORT_V1 suffix.

New features¶

• IMPORT_STATE procedure was added. The procedure can be used to recover a configuration of the reports, schedules, and history of the ingestions after the connector was uninstalled.

Bug fixes¶

Not applicable

Behavior changes¶

• The connector requires all configured identifiers to be quoted based on the identifier requirements.

New features¶

• Report tables have change_tracking enabled.

• You can now reset the connector’s configuration before the configuration is finalized using the RESET_CONFIGURATION procedure.

• You can now recover a connector in the ERROR, PAUSING, or STARTING state using the RECOVER_CONNECTOR_STATE procedure.

Bug fixes¶

Not applicable

Behavior changes¶

N/A

New features¶

• Reports can now be configured to avoid sampling by shortening ingestion interval length.

Bug fixes¶

• Corrected handling of quoted identifiers in the GET_TROUBLESHOOTING_DATA procedure. See also Troubleshooting.

Behavior changes¶

• Sampling metadata is available in the CONNECTOR_STATS view.

• The connector saves INGESTION_RUN_ID in tables with report data.

New features¶

N/A

Bug fixes¶

• To avoid ingestion timeouts, existing task timeouts have been increased to 4 hours.

• Worker tasks can be rescheduled to avoid timeouts during ingestion.

Behavior changes¶

N/A

New features¶

N/A

Bug fixes¶

• Timeout for new tasks has been increased to 4 hours to prevent timeouts during ingestion.

Behavior changes¶

The minimal interval used during ingestion runs has been reduced to one day.

New features¶

• Added the UPDATE_WAREHOUSE procedure.

Bug fixes¶

The CONFIGURE_REPORT procedure can now be called in parallel.

Behavior changes¶

Not applicable.

New features¶

• Added the healthcheck task to all connector instances.

Bug fixes¶

Not applicable.

Behavior changes¶

Not applicable.

New features¶

• Added the UPDATE_CONNECTION_CONFIGURATION procedure.

Bug fixes¶

Not applicable.

Behavior changes¶

Not applicable.

New features¶

Not applicable.

Bug fixes¶

• Fixed issue where the connector could enter an inconsistent state during pausing or resuming.

Behavior changes¶

• The CONFIGURE_REPORT procedure returns validation errors instead of throwing them.

• The connector will wait for 30 seconds before retrying ingestion after a 502 error.

• Worker tasks will not be suspended due to errors.

New features¶

Not applicable.

Bug fixes¶

Not applicable.

Behavior changes¶

• The connector tries to avoid 502 errors by reducing the date range for large reports.

New features¶

Not applicable.

Bug fixes¶

Not applicable.

Behavior changes¶

• The CONNECTOR_EXECUTION_LOG table is no longer visible to users.

New features¶

Not applicable.

Bug fixes¶

Not applicable.

Behavior changes¶

Not applicable.

New features¶

Not applicable.

Bug fixes¶

• Fixed start date calculation (in some cases, the start date could be set after the end date due to timezone differences).

Behavior changes¶

• Date ranges for initial and incremental loads are split into 31-day intervals to reduce the number of 502 API errors.

New features¶

Not applicable.

Bug fixes¶

• Added metadata column to the PUBLIC.CONNECTOR_STATS view and to the result of GET_TROUBLESHOOTING_DATA procedure.

Behavior changes¶

Not applicable.

New features¶

• Added the GET_TROUBLESHOOTING_DATA procedure

Bug fixes¶

Not applicable.

Behavior changes¶

• Added request for the EXECUTE MANAGED TASK privilege to the connector’s manifest.

New features¶

Not applicable.

Bug fixes¶

Not applicable.

Behavior changes¶

• The CONNECTOR_EXECUTION_LOG table is deprecated and will be removed in the future.

New features¶

• Added more details to the CONNECTOR_ERRORS view, including the error reason.

Bug fixes¶

• The CONNECTOR_CONFIGURATION, CONNECTOR_STATS, and CONNECTOR_ERRORS views are now visible to the VIEWER application role.

Behavior changes¶

• Internal changes only.

New features¶

Not applicable.

Bug fixes¶

Not applicable.

Behavior changes¶

Not applicable.

New features¶

• Added alerting handling. Procedures DISABLE_ALERTS and CONFIGURE_ALERTS were added.

Bug fixes¶

Not applicable.

Behavior changes¶

Not applicable.

New features¶

• Generated IDs for all CONNECTOR_EXECUTION_LOG entries.

Bug fixes¶

• Fixed initial load start date calculation.

Behavior changes¶

• The retry count for GA API requests was reduced to 1, and removed retries for 502 errors.

New features¶

• Added ID column to CONNECTOR_EXECUTION_LOG. The column will be populated for new entries.

Bug fixes¶

Not applicable.

Behavior changes¶

Not applicable.

New features¶

• Added views containing basic ingestion statistics - CONNECTOR_STATS and AGGREGATED_CONNECTOR_STATS.

• Added a view containing ingestion errors - CONNECTOR_ERRORS.

• Added a procedure that immediately triggers ingestion for a given report - INGEST_NOW(<report name>).

• Added a function to retrieve dimensions and metrics for a given property - GET_DIMENSIONS_AND_METRICS(<property id>).

Bug fixes¶

Not applicable.

Behavior changes¶

• Date ranges for initial ingestion are split into 6-month intervals. This reduces the risk of initial load failing for reports with a distant start date.

• Updated links to the documentation in prerequisites and README file.

New features¶

Not applicable.

Bug fixes¶

Not applicable.

Behavior changes¶

Initial version.

New features¶

Not applicable.

Bug fixes¶

Not applicable.