What is Lake Database in Synapse Analytics?

The Lake Database can be expressed as Database on top of a Storage which got added to the Synapse workspace Studio in 2022 as a new feature by Microsoft. At first glance, if you read about it then it seems a database which you can create from a template that is prebuilt and exposed to the user from the variety of industries. Well, that’s true that you can just start to design your own data model on top of the Data Lake and it gives you a GUI to map the relationship between the tables you want to create on top of your Azure Storage using Database Designer.

Read More

Polybase in Synapse Analytics?

What is Polybase in Synapse Analytics?
If you have data stored in some external source and you want to read and propagate that chunk of data to your warehouse post transformation or you just want to load it using an INSERT query in any staging table after some simple joins with other tables to form a meaningful data then Polybase would be a good option.

Read More