Forum Discussion
Fabric - Combine Multiple Tables into One
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?
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.
1 Reply
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.