Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I am trying to understand synapse concepts:
When talking about SQL Serverless Pools Managed Tables are not possible, so we have Unamanged or External Tables and Views.
It seems now that I can create a Lake Database for these items or a SQL Database. However since I am using SQL Serverless and all data is stored on Azure Gen2 Data Lake Storage I am wondering what the actual difference between these two types is, since they are also just "Logical" Databases, all data is still stored physically on the Data Lake. When and why would I prefer one scenario over the other? And finally, is there any way of getting managed tables without a dedicated pool?
Greetings
Michael
Hi @mpolonskiy5637 ,
Thanks for using Fabric Community.
Managed vs. External Tables/Views in Serverless SQL Pools:
Lake vs. SQL Database in Serverless SQL Pools:
While both are logical constructs, there are key differences:
Choosing Between Lake and SQL Database:
Hope this is helpful. Please let me know incase of further queries.
Hi @mpolonskiy5637 ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
Otherwise, will respond back with the more details and we will try to help .
Hi @mpolonskiy5637 ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
Otherwise, will respond back with the more details and we will try to help .
Hi @mpolonskiy5637 the difference between Synapse Lake Databaes and Synapse Serverless is that lake databases are spark based, so you can fully manage your reads/writes to tables in lake databases using spark pools. Serverless is t-sql based and is really just for casting structure over data in a data lake and you don't have much in the way of write capabilities.
Lake databases expose their metadata to Serverless as well. So you can create a lake database, create managed or unmanaged tables in the lake database using spark pools, then those tables will be made available for querying using serverless.
think of serverless as more of a read-only service using t-sql
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
Check out the November 2024 Fabric update to learn about new features.
User | Count |
---|---|
5 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
16 | |
7 | |
5 | |
4 | |
3 |