write individual sql queries to select these columns from its tables with condition they arent null or empty
RAW_DATA_VAULT.GROUP_RELATIONSHIP.ODPF_GRP_NAME
udm.customer.customer_segment_code
RDV_EOM.customers_eom.GFPF_C4_RTNG
RDV_EOM.customers_eom.GFPF_C5_RTNG
RDV_EOM.customers_eom.GFPF_P3_RTNG
RDV_EOM.customers_eom.GFPF_P1_RTNG
RDV_EOM.customers_eom.GFPF_P2_RTNG
RAW_DATA_VAULT.ADDITIONAL_CSTMR_INFO_FIELDS.CIS024PF_RISK_NO
raw_data_vault.CUSTOMERS.GFPF_P3_RTNG
raw_data_vault.CUSTOMERS.GFPF_P1_RTNG
raw_data_vault.CUSTOMERS.GFPF_P2_RTNG
raw_data_vault.ACCOUNTS.SCPF_P1_RTNG
RAW_DATA_VAULT.ACCOUNTS.SCPF_NMRC_ANLYS_COD
raw_data_vault.INDIVIDUAL_CUSTOMER.CISI02PF_FRST_NME_AR
raw_data_vault.INDIVIDUAL_CUSTOMER.CISI02PF_FTHR_NME_AR
raw_data_vault.INDIVIDUAL_CUSTOMER.CISI02PF_GRND_FTHR_NME_AR
raw_data_vault.INDIVIDUAL_CUSTOMER.CISI02PF_FMLY_NME_AR
raw_data_vault.MINOR_INFO.CISI03PF_MNR_FNME_AR
raw_data_vault.MINOR_INFO.CISI03PF_GRNDFTHR_NME_AR
raw_data_vault.MINOR_INFO.CISI03PF_FMLY_NME_AR
raw_data_vault.NON_INDIVIDUAL_CUSTOMER.CIS016PF_FULL_NAM1
raw_data_vault.NON_INDIVIDUAL_CUSTOMER.CIS016PF_FULL_NAM2
RDV_EOM.customers_eom.GFPF_CSTMR_NAM
raw_data_vault.INDIVIDUAL_CUSTOMER.CISI02PF_FRST_NME_EN
raw_data_vault.INDIVIDUAL_CUSTOMER.CISI02PF_FTHR_NME_EN
raw_data_vault.INDIVIDUAL_CUSTOMER.CISI02PF_GRND_FTHR_NME_EN
raw_data_vault.INDIVIDUAL_CUSTOMER.CISI02PF_FMLY_NME_EN
raw_data_vault.MINOR_INFO.CISI03PF_MNR_FNME_EN
raw_data_vault.MINOR_INFO.CISI03PF_FTHR_NME_EN
raw_data_vault.MINOR_INFO.CISI03PF_GRNDFTHR_NME_EN
raw_data_vault.MINOR_INFO.CISI03PF_FMLY_NME_EN
raw_data_vault.NON_INDIVIDUAL_CUSTOMER.CIS016PF_FULL_NAM_ENG
RDV_EOM.customers_eom.GFPF_CSTMR_NAM
raw_data_vault.IFRS9_SIC_DESCRIPTION.DESCRIPTION
UDM.customer.risk_country
ifrs9.ifrs9_monthly_ecl_file_upload.effective_staging_date
ifrs9.ifrs9_monthly_ecl_file_upload.effective_staging_reason
ifrs9.deals_funded_unfunded_report_all_lg.customer_delinquency_status
--
IFRS9.IFRS9_CUSTOMER_INFO.CUSTOMER_GROUP_NAME
IFRS9.IFRS9_CUSTOMER_INFO.CUSTOMER_SEGMENT
IFRS9.IFRS9_CUSTOMER_INFO.DEFAULT_RISK_RATING
IFRS9.IFRS9_CUSTOMER_INFO.DEFAULT_RISK_RATING
IFRS9.IFRS9_CUSTOMER_INFO.ECONOMIC_SECTOR
IFRS9.IFRS9_CUSTOMER_INFO.FULL_NAME
IFRS9.IFRS9_CUSTOMER_INFO.FULL_NAME_EN
IFRS9.IFRS9_CUSTOMER_INFO.INDUSTRY_SECTOR
IFRS9.IFRS9_CUSTOMER_INFO.RISK_COUNTRY
IFRS9.ifrs9_ecl_file_result_v.EFFECTIVE_STAGING_DATE_CIB
IFRS9.ifrs9_ecl_file_result_v.EFFECTIVE_STAGING_REASON
raw_data_vault.ACCOUNT_BALANCES.COAACBMF_ACCNT_COA_ITM
raw_data_vault.mis_cln_ifrs9.SYSTEM_GRADE
raw_data_vault.mis_cln_ifrs9.SYSTEM_PD
rdv_eom.COMMITMENT_DETAILS.LCPF_CCY or rdv_eom.LIMIT_CONTROL_DETAILS.HHPF_LMT_CCY
rdv_eom.COMMITMENT_DETAILS.LCPF_CMTMNT_REF or derived from rdv_eom.LIMIT_CONTROL_DETAILS.HHPF_LMT_CTGRY + HHPF_CSTMR_MNMNC
rdv_eom.COMMITMENT_DETAILS.LCPF_CMTMNT_SFX
rdv_eom.COMMITMENT_DETAILS.LCPF_CSTMR_MNMNC or rdv_eom.LIMIT_CONTROL_DETAILS.HHPF_CSTMR_MNMNC
rdv_eom.COMMITMENT_DETAILS.LCPF_EXPRY_DTE or rdv_eom.LIMIT_CONTROL_DETAILS.HHPF_LOAD_DATE
rdv_eom.COMMITMENT_DETAILS.LCPF_UNUSED_CMTMNT_AMNT, raw_data_vault.CURRENCY_DAILY.C8PF_MINR_CCY_UNTS
rdv_eom.COMMITMENT_DETAILS.LCPF_UNUSED_CMTMNT_AMNT, raw_data_vault.CURRENCY_DAILY.C8PF_MINR_CCY_UNTS
rdv_eom.COMMITMENT_DETAILS.LCPF_UNUSED_CMTMNT_AMNT, RAW_DATA_VAULT.CURRENCY_DAILY.C8PF_MINR_CCY_UNTS , RAW_DATA_VAULT.CURRENCY_DAILY.C8PF_SPT_RAT_BS_CCY, C8PF_SPT_RAT_RCPRCL
rdv_eom.EXPOSURE_COMPONENT_LINKAGE.HMPF_LMT_CTGRY or rdv_eom.LIMIT_CONTROL_DETAILS.HHPF_LMT_CTGRY
ifrs9.previous_stage.previous_stage_2_
ifrs9.committed_unutilized_v.CLASSIFICATION
ifrs9.committed_unutilized_v.FACILITY_TYPE
ifrs9.committed_unutilized_v.CASH_MARGIN_USD
ifrs9.committed_unutilized_v.EFFECTIVE_INTEREST_RATE
ifrs9.committed_unutilized_v.FACILITY_DPD
ifrs9.ifrs9_monthly_run_data.customer_delinquency_status
IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.customer_group_name
IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.customer_segmant
IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.DEFAULT_RISK_RATING
IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.default_risk_rating
IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.ECONOMIC_SECTOR
IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.full_name
IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.full_name_en
IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.industry_sector
IFRS9.CUSTOMER_EOM_INFO_UNUSED_LIM.risk_country
ifrs9.previous_stage.previous_stage_2_date
ifrs9.previous_stage.previous_stage_2_reason
ifrs9.committed_unutilized_v.COA_ITEM
IFRS9.MRA_DATA.mra
IFRS9.MRA_DATA.system_pd
ifrs9.committed_unutilized_v.FACILITY_CURRENCY
ifrs9.committed_unutilized_v.LCPF_CMTMNT_REF
ifrs9.committed_unutilized_v.SUFFIX
ifrs9.committed_unutilized_v.LCPF_CSTMR_MNMNC
ifrs9.committed_unutilized_v.FACILITY_MATURITY_DATE
ifrs9.committed_unutilized_v.OUTSNDING_BLNC_ORG_CCY
ifrs9.committed_unutilized_v.OUTSNDING_BLNC_USD
ifrs9.committed_unutilized_v.OUTSNDING_BLNC_LCL_CCY
ifrs9.committed_unutilized_v.IMIT_CATEGORY
FACILITY_TYPE or A.FACILITY_START_DATE
FCLTY_LMT_USD or FCLTY_LMT_LCL
IFRS9.rescheduling_restructuring_v.FLAG
IFRS9.rescheduling_restructuring_v.FLAG
ifrs9.committed_unutilized_v.LCPF_CMTMNT_REF
ifrs9.committed_unutilized_v.LCPF_CSTMR_MNMNC
ifrs9.rtng_orign_cmtd_unutlzd_temp.gfpf_ab_rating
RAW_DATA_VAULT.BRANCHES.CAPF_BRNCH_NUMBER
example when rdv_eom.interest_status_account_eom.s5pf_ststcs_clctd
select rdv_eom.interest_status_account_eom.s5pf_ststcs_clctd from rdv_eom.interest_status_account_eom where interest_status_account_eom.s5pf_ststcs_clctd is NULL or interest_status_account_eom.s5pf_ststcs_clctd = ''
fyi all are separate so I only want select statements with where clause for each