DATADA.AI
Online v0.9.0
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-bank-e501-000000000002 null null STRING NUMBER null null null null 0 null null null null null null 00000000-demo-bank-a502-000000000001 ACCOUNT_SK Surrogate key 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null BOOLEAN null null null null null 21 null null null null null null 00000000-demo-bank-a501-000000000022 IS_CURRENT Current record flag 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null STRING TIMESTAMP_NTZ null null null null 20 null null null null null null 00000000-demo-bank-a501-000000000021 EFFECTIVE_TO SCD2 effective to 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null STRING TIMESTAMP_NTZ null null null null 19 null null null null null null 00000000-demo-bank-a501-000000000020 EFFECTIVE_FROM SCD2 effective from 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null STRING VARCHAR null null null null 18 null null null null null null 00000000-demo-bank-a501-000000000019 STATUS Customer status 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null INTEGER null null null null null 17 null null null null null null 00000000-demo-bank-a501-000000000018 TENURE_MONTHS Tenure in months (computed) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null DATE null null null null null 16 null null null null null null 00000000-demo-bank-a501-000000000017 ONBOARDING_DATE Onboarding date 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null STRING VARCHAR null null null null 15 null null null null null null 00000000-demo-bank-a501-000000000016 KYC_STATUS KYC status 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null STRING VARCHAR null null null null 14 null null null null null null 00000000-demo-bank-a501-000000000015 CUSTOMER_SEGMENT Customer segment 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null STRING VARCHAR null null null null 13 null null null null null null 00000000-demo-bank-a501-000000000014 COUNTRY_NAME Country name (denormalized) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null CHAR null null null null null 12 null null null null null null 00000000-demo-bank-a501-000000000013 COUNTRY_CODE Country code 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null STRING VARCHAR null null null null 11 null null null null null null 00000000-demo-bank-a501-000000000012 CITY City 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null STRING VARCHAR null null null null 10 null null null null null null 00000000-demo-bank-a501-000000000011 PHONE_NUMBER Phone number 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null STRING VARCHAR null null null null 9 null null null null null null 00000000-demo-bank-a501-000000000010 EMAIL Email address 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null STRING VARCHAR null null null null 8 null null null null null null 00000000-demo-bank-a501-000000000009 AGE_BAND Age band for analytics 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null INTEGER null null null null null 7 null null null null null null 00000000-demo-bank-a501-000000000008 AGE Current age (computed) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null DATE null null null null null 6 null null null null null null 00000000-demo-bank-a501-000000000007 DATE_OF_BIRTH Date of birth 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null STRING VARCHAR null null null null 5 null null null null null null 00000000-demo-bank-a501-000000000006 FULL_NAME Full name (computed) 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null STRING VARCHAR null null null null 4 null null null null null null 00000000-demo-bank-a501-000000000005 LAST_NAME Last name 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null STRING VARCHAR null null null null 3 null null null null null null 00000000-demo-bank-a501-000000000004 FIRST_NAME First name 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null STRING VARCHAR null null null null 2 null null null null null null 00000000-demo-bank-a501-000000000003 CUSTOMER_TYPE Customer type 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null STRING VARCHAR null null null null 1 null null null null null null 00000000-demo-bank-a501-000000000002 CUSTOMER_BK Business key 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e501-000000000001 null null STRING NUMBER null null null null 0 null null null null null null 00000000-demo-bank-a501-000000000001 CUSTOMER_SK Surrogate key 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000011 null null STRING VARCHAR null null null null 10 null null null null null null 00000000-demo-bank-a311-000000000011 _BATCH_ID Batch identifier 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000011 null null STRING VARCHAR null null null null 9 null null null null null null 00000000-demo-bank-a311-000000000010 _SOURCE_FILE Source file name 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000011 null null STRING TIMESTAMP_NTZ null null null null 8 null null null null null null 00000000-demo-bank-a311-000000000009 _LOAD_TS Data load timestamp 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000011 null null STRING VARCHAR null null null null 7 null null null null null null 00000000-demo-bank-a311-000000000008 SOURCE Rate source 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000011 null null STRING VARCHAR null null null null 6 null null null null null null 00000000-demo-bank-a311-000000000007 EFFECTIVE_DT Effective date 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000011 null null STRING VARCHAR null null null null 5 null null null null null null 00000000-demo-bank-a311-000000000006 RATE Exchange rate 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000011 null null STRING VARCHAR null null null null 4 null null null null null null 00000000-demo-bank-a311-000000000005 RATE_TYPE Rate type 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000011 null null STRING VARCHAR null null null null 3 null null null null null null 00000000-demo-bank-a311-000000000004 TO_CCY To currency 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000011 null null STRING VARCHAR null null null null 2 null null null null null null 00000000-demo-bank-a311-000000000003 FROM_CCY From currency 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000011 null null STRING VARCHAR null null null null 1 null null null null null null 00000000-demo-bank-a311-000000000002 RATE_ID Rate ID 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000011 null null STRING VARCHAR null null null null 0 null null null null null null 00000000-demo-bank-a311-000000000001 RAW_ID Unique raw record identifier 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000010 null null STRING VARCHAR null null null null 8 null null null null null null 00000000-demo-bank-a310-000000000009 _BATCH_ID Batch identifier 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000010 null null STRING VARCHAR null null null null 7 null null null null null null 00000000-demo-bank-a310-000000000008 _SOURCE_FILE Source file name 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000010 null null STRING TIMESTAMP_NTZ null null null null 6 null null null null null null 00000000-demo-bank-a310-000000000007 _LOAD_TS Data load timestamp 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000010 null null STRING VARCHAR null null null null 5 null null null null null null 00000000-demo-bank-a310-000000000006 IS_ACTIVE Active flag 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000010 null null STRING VARCHAR null null null null 4 null null null null null null 00000000-demo-bank-a310-000000000005 DECIMAL_PLACES Decimal places 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000010 null null STRING VARCHAR null null null null 3 null null null null null null 00000000-demo-bank-a310-000000000004 CCY_SYMBOL Currency symbol 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000010 null null STRING VARCHAR null null null null 2 null null null null null null 00000000-demo-bank-a310-000000000003 CCY_NAME Currency name 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000010 null null STRING VARCHAR null null null null 1 null null null null null null 00000000-demo-bank-a310-000000000002 CCY_CD Currency code 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000010 null null STRING VARCHAR null null null null 0 null null null null null null 00000000-demo-bank-a310-000000000001 RAW_ID Unique raw record identifier 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000009 null null STRING VARCHAR null null null null 9 null null null null null null 00000000-demo-bank-a309-000000000010 _BATCH_ID Batch identifier 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000009 null null STRING VARCHAR null null null null 8 null null null null null null 00000000-demo-bank-a309-000000000009 _SOURCE_FILE Source file name 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000009 null null STRING TIMESTAMP_NTZ null null null null 7 null null null null null null 00000000-demo-bank-a309-000000000008 _LOAD_TS Data load timestamp 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000009 null null STRING VARCHAR null null null null 6 null null null null null null 00000000-demo-bank-a309-000000000007 IS_SEPA SEPA flag 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000009 null null STRING VARCHAR null null null null 5 null null null null null null 00000000-demo-bank-a309-000000000006 IS_EU EU flag 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000009 null null STRING VARCHAR null null null null 4 null null null null null null 00000000-demo-bank-a309-000000000005 REGION Region 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1
00000000-demo-bank-e301-000000000009 null null STRING VARCHAR null null null null 3 null null null null null null 00000000-demo-bank-a309-000000000004 COUNTRY_NAME Country name 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:41:28 2026-01-03 15:41:28 1