This page covers what your Databricks administrator sets up. The steps you take inside Inflection are in Import from Data Warehouse and Export to Data Warehouse.
This page covers importing from Databricks over Delta Sharing. If your workspace imports with a service principal, or you need to set up export, see Databricks Setup: Service Principal. To switch your import to the other method, contact your Inflection customer success team.
Prerequisites
For import- A Unity Catalog-enabled Databricks workspace.
- Permission to create and manage shares and recipients in Unity Catalog, and to grant
SELECTon the tables or schemas you want to share. - Inflection’s Databricks metastore identifier:
aws:us-west-2:7bd7c54d-5bf4-41c6-b6c8-752437ed524d
- See Prepare Databricks for Export on the Service Principal page.
Connection Fields
Import connection
No credentials are entered for import. Access is granted entirely through the share.
Network Access
Confirm per workspace. If your workspace restricts access by IP, the Connect step of the import wizard lists Inflection’s IP addresses under Network access (optional).Prepare Databricks for Import
Inflection reads your data through Databricks-to-Databricks Delta Sharing. You stay in control of what is shared, and Inflection receives read-only access to the tables you choose. Inflection never creates objects in your workspace.Step 1: Choose What to Share
Decide which objects Inflection should read:- One or more tables, for example
your_catalog.your_schema.product_activityandyour_catalog.your_schema.contacts. - Or an entire schema in a catalog, for example
your_catalog.your_schema.
Step 2: Create a Share in Unity Catalog
- In Databricks, open the Catalog panel.
- Click the gear icon and choose Delta Sharing.
- Under Shared by me, click Share data.
- Enter a Share name, for example
inflection_prod_share. - Click Save and continue.
- Add the tables or schemas you want to share, then save.
Step 3: Create a Recipient for Inflection
- In Catalog → Delta Sharing, open the Shared by me tab.
- Click New recipient.
- Enter a Recipient name, for example
inflection_recipient. - For Recipient type, select Databricks.
- In Databricks metastore identifier, paste:
aws:us-west-2:7bd7c54d-5bf4-41c6-b6c8-752437ed524d - Save the recipient.
Step 4: Grant the Share to Inflection
- In Catalog → Delta Sharing → Shared by me, click your share.
- Open the Recipients tab.
- Add
inflection_recipientand grant it access.
Views on Databricks
Inflection cannot create a view in your workspace. When you choose We draft a view for you in the wizard, Inflection still drafts the SQL, but you run it yourself:- Click Copy SQL and run the statement in your workspace under the name shown.
- Add the new view to the share you created for Inflection.
- Back in the wizard, click Verify View, or return to the Source stage and pick the shared view with Read it as it is.
Prepare Databricks for Export
Export is set up the same way for every Databricks workspace. See Prepare Databricks for Export on the Service Principal page.Troubleshooting
I chose 'We draft a view for you' and cannot create the view.
I chose 'We draft a view for you' and cannot create the view.
Inflection cannot create objects in your workspace. Run the drafted SQL yourself and add the view to the share, as described in Views on Databricks.