Understanding the end-to-end scenario
A warehouse in Microsoft Fabric is a relational data store that organizes data into schemas and tables. There are a few different ways for developers to interact with the data warehouse, which are outlined in Table 4.1. It is important to note that Spark-based operations against the data warehouse, even those leveraging Spark SQL, are read-only, while T-SQL commands issued from the SQL endpoint are read/write:
|
Read-capable on warehouse |
Write-capable on warehouse |
|
|
T-SQL |
Yes |
Yes |
|
Table access via lakehouse shortcut |
Yes |
No |
|
Power BI |
Yes |
No |
|
Data Factory pipelines |
Yes |
... |
