OneLake

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:

1. Your Lakehouse URL(e.g., yoururl.datawarehouse.fabric.microsoft.com  and port (e.g., 1443)

2. ClientID

3. ClientSecret

4. Lakehouse name (optional), e.g. lakehousedev

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

1. Click Manage on the Navigation bar.

2. Select Connectors to view the Manage Connectors screen

3. Click the Create Connector button at the top right

4. Enter a Name for your Connector and a Description (optional)

5. Choose Type > Onelake

6. Add any Integration Metadata needed for programmatic integration.

7. Click Create. Connection test will run and if successful, will show Connection Test Status as Successful.

8. Click Close.