I am querying a table in GBQ ~14tb in size. I am filtering table on one of the columns(the column is string) for ~15k different substrings. What would be the most efficient way to do so ? if I subset for 1 substring at a time the cost is too high duw to large size of the table.
any thoughts/suggestions