Node_Only
An autogenerated Node ID.
The Node name.
location object
Where the Node is located.
The name of the Node Storage Location
WORK
The Node description.
The materialization of the Node. Table or View.
Possible values: [table
, view
]
If the Node is Multi Source
override object
If the materializationType
is set to view, users can override Create SQL allows a user to override the DDL of a view, enabling greater flexibility in view creation. Override Create SQL Toggle.
create object
If the user has toggled override to true or false.
The custom script written in the Create SQL box.
tests object[]
Any Node level tests.
Name of the test.
Test
Description of the test.
If the pipeline should keep running, even if the Node test fails.
If the test should run before or after the DML operation.
Possible values: [Before
, After
]
Any custom SQL that was added here.
SELECT * FROM COALESCE
{
"id": "string",
"name": "string",
"nodeType": "string",
"location": {
"name": "WORK"
},
"description": "string",
"isMultisource": true,
"override": {
"create": {
"enabled": true,
"script": "string"
}
},
"tests": [
{
"name": "Test",
"description": "string",
"continueOnFailure": "string",
"templateString": "SELECT * FROM COALESCE"
}
]
}