In this example the dimension is named country and inside the following curly braces there are all the parameters that describe the dimension:
type: string – means the data type of the field is string
map_layer_name: countries – related to a specific feature of Looker where it can map the countries and make a dashboard with them
sql: ${TABLE}.Country – a SQL statement that indicates which field we are referring to in our actual database table – Country in our case. ${TABLE} is a dynamic parameter that contains the sql_table_name
*Notice that each sql statement ends with a pair of semicolons.
1 thought on “Creating a project and getting to know LookML”