Edit

What is the SQL analytics endpoint for a Lakehouse?

  • Article

Microsoft Fabrics 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 immediately available for querying using the SQL analytics endpoint. To learn more, see Data Warehouse documentation: SQL analytics endpoint.

Lakehouse SQL analytics endpoint main screen

SQL analytics endpoint reprovisioning

We offer the ability to retry SQL analytics endpoint provisioning directly within the Lakehouse experience. 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 recreation.

Lakehouse SQL analytics endpoint re-provisioning

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.

SQL analytics endpoint read-only mode

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. They can save functions, views, and set SQL object-level security.

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.

Access control using SQL security

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.

Related content