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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 02e1ae78-3f0d-4f21-85a9-42699738b4ec | price | null | DECIMAL | NUMBER | snowflake | null | null | null | 3 | null | null | null | null | null | null | 267e0a33-f201-4787-9b75-caa3d2e80c41 | 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 | ||||||||||
| 02e1ae78-3f0d-4f21-85a9-42699738b4ec | type | null | STRING | TEXT | snowflake | null | null | null | 2 | null | null | null | null | null | null | 08070ed6-d43a-42d5-9b36-f26de7f7df61 | 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 | ||||||||||
| 02e1ae78-3f0d-4f21-85a9-42699738b4ec | name | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | fa41924d-261d-49e0-98bd-0783ecebd3c3 | 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 | ||||||||||
| 02e1ae78-3f0d-4f21-85a9-42699738b4ec | sku | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | ca009121-a816-4c2d-84f6-4122eb4de400 | sku | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 77687c1c-0cf4-4b16-8d76-3ebf1d18ea50 | tax_rate | null | FLOAT | FLOAT | snowflake | null | null | null | 3 | null | null | null | null | null | null | af234a04-8c5f-4eb9-8d7e-d21cb575d8ca | 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 | ||||||||||
| 77687c1c-0cf4-4b16-8d76-3ebf1d18ea50 | opened_at | null | DATETIME | TIMESTAMP_NTZ | snowflake | null | null | null | 2 | null | null | null | null | null | null | 96c0053e-1281-401d-a8cc-100bb5dc7d86 | opened_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 | ||||||||||
| 77687c1c-0cf4-4b16-8d76-3ebf1d18ea50 | name | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | 33405b54-841c-4c49-9392-fb2e9cc5df00 | 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 | ||||||||||
| 77687c1c-0cf4-4b16-8d76-3ebf1d18ea50 | id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | aa19f457-5d38-4e51-be67-7998b4066a9c | 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 | ||||||||||
| 420533ce-25a8-42a4-883c-80a6a1ffacea | sku | null | STRING | TEXT | snowflake | null | null | null | 2 | null | null | null | null | null | null | bcd73964-33c3-4f31-8ac7-8294d1e53c99 | sku | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 420533ce-25a8-42a4-883c-80a6a1ffacea | order_id | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | 60c1cbe4-a3be-4af9-9ed5-4f71a61ef325 | order_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 | ||||||||||
| 420533ce-25a8-42a4-883c-80a6a1ffacea | id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | bac4cfe9-0fd2-4292-b2bb-dd50bece24ef | 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 | ||||||||||
| a1c11390-1d5d-4d1e-99df-fb206af87d90 | order_total | null | DECIMAL | NUMBER | snowflake | null | null | null | 6 | null | null | null | null | null | null | 9988ccb0-e19c-43de-8534-ef91c653ac41 | 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 | ||||||||||
| a1c11390-1d5d-4d1e-99df-fb206af87d90 | tax_paid | null | DECIMAL | NUMBER | snowflake | null | null | null | 5 | null | null | null | null | null | null | 7f98fc31-6b55-4607-aae5-14c10bca1300 | 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 | ||||||||||
| a1c11390-1d5d-4d1e-99df-fb206af87d90 | subtotal | null | DECIMAL | NUMBER | snowflake | null | null | null | 4 | null | null | null | null | null | null | 21697139-3458-4b7c-a8f7-997299069681 | 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 | ||||||||||
| a1c11390-1d5d-4d1e-99df-fb206af87d90 | store_id | null | STRING | TEXT | snowflake | null | null | null | 3 | null | null | null | null | null | null | b6c1244d-36f7-4268-981c-bf020ad17bce | store_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 | ||||||||||
| a1c11390-1d5d-4d1e-99df-fb206af87d90 | ordered_at | null | DATETIME | TIMESTAMP_NTZ | snowflake | null | null | null | 2 | null | null | null | null | null | null | 0c885080-0fa7-45b4-b5f8-42d3cec4e801 | 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 | ||||||||||
| a1c11390-1d5d-4d1e-99df-fb206af87d90 | customer | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | e853a9cd-3c61-4f44-9c40-30e12b139272 | customer | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| a1c11390-1d5d-4d1e-99df-fb206af87d90 | id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | 2bc0ab44-dbd9-44d1-a782-ec029eaeb708 | 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 | ||||||||||
| 2e739951-e981-400f-86bc-d341df7dea84 | name | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | 3660c529-4b3b-4f07-baad-b6d3bb0e1da4 | 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 | ||||||||||
| 2e739951-e981-400f-86bc-d341df7dea84 | id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | 96b34237-6718-449f-adfc-e3c3b3899ec0 | 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 | ||||||||||
| 75a81c34-8dad-4dc7-bb91-f9f82e9eb8bb | opened_date | null | DATETIME | TIMESTAMP_NTZ | snowflake | null | null | null | 3 | null | null | null | null | null | null | 0cc7f23c-49c2-4436-ab16-5ca07b3d82e5 | 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 | ||||||||||
| 75a81c34-8dad-4dc7-bb91-f9f82e9eb8bb | tax_rate | null | FLOAT | FLOAT | snowflake | null | null | null | 2 | null | null | null | null | null | null | e3a045f9-ce79-44d7-8b7c-a1c926f63410 | 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 | ||||||||||
| 75a81c34-8dad-4dc7-bb91-f9f82e9eb8bb | location_name | null | STRING | TEXT | snowflake | null | null | null | 1 | null | null | null | null | null | null | d37d8b85-0f49-493b-b81b-2244de9aaf83 | 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 | ||||||||||
| 75a81c34-8dad-4dc7-bb91-f9f82e9eb8bb | location_id | null | STRING | TEXT | snowflake | null | null | null | 0 | null | null | null | null | null | null | 35f7e6e7-6ac2-4c96-a6f8-e1bbda5f71a5 | 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 | ||||||||||
| 08218a50-ea53-49d7-b3eb-bbc15c833024 | product_id | null | STRING | TEXT | snowflake | null | null | null | 9 | null | null | null | null | null | null | 43631984-8fcc-4aa5-8f0f-dbb107e33c70 | 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 | ||||||||||
| 08218a50-ea53-49d7-b3eb-bbc15c833024 | order_id | null | STRING | TEXT | snowflake | null | null | null | 8 | null | null | null | null | null | null | 080f16a2-989a-4b75-bb5b-66c0bcee6d3c | order_id | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | |||||||||||
| 08218a50-ea53-49d7-b3eb-bbc15c833024 | order_item_id | null | STRING | TEXT | snowflake | null | null | null | 7 | null | null | null | null | null | null | 91050e8b-cd37-463f-9a2e-093538c9b6d7 | order_item_id | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | |||||||||||
| 08218a50-ea53-49d7-b3eb-bbc15c833024 | supply_cost | null | DECIMAL | NUMBER | snowflake | null | null | null | 6 | null | null | null | null | null | null | 5666aa2b-2a24-4fac-a4a0-7823f73dcf93 | 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 | ||||||||||
| 08218a50-ea53-49d7-b3eb-bbc15c833024 | is_drink_item | null | BOOLEAN | BOOLEAN | snowflake | null | null | null | 5 | null | null | null | null | null | null | 8adb2b24-f05d-49dd-9af8-7c57ed4d7d76 | 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 | ||||||||||
| 08218a50-ea53-49d7-b3eb-bbc15c833024 | is_food_item | null | BOOLEAN | BOOLEAN | snowflake | null | null | null | 4 | null | null | null | null | null | null | ccb5a18e-ce83-4336-bfb0-3c45fc70a94a | 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 | ||||||||||
| 08218a50-ea53-49d7-b3eb-bbc15c833024 | product_price | null | DECIMAL | NUMBER | snowflake | null | null | null | 3 | null | null | null | null | null | null | cdb5e417-1079-498b-b894-a2e1998423b4 | 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 | ||||||||||
| 08218a50-ea53-49d7-b3eb-bbc15c833024 | product_name | null | STRING | TEXT | snowflake | null | null | null | 2 | null | null | null | null | null | null | d2ada01f-786c-42f0-a2f4-7172667e9dd8 | 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 | ||||||||||
| 08218a50-ea53-49d7-b3eb-bbc15c833024 | ordered_at | null | DATETIME | TIMESTAMP_NTZ | snowflake | null | null | null | 1 | null | null | null | null | null | null | 3646c9bf-2fbb-4442-8d62-b3039e8ead6b | 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 | ||||||||||
| 08218a50-ea53-49d7-b3eb-bbc15c833024 | * | null | STRING | null | snowflake | null | null | null | 0 | null | null | null | null | null | null | d057a3e1-5745-489a-be90-f638eb425fc2 | * | null | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| d7a19ded-d932-41c0-9ad8-d129b6ac1245 | date_day | null | DATE | DATE | snowflake | null | null | null | 0 | null | null | null | null | null | null | 08ef95ac-cf92-42a2-8139-d74ee6cc8718 | date_day | 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 | customer_order_number | null | DECIMAL | NUMBER | snowflake | null | null | null | 18 | null | null | null | null | null | null | c0bbe7c8-8395-47f7-98ca-66f5bebafc90 | customer_order_number | 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 | tax_paid | null | DECIMAL | NUMBER | snowflake | null | null | null | 17 | null | null | null | null | null | null | dc170caf-c028-468b-b34a-ba91ef796643 | 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 | ||||||||||
| 25733b02-0b90-44cb-9f09-4c32e3e96461 | subtotal | null | DECIMAL | NUMBER | snowflake | null | null | null | 16 | null | null | null | null | null | null | 74648584-571a-445e-88be-02a91863bd63 | 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_total_cents | null | DECIMAL | NUMBER | snowflake | null | null | null | 15 | null | null | null | null | null | null | 34d2c6fb-1f46-49f4-884e-2073559aeefd | 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 | ||||||||||
| 25733b02-0b90-44cb-9f09-4c32e3e96461 | tax_paid_cents | null | DECIMAL | NUMBER | snowflake | null | null | null | 14 | null | null | null | null | null | null | 8c04912c-3f30-46f2-8438-97fe87c10ed0 | 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 | ||||||||||
| 25733b02-0b90-44cb-9f09-4c32e3e96461 | subtotal_cents | null | DECIMAL | NUMBER | snowflake | null | null | null | 13 | null | null | null | null | null | null | 9586ad9e-b4fb-4d8f-a661-61dfbfc3daac | 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 | ||||||||||
| 25733b02-0b90-44cb-9f09-4c32e3e96461 | location_id | null | STRING | TEXT | snowflake | null | null | null | 12 | null | null | null | null | null | null | 1daa879a-d8dc-40a9-a6b8-27dcd5fdeb55 | 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 | ||||||||||
| 25733b02-0b90-44cb-9f09-4c32e3e96461 | ordered_at | null | DATETIME | TIMESTAMP_NTZ | snowflake | null | null | null | 11 | null | null | null | null | null | null | 5d6bc34e-3a44-46e2-97cc-46231b42befc | ordered_at | The timestamp the order was placed at. | 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_total | null | DECIMAL | NUMBER | snowflake | null | null | null | 10 | null | null | null | null | null | null | 226403c6-a69c-4b95-9491-5bc740071d5d | 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:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 25733b02-0b90-44cb-9f09-4c32e3e96461 | customer_id | null | STRING | TEXT | snowflake | null | null | null | 9 | null | null | null | null | null | null | e9209e9f-53fa-4f6d-9e81-68c1a65e095d | 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:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 25733b02-0b90-44cb-9f09-4c32e3e96461 | order_id | null | STRING | TEXT | snowflake | null | null | null | 8 | null | null | null | null | null | null | 45c99d73-7343-4d02-b5b6-f5f497a716a3 | order_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 | ||||||||||
| 25733b02-0b90-44cb-9f09-4c32e3e96461 | is_drink_order | null | BOOLEAN | BOOLEAN | snowflake | null | null | null | 7 | null | null | null | null | null | null | d0fc61d6-100e-4d7e-8da7-ac47d7e97c1a | 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:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 25733b02-0b90-44cb-9f09-4c32e3e96461 | is_food_order | null | BOOLEAN | BOOLEAN | snowflake | null | null | null | 6 | null | null | null | null | null | null | f48ab4fc-dcfb-4fec-a682-638dc227d9a7 | 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:16:39 | 2026-01-03 15:16:39 | 1 | ||||||||||
| 25733b02-0b90-44cb-9f09-4c32e3e96461 | count_order_items | null | DECIMAL | NUMBER | snowflake | null | null | null | 5 | null | null | null | null | null | null | 559c1c9c-c567-4929-a689-f3f67c6abffc | count_order_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 | count_drink_items | null | DECIMAL | NUMBER | snowflake | null | null | null | 4 | null | null | null | null | null | null | 6cae4e1b-9b1b-43bf-be26-afe50e15311d | count_drink_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 |