Loading speed from data warehouse to BI tool

[larana]

Hello everyone,

I couldn't find a direct answer for this.

Do loading tables from a data warehouse into a BI tool (in my case, qlik sense) will be faster or much faster than loading the tables from an operational database like mysql into qlik sense?

I did load a few tables, one of them on the heavier side from redshift, but it was a "clean" data model so i couldnt compare it to our "messy" one that gets the data from mysql.

(I'm not talking about the transformation phase; only the load phase from the database)

I see quite a few data structures that involve a cloud datalake with a data warehouse that are being absorbed by the BI toll eventually.

Thank you!

[Josef_Gustafson]

Hi @larana ,

As Nanda mentions in this post it is considered best practice to use data warehouses to move data downstream in an application as it is much faster.