Skip to main content

How to Ignore Dimensions

You may want to exclude certain dimensions from validation.

For example, imagine you have a dimension that’s dependent on a parameter. If that parameter doesn’t have a default value, the parameter’s value will be '' during validation and will break the downstream dimension. You may also want to ignore dimensions that don't have a sql parameter, like distance, location, or duration.

To exclude a dimension from validation, add a spectacles: ignore tag to your dimension as shown below:

dimension: addresses {
sql: ${TABLE}.addresses ;;
tags: ["spectacles: ignore"]
}

Alternatively, you can edit the sql field of your dimension LookML to include the comment -- spectacles: ignore.

dimension: addresses {
sql:
-- spectacles: ignore
${TABLE}.addresses ;;
}