Connect to Databricks

This tutorial will assist you with securely accessing Procore datasets using the Databricks environment.

• Required User Permissions:

  • 'USE_PROVIDER' permission for your Databricks account.

  • 'Admin' level permissions on the Company level Admin tool.

• Additional Information:

  • If you have multiple Procore accounts, you can streamline data access. Once you log in to one of your accounts and use your Databricks identifier, you will be able to retrieve data from all your accessible Procore accounts through that single delta share identifier connection. This eliminates the need to log in from other accounts or add identifiers separately.

1. Retrieve Your Sharing Identifier in Databricks

2. Connect Databricks in Procore

3. Complete Setup in Databricks

1. Log in to your Databricks environment.

2. Navigate to the Catalog section.

3. Select Delta Sharing from the top menu.

4. Select Shared with me.

5. Copy the Sharing Identifier provided for you.
   

1. Log in to Procore.

2. Navigate to the Company level Analytics tool.

3. Locate the Connect Your Data section.

4. In the Databricks Direct Connection card, click Begin Setup.

5. Enter or paste the Sharing Identifier you received from Databricks in the Databricks Identifier text box.

6. Click Connect.
   Note: Once the sharing identifier is added to Procore, the Procore Databricks connection will appear within the Shared with me tab under Providers in your Databricks environment. It may take up to 24 hours to see the data.

1. Return to Databricks and go to the Shared with me tab.

2. Select the Procore Identifier under Providers and click Create Catalog.

3. Enter your preferred name for the shared catalog and click Create.
   

4. Your newly shared catalog and tables will now show under the provided name in the Catalog Explorer.
   
   Note: Reach out to Procore Support if you have any questions or need assistance.