Step Type: Create Tables

The Create Tables step copies table definitions (schemas) from a source connection to a target connection. This is useful when setting up a target database or CSV directory to receive migrated data.

Note: This step type is applicable to Database and CSV connections only. ServiceNow and other API-based connections manage their own table schemas.

When to Use

• Before migrating data to a new database, create the target tables to match the source schema
• When setting up CSV output files with the correct column structure
• To replicate table structures between database environments

Configuration

Source and Target

• Source connection — The connection whose table schemas will be copied
• Target connection — The connection where tables will be created (must support table creation)

Tables

Select one or more tables from the source connection to create on the target. Each selected table’s schema (field names, data types, constraints) will be reflected onto the target connection.

Options

Option	Description
Create attachment table	Optionally create an associated table for file attachments
Table schema overrides	Modify field definitions before creating the target table (e.g., change data types, rename fields)
String max length	Set default maximum lengths for string fields
Text conversion threshold	Fields exceeding this length threshold are converted to TEXT type
Preserve source primary key	Use the source table’s primary key instead of generating a Precision Bridge ID

How It Works

1. The step reads the table schema from the source connection
2. Any configured overrides are applied to the schema
3. The modified schema is used to create the table(s) on the target connection
4. If the table already exists on the target, the step behavior depends on your configuration