| title | description | ms.reviewer | ms.author | author | ms.topic | ms.custom | ms.date | ms.search.form | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
What is the SQL analytics endpoint for a lakehouse? |
Learn about the SQL analytics endpoint and how to run SQL queries directly on Fabric lakehouse tables. |
snehagunda |
tvilutis |
tedvilutis |
conceptual |
|
05/13/2024 |
Lakehouse SQL Analytics Endpoint |
Microsoft Fabric provides a SQL-based experience for lakehouse Delta tables. This SQL-based experience is called the SQL analytics endpoint. You can analyze data in Delta tables using T-SQL language, save functions, generate views, and apply SQL security. To access SQL analytics endpoint, you select a corresponding item in the workspace view or switch to SQL analytics endpoint mode in Lakehouse explorer.
Creating a lakehouse creates a SQL analytics endpoint, which points to the lakehouse Delta table storage. Once you create a Delta table in the lakehouse, it's available for querying using the SQL analytics endpoint. To learn more, see Data Warehouse documentation: SQL analytics endpoint.
:::image type="content" source="media\sql-endpoint\main-screen.png" alt-text="Lakehouse SQL analytics endpoint main screen" lightbox="media\sql-endpoint\main-screen.png":::
We offer the ability to retry SQL analytics endpoint provisioning directly within a lakehouse. Therefore if your initial provisioning attempt fails, you have the option to try again without the need to create an entirely new lakehouse. This feature empowers you to self-mitigate provisioning issues in convenient way in the UI avoiding the need for complete lakehouse re-creation.
:::image type="content" source="media\sql-endpoint\SQL-analytics-endpoint-re-provisioning.png" alt-text="Lakehouse SQL analytics endpoint re-provisioning" lightbox="media\sql-endpoint\main-screen.png":::
Note
It's important to note that while this feature improves the user experience, a SQL analytics endpoint re-provisioning can still fail, just as it can during the initial creation of a lakehouse.
The SQL analytics endpoint operates in read-only mode over lakehouse Delta tables. You can only read data from Delta tables using the SQL analytics endpoint. While you can only perform read operations on Delta tables through the SQL analtyics endpoint, you have the flexibility to create functions, define views, and implement SQL object-level security to manage access and structure your data effectively.
Note
External Delta tables created with Spark code won't be visible to the SQL analytics endpoint. Use shortcuts in Table space to make external Delta tables visible to the SQL analytics endpoint.
To modify data in lakehouse Delta tables, you have to switch to lakehouse mode and use Apache Spark.
You can set object-level security for accessing data using SQL analytics endpoint. These security rules will only apply for accessing data via SQL analytics endpoint. To ensure data is not accessible in other ways, you must set workspace roles and permissions, see Workspace roles and permissions.