Connecting Fivetran with databricks

[ashraf1395]

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.

[NandiniN · Accepted solution]

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