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-e301-000000000003 null null STRING VARCHAR null null null null 10 null null null null null null 00000000-demo-bank-a303-000000000011 MONTHLY_PMT Monthly payment 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000003 null null STRING VARCHAR null null null null 9 null null null null null null 00000000-demo-bank-a303-000000000010 TERM_MONTHS Term in months 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000003 null null STRING VARCHAR null null null null 8 null null null null null null 00000000-demo-bank-a303-000000000009 RATE_TYPE Rate type 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000003 null null STRING VARCHAR null null null null 7 null null null null null null 00000000-demo-bank-a303-000000000008 INT_RATE Interest rate 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000003 null null STRING VARCHAR null null null null 6 null null null null null null 00000000-demo-bank-a303-000000000007 CCY_CD Currency code 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000003 null null STRING VARCHAR null null null null 5 null null null null null null 00000000-demo-bank-a303-000000000006 OUTSTAND_AMT Outstanding amount 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000003 null null STRING VARCHAR null null null null 4 null null null null null null 00000000-demo-bank-a303-000000000005 PRINCIPAL_AMT Principal amount 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000003 null null STRING VARCHAR null null null null 3 null null null null null null 00000000-demo-bank-a303-000000000004 LOAN_TYPE Loan type 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000003 null null STRING VARCHAR null null null null 2 null null null null null null 00000000-demo-bank-a303-000000000003 LOAN_NO Loan number 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000003 null null STRING VARCHAR null null null null 1 null null null null null null 00000000-demo-bank-a303-000000000002 LOAN_ID Loan ID 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000003 null null STRING VARCHAR null null null null 0 null null null null null null 00000000-demo-bank-a303-000000000001 RAW_ID Unique raw record identifier 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000002 null null STRING VARCHAR null null null null 18 null null null null null null 00000000-demo-bank-a302-000000000019 _BATCH_ID Batch identifier 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000002 null null STRING VARCHAR null null null null 17 null null null null null null 00000000-demo-bank-a302-000000000018 _SOURCE_FILE Source file name 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000002 null null STRING TIMESTAMP_NTZ null null null null 16 null null null null null null 00000000-demo-bank-a302-000000000017 _LOAD_TS Data load timestamp 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000002 null null STRING VARCHAR null null null null 15 null null null null null null 00000000-demo-bank-a302-000000000016 SRC_UPD_TS Source update timestamp 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000002 null null STRING VARCHAR null null null null 14 null null null null null null 00000000-demo-bank-a302-000000000015 CUST_ID Customer ID 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000002 null null STRING VARCHAR null null null null 13 null null null null null null 00000000-demo-bank-a302-000000000014 PROD_CD Product code 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000002 null null STRING VARCHAR null null null null 12 null null null null null null 00000000-demo-bank-a302-000000000013 BRANCH_CD Branch code 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000002 null null STRING VARCHAR null null null null 11 null null null null null null 00000000-demo-bank-a302-000000000012 STATUS_CD Status code 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000002 null null STRING VARCHAR null null null null 10 null null null null null null 00000000-demo-bank-a302-000000000011 CLOSE_DT Closing date 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000002 null null STRING VARCHAR null null null null 9 null null null null null null 00000000-demo-bank-a302-000000000010 OPEN_DT Opening date 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000002 null null STRING VARCHAR null null null null 8 null null null null null null 00000000-demo-bank-a302-000000000009 INT_RATE Interest rate 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000002 null null STRING VARCHAR null null null null 7 null null null null null null 00000000-demo-bank-a302-000000000008 OD_LIMIT Overdraft limit 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000002 null null STRING VARCHAR null null null null 6 null null null null null null 00000000-demo-bank-a302-000000000007 AVAIL_BAL Available balance 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000002 null null STRING VARCHAR null null null null 5 null null null null null null 00000000-demo-bank-a302-000000000006 CURR_BAL Current balance 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000002 null null STRING VARCHAR null null null null 4 null null null null null null 00000000-demo-bank-a302-000000000005 CCY_CD Currency code 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000002 null null STRING VARCHAR null null null null 3 null null null null null null 00000000-demo-bank-a302-000000000004 ACCT_TYPE Account type 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000002 null null STRING VARCHAR null null null null 2 null null null null null null 00000000-demo-bank-a302-000000000003 ACCT_NO Account number 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000002 null null STRING VARCHAR null null null null 1 null null null null null null 00000000-demo-bank-a302-000000000002 ACCT_ID Account ID 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000002 null null STRING VARCHAR null null null null 0 null null null null null null 00000000-demo-bank-a302-000000000001 RAW_ID Unique raw record identifier 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000001 null null STRING VARCHAR null null null null 18 null null null null null null 00000000-demo-bank-a301-000000000019 _BATCH_ID Batch identifier 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000001 null null STRING VARCHAR null null null null 17 null null null null null null 00000000-demo-bank-a301-000000000018 _SOURCE_FILE Source file name 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000001 null null STRING TIMESTAMP_NTZ null null null null 16 null null null null null null 00000000-demo-bank-a301-000000000017 _LOAD_TS Data load timestamp 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000001 null null STRING VARCHAR null null null null 15 null null null null null null 00000000-demo-bank-a301-000000000016 SRC_UPD_TS Source update timestamp 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000001 null null STRING VARCHAR null null null null 14 null null null null null null 00000000-demo-bank-a301-000000000015 STATUS_CD Status code 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000001 null null STRING VARCHAR null null null null 13 null null null null null null 00000000-demo-bank-a301-000000000014 ONBOARD_DT Onboarding date 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000001 null null STRING VARCHAR null null null null 12 null null null null null null 00000000-demo-bank-a301-000000000013 KYC_STATUS KYC status 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000001 null null STRING VARCHAR null null null null 11 null null null null null null 00000000-demo-bank-a301-000000000012 COUNTRY_CD Country code 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000001 null null STRING VARCHAR null null null null 10 null null null null null null 00000000-demo-bank-a301-000000000011 POSTAL_CD Postal code 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000001 null null STRING VARCHAR null null null null 9 null null null null null null 00000000-demo-bank-a301-000000000010 CITY City 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000001 null null STRING VARCHAR null null null null 8 null null null null null null 00000000-demo-bank-a301-000000000009 ADDR_LINE1 Address line 1 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000001 null null STRING VARCHAR null null null null 7 null null null null null null 00000000-demo-bank-a301-000000000008 TAX_ID Tax ID 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000001 null null STRING VARCHAR null null null null 6 null null null null null null 00000000-demo-bank-a301-000000000007 NAT_ID National ID 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000001 null null STRING VARCHAR null null null null 5 null null null null null null 00000000-demo-bank-a301-000000000006 DOB Date of birth 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000001 null null STRING VARCHAR null null null null 4 null null null null null null 00000000-demo-bank-a301-000000000005 LAST_NM Last name 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000001 null null STRING VARCHAR null null null null 3 null null null null null null 00000000-demo-bank-a301-000000000004 FIRST_NM First name 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000001 null null STRING VARCHAR null null null null 2 null null null null null null 00000000-demo-bank-a301-000000000003 CUST_TYPE Customer type 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000001 null null STRING VARCHAR null null null null 1 null null null null null null 00000000-demo-bank-a301-000000000002 CUST_ID Source customer ID 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1
00000000-demo-bank-e301-000000000001 null null STRING VARCHAR null null null null 0 null null null null null null 00000000-demo-bank-a301-000000000001 RAW_ID Unique raw record identifier 00000000-demo-user-0000-000000000001 00000000-demo-user-0000-000000000001 2026-01-03 15:16:36 2026-01-03 15:16:36 1