Connect to Databricks

Overview

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

Things to Consider

  • Required User Permissions

    • 'USE_PROVIDER' permission for your Databricks account.

  • Considerations

    • 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.

Steps

 Note

This method of connection is typically used by data professionals.

  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.
    Analytics Delta Sharing1

  6. In Procore, click the Account & Profile icon in the top-right area of the navigation bar.

  7. Click My Profile Settings.

  8. Click the Analytics tab.

  9. Enter your Databricks sharing identifier.
    Clipboard E1d2ed9e3cf25a79f259dba109f03e4ab

  10. Click Connect.
    Note: Once the sharing identifier is added to Procore's system, 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.
    Analytics Delta Sharing2

  11. When your Procore Databricks connection becomes visible in the Shared with me tab, select the Procore Identifier and click Create Catalog.

  12. Enter your preferred name for the shared catalog and click Create.
    Analytics Delta Sharing3

  13. Your shared catalog and tables will now show under the provided name in the Catalog Explorer.
    Analytics Delta Sharing4
    Note: Please reach out to Procore Support if you have any questions or need assistance.

See Also

Loading related articles...