Online
v0.9.0
Tables
data_attributes 9849 records
| entity_id | physical_name | origin | data_type | dialect_type | dialect | business_type | business_type_params | data_type_info | order | scale | is_primary_key | is_foreign_key | is_unique | is_nullable | is_autoincrement | is_surrogate_key | is_business_key | is_audit_column | is_scd_column | audit_role | scd_role | pii_level | pcidss_attribute | hipaa_identifier | id | name | description | created_by_id | updated_by_id | created_at | updated_at | version | deleted |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| d1408f5d-2537-4330-a9f0-205672d20652 | price | null | DECIMAL | NUMBER | snowflake | null | null | null | 3 | null | null | null | null | null | null | 3b0dac23-28fe-4a73-8aa7-659f97b6fe67 | price | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| d1408f5d-2537-4330-a9f0-205672d20652 | type | null | STRING | TEXT | snowflake | null | null | null | 2 | null | null | null | null | null | null | 605dbb95-0433-4a45-833b-2bde21b72556 | type | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| d1408f5d-2537-4330-a9f0-205672d20652 | name | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | 44bfded2-9645-450d-898d-fea23eb5568f | name | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| d1408f5d-2537-4330-a9f0-205672d20652 | sku | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | 098cbe4d-5660-4577-84bf-cbd0c07b8485 | sku | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 391ce229-f3af-404a-81e0-09280d98d852 | tax_rate | null | FLOAT | FLOAT | snowflake | null | null | null | 3 | null | null | null | null | null | null | 23ee4ba1-af13-448d-96ce-52463b5b1ff8 | tax_rate | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 391ce229-f3af-404a-81e0-09280d98d852 | opened_at | null | DATETIME | TIMESTAMP_NTZ | snowflake | null | null | null | 2 | null | null | null | null | null | null | 0b551690-0ad3-4287-ac83-0b0e4230e648 | opened_at | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 391ce229-f3af-404a-81e0-09280d98d852 | name | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | 1512030e-c021-4733-987b-f021bbca9f80 | name | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 391ce229-f3af-404a-81e0-09280d98d852 | id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | ca40697e-927d-4028-979d-09a52237cd9a | id | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 2421b5ba-a61b-4cf6-bfa3-fd8344c4ac90 | sku | null | STRING | TEXT | snowflake | null | null | null | 2 | null | null | null | null | null | null | a4669a1c-46f0-4219-9a4a-ee0f5c3ebe2c | sku | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 2421b5ba-a61b-4cf6-bfa3-fd8344c4ac90 | order_id | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | 028323aa-40f1-4928-ad94-b7ce9cd04b6f | order_id | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 2421b5ba-a61b-4cf6-bfa3-fd8344c4ac90 | id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | cc3fb274-47f5-401f-9bae-0861f3e115c5 | id | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| da7c26e2-52e5-4a05-9330-f971f8c1de77 | order_total | null | DECIMAL | NUMBER | snowflake | null | null | null | 6 | null | null | null | null | null | null | 1d808651-ce7b-4fbd-aebc-8b6526bafe9a | order_total | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| da7c26e2-52e5-4a05-9330-f971f8c1de77 | tax_paid | null | DECIMAL | NUMBER | snowflake | null | null | null | 5 | null | null | null | null | null | null | 08072e37-f8c3-4bdd-b182-998cd13a4aab | tax_paid | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| da7c26e2-52e5-4a05-9330-f971f8c1de77 | subtotal | null | DECIMAL | NUMBER | snowflake | null | null | null | 4 | null | null | null | null | null | null | 66db9599-583b-4fac-927e-dc8d9d384338 | subtotal | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| da7c26e2-52e5-4a05-9330-f971f8c1de77 | store_id | null | STRING | TEXT | snowflake | null | null | null | 3 | null | null | null | null | null | null | b5818453-198c-4202-a51c-c2373990071b | store_id | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| da7c26e2-52e5-4a05-9330-f971f8c1de77 | ordered_at | null | DATETIME | TIMESTAMP_NTZ | snowflake | null | null | null | 2 | null | null | null | null | null | null | f032c976-4a9b-4907-ade2-0a76b15baf6a | ordered_at | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| da7c26e2-52e5-4a05-9330-f971f8c1de77 | customer | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | 43eb5786-3927-4586-97f5-7d729a343e58 | customer | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| da7c26e2-52e5-4a05-9330-f971f8c1de77 | id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | 7b337d57-7668-4846-813d-4314f4069d19 | id | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 101f2f0a-68d6-4b9e-9ef7-57f829348b22 | name | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | b2e1cf3d-4601-4a35-8ed8-850738eb16fa | name | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 101f2f0a-68d6-4b9e-9ef7-57f829348b22 | id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | 22e1ef97-91fb-4a3f-952c-e0e671303c87 | id | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 21042441-6e59-481e-945d-21d9d4d49691 | opened_date | null | DATETIME | TIMESTAMP_NTZ | snowflake | null | null | null | 3 | null | null | null | null | null | null | d71b1bb1-c768-4bd9-aa7a-f84ca2546087 | opened_date | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 21042441-6e59-481e-945d-21d9d4d49691 | tax_rate | null | FLOAT | FLOAT | snowflake | null | null | null | 2 | null | null | null | null | null | null | 875d8fb5-e207-430c-a4b6-f597502d8934 | tax_rate | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 21042441-6e59-481e-945d-21d9d4d49691 | location_name | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | 0284feb6-b80e-4b3c-a547-08eb664d25ef | location_name | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 21042441-6e59-481e-945d-21d9d4d49691 | location_id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | 0997a730-1dea-41d9-97f0-2ac7690f1cdc | location_id | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| e9128518-a7e8-4afe-98a8-02b300f1a353 | product_id | null | STRING | TEXT | snowflake | null | null | null | 9 | null | null | null | null | null | null | bfcf795f-33a2-438c-978a-3ac3388226a3 | product_id | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| e9128518-a7e8-4afe-98a8-02b300f1a353 | order_id | null | STRING | TEXT | snowflake | null | null | null | 8 | null | null | null | null | null | null | e33cc8d2-f355-4917-be85-b20282cd878d | order_id | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | |||||||||||
| e9128518-a7e8-4afe-98a8-02b300f1a353 | order_item_id | null | STRING | TEXT | snowflake | null | null | null | 7 | null | null | null | null | null | null | 93a8e0d3-31c5-48fd-890a-ef0cdeb51c38 | order_item_id | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | |||||||||||
| e9128518-a7e8-4afe-98a8-02b300f1a353 | supply_cost | null | DECIMAL | NUMBER | snowflake | null | null | null | 6 | null | null | null | null | null | null | e5b4c92a-360e-4bcf-8d5a-a37ef9163bf6 | supply_cost | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| e9128518-a7e8-4afe-98a8-02b300f1a353 | is_drink_item | null | BOOLEAN | BOOLEAN | snowflake | null | null | null | 5 | null | null | null | null | null | null | eb99ff87-b8af-4098-8939-8f537de5248e | is_drink_item | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| e9128518-a7e8-4afe-98a8-02b300f1a353 | is_food_item | null | BOOLEAN | BOOLEAN | snowflake | null | null | null | 4 | null | null | null | null | null | null | d3da5f62-6d30-49d5-b68e-aba256601f72 | is_food_item | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| e9128518-a7e8-4afe-98a8-02b300f1a353 | product_price | null | DECIMAL | NUMBER | snowflake | null | null | null | 3 | null | null | null | null | null | null | 66962a50-1537-4e05-a731-75ec57bc3032 | product_price | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| e9128518-a7e8-4afe-98a8-02b300f1a353 | product_name | null | STRING | TEXT | snowflake | null | null | null | 2 | null | null | null | null | null | null | d9b23874-b021-40aa-98e9-243a7120ecaa | product_name | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| e9128518-a7e8-4afe-98a8-02b300f1a353 | ordered_at | null | DATETIME | TIMESTAMP_NTZ | snowflake | null | null | null | 1 | null | null | null | null | null | null | d2922576-7d17-44c3-99fd-4af7b2b6c578 | ordered_at | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| e9128518-a7e8-4afe-98a8-02b300f1a353 | * | null | STRING | null | snowflake | null | null | null | 0 | null | null | null | null | null | null | b40bece4-4d82-4b81-a301-bd3c49cea0f3 | * | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 64855201-49f3-440b-b9d6-80251bab5723 | date_day | null | DATE | DATE | snowflake | null | null | null | 0 | null | null | null | null | null | null | e7648bcd-95ed-45be-a316-ab2ce316bbfa | date_day | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 6523419b-95a5-4e7a-9239-befd26484e1e | customer_order_number | null | DECIMAL | NUMBER | snowflake | null | null | null | 18 | null | null | null | null | null | null | ac5fab01-25a0-49ee-97e6-1f3bd55a6b2c | customer_order_number | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 6523419b-95a5-4e7a-9239-befd26484e1e | tax_paid | null | DECIMAL | NUMBER | snowflake | null | null | null | 17 | null | null | null | null | null | null | cb63d52b-c3aa-46be-9b43-570893a37433 | tax_paid | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 6523419b-95a5-4e7a-9239-befd26484e1e | subtotal | null | DECIMAL | NUMBER | snowflake | null | null | null | 16 | null | null | null | null | null | null | c33e61d9-9a6d-4892-95c2-6d18bb309f66 | subtotal | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 6523419b-95a5-4e7a-9239-befd26484e1e | order_total_cents | null | DECIMAL | NUMBER | snowflake | null | null | null | 15 | null | null | null | null | null | null | 722653e2-3dca-4401-8730-2d7d66df4e4b | order_total_cents | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 6523419b-95a5-4e7a-9239-befd26484e1e | tax_paid_cents | null | DECIMAL | NUMBER | snowflake | null | null | null | 14 | null | null | null | null | null | null | 518410ac-e158-408e-9915-fdf10fdba164 | tax_paid_cents | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 6523419b-95a5-4e7a-9239-befd26484e1e | subtotal_cents | null | DECIMAL | NUMBER | snowflake | null | null | null | 13 | null | null | null | null | null | null | 63d74fb3-a7f8-436b-babf-3786b310487f | subtotal_cents | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 6523419b-95a5-4e7a-9239-befd26484e1e | location_id | null | STRING | TEXT | snowflake | null | null | null | 12 | null | null | null | null | null | null | e0476c09-4bc2-4a07-b05f-80374abd2e57 | location_id | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 6523419b-95a5-4e7a-9239-befd26484e1e | ordered_at | null | DATETIME | TIMESTAMP_NTZ | snowflake | null | null | null | 11 | null | null | null | null | null | null | 7b9e1064-216e-4ca5-bcc4-450e08e3808f | ordered_at | The timestamp the order was placed at. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 6523419b-95a5-4e7a-9239-befd26484e1e | order_total | null | DECIMAL | NUMBER | snowflake | null | null | null | 10 | null | null | null | null | null | null | cd82e4d4-65c0-4eb1-b4ce-887529ff250d | order_total | The total amount of the order in USD including tax. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 6523419b-95a5-4e7a-9239-befd26484e1e | customer_id | null | STRING | TEXT | snowflake | null | null | null | 9 | null | null | null | null | null | null | 5484d141-200e-406a-ab4b-0306818755fd | customer_id | The foreign key relating to the customer who placed the order. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 6523419b-95a5-4e7a-9239-befd26484e1e | order_id | null | STRING | TEXT | snowflake | null | null | null | 8 | null | null | null | null | null | null | 55f2c3b9-63db-43b4-a61f-adfe2322121c | order_id | The unique key of the orders mart. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 6523419b-95a5-4e7a-9239-befd26484e1e | is_drink_order | null | BOOLEAN | BOOLEAN | snowflake | null | null | null | 7 | null | null | null | null | null | null | 8815750f-51c0-4577-a4b5-11d69b2a9922 | is_drink_order | A boolean indicating if this order included any drink items. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 6523419b-95a5-4e7a-9239-befd26484e1e | is_food_order | null | BOOLEAN | BOOLEAN | snowflake | null | null | null | 6 | null | null | null | null | null | null | d5e09667-b5b1-486b-b68b-f6790a7fad23 | is_food_order | A boolean indicating if this order included any food items. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 6523419b-95a5-4e7a-9239-befd26484e1e | count_order_items | null | DECIMAL | NUMBER | snowflake | null | null | null | 5 | null | null | null | null | null | null | 30c6b392-9bbf-4ce0-bb35-9dc0d1ae47d2 | count_order_items | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 6523419b-95a5-4e7a-9239-befd26484e1e | count_drink_items | null | DECIMAL | NUMBER | snowflake | null | null | null | 4 | null | null | null | null | null | null | 855e078e-294a-4483-a982-18311832a30f | count_drink_items | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 |