Validation Errors
Validation errors occur when there are semantic errors. Such an something being an array when it should be an object. These types of errors tend to be introduced outside of Coalesce.
When you get a validation error, the Coalesce App will open a drawer showing a list of where the errors are occuring in your repository. You can resolve them by going to the repository and fixing the errors listed.
![](https://files.readme.io/fe99a69-Screenshot_2024-08-14_at_11.22.21_AM.png)
Reading a YAML File
It's important to understand how to read a YAML(.yml) before solving errors.
When reading a YAML file, Coalesce will use dot notation like operation.dataset
or operation.metadata.columns.0.acceptedValues.values
, the notation refers to specific paths within the hierarchical structure of the YAML file.
fileVersion: 1
id: 45ef876a-91d8-4db3-8bc6-27d96889be53
name: LINEITEM
operation: <------
database: ""
dataset: [] <----- operation.dataset
deployEnabled: true
description: Lineitem data as defined by TPC-H
locationName: SAMPLE
metadata: <---------
columns: <--------
- acceptedValues: <-------
strictMatch: true
values: {} <-------- operation.metadata.columns.0.acceptedValues.values
appliedColumnTests: {}
columnReference:
columnCounter: e9ea1254-edec-460e-895c-c3439fcf6b51
stepCounter: 45ef876a-91d8-4db3-8bc6-27d96889be53
config: {}
operation.dataset
: This refers to the dataset key under the operation section. In this example, dataset is an empty list ([]
).operation.metadata.columns.0.acceptedValues.values
:operation.metadata
refers to the metadata section within operation.columns.0
indicates the first item in the columns list (index 0).acceptedValues.values
refers to the values key withinacceptedValues
. In this example, this is an empty dictionary ({}
).
Solving Validation Errors
Using the example again, let's solve these errors.
![](https://files.readme.io/bab8b8e-Screenshot_2024-08-14_at_11.22.21_AM.png)
We can see that there are two errors in the LINEITEM
node.
operation.dataset Expected string, received array
operation.metadata.columns.0.acceptedValues.values Expected array, received object
.
The errors tell you where the the issue is occuring and the data type it expects.
For the first error: operation.dataset Expected string, received array
. In GitHub, go to the node and review the file. The first part of the error operation
points to the operation on line 4, then within operation, the second part, dataset, points to line 6. Finally, the message, Expected string, received array, means that the the array []
should be changed to a string value, or ""
.
![](https://files.readme.io/9f20263-git_validation_error_operation_08_14_2024.png)
The second error: operation.metadata.columns.0.acceptedValues.values Expected array, received object
. In GitHub, go the node and review the file. Starting in operation
on line 4, then metadata
on line 10, then columns
on line 11, then acceptedValues
, and then values
on line 14. You can see the value is an empty object, {}
and it should be changed to an array, []
.
![](https://files.readme.io/8479ae3-git_sync_accepted_values_08_14_2024.png)
Updated 24 days ago