View the original community article here
Last tested: Oct 19, 2018
If you don't specify a sql parameter in a dimension, Looker defaults to ${table}.dimension_name. So when you select the dimension in the explore, the generated sql will select table_name.dimension_name.
This content is subject to limited support.