DATADA.AI
Online v0.9.0
Tables
data_attributes 9849 records
Home
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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 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 EMAIL Customer email 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:38 2026-01-03 15:16:38 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:16:38 2026-01-03 15:16:38 1
Page 177 of 197 (9849 total records)