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: 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