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