Applies to: Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace
...
From the Toolbox, click Datasets.
Click theActions menu ( ⋮ ), click Add Dataset, enter a name, and then click Add.
Set input type to SQL.
Optionally, you can click the Lookup file checkbox to create a lookup file. Refer to using lookup for details.
Enter SQL code into the editor.
(See the code example in this topic.)Optionally, to format and filter data, click Refine.
On the Format tab, use the Incremental Identifier field to specify the column you want to use to identify and process new data during an incremental process.
Use the Preview to confirm the results.
Click Apply.
Optionally, you can click the Actions menu (...) to validate the data or add a note.
Click Save.
...