Knowledge Drop

Column is ambiguous SQL Error

Userlevel 3

Last tested: Sep 6, 2018

You may see an error that says something like Column 'id' in field list is ambiguous. This error means that there is a field name that is present in more than one table, so it needs to be scoped with the table name to avoid ambiguity: using instead of just id will resolve the issue.

Proper LookML references should always avoid these errors, so if you are seeing this, you are most likely doing something like using just field_name instead of ${field_name} or ${TABLE}.field_name. Check out this help center article:


This content is subject to limited support.                


0 replies

Be the first to reply!