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.

To exclude the downstream dimension from validation, edit the sql field of your dimension LookML to include the comment -- spectacles: ignore.

dimension: addresses {

sql:

-- spectacles: ignore

${TABLE}.addresses ;;

}