This page refers to the
sql_table_nameparameter that is part of an
sql_table_namecan also be used as part of a view, described here
sql_table_namecan also be used as part of a join, described here
sql_table_name is a child of
|a table name in your database|
sql_table_name sets the table in your database that will be queried by the
explore. Typically the view for which an explore is named defines the table that will be queried. However, in cases where multiple tables have the same structure, the same view can be used to describe all of them.
sql_table_name enables you to specify which of those tables should be used.
If you need to reference a table from a different database / schema, you can use
database_or_schema_name.table_name. If you don’t explicitly write a database / schema Looker will use the default that you have set. The default is configured in the Admin section of Looker under Connections.
Make the customer explore rely on the customer_1 table from the default database / schema:
Make the customer explore rely on the customer_1 table from the analytics database / schema:
Tables Referenced By
sql_table_name Must Be Accessible From The Current Connection
sql_table_name is part of an explore, which is in turn part of a model. The model will have a database connection defined in it. Any table you reference in
sql_table_name must be accessible within that database connection.
Things to Know
To Name A
view Differently Than The Underlying Table,
sql_table_name At The
In other words, instead of this: