Accessing View Data in Excel

The Exponam.Connect Excel Add-in can access two different types of data sets from the Databricks platform: Tables and Views.

Access to both is governed via Databricks Unity Catalog.   For any access, Unity Catalog must be implemented and Delta Sharing must be enabled.

Setting up Views involves more configuration than Tables. 

• The Account must be enabled for Delta Sharing views. 
  • From the Account Console, click Previews and ensure that "Cross-Platform View Sharing" is enabled.
• You must enable Serverless compute for workflows, notebooks, and Delta Live Tables in the account where view sharing is set up. 
  • See instructions: https://docs.databricks.com/en/admin/workspace-settings/serverless.html
• If the view is configured as a dynamic view (i.e. it has filters and/or column masking based upon the user), the view definition must be set for current_recipient() parameters and the current_recipient() values must be associated with the Recipient credential accessing the Delta Sharing View.