Customer 360 - Load the static csv file and create a view

Introduction: Customer 360 - For Combined Reporting View, volume file “/Volumes/agilisium_playground/purgo_playground/customer_360/mll_field_force_brand_mapping.csv” a static CSV file will be loaded to table containing the list of brand names. The SQL logic will then join this static dataset with the vw_ttm_itm_combined_report view to ensure that all valid brand–market combinations for the USA ITM data source are reflected correctly in the output.

 

Requirements: Load a static CSV file “/Volumes/agilisium_playground/purgo_playground/customer_360/mll_field_force_brand_mapping.csv” from volume to table. Use vw_ttm_itm_combined_report as the base view for brand_name and market_name. Apply filtering conditions Only include records where data_source = 'ITM', country_code = 'USA' (case-insensitive). Perform an inner join on brand_name between both datasets. Use case-insensitive and space-trimmed comparison to ensure robust matching.

 

Expected Output: Result should be distinct list of market_name values associated with valid brands.

 

Unity catalog: vw_ttm_itm_combined_report

 

Volume: “/Volumes/agilisium_playground/purgo_playground/customer_360/mll_field_force_brand_mapping.csv”