Show
The Content Validator searches your LookML for model, Explore, and field names referenced in your Looker content. It's a super useful tool for validating your LookML references, for fixing errors in your LookML after making changes, and for updating the names of your LookML elements across your project. You must have the To open the Content Validator, select Content Validator from the Develop menu: From here, you can use the Content Validator in two ways:
Before using the Content ValidatorYou must be extremely careful when making changes using content validation. The Content Validator does not have an undo function, and it has the potential to impact many Looks and dashboards, along with their Explore from Here links. If you do make a mistake, you should attempt to correct it as soon as possible, before additional changes make it harder to isolate the affected Looks. Also, consider your timing when using the Content Validator. When you push development changes to production you should fix affected Looks and tiles at approximately the same time, so that they are broken for the minimum amount of time. If you fix Looks and tiles too early, based on your work in Development Mode, they will appear broken to users until you push your changes. Similarly, if you delay in fixing Looks and tiles until long after pushing the changes, the Looks and tiles will appear broken to users until you fix them.
Using the Content Validator to fix errorsThe Content Validator is a useful tool for finding and fixing errors resulting from changes in your LookML. For example, if you change a field name from When you run the Content Validator, it validates all references that your Looks and dashboards make to your LookML models, Explores, views, and fields, and will show an error for any references your content makes to an unknown LookML object. The Content Validator does not show errors for the following:
Running the Content Validator
To validate your LookML with the Content Validator:
Viewing the content validation resultsThe content validation results show Looker content that uses model names, Explore names, view names, or field names that do not exist or can't be found. See the Using the Content Validator to fix errors section for details about the LookML elements that the Content Validator can find and validate. The icon next to the content's name identifies the content type: Validation results are based on the LookML available in the mode you're in when you run the validator. If you are in Production Mode, the validation results will reflect all LookML that has been pushed to production. If you are in Development Mode, the validation results will reflect your saved LookML, even if it hasn't been pushed to production. Errors may be due to intentional changes in your LookML, or due to a typo or a missing join. To adjust errors, you can use the buttons in each line of the error table: Looker provides the Replace button for each error (see the Replacing names for fields, views, Explores, and models section below for how to replace names with the Content Validator). For errors with field names in the Data section of a Look or tile, Looker also displays the Remove button (see the Removing a field name section below for how to remove names with the Content Validator). Depending on your Group by setting, the buttons will apply to a single item (Look or tile), or to multiple items:
Here's an example where the table is grouped by Error, so the buttons affect all the instances of that error: Here's an example where the table is grouped by Content, so the buttons affect just the one instance of the error on a single piece of content: In addition, if you group by Content, you have the additional option to delete Looks. Replacing names for fields, views, Explores, and modelsThe content validation results include a Replace button for the following types of elements so that you can rename them:
For any of these errors, you can use the Content Validator to replace an attribute of the content that is equal to or more general than the attribute that is erroring:
Here's how to use the Content Validator to replace the names of elements in your model:
Removing a field nameFor errors with field names in the Data section of a Look or tile, the error table will provide a Remove button to the right of the error. You can use the Content Validator to remove fields that are:
You cannot use the Content Validator to remove fields from custom filters, custom fields, nor table calculations, because typically you need to make additional changes to keep the expression working. Instead, use the content validation error messages to find places where custom filters, custom fields, and table calculation expressions need to be fixed, then rework the expression as appropriate.
Deleting LooksIf you group the error table by Content, you have the option to delete Looks in the table. To use the Content Validator to delete Looks:
Using the Content Validator to find and replaceThe Content Validator can also be used to search and replace the names for models, Explores, and fields. For example, you might decide that you prefer one field over another and want to make that replacement in your project, even though there is no error. The complete list of elements that the Content Validator can search/replace is provided in the Replacing names for fields, views, Explores, and models section above.
To use the Content Validator as a find and replace tool:
Things to considerPlan to rerun content validation to view the results of any fixes you make. Note the following about the Content Validator:
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates. Last updated 2022-11-17 UTC. [{ "type": "thumb-down", "id": "hardToUnderstand", "label":"Hard to understand" },{ "type": "thumb-down", "id": "incorrectInformationOrSampleCode", "label":"Incorrect information or sample code" },{ "type": "thumb-down", "id": "missingTheInformationSamplesINeed", "label":"Missing the information/samples I need" },{ "type": "thumb-down", "id": "otherDown", "label":"Other" }] [{ "type": "thumb-up", "id": "easyToUnderstand", "label":"Easy to understand" },{ "type": "thumb-up", "id": "solvedMyProblem", "label":"Solved my problem" },{ "type": "thumb-up", "id": "otherUp", "label":"Other" }] What happens if you delete a field from a table that contains data?You can delete a field from a query or from a table in Access. When you delete a field from a query, the field remains in the database, but is no longer used in the query. When you delete a field from a table, the field is deleted from the entire database.
When you edit a record pressing Escape once removed the changes to the field what happens if you press escape a second time?A form presents records one at a time, while a datasheet lists all records. When you edit a record, pressing ESC once removes the changes to the field. What happens if you press ESC a second time? Access removes all changes to the record.
Which is a proper method of deleting a column from a query?To remove a single column, select the column you want to remove, and then select Home > Remove Columns > Remove Columns. To remove several columns, select the columns by using Ctrl + Click or Shift + Click.
When a user saves a new query the results of the query are saved in the database for future reference?When a user saves a new query, the results of the query are saved in the database for future reference. A user will need to double-click on the field from field list one and then double-click on the field from field list two to establish a relationship between the two tables.
|