Statsig

Explore the interactive ERD

Table & Field Reference

first_exposures_report

Column	Type	Keys
`_fivetran_id`	String	PK
`group_id`	Unknown	FK
`as_of_pst_date`	LocalDate
`company_id`	String
`experiment_group`	String
`exposure_type`	String
`first_exposure_pst_date`	LocalDate
`first_exposure_utc`	Instant
`name`	String
`percents`	Double
`rollout`	Long
`rule`	String
`stable_id`	Unknown
`unit_id`	String
`unit_type`	String
`user_dimensions`	Json
`user_id`	Unknown

ingestion_run_granular_history

Column	Type	Keys
`ingestion_run_id`	Unknown	PK
`source`	Unknown	PK
`status`	Unknown	PK
`status_timestamp`	Unknown

ingestion_run

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`last_updated_at`	Unknown
`latest_status`	Unknown
`trigger`	Unknown

audit_log

Column	Type	Keys
`id`	Unknown	PK
`action_type`	Unknown
`change_log`	Unknown
`date`	Unknown
`modifier_email`	Unknown
`name`	Unknown
`tags`	Json
`target_app_id`	Unknown
`time`	Unknown
`updated_by`	Unknown
`updated_by_user_id`	Unknown

audit_log_change_rule

Column	Type	Keys
`id`	Unknown	PK
`rule_type`	Unknown	PK
`audit_log_id`	Unknown	PKFK
`enabled_enviroment`	Json
`environment`	Unknown
`group_name`	Unknown
`percentage_pass`	Unknown
`rollouts`	Json
`salt`	Unknown

audit_log_change_rule_condition

Column	Type	Keys
`_fivetran_id`	String	PK
`audit_log_change_rule_id`	Unknown	FK
`audit_log_id`	Unknown	FK
`rule_type`	Unknown	FK
`condition_type`	Unknown
`extra_config`	Json
`operator`	Unknown
`value`	Json

dynamic_config_holdout

Column	Type	Keys
`index`	Unknown	PK
`dynamic_config_id`	Unknown	PKFK
`holdout_id`	Unknown	FK

dynamic_config_rule_condition

Column	Type	Keys
`index`	Unknown	PK
`dynamic_config_id`	Unknown	PKFK
`dynamic_config_rule_name`	Unknown	PKFK
`custom_id`	Unknown
`field`	Unknown
`operator`	Unknown
`target_value`	Json
`type`	Unknown

dynamic_config_rule

Column	Type	Keys
`name`	Unknown	PK
`dynamic_config_id`	Unknown	PKFK
`environments`	Json
`pass_percentage`	Unknown
`return_value_key`	Json

dynamic_config_tag

Column	Type	Keys
`index`	Unknown	PK
`dynamic_config_id`	Unknown	PKFK
`tags`	Unknown

dynamic_config

Column	Type	Keys
`id`	Unknown	PK
`created_time`	Unknown
`creator_email`	Unknown
`creator_id`	Unknown
`creator_name`	Unknown
`default_value_key`	Json
`description`	Unknown
`id_type`	Unknown
`is_enabled`	Unknown
`last_modified_time`	Unknown
`last_modifier_email`	Unknown
`last_modifier_id`	Unknown
`last_modifier_name`	Unknown
`name`	Unknown
`status`	Unknown
`target_apps`	Json
`team`	Unknown
`type`	Unknown
`type_reason`	Unknown

experiment_holdout

Column	Type	Keys
`index`	Unknown	PK
`experiment_id`	Unknown	PKFK
`holdout_id`	Unknown	FK

experiment_group

Column	Type	Keys
`_fivetran_id`	String	PK
`experiment_id`	Unknown	FK
`description`	Unknown
`id`	Unknown
`name`	Unknown
`size`	Unknown
`parameter_values_`

experiment_health_check

Column	Type	Keys
`index`	Unknown	PK
`experiment_id`	Unknown	PKFK
`description`	Unknown
`metadata`	Json
`name`	Unknown
`status`	Unknown
`type`	Unknown

experiment_primary_metric

Column	Type	Keys
`experiment_id`	Unknown	PKFK
`name`	Unknown	PKFK
`type`	Unknown

experiment_primary_metric_tag

Column	Type	Keys
`index`	Unknown	PK
`experiment_id`	Unknown	PKFK
`tags`	Unknown	FK

experiment_secondary_metric

Column	Type	Keys
`experiment_id`	Unknown	PKFK
`name`	Unknown	PKFK
`type`	Unknown

experiment_secondary_metric_tag

Column	Type	Keys
`index`	Unknown	PK
`experiment_id`	Unknown	PKFK
`tags`	Unknown	FK

experiment_tag

Column	Type	Keys
`index`	Unknown	PK
`experiment_id`	Unknown	PKFK
`tags`	Unknown

experiment_allowed_reviewer

Column	Type	Keys
`id`	Unknown	PK
`experiment_id`	Unknown	PKFK
`email`	Unknown
`name`	Unknown

experiment_other_matrix

Column	Type	Keys
`index`	Unknown	PK
`experiment_id`	Unknown	PKFK
`name`	Unknown	FK
`direction`	Unknown
`hypothesized_value`	Unknown
`type`	Unknown

experiment_assignment_source_filter

Column	Type	Keys
`index`	Unknown	PK
`experiment_id`	Unknown	PKFK
`columns`	Unknown
`condition`	Unknown
`values`	Json

experiment_link

Column	Type	Keys
`index`	Unknown	PK
`experiment_id`	Unknown	PKFK
`title`	Unknown
`url`	Unknown

experiment

Column	Type	Keys
`id`	Unknown	PK
`layer_id`	Unknown	FK
`targeting_gate_id`	Unknown	FK
`active_review_description`	Unknown
`active_review_id`	Unknown
`active_review_status`	Unknown
`allocation`	Unknown
`allocation_duration`	Unknown
`analysis_end_time`	Unknown
`analytics_type`	Unknown
`assignment_source_experiment_name`	Unknown
`assignment_source_name`	Unknown
`benjamini_hochberg_per_metric`	Unknown
`benjamini_hochberg_per_variant`	Unknown
`benjamini_primary_metrics_only`	Unknown
`bonferroni_correction`	Unknown
`bonferroni_correction_per_metric`	Unknown
`cohort_wait_until_end_to_include`	Unknown
`cohorted_analysis_duration`	Unknown
`cohorted_metrics_mature_after_end`	Unknown
`control_group_id`	Unknown
`created_time`	Unknown
`creator_email`	Unknown
`creator_id`	Unknown
`creator_name`	Unknown
`decision_reason`	Unknown
`decision_time`	Unknown
`default_confidence_interval`	Unknown
`description`	Unknown
`duration`	Unknown
`end_time`	Unknown
`external_experiment_name`	Unknown
`fixed_analysis_duration`	Unknown
`health_check_status`	Unknown
`hypothesis`	Unknown
`id_type`	Unknown
`identifier_mapping_mode`	Unknown
`identity_resolution_source`	Unknown
`inline_targeting_rules_json`	Unknown
`is_analysis_only`	Unknown
`last_modified_time`	Unknown
`last_modifier_email`	Unknown
`last_modifier_id`	Unknown
`last_modifier_name`	Unknown
`launched_group_id`	Unknown
`name`	Unknown
`owner_email`	Unknown
`owner_id`	Unknown
`owner_name`	Unknown
`owner_type`	Unknown
`review_settings_required_review`	Unknown
`scheduled_reload_hour`	Unknown
`scheduled_reload_type`	Unknown
`secondary_id_type`	Unknown
`sequential_testing`	Unknown
`start_time`	Unknown
`status`	Unknown
`subtype`	Unknown
`target_apps`	Json
`target_exposure`	Unknown
`team`	Unknown
`team_id`	Unknown
`version`	Unknown

pulse_daily_report

Column	Type	Keys
`_fivetran_id`	String	PK
`absolute_delta`	Double
`absolute_standard_error`	Double
`company_id`	String
`control_mean`	Double
`control_standard_error`	Double
`control_units`	Long
`experiment_group`	String
`mean`	Double
`metric_dimension`	String
`metric_name`	String
`metric_type`	String
`name`	String
`participating_units`	Long
`pst_date`	LocalDate
`relative_delta`	Double
`relative_standard_error`	Double
`rule`	String
`standard_deviation`	Double
`standard_error`	Double
`test_mean`	Double
`test_standard_error`	Double
`test_units`	Long
`total`	Double
`units`	Long
`varpop`	Double
`z_score`	Double

holdout_tag

Column	Type	Keys
`index`	Unknown	PK
`holdout_id`	Unknown	PKFK
`tags`	Unknown

holdout

Column	Type	Keys
`id`	Unknown	PK
`created_time`	Unknown
`creator_email`	Unknown
`creator_id`	Unknown
`creator_name`	Unknown
`description`	Unknown
`id_type`	Unknown
`is_enabled`	Unknown
`is_global`	Unknown
`last_modified_time`	Unknown
`last_modifier_email`	Unknown
`last_modifier_id`	Unknown
`last_modifier_name`	Unknown
`name`	Unknown
`pass_percentage`	Unknown
`target_apps`	Json
`targeting_gate_id`	Unknown
`team`	Unknown

autotune_holdout

Column	Type	Keys
`index`	Unknown	PK
`autotune_id`	Unknown	PKFK
`holdout_id`	Unknown	FK

autotune_tag

Column	Type	Keys
`index`	Unknown	PK
`autotune_id`	Unknown	PKFK
`tags`	Unknown

autotune_variant

Column	Type	Keys
`id`	Unknown	PK
`autotune_id`	Unknown	PKFK
`json`	Json
`name`	Unknown

autotune

Column	Type	Keys
`id`	Unknown	PK
`attribution_window`	Unknown
`created_time`	Unknown
`creator_email`	Unknown
`creator_id`	Unknown
`creator_name`	Unknown
`description`	Unknown
`exploration_window`	Unknown
`id_type`	Unknown
`is_started`	Unknown
`last_modified_time`	Unknown
`last_modifier_email`	Unknown
`last_modifier_id`	Unknown
`last_modifier_name`	Unknown
`name`	Unknown
`success_event`	Unknown
`success_event_value`	Unknown
`target_apps`	Json
`winner`	Unknown
`winner_threshold`	Unknown

segment_holdout

Column	Type	Keys
`index`	Unknown	PK
`segment_id`	Unknown	PKFK
`holdout_id`	Unknown	FK

segment_tag

Column	Type	Keys
`index`	Unknown	PK
`segment_id`	Unknown	PKFK
`tags`	Unknown

segment_rule_condition_target_value

Column	Type	Keys
`_fivetran_id`	String	PK
`segment_id`	Unknown	FK
`segment_rule_condition_index`	Unknown	FK
`segment_rule_name`	Unknown	FK
`target_value`	Unknown

segment_rule_condition

Column	Type	Keys
`index`	Unknown	PK
`segment_id`	Unknown	PKFK
`segment_rule_name`	Unknown	PKFK
`custom_id`	Unknown
`field`	Unknown
`operator`	Unknown
`type`	Unknown

segment_rule

Column	Type	Keys
`name`	Unknown	PK
`segment_id`	Unknown	PKFK
`environments`	Json
`pass_percentage`	Unknown

segment

Column	Type	Keys
`id`	Unknown	PK
`count`	Unknown
`created_time`	Unknown
`creator_email`	Unknown
`creator_id`	Unknown
`creator_name`	Unknown
`description`	Unknown
`id_type`	Unknown
`is_enabled`	Unknown
`last_modified_time`	Unknown
`last_modifier_email`	Unknown
`last_modifier_id`	Unknown
`last_modifier_name`	Unknown
`name`	Unknown
`status`	Unknown
`target_apps`	Json
`team`	Unknown
`type`	Unknown
`type_reason`	Unknown

ingestion_status

Column	Type	Keys
`_fivetran_id`	String	PK
`date_stamp`	Unknown
`ingestion_dataset`	Unknown
`ingestion_source`	Unknown
`message`	Unknown
`row_count`	Unknown
`status`	Unknown
`time_stamp`	Unknown

metric_unit_type

Column	Type	Keys
`index`	Unknown	PK
`metric_id`	Unknown	PKFK
`unit_type`	Unknown

metric_tag

Column	Type	Keys
`index`	Unknown	PK
`metric_id`	Unknown	PKFK
`tags`	Unknown

metric

Column	Type	Keys
`id`	Unknown	PK
`created_time`	Unknown
`creator_email`	Unknown
`creator_name`	Unknown
`description`	Unknown
`is_hidden`	Unknown
`lineage_events`	Json
`lineage_metrics`	Json
`name`	Unknown
`owner_name`	Unknown
`tags`	Json
`team`	Unknown
`type`	Unknown

gate_holdout

Column	Type	Keys
`index`	Unknown	PK
`gate_id`	Unknown	PKFK
`holdout_id`	Unknown	FK

gate_rule_condition_target_value

Column	Type	Keys
`_fivetran_id`	String	PK
`gate_id`	Unknown	FK
`gate_rule_condition_index`	Unknown	FK
`gate_rule_name`	Unknown	FK
`target_value`	Unknown

gate_rule_condition

Column	Type	Keys
`index`	Unknown	PK
`gate_id`	Unknown	PKFK
`gate_rule_name`	Unknown	PKFK
`custom_id`	Unknown
`field`	Unknown
`operator`	Unknown
`type`	Unknown

gate_rule

Column	Type	Keys
`name`	Unknown	PK
`gate_id`	Unknown	PKFK
`environments`	Json
`pass_percentage`	Unknown

gate_tag

Column	Type	Keys
`index`	Unknown	PK
`gate_id`	Unknown	PKFK
`tags`	Unknown

gate_allowed_reviewer

Column	Type	Keys
`id`	Unknown	PK
`gate_id`	Unknown	PKFK
`email`	Unknown
`name`	Unknown

gate_monitoring_metric

Column	Type	Keys
`index`	Unknown	PK
`gate_id`	Unknown	PKFK
`name`	Unknown
`type`	Unknown

gate

Column	Type	Keys
`id`	Unknown	PK
`active_review_description`	Unknown
`active_review_id`	Unknown
`active_review_status`	Unknown
`checks_per_hour`	Unknown
`created_time`	Unknown
`creator_email`	Unknown
`creator_id`	Unknown
`creator_name`	Unknown
`description`	Unknown
`id_type`	Unknown
`is_enabled`	Unknown
`last_modified_time`	Unknown
`last_modifier_email`	Unknown
`last_modifier_id`	Unknown
`last_modifier_name`	Unknown
`measure_metric_lifts`	Unknown
`name`	Unknown
`owner_email`	Unknown
`owner_id`	Unknown
`owner_name`	Unknown
`owner_type`	Unknown
`release_pipeline_id`	Unknown
`review_settings_required_review`	Unknown
`status`	Unknown
`target_apps`	Json
`team`	Unknown
`team_id`	Unknown
`type`	Unknown
`type_reason`	Unknown
`version`	Unknown

layer_tag

Column	Type	Keys
`index`	Unknown	PK
`layer_id`	Unknown	PKFK
`tags`	Unknown

layer_holdout

Column	Type	Keys
`index`	Unknown	PK
`layer_id`	Unknown	PKFK
`holdout_id`	Unknown	FK

layer_parameter

Column	Type	Keys
`index`	Unknown	PK
`layer_id`	Unknown	PKFK
`default_value`	Unknown
`name`	Unknown
`type`	Unknown

layer

Column	Type	Keys
`id`	Unknown	PK
`created_time`	Unknown
`creator_email`	Unknown
`creator_id`	Unknown
`creator_name`	Unknown
`description`	Unknown
`id_type`	Unknown
`is_implicit_layer`	Unknown
`last_modified_time`	Unknown
`last_modifier_email`	Unknown
`last_modifier_id`	Unknown
`last_modifier_name`	Unknown
`pass_percentage`	Unknown
`target_apps`	Json
`team`	Unknown

event_updated

Column	Type	Keys
`time_uuid`	Unknown	PK
`event_name`	Unknown
`stable_id`	Unknown
`statsig_metadata_sdk_type`	Unknown
`statsig_metadata_sdk_version`	Unknown
`statsig_metadata_statsig_request_id`	Unknown
`statsig_metadata_statsig_tier`	Unknown
`time_stamp`	Unknown
`user_agent`	Unknown
`user_app_version`	Unknown
`user_browser_name`	Unknown
`user_browser_version`	Unknown
`user_country`	Unknown
`user_email`	Unknown
`user_id`	Unknown
`user_ip`	Unknown
`user_locale`	Unknown
`user_system_name`	Unknown
`user_system_version`	Unknown
`value`	Unknown
`metadata_`
`user_custom_`

event_config_change

Column	Type	Keys
`_fivetran_id`	String	PK
`event_name`	Unknown
`time_stamp`	Unknown
`time_uuid`	Unknown
`user_email`	Unknown
`user_name`	Unknown
`metadata_`