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: View log
description: Each row describes a question, model, table or dashboard view
entity_id: P6Ityjj7igswKh4NgZZjz
created_at: '2023-10-31T13:40:12.944134Z'
creator_id: [email protected]
display: table
collection_id: vG58R8k-QddHWA7_47umn
collection_position: 3
query_type: query
database_id: Internal Metabase Database
table_id: [Internal Metabase Database, public, v_view_log]
parameters: []
parameter_mappings: []
dataset_query:
database: Internal Metabase Database
stages:
- fields:
- - field
- {base-type: type/Integer, effective-type: type/Integer}
- [Internal Metabase Database, public, v_view_log, id]
- - field
- {base-type: type/DateTimeWithLocalTZ, effective-type: type/DateTimeWithLocalTZ}
- [Internal Metabase Database, public, v_view_log, timestamp]
- - field
- {base-type: type/Integer, effective-type: type/Integer}
- [Internal Metabase Database, public, v_view_log, user_id]
- - field
- {base-type: type/Text, effective-type: type/Text}
- [Internal Metabase Database, public, v_view_log, entity_type]
- - field
- {base-type: type/Integer, effective-type: type/Integer}
- [Internal Metabase Database, public, v_view_log, entity_id]
- - field
- {base-type: type/Text, effective-type: type/Text}
- [Internal Metabase Database, public, v_view_log, entity_qualified_id]
- - field
- {base-type: type/Text, effective-type: type/Text}
- [Internal Metabase Database, public, v_view_log, embedding_client]
- - field
- {base-type: type/Text, effective-type: type/Text}
- [Internal Metabase Database, public, v_view_log, embedding_client_identifier]
- - field
- {base-type: type/Text, effective-type: type/Text}
- [Internal Metabase Database, public, v_view_log, auth_method]
- - field
- {base-type: type/Boolean, effective-type: type/Boolean}
- [Internal Metabase Database, public, v_view_log, is_preview]
- - field
- {base-type: type/Text, effective-type: type/Text}
- [Internal Metabase Database, public, v_view_log, metabase_version]
- - field
- {base-type: type/Text, effective-type: type/Text}
- [Internal Metabase Database, public, v_view_log, embedding_sdk_version]
- - field
- {base-type: type/Integer, effective-type: type/Integer}
- [Internal Metabase Database, public, v_view_log, tenant_id]
- - field
- {base-type: type/Text, effective-type: type/Text}
- [Internal Metabase Database, public, v_view_log, embedding_hostname]
- - field
- {base-type: type/Text, effective-type: type/Text}
- [Internal Metabase Database, public, v_view_log, embedding_path]
- - field
- {base-type: type/Text, effective-type: type/Text}
- [Internal Metabase Database, public, v_view_log, user_agent]
- - field
- {base-type: type/Text, effective-type: type/Text}
- [Internal Metabase Database, public, v_view_log, sanitized_user_agent]
- - field
- {base-type: type/Text, effective-type: type/Text}
- [Internal Metabase Database, public, v_view_log, ip_address]
- - field
- {base-type: type/Text, effective-type: type/Text}
- [Internal Metabase Database, public, v_view_log, context]
order-by:
- - desc
- {}
- - field
- {base-type: type/DateTimeWithLocalTZ, effective-type: type/DateTimeWithLocalTZ}
- [Internal Metabase Database, public, v_view_log, timestamp]
source-table: [Internal Metabase Database, public, v_view_log]
lib/type: mbql.stage/mbql
lib/type: mbql/query
result_metadata:
- base_type: type/Integer
coercion_strategy: null
description: View ID, each question, dashboard, model, collection view generated one new sequential ID.
display_name: ID
effective_type: type/Integer
field_ref:
- field
- [Internal Metabase Database, public, v_view_log, id]
- {base-type: type/Integer}
fk_target_field_id: null
id: [Internal Metabase Database, public, v_view_log, id]
name: id
semantic_type: type/PK
settings: null
visibility_type: normal
- base_type: type/DateTimeWithLocalTZ
coercion_strategy: null
description: When the view happened
display_name: Timestamp
effective_type: type/DateTimeWithLocalTZ
field_ref:
- field
- [Internal Metabase Database, public, v_view_log, timestamp]
- {base-type: type/DateTimeWithLocalTZ, temporal-unit: default}
fk_target_field_id: null
id: [Internal Metabase Database, public, v_view_log, timestamp]
name: timestamp
semantic_type: type/CreationTimestamp
settings: null
unit: default
visibility_type: normal
- base_type: type/Integer
coercion_strategy: null
description: Who viewed the content
display_name: User ID
effective_type: type/Integer
field_ref:
- field
- [Internal Metabase Database, public, v_view_log, user_id]
- {base-type: type/Integer}
fk_target_field_id: [Internal Metabase Database, public, v_users, user_id]
id: [Internal Metabase Database, public, v_view_log, user_id]
name: user_id
semantic_type: type/FK
settings: null
visibility_type: normal
- base_type: type/Text
coercion_strategy: null
description: card (question, model, metric), table, dashboard or collection
display_name: Entity Type
effective_type: type/Text
field_ref:
- field
- [Internal Metabase Database, public, v_view_log, entity_type]
- {base-type: type/Text}
fk_target_field_id: null
id: [Internal Metabase Database, public, v_view_log, entity_type]
name: entity_type
semantic_type: type/Category
settings: null
visibility_type: normal
- base_type: type/Integer
coercion_strategy: null
description: The sequential ID of the card, dashboard, collection
display_name: Entity ID
effective_type: type/Integer
field_ref:
- field
- [Internal Metabase Database, public, v_view_log, entity_id]
- {base-type: type/Integer}
fk_target_field_id: null
id: [Internal Metabase Database, public, v_view_log, entity_id]
name: entity_id
semantic_type: null
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_view_log, entity_qualified_id]
- {base-type: type/Text}
fk_target_field_id: [Internal Metabase Database, public, v_content, entity_qualified_id]
id: [Internal Metabase Database, public, v_view_log, entity_qualified_id]
name: entity_qualified_id
semantic_type: type/FK
settings: null
visibility_type: normal
- base_type: type/Text
coercion_strategy: null
description: null
display_name: Embedding Client
effective_type: type/Text
field_ref:
- field
- [Internal Metabase Database, public, v_view_log, embedding_client]
- {base-type: type/Text}
fk_target_field_id: null
id: [Internal Metabase Database, public, v_view_log, embedding_client]
name: embedding_client
semantic_type: type/Category
settings: null
visibility_type: normal
- base_type: type/Text
coercion_strategy: null
description: null
display_name: Embedding Client Identifier
effective_type: type/Text
field_ref:
- field
- [Internal Metabase Database, public, v_view_log, embedding_client_identifier]
- null
fk_target_field_id: null
id: [Internal Metabase Database, public, v_view_log, embedding_client_identifier]
name: embedding_client_identifier
semantic_type: type/Category
settings: null
visibility_type: normal
- base_type: type/Text
coercion_strategy: null
description: null
display_name: Auth Method
effective_type: type/Text
field_ref:
- field
- [Internal Metabase Database, public, v_view_log, auth_method]
- {base-type: type/Text}
fk_target_field_id: null
id: [Internal Metabase Database, public, v_view_log, auth_method]
name: auth_method
semantic_type: type/Category
settings: null
visibility_type: normal
- base_type: type/Boolean
coercion_strategy: null
description: null
display_name: Is Preview
effective_type: type/Boolean
field_ref:
- field
- [Internal Metabase Database, public, v_view_log, is_preview]
- {base-type: type/Boolean}
fk_target_field_id: null
id: [Internal Metabase Database, public, v_view_log, is_preview]
name: is_preview
semantic_type: type/Category
settings: null
visibility_type: normal
- base_type: type/Text
coercion_strategy: null
description: null
display_name: Metabase Version
effective_type: type/Text
field_ref:
- field
- [Internal Metabase Database, public, v_view_log, metabase_version]
- {base-type: type/Text}
fk_target_field_id: null
id: [Internal Metabase Database, public, v_view_log, metabase_version]
name: metabase_version
semantic_type: type/Category
settings: null
visibility_type: normal
- base_type: type/Text
coercion_strategy: null
description: null
display_name: Embedding SDK Package Version
effective_type: type/Text
field_ref:
- field
- [Internal Metabase Database, public, v_view_log, embedding_sdk_version]
- {base-type: type/Text}
fk_target_field_id: null
id: [Internal Metabase Database, public, v_view_log, embedding_sdk_version]
name: embedding_sdk_version
semantic_type: type/Category
settings: null
visibility_type: normal
- base_type: type/Integer
coercion_strategy: null
description: null
display_name: Tenant ID
effective_type: type/Integer
field_ref:
- field
- [Internal Metabase Database, public, v_view_log, tenant_id]
- {base-type: type/Integer}
fk_target_field_id: [Internal Metabase Database, public, v_tenants, tenant_id]
id: [Internal Metabase Database, public, v_view_log, tenant_id]
name: tenant_id
semantic_type: type/FK
settings: null
visibility_type: normal
- base_type: type/Text
coercion_strategy: null
description: null
display_name: Embedding Hostname
effective_type: type/Text
field_ref:
- field
- [Internal Metabase Database, public, v_view_log, embedding_hostname]
- {base-type: type/Text}
fk_target_field_id: null
id: [Internal Metabase Database, public, v_view_log, embedding_hostname]
name: embedding_hostname
semantic_type: null
settings: null
visibility_type: normal
- base_type: type/Text
coercion_strategy: null
description: null
display_name: Embedding Path
effective_type: type/Text
field_ref:
- field
- [Internal Metabase Database, public, v_view_log, embedding_path]
- {base-type: type/Text}
fk_target_field_id: null
id: [Internal Metabase Database, public, v_view_log, embedding_path]
name: embedding_path
semantic_type: null
settings: null
visibility_type: normal
- base_type: type/Text
coercion_strategy: null
description: null
display_name: User Agent
effective_type: type/Text
field_ref:
- field
- [Internal Metabase Database, public, v_view_log, user_agent]
- {base-type: type/Text}
fk_target_field_id: null
id: [Internal Metabase Database, public, v_view_log, user_agent]
name: user_agent
semantic_type: null
settings: null
visibility_type: normal
- base_type: type/Text
coercion_strategy: null
description: null
display_name: Sanitized User Agent
effective_type: type/Text
field_ref:
- field
- [Internal Metabase Database, public, v_view_log, sanitized_user_agent]
- {base-type: type/Text}
fk_target_field_id: null
id: [Internal Metabase Database, public, v_view_log, sanitized_user_agent]
name: sanitized_user_agent
semantic_type: null
settings: null
visibility_type: normal
- base_type: type/Text
coercion_strategy: null
description: null
display_name: IP Address
effective_type: type/Text
field_ref:
- field
- [Internal Metabase Database, public, v_view_log, ip_address]
- {base-type: type/Text}
fk_target_field_id: null
id: [Internal Metabase Database, public, v_view_log, ip_address]
name: ip_address
semantic_type: type/Category
settings: null
visibility_type: normal
- base_type: type/Text
coercion_strategy: null
description: Context the view happened in (dashboard, collection, etc.). Use to filter out dashcards from top-viewed content.
display_name: Context
effective_type: type/Text
field_ref:
- field
- [Internal Metabase Database, public, v_view_log, context]
- {base-type: type/Text}
fk_target_field_id: null
id: [Internal Metabase Database, public, v_view_log, context]
name: context
semantic_type: type/Category
settings: null
visibility_type: normal
visualization_settings: {column_settings: null, table.cell_column: user_id, table.pivot_column: details}
card_schema: 23
serdes/meta:
- {id: P6Ityjj7igswKh4NgZZjz, label: view_log, model: Card}
type: model