Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: ✅ SQL database in Microsoft Fabric and SQL analytics endpoint
Microsoft Fabric provides a SQL-based experience for SQL database in Fabric data automatically replicated into the OneLake. This SQL-based experience is called the SQL analytics endpoint. You can analyze OneLake 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 SQL database in Fabric explorer.
Creating a SQL database in Fabric creates a SQL analytics endpoint, which points to the SQL database in Fabric Delta table storage. Once you create a transactional table in the SQL database in Fabric, it's available for querying using the SQL analytics endpoint. Using similar technology, a database, warehouse, and Fabric OneLake all automatically provision a SQL analytics endpoint when created.
SQL analytics endpoint is read-only
The SQL analytics endpoint operates in read-only mode over SQL database in Fabric Delta tables. With the SQL analytics endpoint, T-SQL commands can define and query data objects but not manipulate or modify the data. You can create functions, views, and implement SQL object-level security to manage access and structure your data effectively. To modify data in SQL database directly in Fabric Delta tables in the OneLake, use Apache Spark.
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 learn how to create a shortcut, see OneLake shortcuts.
Connect to the SQL analytics endpoint
You can connect to the SQL analytics endpoint via Power BI desktop or client tools such as SQL Server Management Studio or the mssql extension for Visual Studio Code. The SQL analytics endpoint connection string looks like <server-unique-identifier>.<tenant>.fabric.microsoft.com as opposed to the connection string of the SQL database itself, which looks like <server-unique-identifer>.database.windows.net. To find the connection string of the SQL analytics endpoint in the workspace, select the ... menu and then Copy SQL connection string, or find the connection string in Settings in the SQL endpoint page.
You can also query the SQL analytics endpoint in the SQL query editor in the Fabric portal by selecting the SQL analytics endpoint from drop-down list, as shown in the following screenshot:
For more information on connecting to your SQL database data, see Connect to your SQL database in Microsoft Fabric.
Access control using SQL security
You can set object-level security for database users or database roles using (workspace roles or item permissions) in the Fabric portal, or by using GRANT, REVOKE, and DENY Transact-SQL statements. These security rules will only apply for accessing data via SQL analytics endpoint.