Datasource Create Table

Impure

Creates a table in the datasource using the given datasource mapping.

Pure Function

No

Execute Inputs

Execution

INPUT

Execution Input.

Execute Outputs

Complete

OUTPUT

Fires when table creation logic completes (SQL executed or skipped).

Data Inputs

Datasource

INPUT

Name of the datasource to use.

Table Name

INPUT

The name of the SQL table to create.

Mapping

INPUT

The datasource mapping to use for creating the table.

Execute

INPUT

Whether to actually execute the CREATE TABLE SQL or just return it.

Data Outputs

Generated SQL

OUTPUTstring

The generated SQL statement based on the mapping and table name.

Multiple

Settings

If Not Exists

BOOLEAN

If true, adds IF NOT EXISTS clause to CREATE TABLE.

Default: true

Throw on SQL Error

BOOLEAN

If true, will throw an error if a SQL error occurs during query.

Default: true

Debug

STRING

Break on node when executing.

Default: No

Options:

NoBeforeInputsBeforeProcessingAfterProcessing