Skip to content

The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:

7.1 KB
Raw Blame
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