Release Notes

June 2024

We now incrementally sync the AUDIT_LOG table to capture new records.

We have changed the connector type of our Statsig connector from Lite to Standard. We are gradually rolling out this upgrade to all existing connectors.

April 2024

We have changed the way we calculate the value for the _fivetran_id column in the EVENT_CONFIG_CHANGE table.

Effective April 18, 2024 we use a new April 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

This schema change is necessary to align column names with standard SQL practices.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

37 total changes • 10 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`AUTOTUNE`
table	New Table		`AUTOTUNE`
`AUTOTUNE_HOLDOUT`
table	New Table		`AUTOTUNE_HOLDOUT`
`AUTOTUNE_TAG`
table	New Table		`AUTOTUNE_TAG`
`AUTOTUNE_VARIANT`
table	New Table		`AUTOTUNE_VARIANT`
`DYNAMIC_CONFIG`
column	Deprecated Column	`holdout_ids`		We are deprecating this column as we now populate this data into a separate table.
`DYNAMIC_CONFIG_TAG`
column	Rename Column	`tag`	`tags`	We are aligning the column name with standard SQL practices.
`EXPERIMENT`
column	Deprecated Column	`holdout_ids`		We are deprecating this column as we now populate this data into a separate table.
`EXPERIMENT_PRIMARY_METRIC_TAG`
column	Rename Column	`tag`	`tags`	We are aligning the column name with standard SQL practices.
`EXPERIMENT_SECONDARY_METRIC_TAG`
column	Rename Column	`tag`	`tags`	We are aligning the column name with standard SQL practices.
`EXPERIMENT_TAG`
column	Rename Column	`tag`	`tags`	We are aligning the column name with standard SQL practices.
`FIRST_EXPOSURES_REPORT`
column	Primary Key Change	`_fivetran_id` 🔑	`_fivetran_id` 🔑	The calculation of this column has been updated due to the addition of a new column to the table.
column	Rename Column	`percent`	`percents`	We are aligning the column name with standard SQL practices.
column	New Column		`group_id`
`GATE`
column	Deprecated Column	`holdout_ids`		We are deprecating this column as we now populate this data into a separate table.
`GATE_TAG`
column	Rename Column	`tag`	`tags`	We are aligning the column name with standard SQL practices.
`HOLDOUT`
table	New Table		`HOLDOUT`
`HOLDOUT_TAG`
table	New Table		`HOLDOUT_TAG`
`INGESTION_RUN`
table	New Table		`INGESTION_RUN`
`INGESTION_RUN_GRANULAR_HISTORY`
table	New Table		`INGESTION_RUN_GRANULAR_HISTORY`
`INGESTION_STATUS`
table	New Table		`INGESTION_STATUS`
`LAYER`
table	New Table		`LAYER`
`LAYER_HOLDOUT`
table	New Table		`LAYER_HOLDOUT`
`LAYER_PARAMETER`
table	New Table		`LAYER_PARAMETER`
`LAYER_TAG`
table	New Table		`LAYER_TAG`
`METRIC`
column	New Column		`created_time`
column	New Column		`creator_email`
column	New Column		`creator_name`
column	New Column		`owner_name`
column	New Column		`team`
`METRIC_TAG`
table	New Table		`METRIC_TAG`
`METRIC_UNIT_TYPE`
table	New Table		`METRIC_UNIT_TYPE`
`SEGMENT`
table	New Table		`SEGMENT`
`SEGMENT_HOLDOUT`
table	New Table		`SEGMENT_HOLDOUT`
`SEGMENT_RULE`
table	New Table		`SEGMENT_RULE`
`SEGMENT_RULE_CONDITION`
table	New Table		`SEGMENT_RULE_CONDITION`
`SEGMENT_RULE_CONDITION_TARGET_VALUE`
table	New Table		`SEGMENT_RULE_CONDITION_TARGET_VALUE`
`SEGMENT_TAG`
table	New Table		`SEGMENT_TAG`

February 2024

We have added the following new tables:

DYNAMIC_CONFIG
DYNAMIC_CONFIG_TAG
DYNAMIC_CONFIG_RULE
DYNAMIC_CONFIG_RULE_CONDITION
GATE
GATE_TAG
GATE_RULE
GATE_RULE_CONDITION
GATE_RULE_CONDITION_TARGET_VALUE

January 2024

You can now configure your Statsig connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.

October 2023

The Statsig connector now supports table-level re-syncs.

We have changed the authentication method for Statsig connector. We now use console secret key instead of the server-side secret key to authenticate the Statsig connector. Be sure to use the console secret key and re-authenticate your Statsig connector to ensure continued service. For more information, see Statsig's documentation.

We have added the following new tables:

AUDIT_LOG
AUDIT_LOG_CHANGE_RULE
AUDIT_LOG_CHANGE_RULE_CONDITION
EVENT_CONFIG_CHANGE
EXPERIMENT
EXPERIMENT_GROUP
EXPERIMENT_PRIMARY_METRIC
EXPERIMENT_PRIMARY_METRIC_TAG
EXPERIMENT_SECONDARY_METRIC
EXPERIMENT_SECONDARY_METRIC_TAG
EXPERIMENT_TAG
METRIC

We no longer sync the UNIT_METRICS_DAILY_REPORT table because Statsig does not support it.

January 2023

Lite connectors are now available for the following sources: