Skip to content

SQL file exporter

Write rows as SQL statements in an artifact.

Why: Use when a downstream system applies generated SQL statements.

Output: artifact; per_worker.

1
<generate name="items" count="1" target="SQL"/>

Platform Artifact View

On DATAMIMIC Platform, leave storageId and exportUri unset. Platform-managed artifact storage chooses the task-scoped location read by Artifact View.

Set exportUri only together with a storageId that names your own <object-storage>. It is a relative path prefix, not a filename. Outputs in custom object storage are outside Platform Artifact View.

Options: dialect, database_type, table_name, columns, column_map, batch_size, mode

targetEntity: not supported