cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Connecting Fivetran with databricks

ashraf1395
Valued Contributor

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.

ashraf1395_1-1737527775298.png

 

 

1 REPLY 1

NandiniN
Databricks Employee
Databricks Employee

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

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group