When migrating your existing DW Start schema from traditional RDBMS to Google BigQuery what best practices regarding data modeling one should follow.

So I was able to understand below is good

  1. Deformalize is the key to get fast query response
  2. If Dimension table is conformed and you have multiple fact tables better to keep the that dimension table as a separate table
  3. If you have static dimensions tables which are not conformed, merge them with fact table to de-normalize.
  4. SCD Type 1 dimensions table can be merged with fact table to de-normalize

However, I am not able to understand

  • What to do when you have SCD type 2 dimensions
    • How to handle it if we want to merge them with fact table
    • Should we keep them separate table in BigQuery
  • Does BigQuery have concept of PK/FK to join tables, Is it recommended if not whats the alternative
New contributor
Kuldeep Chitrakar is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

Your Answer

Kuldeep Chitrakar is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.