Skip to main content

Export to Databricks with Delta Sharing (beta)

Connecting to Funnel Data via Databricks Delta Sharing

Delta Sharing allows you to securely access Funnel data directly from Databricks without copying or moving data between systems. Once connected, your Funnel exports appear as tables in Databricks and can be queried using standard Databricks tools.

Beta feature

Delta Sharing for Databricks is currently in beta. While the feature is fully functional, you may experience limitations or changes as we continue to refine the experience. We welcome your feedback as we work toward general availability.

Prerequisites

Before you begin, make sure you have:

  • Access to a Databricks workspace

  • Permissions to create catalogs and install Delta Shares in Databricks

  • Delta Sharing enabled for your Funnel subscription

Step 1: Create a Delta Sharing Export in Funnel

Create a new Delta Sharing export in Funnel. When configuring the export, specify:

  • Schema name – The schema where the table will be created. The name must be unique within the target Databricks catalog.

  • Table name – The name of the exported table. The name must be unique within the schema.

Save the export once configuration is complete and make sure you run it.

Step 2: Generate Delta Sharing Credentials

To connect Databricks to Funnel, you'll need a Delta Sharing credential file.

  1. In Funnel, navigate to Subscription overviewUsers.

  2. Open the System users tab.

  3. Create a new system user and select Deltashare as the user type.

  4. After the system user has been created, click the Download icon to download the .share credential file.

Keep this file secure, as it provides access to your shared data.

Step 3: Install the Share in Databricks

  1. In Databricks, navigate to CatalogDelta SharingShared with me.

  2. Select Install share.

  3. Enter a provider name. This can be any descriptive name, such as funnel.

  4. Upload the .share credential file downloaded from Funnel.

  5. Complete the installation process.

For more information, see the Databricks documentation: https://docs.databricks.com/aws/en/delta-sharing/read-data-open

Step 4: Mount the Share to a Catalog

After the share has been installed:

  1. Select the Funnel share you want to access.

  2. Choose an existing catalog or create a new catalog.

  3. Mount the share to the selected catalog.

Databricks will make the shared schemas and tables available within that catalog.

Step 5: Verify the Connection

  1. Open Catalog Explorer in Databricks.

  2. Navigate to the catalog where you mounted the share.

  3. Locate the schema and table you created in Funnel.

  4. Run a sample query to confirm that data is available.

Example:

SELECT * FROM <catalog_name>.<schema_name>.<table_name> LIMIT 10;

If rows are returned, the connection has been successfully configured.

Did this answer your question?