Best Of

For anyone who needs to know this in the future, here's who we ultimately solved for this:

1. If I use Domo to directly connect to a table in BigQuery, it's only one single day's data. I'd have to set up a different dataset/connection for each new day- absolutely not sustainable. Is there a different solution than to create a new view in BigQuery with all the days' data?

We made a combined table in BigQuery and used wildcards to incorporate fields that are in some properties and not others. Note: It's a table, not a view, as it does not appear Domo can ingest table data.

2. Most of the important data I need is coming all bundled up into one single. field, "event params." How are you getting around this?

We had to both unnest the fields and pivot them. For example if I have a page view where one field is Event Category (button, search, link), and another field is Event Label (the actual identifier), simply unnesting them means I get one line for Event Cagoery and one line for Event Label. I cannot then make a table that shows me the Event Labels for all events with a certain Event Category (example: show me all the search terms my users entered, so show me all the Event Labels for the events where the Event Category is Search). Therefore for our unnesting had to include a pivot.