Flattening BigQuery tables to Analyze in Looker

Hi all,

I am trying to bring the data from my company’s app in BigQuery into Looker so I can then create visualizations out of the data.

The data in BigQuery has a separate table for every single day. The columns are all the same so I’m trying to figure out if there is a way to join all of the individual tables from each day. When I bring the data into Looker, each day is a separate view. Then I am unable to compare data over a period of time because its all separate. I provided some photos for context on how the data looks right now.

I’m thinking that another company building an app may have come across this issue before and may be able to share what they did.

0 2 1,164
2 REPLIES 2
Top Labels in this Space