# Statsig schema ERD

Table and field reference for the Fivetran Statsig connector.

## 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 | PK, FK |
| 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 | PK, FK |
| holdout_id | Unknown | FK |

### dynamic_config_rule_condition

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| dynamic_config_id | Unknown | PK, FK |
| dynamic_config_rule_name | Unknown | PK, FK |
| 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 | PK, FK |
| environments | Json |  |
| pass_percentage | Unknown |  |
| return_value_key | Json |  |

### dynamic_config_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| dynamic_config_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| description | Unknown |  |
| metadata | Json |  |
| name | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### experiment_primary_metric

| Column | Type | Keys |
| --- | --- | --- |
| experiment_id | Unknown | PK, FK |
| name | Unknown | PK, FK |
| type | Unknown |  |

### experiment_primary_metric_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| experiment_id | Unknown | PK, FK |
| tags | Unknown | FK |

### experiment_secondary_metric

| Column | Type | Keys |
| --- | --- | --- |
| experiment_id | Unknown | PK, FK |
| name | Unknown | PK, FK |
| type | Unknown |  |

### experiment_secondary_metric_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| experiment_id | Unknown | PK, FK |
| tags | Unknown | FK |

### experiment_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| experiment_id | Unknown | PK, FK |
| tags | Unknown |  |

### experiment_allowed_reviewer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| experiment_id | Unknown | PK, FK |
| email | Unknown |  |
| name | Unknown |  |

### experiment_other_matrix

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| experiment_id | Unknown | PK, FK |
| name | Unknown | FK |
| direction | Unknown |  |
| hypothesized_value | Unknown |  |
| type | Unknown |  |

### experiment_assignment_source_filter

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| experiment_id | Unknown | PK, FK |
| columns | Unknown |  |
| condition | Unknown |  |
| values | Json |  |

### experiment_link

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| experiment_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| holdout_id | Unknown | FK |

### autotune_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| autotune_id | Unknown | PK, FK |
| tags | Unknown |  |

### autotune_variant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| autotune_id | Unknown | PK, FK |
| 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 | PK, FK |
| holdout_id | Unknown | FK |

### segment_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| segment_id | Unknown | PK, FK |
| 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 | PK, FK |
| segment_rule_name | Unknown | PK, FK |
| custom_id | Unknown |  |
| field | Unknown |  |
| operator | Unknown |  |
| type | Unknown |  |

### segment_rule

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| segment_id | Unknown | PK, FK |
| 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 | PK, FK |
| unit_type | Unknown |  |

### metric_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| metric_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| gate_rule_name | Unknown | PK, FK |
| custom_id | Unknown |  |
| field | Unknown |  |
| operator | Unknown |  |
| type | Unknown |  |

### gate_rule

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| gate_id | Unknown | PK, FK |
| environments | Json |  |
| pass_percentage | Unknown |  |

### gate_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| gate_id | Unknown | PK, FK |
| tags | Unknown |  |

### gate_allowed_reviewer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| gate_id | Unknown | PK, FK |
| email | Unknown |  |
| name | Unknown |  |

### gate_monitoring_metric

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| gate_id | Unknown | PK, FK |
| 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 | PK, FK |
| tags | Unknown |  |

### layer_holdout

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| layer_id | Unknown | PK, FK |
| holdout_id | Unknown | FK |

### layer_parameter

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| layer_id | Unknown | PK, FK |
| 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_** |  |  |

## Relationships

- first_exposures_report(group_id) → experiment_group(_fivetran_id)
- audit_log_change_rule(audit_log_id) → audit_log(id)
- audit_log_change_rule_condition(rule_type) → audit_log_change_rule(rule_type)
- audit_log_change_rule_condition(audit_log_change_rule_id) → audit_log_change_rule(id)
- audit_log_change_rule_condition(audit_log_id) → audit_log_change_rule(audit_log_id)
- dynamic_config_holdout(holdout_id) → holdout(id)
- dynamic_config_holdout(dynamic_config_id) → dynamic_config(id)
- dynamic_config_rule_condition(dynamic_config_rule_name) → dynamic_config_rule(name)
- dynamic_config_rule_condition(dynamic_config_id) → dynamic_config_rule(dynamic_config_id)
- dynamic_config_rule(dynamic_config_id) → dynamic_config(id)
- dynamic_config_tag(dynamic_config_id) → dynamic_config(id)
- experiment_holdout(holdout_id) → holdout(id)
- experiment_holdout(experiment_id) → experiment(id)
- experiment_group(experiment_id) → experiment(id)
- experiment_health_check(experiment_id) → experiment(id)
- experiment_primary_metric(name) → metric(name)
- experiment_primary_metric(experiment_id) → experiment(id)
- experiment_primary_metric_tag(tags) → metric_tag(tags)
- experiment_primary_metric_tag(experiment_id) → experiment(id)
- experiment_secondary_metric(name) → metric(name)
- experiment_secondary_metric(experiment_id) → experiment(id)
- experiment_secondary_metric_tag(tags) → metric_tag(tags)
- experiment_secondary_metric_tag(experiment_id) → experiment(id)
- experiment_tag(experiment_id) → experiment(id)
- experiment_allowed_reviewer(experiment_id) → experiment(id)
- experiment_other_matrix(name) → metric(name)
- experiment_other_matrix(experiment_id) → experiment(id)
- experiment_assignment_source_filter(experiment_id) → experiment(id)
- experiment_link(experiment_id) → experiment(id)
- experiment(layer_id) → layer(id)
- experiment(targeting_gate_id) → gate(id)
- holdout_tag(holdout_id) → holdout(id)
- autotune_holdout(holdout_id) → holdout(id)
- autotune_holdout(autotune_id) → autotune(id)
- autotune_tag(autotune_id) → autotune(id)
- autotune_variant(autotune_id) → autotune(id)
- segment_holdout(holdout_id) → holdout(id)
- segment_holdout(segment_id) → segment(id)
- segment_tag(segment_id) → segment(id)
- segment_rule_condition_target_value(segment_rule_condition_index) → segment_rule_condition(index)
- segment_rule_condition_target_value(segment_rule_name) → segment_rule_condition(segment_rule_name)
- segment_rule_condition_target_value(segment_id) → segment_rule_condition(segment_id)
- segment_rule_condition(segment_id) → segment_rule(segment_id)
- segment_rule_condition(segment_rule_name) → segment_rule(name)
- segment_rule(segment_id) → segment(id)
- metric_unit_type(metric_id) → metric(id)
- metric_tag(metric_id) → metric(id)
- gate_holdout(holdout_id) → holdout(id)
- gate_holdout(gate_id) → gate(id)
- gate_rule_condition_target_value(gate_rule_condition_index) → gate_rule_condition(index)
- gate_rule_condition_target_value(gate_rule_name) → gate_rule_condition(gate_rule_name)
- gate_rule_condition_target_value(gate_id) → gate_rule_condition(gate_id)
- gate_rule_condition(gate_rule_name) → gate_rule(name)
- gate_rule_condition(gate_id) → gate_rule(gate_id)
- gate_rule(gate_id) → gate(id)
- gate_tag(gate_id) → gate(id)
- gate_allowed_reviewer(gate_id) → gate(id)
- gate_monitoring_metric(gate_id) → gate(id)
- layer_tag(layer_id) → layer(id)
- layer_holdout(holdout_id) → holdout(id)
- layer_holdout(layer_id) → layer(id)
- layer_parameter(layer_id) → layer(id)