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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25733b02-0b90-44cb-9f09-4c32e3e96461 | count_food_items | null | DECIMAL | NUMBER | snowflake | null | null | null | 3 | null | null | null | null | null | null | 2386801e-963d-415d-aac0-7581e8080de8 | count_food_items | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 25733b02-0b90-44cb-9f09-4c32e3e96461 | order_items_subtotal | null | DECIMAL | NUMBER | snowflake | null | null | null | 2 | null | null | null | null | null | null | 65a3b32a-335c-43a0-b840-5d8d5d5edd9f | order_items_subtotal | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 25733b02-0b90-44cb-9f09-4c32e3e96461 | order_cost | null | DECIMAL | NUMBER | snowflake | null | null | null | 1 | null | null | null | null | null | null | 21f56ff8-442b-4f60-bf1e-e56e884271d0 | 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:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 25733b02-0b90-44cb-9f09-4c32e3e96461 | * | null | STRING | null | snowflake | null | null | null | 0 | null | null | null | null | null | null | d2a1f08a-4286-4d81-bbc9-a6d08a3dc33c | * | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| ce31881f-4e2d-49ac-8df6-4c58d10a3941 | customer_name | null | STRING | TEXT | snowflake | null | null | null | 9 | null | null | null | null | null | null | 3c16d95a-3a55-453a-80a6-1c43fc2b8b58 | customer_name | Customers' full name. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| ce31881f-4e2d-49ac-8df6-4c58d10a3941 | customer_id | null | STRING | TEXT | snowflake | null | null | null | 8 | null | null | null | null | null | null | d023d998-3cc1-484e-a4cb-0b7e82bbad41 | customer_id | The unique key of the orders mart. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| ce31881f-4e2d-49ac-8df6-4c58d10a3941 | customer_type | null | STRING | TEXT | snowflake | null | null | null | 7 | null | null | null | null | null | null | c704d8c3-5dac-431c-b5fa-bb5881b06887 | 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:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| ce31881f-4e2d-49ac-8df6-4c58d10a3941 | lifetime_spend | null | DECIMAL | NUMBER | snowflake | null | null | null | 6 | null | null | null | null | null | null | 3423fd0c-326b-4ead-94ef-f4f4827dfb63 | 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:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| ce31881f-4e2d-49ac-8df6-4c58d10a3941 | lifetime_tax_paid | null | DECIMAL | NUMBER | snowflake | null | null | null | 5 | null | null | null | null | null | null | 3833677c-8b92-42aa-b386-50dd48538490 | 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:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| ce31881f-4e2d-49ac-8df6-4c58d10a3941 | lifetime_spend_pretax | null | DECIMAL | NUMBER | snowflake | null | null | null | 4 | null | null | null | null | null | null | 2cafe998-ce39-4eb3-adbf-0e9c494b91c0 | 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:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| ce31881f-4e2d-49ac-8df6-4c58d10a3941 | last_ordered_at | null | DATETIME | TIMESTAMP_NTZ | snowflake | null | null | null | 3 | null | null | null | null | null | null | 3b3a6cc4-2c6d-489f-9b51-91567fd482e0 | 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:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| ce31881f-4e2d-49ac-8df6-4c58d10a3941 | first_ordered_at | null | DATETIME | TIMESTAMP_NTZ | snowflake | null | null | null | 2 | null | null | null | null | null | null | fa73db27-a801-4ea7-bd8b-077f2b14843a | 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:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| ce31881f-4e2d-49ac-8df6-4c58d10a3941 | count_lifetime_orders | null | DECIMAL | NUMBER | snowflake | null | null | null | 1 | null | null | null | null | null | null | f837d2e6-d2e8-41fc-9140-966d56981d39 | 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:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| ce31881f-4e2d-49ac-8df6-4c58d10a3941 | * | null | STRING | null | snowflake | null | null | null | 0 | null | null | null | null | null | null | afdcd521-e5a9-4bfb-a783-c2e73f792631 | * | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| f5127610-f844-47ad-830c-c7d57846b9f7 | is_drink_item | null | BOOLEAN | BOOLEAN | snowflake | null | null | null | 6 | null | null | null | null | null | null | dd60d0b9-cc1f-4ac6-8c8e-fb9ad9fdaf1f | is_drink_item | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| f5127610-f844-47ad-830c-c7d57846b9f7 | is_food_item | null | BOOLEAN | BOOLEAN | snowflake | null | null | null | 5 | null | null | null | null | null | null | b6bda482-3286-4f22-a0e1-f54f9f24ceae | is_food_item | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| f5127610-f844-47ad-830c-c7d57846b9f7 | product_price | null | DECIMAL | NUMBER | snowflake | null | null | null | 4 | null | null | null | null | null | null | dcb98c75-fa08-4d0e-890d-6d67e68fd361 | product_price | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| f5127610-f844-47ad-830c-c7d57846b9f7 | product_description | null | STRING | TEXT | snowflake | null | null | null | 3 | null | null | null | null | null | null | 8b9e6355-98cd-414f-a722-185e64a2a02d | product_description | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| f5127610-f844-47ad-830c-c7d57846b9f7 | product_type | null | STRING | TEXT | snowflake | null | null | null | 2 | null | null | null | null | null | null | 41f38619-56ec-4210-b8c9-89963549d519 | product_type | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| f5127610-f844-47ad-830c-c7d57846b9f7 | product_name | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | 0c36a115-83b1-4f9f-b981-22d4f9d88384 | product_name | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| f5127610-f844-47ad-830c-c7d57846b9f7 | product_id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | d988bacb-813f-4dc9-909c-1754f8d91b23 | product_id | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| a728a5a1-873e-49a8-ae9c-cf352c56cdfb | is_perishable_supply | null | BOOLEAN | BOOLEAN | snowflake | null | null | null | 5 | null | null | null | null | null | null | b4e4da89-08b4-498e-98e0-ed25089304f8 | is_perishable_supply | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| a728a5a1-873e-49a8-ae9c-cf352c56cdfb | supply_cost | null | DECIMAL | NUMBER | snowflake | null | null | null | 4 | null | null | null | null | null | null | bbfb5c8c-a66f-434e-b23e-9488f90a431f | supply_cost | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| a728a5a1-873e-49a8-ae9c-cf352c56cdfb | supply_name | null | STRING | TEXT | snowflake | null | null | null | 3 | null | null | null | null | null | null | 2684fe22-a329-4fde-8097-0bb9a0bae93c | supply_name | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| a728a5a1-873e-49a8-ae9c-cf352c56cdfb | product_id | null | STRING | TEXT | snowflake | null | null | null | 2 | null | null | null | null | null | null | 3c712290-e8ce-4de3-a9fa-1e9e5806c5f8 | product_id | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| a728a5a1-873e-49a8-ae9c-cf352c56cdfb | supply_id | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | 36080888-803c-4485-a636-1bee9af9633d | supply_id | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| a728a5a1-873e-49a8-ae9c-cf352c56cdfb | supply_uuid | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | f2c62df7-0dfe-467d-9f24-91308a210271 | supply_uuid | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 3954e987-8f57-457e-a057-d4ea58242f4d | opened_date | null | DATETIME | TIMESTAMP_NTZ | snowflake | null | null | null | 3 | null | null | null | null | null | null | be1ed982-7d29-484f-8437-17d15bfd4d95 | opened_date | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 3954e987-8f57-457e-a057-d4ea58242f4d | tax_rate | null | FLOAT | FLOAT | snowflake | null | null | null | 2 | null | null | null | null | null | null | a0631fd9-141c-4d0c-b5ce-0d3de53ff6b1 | tax_rate | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 3954e987-8f57-457e-a057-d4ea58242f4d | location_name | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | 0e46a240-33b6-4f19-895e-a9478c3bb412 | location_name | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 3954e987-8f57-457e-a057-d4ea58242f4d | location_id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | 8a43ae49-c02d-40df-9768-ee01087e0870 | location_id | The unique key for each location. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| c7902b71-d3b0-4722-b542-b109e0c2e5b1 | product_id | null | STRING | TEXT | snowflake | null | null | null | 2 | null | null | null | null | null | null | 7c71597a-b15b-4642-a27f-60d492a8e068 | product_id | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| c7902b71-d3b0-4722-b542-b109e0c2e5b1 | order_id | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | ae950618-ac14-4853-9442-a8d6c47de20d | order_id | The corresponding order each order item belongs to | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| c7902b71-d3b0-4722-b542-b109e0c2e5b1 | order_item_id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | 35edb0a9-b103-4367-a83b-c8223a57dcdf | order_item_id | The unique key for each order item. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 187d6bdc-2248-4610-842b-645ebfb65906 | ordered_at | null | DATETIME | TIMESTAMP_NTZ | snowflake | null | null | null | 9 | null | null | null | null | null | null | 895ba132-d389-47f9-86b6-7ca8a4eaf1b1 | ordered_at | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 187d6bdc-2248-4610-842b-645ebfb65906 | order_total | null | DECIMAL | NUMBER | snowflake | null | null | null | 8 | null | null | null | null | null | null | 958dc11c-df1a-4d2f-8a74-7bb34385b398 | order_total | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 187d6bdc-2248-4610-842b-645ebfb65906 | tax_paid | null | DECIMAL | NUMBER | snowflake | null | null | null | 7 | null | null | null | null | null | null | 7d00f297-d6f3-4a1a-8c5f-dfaf4395cdd2 | tax_paid | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 187d6bdc-2248-4610-842b-645ebfb65906 | subtotal | null | DECIMAL | NUMBER | snowflake | null | null | null | 6 | null | null | null | null | null | null | 8090ecfb-4c4f-4be9-994e-e4e9618bf0c3 | subtotal | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 187d6bdc-2248-4610-842b-645ebfb65906 | order_total_cents | null | DECIMAL | NUMBER | snowflake | null | null | null | 5 | null | null | null | null | null | null | bf9d60da-95d6-444c-8ea2-dc6648d4f3c9 | order_total_cents | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 187d6bdc-2248-4610-842b-645ebfb65906 | tax_paid_cents | null | DECIMAL | NUMBER | snowflake | null | null | null | 4 | null | null | null | null | null | null | 609fa9e9-5ab6-4ba5-aee4-18fa41792518 | tax_paid_cents | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 187d6bdc-2248-4610-842b-645ebfb65906 | subtotal_cents | null | DECIMAL | NUMBER | snowflake | null | null | null | 3 | null | null | null | null | null | null | 8e4dec2d-40fc-47fc-a893-3daf8cd3ddf2 | subtotal_cents | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 187d6bdc-2248-4610-842b-645ebfb65906 | customer_id | null | STRING | TEXT | snowflake | null | null | null | 2 | null | null | null | null | null | null | b6406eed-45cf-4727-af73-6fd901a8a92c | customer_id | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 187d6bdc-2248-4610-842b-645ebfb65906 | location_id | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | 06a1a304-b2ec-4420-8a17-05e602b8dfc5 | location_id | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 187d6bdc-2248-4610-842b-645ebfb65906 | order_id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | 6b9f90ae-b855-47eb-9cb8-df4e6aa384e9 | order_id | The unique key for each order. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 7781efd9-d4e5-4695-8371-dc2ecbe38232 | is_perishable_supply | null | BOOLEAN | BOOLEAN | snowflake | null | null | null | 5 | null | null | null | null | null | null | 772308c9-a9cc-4c79-b1f8-10ef372de765 | is_perishable_supply | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 7781efd9-d4e5-4695-8371-dc2ecbe38232 | supply_cost | null | DECIMAL | NUMBER | snowflake | null | null | null | 4 | null | null | null | null | null | null | 64fa94a3-d10e-42ee-be58-a7dec2e4bc90 | supply_cost | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 7781efd9-d4e5-4695-8371-dc2ecbe38232 | supply_name | null | STRING | TEXT | snowflake | null | null | null | 3 | null | null | null | null | null | null | ad0e0ef2-3dc8-4af9-8d2c-53d678c9c058 | supply_name | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 7781efd9-d4e5-4695-8371-dc2ecbe38232 | product_id | null | STRING | TEXT | snowflake | null | null | null | 2 | null | null | null | null | null | null | d375772e-b398-46a1-9429-2c4afc15bc9a | product_id | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 7781efd9-d4e5-4695-8371-dc2ecbe38232 | supply_id | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | a16f3a64-31ed-40c6-a202-40434b3f0dd1 | supply_id | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 7781efd9-d4e5-4695-8371-dc2ecbe38232 | supply_uuid | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | 6dc09e49-589d-4807-a3b9-7ee6bf3535fd | supply_uuid | The unique key of our supplies per cost. | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 |