Articles in this section

See more

Automatically create staging tables from any data source

  • Updated
Follow

The Etlworks Integrator can automatically create (and drop) staging tables for you from practically any data source: files, API endpoints, etc.

Step 1. Begin to create a data integration Flow by opening the Flows window. Click + and type create staging tables in the Select Flow Type box. 

create-staging-tables.png

Step 2. Continue by defining the FROM and TO. Select a database Connection for the staging table(s) in the TO Connection field. 

The TO field will be used as the name for the staging table.

create-staging-flow.png

Step 3. Configure the Flow to drop an existing staging table if it already exists.

drop-staging.png

Related articles

Comments

0 comments

Please sign in to leave a comment.