LookML Sets

Sets are reusable lists of fields (dimensions, measures, and filters) defined within a view or a model. They are primarily used to group fields together for various purposes such as drill-down paths, explore field visibility, and more.

Syntax

set: set_name {
  fields: [field_name1, field_name2, view_name.field_name3, ...]
}

Key Features

• Reusability: Define a list of fields once and use it in multiple places.
• Composition:
  • Include All: [set_name*] includes all fields from another set.
  • Exclude: [-field_name] excludes a specific field.
  • External Reference: view_name.set_name* refers to a set in another view (ensure views are joined).