Forum Discussion
Cross datawarehouse queries
Hi sana_ali84 ,
Thank you for reaching out to the Microsoft fabric community forum.Running queries across multiple warehouses typically uses more resources than querying within a single warehouse, which can affect both performance and cost. This is due to factors like extra data movement, distributed joins, and coordination between compute engines, all of which can increase query latency and resource consumption.
Because of this, total capacity usage and costs may rise. To address this, consider optimizing queries by applying filters early, reducing data movement, and, where possible, consolidating commonly joined data into one warehouse. Using Fabric’s diagnostics tools can also help you monitor and improve query performance and efficiency.
Hope this helps. Please reach out for further assistance.
Thank you.
Hi sana_ali84 ,
Thank you for reaching out to the Microsoft fabric community forum.
Running queries across multiple warehouses typically uses more resources than querying within a single warehouse, which can affect both performance and cost. This is due to factors like extra data movement, distributed joins, and coordination between compute engines, all of which can increase query latency and resource consumption.
Because of this, total capacity usage and costs may rise. To address this, consider optimizing queries by applying filters early, reducing data movement, and, where possible, consolidating commonly joined data into one warehouse. Using Fabric’s diagnostics tools can also help you monitor and improve query performance and efficiency.
Hope this helps. Please reach out for further assistance.
Thank you.
Yes, thanks for the information. This is usefule information