Azure Synapse Lakehouse with Serverless SQL and Spark Tables Tutorial

SQL developers can easily leverage Big Data power using Azure Synapse Serverless SQL pool with no-code Spark tables to access Parquet files in Azure Data Lake. Learn the fundamentals of building a simple fact table in a Logical Data Warehouse (LDW), then build a Power BI dashboard with your new warehouse.

[@you_dont_know_me_sir]

So concise and yet so detailed. Other KZbinrs should learn from you how to not waste viewers’ time.

[@EdwardKench]

Thank you, Imran! My goal is always to be concise and helpful, so I very much appreciate the feedback!

[@emiliveiga517]

This is by far the best tutorial I've ever seen! Great work! Thank you so much!

[@fabtechcrazy1634]

Very informative video thank you sir

[@samanthamccarthy9765]

Fantastic video . Thank u so much

[@SivaVignesh-xm6lu]

Very good video thank you sir❤

[@codesling3421]

Would you happen to have any knowledge on how to fail over this whole setup to a secondary region?

[@davidruiz4544]

I saw the whole video, I only have one question, how to load all the tables together that are in the parquet folder, instead of loading one by one.

[@mostofamojlish8255]

you have to auto trigger the pipeline

[@7anishok390]

Hi Please help me. I have created an external table in the synapse lake database, Now I like to load the records from the external table into the dedicated SQL pool table. Please advice on the procedure.

[@johnpatrick4185]

Just wondering why you bothered with a pipeline . I think when source data is in the Lake you can use serverless sql to create external tables (parquet) which can feed power bi (with or without views)

[@codesling3421]

@9:27 made it this far with no issues, but when I run my query I get an empty set as a result (only my column headers show) I have a feeling my parquet file is not being created properly (i have made extra sure to carefully follow these steps), thoughts? Also, I notice my CSV gets truncated, the last few rows don't show on the upload preview, is this normal behavior?

[@XboxGamerkings]

same

[@John_F_Ketamine]

Does this read compute and visualize realtime data?