Create And Load Action

This action creates a table in the data source with the same columns as in the source input schema and loads the input data into it. If the table already exists, it can either be dropped and re-created, or Skyvia can use existing table, provided that its schema matches the input schema.

This action is supported only for Databases, Elasticsearch, and Airtable connectors.

Action Settings

Setting Description
Table The name of the table to create and load data to.
Recreate if exists Determines whether to recreate the table if it already exists.
Sanitize Column Names Determines whether to sanitize column names. If selected, Skyvia removes all non-alphanumeric characters including spaces from the source object name and replaces them with underscores.

Action Parameters

This action does not have parameters.

Result

The action creates a table in the data source with the same columns as in the source input schema and loads the input data into it.

Example

Here is an example of the Create And Load action in the Target component of Data Flow.

Create And Load action in data flow

On This Page