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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 00000000-demo-ecom-phys-000000000004 | null | null | INTEGER | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-ecom-p004-000000000006 | ORDER_DATE_SK | Order date dimension key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | INTEGER | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-p004-000000000005 | PRODUCT_SK | Product dimension key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | INTEGER | null | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-p004-000000000004 | CUSTOMER_SK | Customer dimension key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-p004-000000000003 | ORDER_ITEM_BK | Order item business key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-p004-000000000002 | ORDER_BK | Order business key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000004 | null | null | INTEGER | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-p004-000000000001 | ORDER_FACT_SK | Surrogate key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000003 | null | null | INTEGER | null | null | null | null | null | 19 | null | null | null | null | null | null | 00000000-demo-ecom-p003-000000000020 | FISCAL_QUARTER | Fiscal quarter | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000003 | null | null | INTEGER | null | null | null | null | null | 18 | null | null | null | null | null | null | 00000000-demo-ecom-p003-000000000019 | FISCAL_YEAR | Fiscal year | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000003 | null | null | BOOLEAN | null | null | null | null | null | 17 | null | null | null | null | null | null | 00000000-demo-ecom-p003-000000000018 | IS_BUSINESS_DAY | Business day flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000003 | null | null | BOOLEAN | null | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-ecom-p003-000000000017 | IS_HOLIDAY | Holiday flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000003 | null | null | BOOLEAN | null | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-ecom-p003-000000000016 | IS_WEEKEND | Weekend flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-ecom-p003-000000000015 | YEAR_QUARTER | Year-Quarter (YYYY-Q#) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000003 | null | null | CHAR | null | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-ecom-p003-000000000014 | YEAR_MONTH | Year-Month (YYYY-MM) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000003 | null | null | INTEGER | null | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-ecom-p003-000000000013 | YEAR | Year | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000003 | null | null | CHAR | null | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-ecom-p003-000000000012 | QUARTER_NAME | Quarter name (Q1-Q4) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000003 | null | null | INTEGER | null | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-ecom-p003-000000000011 | QUARTER | Quarter (1-4) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000003 | null | null | CHAR | null | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-ecom-p003-000000000010 | MONTH_SHORT_NAME | Month short name | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-ecom-p003-000000000009 | MONTH_NAME | Month name | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000003 | null | null | INTEGER | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-ecom-p003-000000000008 | MONTH_NUMBER | Month number | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000003 | null | null | INTEGER | null | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-ecom-p003-000000000007 | WEEK_OF_YEAR | Week of year | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000003 | null | null | INTEGER | null | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-ecom-p003-000000000006 | DAY_OF_YEAR | Day of year | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000003 | null | null | INTEGER | null | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-p003-000000000005 | DAY_OF_MONTH | Day of month | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000003 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-p003-000000000004 | DAY_NAME | Day name | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000003 | null | null | INTEGER | null | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-p003-000000000003 | DAY_OF_WEEK | Day of week (1-7) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000003 | null | null | DATE | null | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-p003-000000000002 | DATE_VALUE | Date value | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000003 | null | null | INTEGER | null | null | null | null | null | 0 | null | null | null | null | null | null | 00000000-demo-ecom-p003-000000000001 | DATE_SK | Surrogate key (YYYYMMDD) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | BOOLEAN | null | null | null | null | null | 24 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000025 | IS_CURRENT | Current record flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 23 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000024 | EFFECTIVE_TO | SCD2 effective to | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | STRING | TIMESTAMP_NTZ | null | null | null | null | 22 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000023 | EFFECTIVE_FROM | SCD2 effective from | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 21 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000022 | STATUS | Customer status | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | BOOLEAN | null | null | null | null | null | 20 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000021 | MARKETING_CONSENT | Marketing consent flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | BOOLEAN | null | null | null | null | null | 19 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000020 | EMAIL_VERIFIED | Email verified flag | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | INTEGER | null | null | null | null | null | 18 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000019 | LOYALTY_POINTS | Current loyalty points | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | INTEGER | null | null | null | null | null | 17 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000018 | TENURE_MONTHS | Tenure in months | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | DATE | null | null | null | null | null | 16 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000017 | REGISTRATION_DATE | Registration date | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 15 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000016 | COUNTRY_NAME | Country name | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | CHAR | null | null | null | null | null | 14 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000015 | COUNTRY_CODE | Country code | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 13 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000014 | STATE | Primary state | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 12 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000013 | CITY | Primary city | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 11 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000012 | CUSTOMER_SEGMENT | Customer segment (VIP, Regular, New) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 10 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000011 | GENDER | Gender | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 9 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000010 | AGE_BAND | Age band for analytics | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | INTEGER | null | null | null | null | null | 8 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000009 | AGE | Current age (computed) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | DATE | null | null | null | null | null | 7 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000008 | DATE_OF_BIRTH | Date of birth | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 6 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000007 | PHONE | Phone number | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 5 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000006 | FULL_NAME | Full name (computed) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 4 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000005 | LAST_NAME | Last name | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000004 | FIRST_NAME | First name | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | ||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000003 | Customer email | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 | |||||||||||
| 00000000-demo-ecom-phys-000000000002 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | 00000000-demo-ecom-p002-000000000002 | CUSTOMER_BK | Business key (customer_id) | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:41:30 | 2026-01-03 15:41:30 | 1 |