Connecting Fivetran with databricks

ashraf1395 — Wed, 22 Jan 2025 06:37:48 GMT

So, We are migrating a hive metastore to UC catalog. We have some fivetran connections.

We are creating all tables as external locations and we have specified the external locations at the schema level.

So when we specify the destination in the fivetran connector. We select the catalog name, schema name

and then we select the dialog box to create external tables. So we are asked to write the external location.

Then how do we have to reference the external location whether just the name or adls/bucket path.

This is what I see at the fivetran page. I don't understand it clearly.

Re: Connecting Fivetran with databricks

NandiniN — Sun, 26 Jan 2025 11:57:47 GMT

This message is just mentioning, if you do not provide the {{path}} it will use the default location which is on DBFS.

When configuring the Fivetran connector, you will be prompted to select the catalog name, schema name, and then specify the external location. In this step, you need to provide the full path to the external location (e.g., abfss://<container>@<account>.dfs.core.windows.net/<path> for ADLS).

topic Re: Connecting Fivetran with databricks in Data Engineering

Connecting Fivetran with databricks

Re: Connecting Fivetran with databricks