Preparing unified view of HCP interactions

Introduction:

 

As a sales representative, I want to access a unified view of all my HCP interactions across channels (email, in-person, webinars), so that I can tailor my pitch and provide more value in my conversations. Given I am preparing for a meeting with an HCP, when I check my dashboard, then I should see a summary of their past interactions, preferences, and engagement history.

 

Requirement:

 

Create Databricks SQL code to drop and create a permanent view which should display all the HCP related information using the use of mapping excel attached below.

 

 

 

Unity catalog information: purgo_playground.hcp_interaction and purgo_playground.customer_360_raw

 

 

 

Expected output: Databricks SQL