Fabric - Combine Multiple Tables into One

[jragan]

We have a Fabric notebook that integrates with an external LMS to create different tables containing user data with similar schemas. I now want to combine the tables into one, taking select columns and performing various conversions across them to the output. I have the SQL written to do everything I need (but I don't have to use SQL) but since Fabric is very visual it doesn't look like there is any kind of a "just run this SQL" kind of transform I can use anywhere... What would be the best way to achieve this?

[v-tangjie-msft · Accepted solution]

Hi @jragan ,

In Microsoft Fabric, a data warehouse provides a relational database for large-scale analytics. Unlike the default read-only SQL endpoint for tables defined in a lakehouse, a data warehouse provides full SQL semantics.

Please refer: mslearn-fabric (microsoftlearning.github.io)

In addition, Apache Spark can also be used in conjunction with laptops to work with SQL data.

Please refer: mslearn-fabric (microsoftlearning.github.io)

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.