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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6523419b-95a5-4e7a-9239-befd26484e1e | count_food_items | null | DECIMAL | NUMBER | snowflake | null | null | null | 3 | null | null | null | null | null | null | 42102084-85ca-4efb-bd08-2e822140e479 | count_food_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 | order_items_subtotal | null | DECIMAL | NUMBER | snowflake | null | null | null | 2 | null | null | null | null | null | null | 7fe74bbd-061e-45b2-a3aa-3b820063247a | order_items_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_cost | null | DECIMAL | NUMBER | snowflake | null | null | null | 1 | null | null | null | null | null | null | 294badc6-568c-446d-ac7e-e5ce03f8c22b | order_cost | The sum of supply expenses to fulfill 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 | * | null | STRING | null | snowflake | null | null | null | 0 | null | null | null | null | null | null | a91ec21c-65fd-459f-afe7-3db545dfa61f | * | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 120058b7-8a53-4a13-80c6-b8e8ef0e8d52 | customer_name | null | STRING | TEXT | snowflake | null | null | null | 9 | null | null | null | null | null | null | 8e7413c3-e62d-4ffc-b1de-fde7a39caab8 | customer_name | Customers' full name. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 120058b7-8a53-4a13-80c6-b8e8ef0e8d52 | customer_id | null | STRING | TEXT | snowflake | null | null | null | 8 | null | null | null | null | null | null | e897dd98-4aec-416f-9b68-9de778d9cdbc | customer_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 | ||||||||||
| 120058b7-8a53-4a13-80c6-b8e8ef0e8d52 | customer_type | null | STRING | TEXT | snowflake | null | null | null | 7 | null | null | null | null | null | null | 5ef45256-7924-470a-a8d7-a075dcc10bc0 | customer_type | Options are 'new' or 'returning', indicating if a customer has ordered more than once or has only pl... | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 120058b7-8a53-4a13-80c6-b8e8ef0e8d52 | lifetime_spend | null | DECIMAL | NUMBER | snowflake | null | null | null | 6 | null | null | null | null | null | null | 704dcf10-f0b5-476e-bed6-d1a22d5863a2 | lifetime_spend | The sum of all the order totals (including tax) that a customer has ever placed. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 120058b7-8a53-4a13-80c6-b8e8ef0e8d52 | lifetime_tax_paid | null | DECIMAL | NUMBER | snowflake | null | null | null | 5 | null | null | null | null | null | null | 632eec5b-b4b5-4b9f-b3f7-721321db4711 | lifetime_tax_paid | The sum of all the tax portion of every order a customer has placed. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 120058b7-8a53-4a13-80c6-b8e8ef0e8d52 | lifetime_spend_pretax | null | DECIMAL | NUMBER | snowflake | null | null | null | 4 | null | null | null | null | null | null | 520b7cef-30b5-4723-bdb6-2af6844be454 | lifetime_spend_pretax | The sum of all the pre-tax subtotals of every order a customer has placed. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 120058b7-8a53-4a13-80c6-b8e8ef0e8d52 | last_ordered_at | null | DATETIME | TIMESTAMP_NTZ | snowflake | null | null | null | 3 | null | null | null | null | null | null | f58421ae-72c3-4a49-9dad-926b0b06294b | last_ordered_at | The timestamp of a customer's most recent order. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 120058b7-8a53-4a13-80c6-b8e8ef0e8d52 | first_ordered_at | null | DATETIME | TIMESTAMP_NTZ | snowflake | null | null | null | 2 | null | null | null | null | null | null | b54a0d7d-31e5-4bb5-b271-27acf211b678 | first_ordered_at | The timestamp when a customer placed their first order. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 120058b7-8a53-4a13-80c6-b8e8ef0e8d52 | count_lifetime_orders | null | DECIMAL | NUMBER | snowflake | null | null | null | 1 | null | null | null | null | null | null | 75419944-9028-4df4-84d2-5dc63ce1d645 | count_lifetime_orders | Total number of orders a customer has ever placed. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 120058b7-8a53-4a13-80c6-b8e8ef0e8d52 | * | null | STRING | null | snowflake | null | null | null | 0 | null | null | null | null | null | null | 7cbf3f4b-47df-4875-94b6-528fb9e8677d | * | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| e6410e0a-6ec8-498b-98bf-09f9cfbcab45 | is_drink_item | null | BOOLEAN | BOOLEAN | snowflake | null | null | null | 6 | null | null | null | null | null | null | f09f3a13-7b47-4a89-ab9e-f657693dba65 | 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 | ||||||||||
| e6410e0a-6ec8-498b-98bf-09f9cfbcab45 | is_food_item | null | BOOLEAN | BOOLEAN | snowflake | null | null | null | 5 | null | null | null | null | null | null | c92fb03a-7fdc-4533-9515-8436774f8d00 | 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 | ||||||||||
| e6410e0a-6ec8-498b-98bf-09f9cfbcab45 | product_price | null | DECIMAL | NUMBER | snowflake | null | null | null | 4 | null | null | null | null | null | null | 6344d203-86e2-402b-91e2-e7513d7e7b2b | 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 | ||||||||||
| e6410e0a-6ec8-498b-98bf-09f9cfbcab45 | product_description | null | STRING | TEXT | snowflake | null | null | null | 3 | null | null | null | null | null | null | 8b44bec6-8c3e-4960-a403-b9ef48b66695 | product_description | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| e6410e0a-6ec8-498b-98bf-09f9cfbcab45 | product_type | null | STRING | TEXT | snowflake | null | null | null | 2 | null | null | null | null | null | null | bc8cb2b2-34dd-44e0-b281-0440fe014a98 | product_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 | ||||||||||
| e6410e0a-6ec8-498b-98bf-09f9cfbcab45 | product_name | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | db0d2e47-c21e-42e1-b9d7-f3d09238ccba | 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 | ||||||||||
| e6410e0a-6ec8-498b-98bf-09f9cfbcab45 | product_id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | 6f417edc-6235-45d4-883a-fc71805a6607 | 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 | ||||||||||
| c1fab5e3-b586-41e4-848e-80885d8bcac2 | is_perishable_supply | null | BOOLEAN | BOOLEAN | snowflake | null | null | null | 5 | null | null | null | null | null | null | 5f72a6b8-f089-4856-9e3e-38004d034020 | is_perishable_supply | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| c1fab5e3-b586-41e4-848e-80885d8bcac2 | supply_cost | null | DECIMAL | NUMBER | snowflake | null | null | null | 4 | null | null | null | null | null | null | 996157bc-0b3f-43f5-ba03-2a8ea9dad780 | 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 | ||||||||||
| c1fab5e3-b586-41e4-848e-80885d8bcac2 | supply_name | null | STRING | TEXT | snowflake | null | null | null | 3 | null | null | null | null | null | null | 481e4df4-6f11-4275-815a-27d09020acb6 | supply_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 | ||||||||||
| c1fab5e3-b586-41e4-848e-80885d8bcac2 | product_id | null | STRING | TEXT | snowflake | null | null | null | 2 | null | null | null | null | null | null | 73a264fb-dcaf-4683-984e-41dc165c3221 | 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 | ||||||||||
| c1fab5e3-b586-41e4-848e-80885d8bcac2 | supply_id | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | f9856b3e-0063-4ec7-9746-9f69a6846d1f | supply_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 | ||||||||||
| c1fab5e3-b586-41e4-848e-80885d8bcac2 | supply_uuid | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | 1aa7c2a8-5a2d-47b1-bb37-a24a68cf4c9f | supply_uuid | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| ce2f6e89-a44c-4aa1-911a-fe3769f68718 | opened_date | null | DATETIME | TIMESTAMP_NTZ | snowflake | null | null | null | 3 | null | null | null | null | null | null | 8eab4c0b-7485-4c54-aece-4f2e51bca148 | 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 | ||||||||||
| ce2f6e89-a44c-4aa1-911a-fe3769f68718 | tax_rate | null | FLOAT | FLOAT | snowflake | null | null | null | 2 | null | null | null | null | null | null | 7661d3f3-be93-40dd-a42e-3e62aaa14eb2 | 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 | ||||||||||
| ce2f6e89-a44c-4aa1-911a-fe3769f68718 | location_name | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | b121c542-02bc-4101-8413-435cbe242271 | 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 | ||||||||||
| ce2f6e89-a44c-4aa1-911a-fe3769f68718 | location_id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | d67dafdd-c3bf-48a6-9ac1-cb48e391a166 | location_id | The unique key for each location. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| a0581284-1ecf-4fad-9c72-98a8eeb43fdf | product_id | null | STRING | TEXT | snowflake | null | null | null | 2 | null | null | null | null | null | null | ddd8aad6-a5f6-4326-8205-325da3d7b73e | 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 | ||||||||||
| a0581284-1ecf-4fad-9c72-98a8eeb43fdf | order_id | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | 7e5b98dc-49f3-493f-b2fa-e76ff729e91d | order_id | The corresponding order each order item belongs to | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| a0581284-1ecf-4fad-9c72-98a8eeb43fdf | order_item_id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | e34e41b9-88c6-4ec6-b369-45559fe9cd0d | order_item_id | The unique key for each order item. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| 01f056e2-6947-4d84-b0a1-700d57a9d0ca | ordered_at | null | DATETIME | TIMESTAMP_NTZ | snowflake | null | null | null | 9 | null | null | null | null | null | null | bda04236-150c-434c-9362-32dcec27a441 | 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 | ||||||||||
| 01f056e2-6947-4d84-b0a1-700d57a9d0ca | order_total | null | DECIMAL | NUMBER | snowflake | null | null | null | 8 | null | null | null | null | null | null | dfcf7efc-8ee2-43e2-b9c8-2721face27ca | 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 | ||||||||||
| 01f056e2-6947-4d84-b0a1-700d57a9d0ca | tax_paid | null | DECIMAL | NUMBER | snowflake | null | null | null | 7 | null | null | null | null | null | null | cc2a656b-cb33-4c44-8d9f-3a425ccf3387 | 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 | ||||||||||
| 01f056e2-6947-4d84-b0a1-700d57a9d0ca | subtotal | null | DECIMAL | NUMBER | snowflake | null | null | null | 6 | null | null | null | null | null | null | dc2da1c3-89ee-4c35-8082-68bdf224773d | 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 | ||||||||||
| 01f056e2-6947-4d84-b0a1-700d57a9d0ca | order_total_cents | null | DECIMAL | NUMBER | snowflake | null | null | null | 5 | null | null | null | null | null | null | 2cc43a13-85f3-471f-93d5-8fc3f73c09f9 | 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 | ||||||||||
| 01f056e2-6947-4d84-b0a1-700d57a9d0ca | tax_paid_cents | null | DECIMAL | NUMBER | snowflake | null | null | null | 4 | null | null | null | null | null | null | c2eca1d0-d86d-4ace-b30e-7babcfdc5632 | 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 | ||||||||||
| 01f056e2-6947-4d84-b0a1-700d57a9d0ca | subtotal_cents | null | DECIMAL | NUMBER | snowflake | null | null | null | 3 | null | null | null | null | null | null | f84b3304-934a-4733-a28f-1d6e355b8c4f | 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 | ||||||||||
| 01f056e2-6947-4d84-b0a1-700d57a9d0ca | customer_id | null | STRING | TEXT | snowflake | null | null | null | 2 | null | null | null | null | null | null | 7c1c5548-2f80-4172-9b67-016ae5446d46 | customer_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 | ||||||||||
| 01f056e2-6947-4d84-b0a1-700d57a9d0ca | location_id | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | 8dfa4e3f-b180-48b7-b1bf-0940977a9ce6 | 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 | ||||||||||
| 01f056e2-6947-4d84-b0a1-700d57a9d0ca | order_id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | 3ced2b6b-da2c-4728-9064-efd91bb0ae60 | order_id | The unique key for each order. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| a57f57ff-d4ea-4bd8-881f-bf0b925ec05c | is_perishable_supply | null | BOOLEAN | BOOLEAN | snowflake | null | null | null | 5 | null | null | null | null | null | null | cea35bbb-4778-4cae-880d-bb439e42aca6 | is_perishable_supply | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 | ||||||||||
| a57f57ff-d4ea-4bd8-881f-bf0b925ec05c | supply_cost | null | DECIMAL | NUMBER | snowflake | null | null | null | 4 | null | null | null | null | null | null | 6343b69b-3db3-4e60-aa42-ff2fb034050b | 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 | ||||||||||
| a57f57ff-d4ea-4bd8-881f-bf0b925ec05c | supply_name | null | STRING | TEXT | snowflake | null | null | null | 3 | null | null | null | null | null | null | 77b43ae0-ba32-4599-9aee-54f7d2975d53 | supply_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 | ||||||||||
| a57f57ff-d4ea-4bd8-881f-bf0b925ec05c | product_id | null | STRING | TEXT | snowflake | null | null | null | 2 | null | null | null | null | null | null | e2d7e855-776e-48a6-aeb0-f17f832169c0 | 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 | ||||||||||
| a57f57ff-d4ea-4bd8-881f-bf0b925ec05c | supply_id | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | 8a4b207a-d4e1-4881-9e81-96b9f9c8f1d2 | supply_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 | ||||||||||
| a57f57ff-d4ea-4bd8-881f-bf0b925ec05c | supply_uuid | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | ade2bf0b-96be-45c6-9d5b-a1b007229331 | supply_uuid | The unique key of our supplies per cost. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:31 | 2026-01-03 15:41:31 | 1 |