Using a Discover Endpoint with CRM Analytics

CRM Analytics only supports the use of SQL endpoints. To use an SQL endpoint with CRM Analytics, perform the following:

Open Analytics Studio.
Click Create.
Select Dataset from the menu.
Select External Data from the modal.
A new window opens. Select Create New Connection.
On the Select Connector window, scroll down or search for Databricks Connector, select it, and click Next.
Enter the following information and click Save and Test:

Connection Name: Enter a name for the data connection.
Developer Name: Enter the name of the user who is using or managing the data connection.
Description: Provide a description for the data connection.
Token: Enter the user's Authentication Token.
Server: Enter the SQL Host.
HTTPPath: Enter the SQL Path.
Database: Enter the API Catalog and API Schema, separated by a period. Review the example image to ensure proper formatting.
Schema: Enter the API Schema.

Select the objects and fields to use with the new connection and click Save.
The new connection is now saved and available from the Connections menu.
Select the new connection, click Object Options , and select Run Data Sync.
The new connection is now synced and ready to use.

For more information on using CRM Analytics, please review the documentation available here.