Query Funnel data in Databricks through Delta Sharing without copying the data into Databricks. Use this when you want Databricks to read a Funnel export as shared tables.
Before you begin
A Funnel subscription with Delta Sharing exports enabled.
Permission to create exports in the workspace and to create system users on the subscription.
A Databricks workspace with Unity Catalog.
A metastore admin, or a user with the
CREATE PROVIDERandCREATE CATALOGprivileges.
Step 1: (In Funnel) Create a Delta Sharing export
In Funnel, go to Export, click + Create Export and search for Delta Sharing.
In the Data type pane, select Data or Data sources and click Continue.
Data exports your marketing data as a table. Data sources exports details about your connected data sources.
In the Destination pane, enter an Export name, a Schema name and a Table name and click Continue.
Use alphanumeric characters and underscores. The table name must be unique within the schema.
Choose the data, time series, date range, schedule and click Save.
Optionally, you can add notes.
On the export page, click Start. Then click More actions and select Run now.
In the Delta Sharing section, copy Unique share name. You use that name to find the share in Databricks.
Databricks lists the table only after the export run succeeds. Wait for a successful run before you query the table.
Step 2: (In Funnel) Download Delta Sharing credentials
Databricks needs a Delta Sharing credential file to connect to Funnel.
In Funnel, open your profile menu and select Subscription overview.
In the Subscription Management pane, select Users.
Select the System users tab.
Click + Create System user.
Enter a name, select Deltashare and click + Create.
Download the
.sharecredential file.
Keep this file secure. It provides access to your shared data.
Step 3: (In Databricks) Upload the credential file, create a catalog and query the table
Upload the
.sharecredential file that you downloaded in the previous step.
Create a catalog from the share whose name matches the Unique share name you copied in Funnel.
Query the table to verify the connection.
Query the schema and table you named in the Funnel export.
What to expect
The query returns rows from the Funnel export. The catalog is read-only: later export runs update the same table, and the data stays in Funnel. Grant teammates access to the catalog when they need to query it.