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: Dashboard subscriptions
description: Which subscriptions are active, who created them, who's subscribed to them, when they're sent, and more.
entity_id: 5ojUtU9iE-DCggHdFPIll
created_at: '2023-06-08T14:36:00.472585Z'
creator_id: [email protected]
display: table
collection_id: vG58R8k-QddHWA7_47umn
collection_position: 14
query_type: query
database_id: Internal Metabase Database
table_id: [Internal Metabase Database, public, v_subscriptions]
parameters: []
parameter_mappings: []
dataset_query:
  database: Internal Metabase Database
  stages:
  - source-table: [Internal Metabase Database, public, v_subscriptions]
    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_subscriptions, entity_id]
  - null
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_subscriptions, 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_subscriptions, entity_qualified_id]
  - null
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_subscriptions, 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_subscriptions, created_at]
  - {temporal-unit: default}
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_subscriptions, 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_subscriptions, updated_at]
  - {temporal-unit: default}
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_subscriptions, 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_subscriptions, creator_id]
  - null
  fk_target_field_id: [Internal Metabase Database, public, v_users, user_id]
  id: [Internal Metabase Database, public, v_subscriptions, creator_id]
  name: creator_id
  semantic_type: type/FK
  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_subscriptions, archived]
  - null
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_subscriptions, archived]
  name: archived
  semantic_type: type/Category
  settings: null
  visibility_type: normal
- base_type: type/Text
  coercion_strategy: null
  description: null
  display_name: Dashboard Qualified ID
  effective_type: type/Text
  field_ref:
  - field
  - [Internal Metabase Database, public, v_subscriptions, dashboard_qualified_id]
  - null
  fk_target_field_id: [Internal Metabase Database, public, v_content, entity_qualified_id]
  id: [Internal Metabase Database, public, v_subscriptions, dashboard_qualified_id]
  name: dashboard_qualified_id
  semantic_type: type/FK
  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_subscriptions, schedule_type]
  - null
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_subscriptions, 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_subscriptions, schedule_day]
  - null
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_subscriptions, 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_subscriptions, schedule_hour]
  - null
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_subscriptions, schedule_hour]
  name: schedule_hour
  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_subscriptions, recipient_type]
  - null
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_subscriptions, 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_subscriptions, recipients]
  - null
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_subscriptions, 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_subscriptions, recipient_external]
  - null
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_subscriptions, recipient_external]
  name: recipient_external
  semantic_type: null
  settings: null
  visibility_type: normal
- base_type: type/Text
  coercion_strategy: null
  description: null
  display_name: Parameters
  effective_type: type/Text
  field_ref:
  - field
  - [Internal Metabase Database, public, v_subscriptions, parameters]
  - null
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_subscriptions, parameters]
  name: parameters
  semantic_type: type/SerializedJSON
  settings: null
  visibility_type: normal
visualization_settings:
  column_settings: null
  table.cell_column: recipient_external
  table.column_widths: [null, null, null, null, 136]
  table.pivot_column: name
card_schema: 23
serdes/meta:
- {id: 5ojUtU9iE-DCggHdFPIll, label: dashboard_subscriptions, model: Card}
type: model