Skip to content

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

13.8 KB
Raw Blame
name: Tables
description: List of all tables across all connected data sources.
entity_id: x7GwgNdjfzrpQkKTraaqo
created_at: '2023-10-31T21:46:14.039531Z'
creator_id: [email protected]
display: table
collection_id: vG58R8k-QddHWA7_47umn
collection_position: 18
query_type: query
database_id: Internal Metabase Database
table_id: [Internal Metabase Database, public, v_tables]
parameters: []
parameter_mappings: []
dataset_query:
  database: Internal Metabase Database
  stages:
  - source-table: [Internal Metabase Database, public, v_tables]
    lib/type: mbql.stage/mbql
  lib/type: mbql/query
result_metadata:
- active: true
  base_type: type/Integer
  database_type: int4
  display_name: Entity ID
  effective_type: type/Integer
  field_ref:
  - field
  - [Internal Metabase Database, public, v_tables, entity_id]
  - null
  id: [Internal Metabase Database, public, v_tables, entity_id]
  name: entity_id
  position: 0
  semantic_type: type/PK
  source: fields
  table_id: [Internal Metabase Database, public, v_tables]
  visibility_type: normal
  lib/deduplicated-name: entity_id
  lib/desired-column-alias: entity_id
  lib/original-display-name: Entity ID
  lib/original-name: entity_id
  lib/source: source/table-defaults
  lib/source-column-alias: entity_id
  qp/implicit-field?: true
- active: true
  base_type: type/Text
  database_type: text
  display_name: Entity Qualified ID
  effective_type: type/Text
  field_ref:
  - field
  - [Internal Metabase Database, public, v_tables, entity_qualified_id]
  - null
  id: [Internal Metabase Database, public, v_tables, entity_qualified_id]
  name: entity_qualified_id
  position: 1
  semantic_type: type/PK
  source: fields
  table_id: [Internal Metabase Database, public, v_tables]
  visibility_type: normal
  lib/deduplicated-name: entity_qualified_id
  lib/desired-column-alias: entity_qualified_id
  lib/original-display-name: Entity Qualified ID
  lib/original-name: entity_qualified_id
  lib/source: source/table-defaults
  lib/source-column-alias: entity_qualified_id
  qp/implicit-field?: true
- active: true
  base_type: type/DateTimeWithLocalTZ
  database_type: timestamptz
  display_name: Created At
  effective_type: type/DateTimeWithLocalTZ
  field_ref:
  - field
  - [Internal Metabase Database, public, v_tables, created_at]
  - null
  id: [Internal Metabase Database, public, v_tables, created_at]
  name: created_at
  position: 2
  semantic_type: type/CreationTimestamp
  source: fields
  table_id: [Internal Metabase Database, public, v_tables]
  visibility_type: normal
  lib/deduplicated-name: created_at
  lib/desired-column-alias: created_at
  lib/original-display-name: Created At
  lib/original-name: created_at
  lib/source: source/table-defaults
  lib/source-column-alias: created_at
  qp/implicit-field?: true
- active: true
  base_type: type/DateTimeWithLocalTZ
  database_type: timestamptz
  display_name: Updated At
  effective_type: type/DateTimeWithLocalTZ
  field_ref:
  - field
  - [Internal Metabase Database, public, v_tables, updated_at]
  - null
  id: [Internal Metabase Database, public, v_tables, updated_at]
  name: updated_at
  position: 3
  semantic_type: type/UpdatedTimestamp
  source: fields
  table_id: [Internal Metabase Database, public, v_tables]
  visibility_type: normal
  lib/deduplicated-name: updated_at
  lib/desired-column-alias: updated_at
  lib/original-display-name: Updated At
  lib/original-name: updated_at
  lib/source: source/table-defaults
  lib/source-column-alias: updated_at
  qp/implicit-field?: true
- active: true
  base_type: type/Text
  database_type: varchar
  display_name: Name
  effective_type: type/Text
  field_ref:
  - field
  - [Internal Metabase Database, public, v_tables, name]
  - null
  id: [Internal Metabase Database, public, v_tables, name]
  name: name
  position: 4
  semantic_type: type/Name
  source: fields
  table_id: [Internal Metabase Database, public, v_tables]
  visibility_type: normal
  lib/deduplicated-name: name
  lib/desired-column-alias: name
  lib/original-display-name: Name
  lib/original-name: name
  lib/source: source/table-defaults
  lib/source-column-alias: name
  qp/implicit-field?: true
- active: true
  base_type: type/Text
  database_type: varchar
  display_name: Display Name
  effective_type: type/Text
  field_ref:
  - field
  - [Internal Metabase Database, public, v_tables, display_name]
  - null
  id: [Internal Metabase Database, public, v_tables, display_name]
  name: display_name
  position: 5
  semantic_type: type/Name
  source: fields
  table_id: [Internal Metabase Database, public, v_tables]
  visibility_type: normal
  lib/deduplicated-name: display_name
  lib/desired-column-alias: display_name
  lib/original-display-name: Display Name
  lib/original-name: display_name
  lib/source: source/table-defaults
  lib/source-column-alias: display_name
  qp/implicit-field?: true
- active: true
  base_type: type/Text
  database_type: text
  display_name: Description
  effective_type: type/Text
  field_ref:
  - field
  - [Internal Metabase Database, public, v_tables, description]
  - null
  id: [Internal Metabase Database, public, v_tables, description]
  name: description
  position: 6
  semantic_type: type/Description
  source: fields
  table_id: [Internal Metabase Database, public, v_tables]
  visibility_type: normal
  lib/deduplicated-name: description
  lib/desired-column-alias: description
  lib/original-display-name: Description
  lib/original-name: description
  lib/source: source/table-defaults
  lib/source-column-alias: description
  qp/implicit-field?: true
- active: true
  base_type: type/Boolean
  database_type: bool
  description: True if table is available in the data source. False if it not found in sync anymore.
  display_name: Active
  effective_type: type/Boolean
  field_ref:
  - field
  - [Internal Metabase Database, public, v_tables, active]
  - null
  id: [Internal Metabase Database, public, v_tables, active]
  name: active
  position: 7
  semantic_type: type/Category
  source: fields
  table_id: [Internal Metabase Database, public, v_tables]
  visibility_type: normal
  lib/deduplicated-name: active
  lib/desired-column-alias: active
  lib/original-display-name: Active
  lib/original-name: active
  lib/source: source/table-defaults
  lib/source-column-alias: active
  qp/implicit-field?: true
- active: true
  base_type: type/Integer
  database_type: int4
  display_name: Database ID
  effective_type: type/Integer
  field_ref:
  - field
  - [Internal Metabase Database, public, v_tables, database_id]
  - null
  fk_target_field_id: [Internal Metabase Database, public, v_databases, entity_id]
  id: [Internal Metabase Database, public, v_tables, database_id]
  name: database_id
  options: {metabase.query-processor.middleware.add-remaps/original-field-dimension-id: 39}
  position: 8
  remapped_to: name_2
  semantic_type: type/FK
  source: fields
  table_id: [Internal Metabase Database, public, v_tables]
  visibility_type: normal
  lib/deduplicated-name: database_id
  lib/desired-column-alias: database_id
  lib/external-remap: {field-id: 1342, id: 39, name: Database ID, lib/type: metadata.column.remapping/external}
  lib/original-display-name: Database ID
  lib/original-name: database_id
  lib/source: source/table-defaults
  lib/source-column-alias: database_id
  qp/implicit-field?: true
- active: true
  base_type: type/Text
  database_type: varchar
  display_name: Schema
  effective_type: type/Text
  field_ref:
  - field
  - [Internal Metabase Database, public, v_tables, schema]
  - null
  id: [Internal Metabase Database, public, v_tables, schema]
  name: schema
  position: 9
  semantic_type: type/Category
  source: fields
  table_id: [Internal Metabase Database, public, v_tables]
  visibility_type: normal
  lib/deduplicated-name: schema
  lib/desired-column-alias: schema
  lib/original-display-name: Schema
  lib/original-name: schema
  lib/source: source/table-defaults
  lib/source-column-alias: schema
  qp/implicit-field?: true
- active: true
  base_type: type/Boolean
  database_type: bool
  display_name: Is Upload
  effective_type: type/Boolean
  field_ref:
  - field
  - [Internal Metabase Database, public, v_tables, is_upload]
  - null
  id: [Internal Metabase Database, public, v_tables, is_upload]
  name: is_upload
  position: 10
  semantic_type: type/Category
  source: fields
  table_id: [Internal Metabase Database, public, v_tables]
  visibility_type: normal
  lib/deduplicated-name: is_upload
  lib/desired-column-alias: is_upload
  lib/original-display-name: Is Upload
  lib/original-name: is_upload
  lib/source: source/table-defaults
  lib/source-column-alias: is_upload
  qp/implicit-field?: true
- active: true
  base_type: type/Text
  database_type: varchar
  display_name: Entity Type
  effective_type: type/Text
  field_ref:
  - field
  - [Internal Metabase Database, public, v_tables, entity_type]
  - null
  id: [Internal Metabase Database, public, v_tables, entity_type]
  name: entity_type
  position: 11
  semantic_type: type/Category
  source: fields
  table_id: [Internal Metabase Database, public, v_tables]
  visibility_type: normal
  lib/deduplicated-name: entity_type
  lib/desired-column-alias: entity_type
  lib/original-display-name: Entity Type
  lib/original-name: entity_type
  lib/source: source/table-defaults
  lib/source-column-alias: entity_type
  qp/implicit-field?: true
- active: true
  base_type: type/Text
  database_type: varchar
  display_name: Visibility Type
  effective_type: type/Text
  field_ref:
  - field
  - [Internal Metabase Database, public, v_tables, visibility_type]
  - null
  id: [Internal Metabase Database, public, v_tables, visibility_type]
  name: visibility_type
  position: 12
  semantic_type: type/Category
  source: fields
  table_id: [Internal Metabase Database, public, v_tables]
  visibility_type: normal
  lib/deduplicated-name: visibility_type
  lib/desired-column-alias: visibility_type
  lib/original-display-name: Visibility Type
  lib/original-name: visibility_type
  lib/source: source/table-defaults
  lib/source-column-alias: visibility_type
  qp/implicit-field?: true
- active: true
  base_type: type/BigInteger
  database_type: int8
  display_name: Estimated Row Count
  effective_type: type/BigInteger
  field_ref:
  - field
  - [Internal Metabase Database, public, v_tables, estimated_row_count]
  - null
  id: [Internal Metabase Database, public, v_tables, estimated_row_count]
  name: estimated_row_count
  position: 13
  semantic_type: type/Quantity
  source: fields
  table_id: [Internal Metabase Database, public, v_tables]
  visibility_type: normal
  lib/deduplicated-name: estimated_row_count
  lib/desired-column-alias: estimated_row_count
  lib/original-display-name: Estimated Row Count
  lib/original-name: estimated_row_count
  lib/source: source/table-defaults
  lib/source-column-alias: estimated_row_count
  qp/implicit-field?: true
- active: true
  base_type: type/Integer
  database_type: int4
  display_name: View Count
  effective_type: type/Integer
  field_ref:
  - field
  - [Internal Metabase Database, public, v_tables, view_count]
  - null
  id: [Internal Metabase Database, public, v_tables, view_count]
  name: view_count
  position: 14
  semantic_type: type/Quantity
  source: fields
  table_id: [Internal Metabase Database, public, v_tables]
  visibility_type: normal
  lib/deduplicated-name: view_count
  lib/desired-column-alias: view_count
  lib/original-display-name: View Count
  lib/original-name: view_count
  lib/source: source/table-defaults
  lib/source-column-alias: view_count
  qp/implicit-field?: true
- active: true
  base_type: type/Text
  database_type: text
  display_name: Owner Email
  effective_type: type/Text
  field_ref:
  - field
  - [Internal Metabase Database, public, v_tables, owner_email]
  - null
  id: [Internal Metabase Database, public, v_tables, owner_email]
  name: owner_email
  position: 15
  semantic_type: type/Owner
  source: fields
  table_id: [Internal Metabase Database, public, v_tables]
  visibility_type: normal
  lib/deduplicated-name: owner_email
  lib/desired-column-alias: owner_email
  lib/original-display-name: Owner Email
  lib/original-name: owner_email
  lib/source: source/table-defaults
  lib/source-column-alias: owner_email
  qp/implicit-field?: true
- active: true
  base_type: type/Integer
  database_type: int4
  display_name: Owner User ID
  effective_type: type/Integer
  field_ref:
  - field
  - [Internal Metabase Database, public, v_tables, owner_user_id]
  - null
  id: [Internal Metabase Database, public, v_tables, owner_user_id]
  name: owner_user_id
  position: 16
  semantic_type: type/Owner
  source: fields
  table_id: [Internal Metabase Database, public, v_tables]
  visibility_type: normal
  lib/deduplicated-name: owner_user_id
  lib/desired-column-alias: owner_user_id
  lib/original-display-name: Owner User ID
  lib/original-name: owner_user_id
  lib/source: source/table-defaults
  lib/source-column-alias: owner_user_id
  qp/implicit-field?: true
- active: true
  base_type: type/Text
  database_type: varchar
  display_name: Database ID
  effective_type: type/Text
  field_ref:
  - field
  - [Internal Metabase Database, public, v_databases, name]
  - source-field: [Internal Metabase Database, public, v_tables, database_id]
  fk_field_id: 1410
  id: [Internal Metabase Database, public, v_databases, name]
  name: name_2
  options: {metabase.query-processor.middleware.add-remaps/new-field-dimension-id: 39}
  position: 4
  remapped_from: database_id
  semantic_type: type/Name
  source: fields
  table_id: [Internal Metabase Database, public, v_databases]
  visibility_type: normal
  lib/breakout?: false
  lib/deduplicated-name: name_2
  lib/desired-column-alias: v_databases__via__database_id__name
  lib/original-display-name: Name
  lib/original-name: name
  lib/source: source/implicitly-joinable
  lib/source-column-alias: name
  qp/implicit-field?: true
visualization_settings: {column_settings: null, table.cell_column: schema, table.pivot_column: is_upload}
card_schema: 23
serdes/meta:
- {id: x7GwgNdjfzrpQkKTraaqo, label: tables, model: Card}
type: model