Rather than a storage connector, that connects to a GCP or S3 bucket for example, a Onelake connector is referred to as a database connector. Currently, the Onelake connector is supported for the creation of platform, tabular assets and cannot be used as an export location.
Pre-requisites
To connect your Onelake database, you need:
-
Your Lakehouse URL(e.g., yoururl.datawarehouse.fabric.microsoft.com and port (e.g.,
1443) -
ClientID
-
ClientSecret
-
Lakehouse name (optional), e.g. lakehousedev
-
Minimum Role: Workspace Viewer Role
The Workspace Viewer Role grants the following permissions:
-
Read access to the SQL Analytics Endpoint. All queries are executed through the Lakehouse’s SQL endpoint via JDBC.
-
Read access to system catalog views, which are required for connector discovery.
-
SELECT permission on tables and views, which is required for both the access check and the actual data ingestion.
Create the Connector
-
Click Manage on the Navigation bar.
-
Select Connectors to view the Manage Connectors screen
-
Click the Create Connector button at the top right
-
Enter a Name for your Connector and a Description (optional)
-
Choose Type > Onelake
-
Add any Integration Metadata needed for programmatic integration.
-
Click Create. Connection test will run and if successful, will show Connection Test Status as Successful.
-
Click Close.