Skip to content

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

6.4 KB
Raw Blame
name: Source Model
entity_id: sRcMoDeL00ExAmPlEx001
creator_id: [email protected]
display: table
parameters: []
parameter_mappings: []
dataset_query:
  database: Sample Database
  stages:
  - source-table:
    - Sample Database
    - PUBLIC
    - ORDERS
    lib/type: mbql.stage/mbql
  lib/type: mbql/query
result_metadata:
- active: true
  base_type: type/BigInteger
  database_type: BIGINT
  display_name: ID
  effective_type: type/BigInteger
  field_ref:
  - field
  - - Sample Database
    - PUBLIC
    - ORDERS
    - ID
  - null
  id:
  - Sample Database
  - PUBLIC
  - ORDERS
  - ID
  name: ID
  position: 0
  semantic_type: type/PK
  source: fields
  table_id:
  - Sample Database
  - PUBLIC
  - ORDERS
  visibility_type: normal
  lib/deduplicated-name: ID
  lib/desired-column-alias: ID
  lib/original-display-name: ID
  lib/original-name: ID
  lib/source: source/table-defaults
  lib/source-column-alias: ID
  qp/implicit-field?: true
- active: true
  base_type: type/Integer
  database_type: INTEGER
  display_name: User ID
  effective_type: type/Integer
  field_ref:
  - field
  - - Sample Database
    - PUBLIC
    - ORDERS
    - USER_ID
  - null
  fk_target_field_id:
  - Sample Database
  - PUBLIC
  - PEOPLE
  - ID
  id:
  - Sample Database
  - PUBLIC
  - ORDERS
  - USER_ID
  name: USER_ID
  position: 1
  semantic_type: type/FK
  source: fields
  table_id:
  - Sample Database
  - PUBLIC
  - ORDERS
  visibility_type: normal
  lib/deduplicated-name: USER_ID
  lib/desired-column-alias: USER_ID
  lib/original-display-name: User ID
  lib/original-name: USER_ID
  lib/source: source/table-defaults
  lib/source-column-alias: USER_ID
  qp/implicit-field?: true
- active: true
  base_type: type/Integer
  database_type: INTEGER
  display_name: Product ID
  effective_type: type/Integer
  field_ref:
  - field
  - - Sample Database
    - PUBLIC
    - ORDERS
    - PRODUCT_ID
  - null
  fk_target_field_id:
  - Sample Database
  - PUBLIC
  - PRODUCTS
  - ID
  id:
  - Sample Database
  - PUBLIC
  - ORDERS
  - PRODUCT_ID
  name: PRODUCT_ID
  position: 2
  semantic_type: type/FK
  source: fields
  table_id:
  - Sample Database
  - PUBLIC
  - ORDERS
  visibility_type: normal
  lib/deduplicated-name: PRODUCT_ID
  lib/desired-column-alias: PRODUCT_ID
  lib/original-display-name: Product ID
  lib/original-name: PRODUCT_ID
  lib/source: source/table-defaults
  lib/source-column-alias: PRODUCT_ID
  qp/implicit-field?: true
- active: true
  base_type: type/Float
  database_type: DOUBLE PRECISION
  display_name: Subtotal
  effective_type: type/Float
  field_ref:
  - field
  - - Sample Database
    - PUBLIC
    - ORDERS
    - SUBTOTAL
  - null
  id:
  - Sample Database
  - PUBLIC
  - ORDERS
  - SUBTOTAL
  name: SUBTOTAL
  position: 3
  source: fields
  table_id:
  - Sample Database
  - PUBLIC
  - ORDERS
  visibility_type: normal
  lib/deduplicated-name: SUBTOTAL
  lib/desired-column-alias: SUBTOTAL
  lib/original-display-name: Subtotal
  lib/original-name: SUBTOTAL
  lib/source: source/table-defaults
  lib/source-column-alias: SUBTOTAL
  qp/implicit-field?: true
- active: true
  base_type: type/Float
  database_type: DOUBLE PRECISION
  display_name: Tax
  effective_type: type/Float
  field_ref:
  - field
  - - Sample Database
    - PUBLIC
    - ORDERS
    - TAX
  - null
  id:
  - Sample Database
  - PUBLIC
  - ORDERS
  - TAX
  name: TAX
  position: 4
  source: fields
  table_id:
  - Sample Database
  - PUBLIC
  - ORDERS
  visibility_type: normal
  lib/deduplicated-name: TAX
  lib/desired-column-alias: TAX
  lib/original-display-name: Tax
  lib/original-name: TAX
  lib/source: source/table-defaults
  lib/source-column-alias: TAX
  qp/implicit-field?: true
- active: true
  base_type: type/Float
  database_type: DOUBLE PRECISION
  display_name: Total
  effective_type: type/Float
  field_ref:
  - field
  - - Sample Database
    - PUBLIC
    - ORDERS
    - TOTAL
  - null
  id:
  - Sample Database
  - PUBLIC
  - ORDERS
  - TOTAL
  name: TOTAL
  position: 5
  source: fields
  table_id:
  - Sample Database
  - PUBLIC
  - ORDERS
  visibility_type: normal
  lib/deduplicated-name: TOTAL
  lib/desired-column-alias: TOTAL
  lib/original-display-name: Total
  lib/original-name: TOTAL
  lib/source: source/table-defaults
  lib/source-column-alias: TOTAL
  qp/implicit-field?: true
- active: true
  base_type: type/Float
  database_type: DOUBLE PRECISION
  display_name: Discount
  effective_type: type/Float
  field_ref:
  - field
  - - Sample Database
    - PUBLIC
    - ORDERS
    - DISCOUNT
  - null
  id:
  - Sample Database
  - PUBLIC
  - ORDERS
  - DISCOUNT
  name: DISCOUNT
  position: 6
  semantic_type: type/Discount
  source: fields
  table_id:
  - Sample Database
  - PUBLIC
  - ORDERS
  visibility_type: normal
  lib/deduplicated-name: DISCOUNT
  lib/desired-column-alias: DISCOUNT
  lib/original-display-name: Discount
  lib/original-name: DISCOUNT
  lib/source: source/table-defaults
  lib/source-column-alias: DISCOUNT
  qp/implicit-field?: true
- active: true
  base_type: type/DateTimeWithLocalTZ
  database_type: TIMESTAMP WITH TIME ZONE
  display_name: Created At
  effective_type: type/DateTimeWithLocalTZ
  field_ref:
  - field
  - - Sample Database
    - PUBLIC
    - ORDERS
    - CREATED_AT
  - null
  id:
  - Sample Database
  - PUBLIC
  - ORDERS
  - CREATED_AT
  name: CREATED_AT
  position: 7
  semantic_type: type/CreationTimestamp
  source: fields
  table_id:
  - Sample Database
  - PUBLIC
  - ORDERS
  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/Integer
  database_type: INTEGER
  display_name: Quantity
  effective_type: type/Integer
  field_ref:
  - field
  - - Sample Database
    - PUBLIC
    - ORDERS
    - QUANTITY
  - null
  id:
  - Sample Database
  - PUBLIC
  - ORDERS
  - QUANTITY
  name: QUANTITY
  position: 8
  semantic_type: type/Quantity
  source: fields
  table_id:
  - Sample Database
  - PUBLIC
  - ORDERS
  visibility_type: normal
  lib/deduplicated-name: QUANTITY
  lib/desired-column-alias: QUANTITY
  lib/original-display-name: Quantity
  lib/original-name: QUANTITY
  lib/source: source/table-defaults
  lib/source-column-alias: QUANTITY
  qp/implicit-field?: true
visualization_settings: {}
card_schema: 24
serdes/meta:
- model: Card
metabase_version: v1.57.1-SNAPSHOT (14ff27d)
type: model