Does transactional database which is migrated to analytical to use with Bigquery and eventually Looker, need to be denormalized for faster queries and higher concurrency?
Thanks!
Does transactional database which is migrated to analytical to use with Bigquery and eventually Looker, need to be denormalized for faster queries and higher concurrency?
Thanks!
I can say "yes", here is the best practice recommended by google. https://cloud.google.com/bigquery/docs/best-practices-performance-input#denormalizing_data