Hi there,
We use Bigquery and we have tables with RECORD (repeated and nullable).
Sometimes for a table we have multiples times the same field name (ex : end_date) that we can find in multiple RECORD.
Then we usually generate view using the "Generate view from table" option.
We noticed that for some dimensions : sql field are missing the ${TABLE} and it creates bug when trying to use this field that is present in multiple record for an explore, do you know why this happens?
We get this error : Query execution failed: - Column name end_date is ambiguous at [2:5]
when we try to query the field end_date that is present in multiples RECORD.
The question is : why the feature "Generate view from table" sometimes not add the ${TABLE} in the sql field?
Thanks for the help