Get timestamp
The Get timestamp transform makes it easier to create dynamic staging pipelines where it is possible to run the pipeline if the table are missing (first runtime).
File options
| Option | Description |
|---|---|
| Transform name | Name of the step. |
| Connection | Select predefined database connection |
| Schema name | The name of the Schema for the table to read data from |
| Table name | Name of the source table. |
| Column name | Name of the table column with timestamp. |
| Default value | Use this value if no value found (missing table of column) |
| Result fieldname | The name of the field to put the result of the sql |