Customer 360 – Claim update on Brand “Grazette” on Materialized views

Requirement: Develop SQL logic, Modify the existing claims update logic to populate default for brand_name 'Grazette' and its claim amounts when the claim_amount is 0 or NULL. After the updating table c360_brand_name to reflect the latest values for analytics and dashboard reporting.

 

Update Logic:

 

* for brand_name “Grazette“, if country_code = 'USA' and claim_amount = 0 and set claim_amount = 25000

* for brand_name “Grazette“, if country_code <> 'USA' and claim_amount = 0 and set claim_amount = 20000

 

Final output: Show the result.

 

Prerequisite:

 

1. Drop the table c360_brand_name_clone if exist.
2. Create replica of c360_brand_name table in c360_brand_name_clone table and perform the requirement in the replica table.

 

Unity catalog: c360_brand_name