Creating Tables in Microsoft Fabric Warehouses

Learn how to create tables in a Fabric data warehouse using T-SQL. Uncover the key differences between the Fabric lakehouse and warehouse in this instructional video. We explore SQL Endpoint's automatic table generation and the control you have in a Data Warehouse. Whether you're a data engineer or analyst, this video is your guide to efficient data management and analysis.
Learn With The Nerds: Creating A Microsoft Fabric End-To-End Solution: • Creating A Microsoft F...
👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Austin30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks...
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2u...
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks...
🔗Pragmatic Works Boot Camps: pragmaticworks...
🔗Pragmatic Works Hackathons: pragmaticworks...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks...
🔗Pragmatic Works Blog: blog.pragmaticw...
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️RUclips: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
Email: [e-mail]
#PragmaticWorks

[@thelastfry23]

Great Video! Just finished your end to end video and went here immediately. I currently use powerBI and a bunch of DAX to calculate out forecasts, I then use analyze in excel to create a table of values by sku, customer by month and copy and paste that in to our planning software. Is there any way to utilize the output of a PBI model in a workbook or query it using sql similar to to how you can use DAX studio?

[@sushils8297]

Hi Austin, Nice video. Is write operatons allowed in lakehouse only using pyspark or R?

[@austinlibal]

Thanks! You're able to write data to a Lakehouse with a Spark Notebook, with a Data Factory Pipeline, or a Dataflow Gen 2.

[@veniciosoliveira9296]

This is duplicating the data or just referencing the data from the lakehouse? And how can be up to date in the warehouse?

[@Kulfi2241]

Nice video 😊

[@austinlibal]

Thanks!

[@Yanjie-cq4pc]

How do you save the work? I can run SQL and it shows the results, but I can't save it anywhere. I can only view it.