Forum Discussion
Performance question - create a reference table in editor or a calculated table?
Hi all! A performance question. The queries I'm working with are 10 - 20 millions of rows (BigQuery Google Analytics data mostly). I've a few dashboards where I've created a 'bridge table' to ...
Thanks for that. Another observation is that when the dashboard refreshes the reference tables are refreshing as well (as you point out by saying it creates a copy) so that will definitely slow it down.
With regard to your comment about star schema - if I create a separate reference table them I am creating a star schema, right?