BigQuery Table design | C2C Community

BigQuery Table design

  • 20 August 2021
  • 3 replies

Userlevel 1



I am collecting some data for analytics and the intent is to store it in the BQ DB. Need some guidance on structuring the table so that I can utilize BQ ML for analytics.

I have reviewed the best practices document of do’s and don’ts. What I am interested is in guidance on table design to optimize some repetitive data and some of the data is in JSON. Please reach out if you are in a position to help!


3 replies

Userlevel 7
Badge +26

@jaclyn_wood would someone on your team have some insight here?

Userlevel 1

@Marissa  can I get some assistance with the above question,, This community isn’t what I thought would be collaborate and help each other out. 

Userlevel 5
Badge +8

Hi @Mali , pumping this conversation to the top of the list to see if anybody in the community has the concrete expertise to answer you!.

I’ll have a look to see if I can bring someone with the knowledge to answer your question. Stay tuned!