Snowflake Share Data Model

Bigeye is able to share data with customers via Snowflake shares. This document provides an overview of the data model for the Snowflake share schema. The shared schema includes multiple views that expose usage data to Bigeye customers in a structured manner, helping them analyze key metrics related to their data.

Overview

The views within our snowflake share schema are:

DIM_METRIC: Contains information about all metrics used in a customer's Bigeye environment.
DIM_ISSUE: Contains information about all issues including their status, priority, and activity.
DIM_DELTA: Contains information about all deltas used in a customer's Bigeye environment.
DIM_COLLECTION: Contains information about all collections used in a customer's Bigeye environment.
FACT_METRIC_RUN: Contains information about all metric runs in a customer's Bigeye environment.
FACT_DELTA_RUN: Contains information about all delta runs used in a customer's Bigeye environment.
FACT_COLLECTION_METRIC: Contains information about the relationship between collections and metrics within a customer's Bigeye environment.
AGG_WORKSPACE_MONTHLY: Contains aggregated data at the workspace level, providing monthly statistics related to metrics, datasets (tables), deltas, and billable metrics.

View Definitions

`DIM_METRIC`

The following fields are included in the view:

Field Name	Description
`WORKSPACE_ID`	A unique identifier for the workspace
`WORKSPACE_NAME`	The name of the workspace
`SOURCE_ID`	A unique identifier for the data source
`SOURCE_NAME`	The name of the data source
`SOURCE_WAREHOUSEVENDOR`	Type of the source warehouse vendor
`SCHEMA_ID`	A unique identifier for the schema
`SCHEMA_NAME`	The name of the schema
`DATASET_ID`	A unique identifier for the dataset (table)
`DATASET_NAME`	The name of the dataset (table)
`COLUMN_NAME`	The name of the column (if applicable)
`METRIC_ID`	A unique identifier for the metric
`METRIC_NAME`	The name of the metric
`METRIC_GIVEN_NAME`	The given name for the metric
`METRIC_DESCRIPTION`	A description of the metric
`METRIC_TEMPLATE_ID`	A unique identifier for the metric template (if applicable)
`METRIC_CREATED_BY_ID`	ID of the user who created the metric
`METRIC_CREATED_AT`	Timestamp of when the metric was created
`METRIC_FIRST_RUN_AT`	Timestamp of the metric’s first run
`METRIC_UPDATED_BY_ID`	ID of the user who last updated the metric
`METRIC_UPDATED_AT`	Timestamp of the metric’s last update
`METRIC_DELTED_BY_ID`	ID of the user who deleted the metric (if applicable)
`METRIC_DELETED_AT`	Timestamp of when the metric was deleted (if applicable)
`METRIC_METRIC_CREATION_STATE`	How was the metric created
`METRIC_CATEGORY`	The category the metric falls under
`NEW_METRIC_CATEGORY`	A newly assigned category for the metric
`METRIC_TYPE`	The type of the metric
`METRIC_AGGREGATIONTYPE`	The aggregation type for the metric
`METRIC_LOOKBACK_TYPE`	The type of lookback for the metric
`METRIC_INTERVAL_TYPE`	The interval type for the metric
`METRIC_INTERVAL_VALUE`	The interval value for the metric
`THRESHOLD_TYPE`	The type of threshold applied
`THRESHOLD_BOUND`	The boundary for the threshold
`THRESHOLD_SENSITIVITY`	The sensitivity level of the threshold
`METRIC_IS_DEPLOYED`	Whether the metric is currently deployed or not
`METRIC_IS_DEPLOYED_BIGCONFIG`	Whether the metric was deployed using bigconfig or not
`METRIC_GRAIN_SIZE`	The granularity of the metric
`METRIC_PARTITIONSTOLOOKBACK`	The partition settings for the lookback
`METRIC_GROUP_COUNT_TOTAL`	The total number of metric groups
`METRIC_GROUP_COUNT_CRITICAL`	The number of critical metric groups
`METRIC_STATUS`	The current status of the metric
`IS_MUTED`	Indicates if the metric is muted
`_LOADED_AT_TS`	Timestamp of when the table was last loaded

`DIM_ISSUE`

The following fields are included in the view:

Field Name	Description
`WORKSPACE_ID`	A unique identifier for the workspace
`SOURCE_ID`	A unique identifier for the data source
`METRIC_ID`	A unique identifier for the metric
`ISSUE_ID`	A unique identifier for the issue
`ISSUE_CREATED_AT`	Timestamp when the issue was created
`ISSUE_CURRENT_STATUS`	The current status of the issue
`ISSUE_PRIORITY_SCORE`	Priority score for the issue
`IS_MUTED`	Indicates if the issue is muted
`FIRST_ACTIVITY_AT`	Timestamp of the first activity related to the issue
`LAST_ACTIVITY_AT`	Timestamp of the last activity related to the issue
`ISSUE_ACKED_AT`	Timestamp of when the issue was acknowledged
`IS_MUTED_BY_ACK`	Whether the issue is muted by acknowledgment of the issue
`ISSUE_MONITORING_AT`	Timestamp of when the issue started being monitored
`ISSUE_CLOSED_AT`	Timestamp of when the issue was closed
`ISSUE_CLOSING_LABEL`	Label for how the issue was closed (e.g., "Maintain thresholds" or "Adapt thresholds")
`IS_AUTO_CLOSED`	Whether the issue was automatically closed
`CNTD_USERS_INTERACTED`	The count of unique users who interacted with the issue
`CNT_COLLECTIONS`	The number of collections associated with the issue
`CNT_ACTIVITY`	The count of user activities associated with the issue
`ISSUE_TYPE`	The type of the issue (e.g., issue or incident)
`IS_INCIDENT`	Indicates if the issue is an incident
`PARENT_ISSUE_ID`	A reference to the parent issue (if applicable)
`IS_ROOT_CAUSE`	Whether this issue is the root cause
`NUM_IMPACTED_OBJECTS`	The number of objects impacted by the issue
`DESCRIPTION`	A description of the issue
`_LOADED_AT_TS`	Timestamp of when the table was last loaded

`DIM_DELTA`

The following fields are included in the view:

Field Name	Description
`DELTA_ID`	A unique identifier for the delta
`DELTA_NAME`	The name of the delta
`CREATED_AT`	Timestamp when the delta was created
`CREATED_BY_ID`	ID of the user who created the delta
`UPDATED_AT`	Timestamp when the delta was last updated
`UPDATED_BY_ID`	ID of the user who last updated the delta
`LAST_RUN_AT`	Timestamp of when the delta was last run
`SOURCE_ROW_COUNT`	The row count in the source dataset for the delta
`TARGET_ROW_COUNT`	The row count in the target dataset for the delta
`TOTAL_METRIC_COUNT`	The total number of metrics associated with the delta
`ALERTING_METRIC_COUNT`	The count of metrics triggering alerts for the delta
`FAILED_METRIC_COUNT`	The number of metrics that failed for the delta
`SOURCE_WAREHOUSE_ID`	The ID of the source warehouse
`SOURCE_SCHEMA_ID`	The ID of the source schema
`SOURCE_TABLE_ID`	The ID of the source table
`SOURCE_WAREHOUSE_NAME`	The name of the source warehouse
`SOURCE_SCHEMA_NAME`	The name of the source schema
`SOURCE_TABLE_NAME`	The name of the source table
`TARGET_WAREHOUSE_ID`	The ID of the target warehouse
`TARGET_SCHEMA_ID`	The ID of the target schema
`TARGET_TABLE_ID`	The ID of the target table
`TARGET_WAREHOUSE_NAME`	The name of the target warehouse
`TARGET_SCHEMA_NAME`	The name of the target schema
`TARGET_TABLE_NAME`	The name of the target table
`_LOADED_AT_TS`	Timestamp of when the table was last loaded

`DIM_COLLECTION`

The following fields are included in the view:

Field Name	Description
`WORKSPACE_ID`	A unique identifier for the workspace
`COLLECTION_ID`	A unique identifier for the collection
`COLLECTION_NAME`	The name of the collection
`COLLECTION_DESCRIPTION`	A description of the collection
`COLLECTION_OWNER_USER_ID`	The user ID of the collection owner
`COLLECTION_CREATED_BY_USER_ID`	The user ID of the person who created the collection
`COLLECTION_CREATED_AT`	Timestamp when the collection was created
`COLLECTION_UPDATED_BY_USER_ID`	The user ID of the person who last updated the collection
`COLLECTION_UPDATED_AT`	Timestamp when the collection was last updated
`COLLECTION_IS_MUTED`	Whether the collection is muted
`_LOADED_AT_TS`	Timestamp of when the table was last loaded

`FACT_METRIC_RUN`

The following fields are included in the view:

Field Name	Description
`WORKSPACE_ID`	A unique identifier for the workspace
`WORKSPACE_NAME`	The name of the workspace
`SOURCE_ID`	A unique identifier for the data source
`SOURCE_WAREHOUSEVENDOR`	The type of source warehouse vendor
`SCHEMA_ID`	A unique identifier for the schema
`DATASET_ID`	A unique identifier for the dataset
`METRIC_ID`	A unique identifier for the metric
`METRIC_EVENT_ID`	A unique identifier for the metric event
`METRIC_RUN_ID`	A unique identifier for the metric run
`METRIC_RUN_STATUS`	The status of the metric run
`METRIC_RUN_AT`	The timestamp when the metric run occurred
`METRIC_RUN_FAILURE_REASON`	The reason for any failure in the metric run
`METRIC_RUN_GRAIN_START`	The starting grain for the metric run
`METRIC_RUN_GRAIN_END`	The ending grain for the metric run
`THRESHOLD_IS_POST_HOC`	Indicates whether the threshold is post-hoc
`METRIC_STATUS`	The status of the metric
`METRIC_ACTUAL_VALUE`	The actual value of the metric
`THRESHOLD_LOWER_CRIT`	The lower critical threshold value
`THRESHOLD_UPPER_CRIT`	The upper critical threshold value
`METRIC_GROUP_COUNT_TOTAL`	The total group count of the metric
`METRIC_GROUP_COUNT_CRITICAL`	The group count of the metric that is critical
`_LOADED_AT_TS`	Timestamp of when the table was last loaded

`FACT_DELTA_RUN`

The following fields are included in the view:

Field Name	Description
`DELTA_METRIC_RUN_ID`	A unique identifier for the delta metric run
`DELTA_METRIC_ID`	A unique identifier for the delta metric
`DELTA_METRIC_RUN_AT`	The timestamp when the delta metric run occurred
`DELTA_ID`	A unique identifier for the delta
`DELTA_NAME`	The name of the delta
`TOTAL_METRIC_COUNT`	The total count of metrics in the delta run
`ALERTING_METRIC_COUNT`	The count of metrics in the delta run that triggered an alert
`FAILED_METRIC_COUNT`	The count of metrics that failed in the delta run
`METRIC_NAME`	The name of the metric
`GROUP_COUNT`	The count of groups in the delta run
`TOLERANCE`	The tolerance value for the delta
`USER_SPECIFIED`	Whether the delta run was user-specified
`SOURCE_TABLE_ID`	The identifier for the source table in the delta
`SOURCE_VALUE`	The value from the source table
`SOURCE_ROW_COUNT`	The row count in the source table
`TARGET_TABLE_ID`	The identifier for the target table in the delta
`TARGET_VALUE`	The value from the target table
`TARGET_ROW_COUNT`	The row count in the target table
`_LOADED_AT_TS`	Timestamp of when the table was last loaded

`FACT_COLLECTION_METRIC`

The following fields are included in the view:

Field Name	Description
`WORKSPACE_ID`	The unique identifier for the workspace where the metric is tracked
`COLLECTION_ID`	The unique identifier for the collection in the workspace
`METRIC_ID`	The unique identifier for the metric
`_LOADED_AT_TS`	Timestamp of when the table was last loaded

`AGG_WORKSPACE_MONTHLY`

The following fields are included in the view:

Field Name	Description
`WORKSPACE_ID`	The unique identifier for the workspace
`WORKSPACE_NAME`	The name of the workspace
`METRIC_RUN_MONTH`	The month when the metric run occurred
`CNT_METRIC_RUNS`	The count of metric runs for the given workspace and month
`CNTD_METRICS`	The count of distinct metrics
`CNTD_DATASETS`	The count of distinct datasets (tables)
`CNTD_DELTAS`	The count of distinct deltas
`CNTD_DELTA_DATASETS`	The count of distinct delta datasets
`CNT_BILLABLE_METRIC_RUNS`	The count of billable metric runs
`CNTD_BILLABLE_DATASETS`	The count of distinct billable datasets (tables)
`_LOADED_AT_TS`	Timestamp of when the table was last loaded

Overview

View Definitions

DIM_METRIC

DIM_ISSUE

DIM_DELTA

DIM_COLLECTION

FACT_METRIC_RUN

FACT_DELTA_RUN

FACT_COLLECTION_METRIC

AGG_WORKSPACE_MONTHLY

ERD

`DIM_METRIC`

`DIM_ISSUE`

`DIM_DELTA`

`DIM_COLLECTION`

`FACT_METRIC_RUN`

`FACT_DELTA_RUN`

`FACT_COLLECTION_METRIC`

`AGG_WORKSPACE_MONTHLY`