Missing ${TABLE} prefix for some sql field of dimensions when using "Generate view from table"

Looker Q&A Looker
,
1

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

1 Like