The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:
TypeScript analyticsbibusiness-intelligencebusinessintelligenceclojuredashboarddatadata-analysisdata-visualizationdatabasemetabasemysqlpostgrespostgresqlreportingslacksql-editorvisualization
name: Alerts
description: All alerts, both active and archived.
entity_id: skoPT2xiuEcUV8vFkHE6S
created_at: '2023-11-01T02:49:36.532503Z'
creator_id: [email protected]
display: table
collection_id: vG58R8k-QddHWA7_47umn
collection_position: 16
query_type: query
database_id: Internal Metabase Database
table_id: [Internal Metabase Database, public, v_alerts]
parameters: []
parameter_mappings: []
dataset_query:
database: Internal Metabase Database
stages:
- source-table: [Internal Metabase Database, public, v_alerts]
lib/type: mbql.stage/mbql
lib/type: mbql/query
result_metadata:
- base_type: type/Integer
coercion_strategy: null
description: null
display_name: Entity ID
effective_type: type/Integer
field_ref:
- field
- [Internal Metabase Database, public, v_alerts, entity_id]
- null
fk_target_field_id: null
id: [Internal Metabase Database, public, v_alerts, entity_id]
name: entity_id
semantic_type: type/PK
settings: null
visibility_type: normal
- base_type: type/Text
coercion_strategy: null
description: null
display_name: Entity Qualified ID
effective_type: type/Text
field_ref:
- field
- [Internal Metabase Database, public, v_alerts, entity_qualified_id]
- null
fk_target_field_id: null
id: [Internal Metabase Database, public, v_alerts, entity_qualified_id]
name: entity_qualified_id
semantic_type: type/PK
settings: null
visibility_type: normal
- base_type: type/DateTimeWithLocalTZ
coercion_strategy: null
description: null
display_name: Created At
effective_type: type/DateTimeWithLocalTZ
field_ref:
- field
- [Internal Metabase Database, public, v_alerts, created_at]
- {temporal-unit: default}
fk_target_field_id: null
id: [Internal Metabase Database, public, v_alerts, created_at]
name: created_at
semantic_type: type/CreationTimestamp
settings: null
unit: default
visibility_type: normal
- base_type: type/DateTimeWithLocalTZ
coercion_strategy: null
description: null
display_name: Updated At
effective_type: type/DateTimeWithLocalTZ
field_ref:
- field
- [Internal Metabase Database, public, v_alerts, updated_at]
- {temporal-unit: default}
fk_target_field_id: null
id: [Internal Metabase Database, public, v_alerts, updated_at]
name: updated_at
semantic_type: type/UpdatedTimestamp
settings: null
unit: default
visibility_type: normal
- base_type: type/Integer
coercion_strategy: null
description: null
display_name: Creator ID
effective_type: type/Integer
field_ref:
- field
- [Internal Metabase Database, public, v_alerts, creator_id]
- null
fk_target_field_id: [Internal Metabase Database, public, v_users, user_id]
id: [Internal Metabase Database, public, v_alerts, creator_id]
name: creator_id
semantic_type: type/FK
settings: null
visibility_type: normal
- base_type: type/Integer
coercion_strategy: null
description: null
display_name: Card ID
effective_type: type/Integer
field_ref:
- field
- [Internal Metabase Database, public, v_alerts, card_id]
- null
fk_target_field_id: null
id: [Internal Metabase Database, public, v_alerts, card_id]
name: card_id
semantic_type: null
settings: null
visibility_type: normal
- base_type: type/Text
coercion_strategy: null
description: null
display_name: Card Qualified ID
effective_type: type/Text
field_ref:
- field
- [Internal Metabase Database, public, v_alerts, card_qualified_id]
- null
fk_target_field_id: [Internal Metabase Database, public, v_content, entity_qualified_id]
id: [Internal Metabase Database, public, v_alerts, card_qualified_id]
name: card_qualified_id
semantic_type: type/FK
settings: null
visibility_type: normal
- base_type: type/Text
coercion_strategy: null
description: null
display_name: Alert Condition
effective_type: type/Text
field_ref:
- field
- [Internal Metabase Database, public, v_alerts, alert_condition]
- null
fk_target_field_id: null
id: [Internal Metabase Database, public, v_alerts, alert_condition]
name: alert_condition
semantic_type: type/Category
settings: null
visibility_type: normal
- base_type: type/Text
coercion_strategy: null
description: null
display_name: Schedule Type
effective_type: type/Text
field_ref:
- field
- [Internal Metabase Database, public, v_alerts, schedule_type]
- null
fk_target_field_id: null
id: [Internal Metabase Database, public, v_alerts, schedule_type]
name: schedule_type
semantic_type: type/Category
settings: null
visibility_type: normal
- base_type: type/Text
coercion_strategy: null
description: null
display_name: Schedule Day
effective_type: type/Text
field_ref:
- field
- [Internal Metabase Database, public, v_alerts, schedule_day]
- null
fk_target_field_id: null
id: [Internal Metabase Database, public, v_alerts, schedule_day]
name: schedule_day
semantic_type: type/Category
settings: null
visibility_type: normal
- base_type: type/Integer
coercion_strategy: null
description: null
display_name: Schedule Hour
effective_type: type/Integer
field_ref:
- field
- [Internal Metabase Database, public, v_alerts, schedule_hour]
- null
fk_target_field_id: null
id: [Internal Metabase Database, public, v_alerts, schedule_hour]
name: schedule_hour
semantic_type: type/Category
settings: null
visibility_type: normal
- base_type: type/Boolean
coercion_strategy: null
description: null
display_name: Archived
effective_type: type/Boolean
field_ref:
- field
- [Internal Metabase Database, public, v_alerts, archived]
- null
fk_target_field_id: null
id: [Internal Metabase Database, public, v_alerts, archived]
name: archived
semantic_type: type/Category
settings: null
visibility_type: normal
- base_type: type/Text
coercion_strategy: null
description: null
display_name: Recipient Type
effective_type: type/Text
field_ref:
- field
- [Internal Metabase Database, public, v_alerts, recipient_type]
- null
fk_target_field_id: null
id: [Internal Metabase Database, public, v_alerts, recipient_type]
name: recipient_type
semantic_type: type/Category
settings: null
visibility_type: normal
- base_type: type/Text
coercion_strategy: null
description: null
display_name: Recipients
effective_type: type/Text
field_ref:
- field
- [Internal Metabase Database, public, v_alerts, recipients]
- null
fk_target_field_id: null
id: [Internal Metabase Database, public, v_alerts, recipients]
name: recipients
semantic_type: type/Category
settings: null
visibility_type: normal
- base_type: type/Text
coercion_strategy: null
description: null
display_name: Recipient External
effective_type: type/Text
field_ref:
- field
- [Internal Metabase Database, public, v_alerts, recipient_external]
- null
fk_target_field_id: null
id: [Internal Metabase Database, public, v_alerts, recipient_external]
name: recipient_external
semantic_type: type/Category
settings: null
visibility_type: normal
visualization_settings: {column_settings: null, table.cell_column: card_id, table.pivot_column: schedule_day}
card_schema: 23
serdes/meta:
- {id: skoPT2xiuEcUV8vFkHE6S, label: alerts, model: Card}
type: model