Welcome to the Alteryx Knowledge Base

Configure Databricks Unity Catalog Volumes in AACP

• Databricks admin access
• AACP admin access

Alteryx Analytics Platforms now supports Unity Catalog volumes as alternative to the personal staging location that has been deprecated by Databricks. The Unity Catalog can now be used as internal staging location for writing data to Databricks from Alteryx Analytics Cloud Platform.

To configure Databricks Unity Catalog as a staging location for your AACP instance, as admin complete the following steps:

1. Generate a Personal Access Token for Databricks admin;
2. Create a new Unity Catalog volume to be assigned to your AACP Databricks workspace;
3. Create a new Databricks workspace in your AACP account;
4. Use your newly created AACP Databricks workspace to configure a new connection;

Step 1: Generate a Personal Access Token for Databricks admin;

1. Navigate to your Databricks account, click on your user icon at the top right corner and click settings:

2. Click Developer

3. Next to Access tokens, click Manage:

4. Click Generate new token:

5. Copy and save the token value:

Step 2: Create a new Unity Catalog volume to be assigned to your AACP Databricks workspace

1. 1. As account admin, go to your Databricks workspace

   2. Navigate to catalog, select a catalog and a schema, and click Create Volume

   3. Specify the volume name, select the volume type and, provide descriptive name, i.e. aacp_volume, and click Create:

4. Save the volume name, you will need it in next steps

Step 3: Create / edit a new Databricks workspace in your AACP account

1. As AACP admin, navigate to your AACP account, click on your user icon and select workspace admin;

2. Next, navigate to Databricks tab and select New workspace:

3. Specify your Databricks workspace url and the personal access token we collected in previous step and click authenticate:

4. In the new workspace configuration, provide a descriptive name for your Databricks workspace in AACP and provide required configuration

5. Select the SQL warehouse

6. In the Unity Catalog Volumes configuration, perform the following steps to configure your AACP workspace with existing volume:

   1. Select Existing volumes option

   2. Select the catalog name of the unity catalog which you created your volume in

   3. Select the schema name which you created your volume in

   4. Select the volume name you created in step 2 of this guide

Note: Here is an option. If you want to create a new volume for your ACCP workspace, you may choose to create a new Volume.

In the Unity Catalog Volumes configuration, perform the following steps to configure your AACP workspace:

1. 1. Select the catalog name of the unity catalog which you created your volume in

   2. Select the schema name which you created your volume in

   3. Provide descriptive name for your Unity Catalog Volume:

1. 4. Provide remaining configuration and click save.

Step 4. Use your newly created AACP Databricks workspace to configure a new connection

1. As an AACP workspace user, navigate to connections:

2. Click create connection and select Databricks from the list of connections

3. Set a descriptive connection name, select the Databricks workspace your admin has configured for you and provide your Personal Access Token (PAT):

4. Click test connection to validate the connection;

5. Save the connection by clicking Create;

As a user, you can now use your newly created Databricks connection in AACP workflow.