For Fact Tables - How would you include data that ...
# ask-questionsn
nice-shampoo-1738
10/28/2024, 7:53 AMFor Fact Tables - How would you include data that are included in the events as an array in this way:
It would be nice to use the attributes and values as filters
f
fresh-football-47124
10/28/2024, 12:59 PM
interesting
fresh-football-47124
10/28/2024, 12:59 PM
let me ask the team on this
fresh-football-47124
10/28/2024, 1:00 PM
there are some hackish ways to make it work with string concatenation - but there should be a better way
f
future-teacher-7046
10/28/2024, 1:37 PM
I assume this is BigQuery?
If it's just an array of string values, looks like the IN operator and UNNEST can be used in a filter. https://cloud.google.com/bigquery/docs/arrays#scanning_for_specific_values
If it's an array of structs or more complicated values, you might have to do a join in your fact table SQL definition to UNNEST them as dedicated columns. Then, reference those in your filters. That same page I linked has examples for this further up.
n
nice-shampoo-1738
11/01/2024, 7:27 AMYes, its BigQuery. I am not sql strong. Isn't the google docs only describing looking for specific values and attribute? So for a fact table to work I should call out all possible attribute names to be pulled in. And then the filters in Growthbook would allow me to choose specific ones for specific metrics?
35 Views