Database Output Step

Saves the transformed data from your plan to a catalog item within a data source.

This step is available for standalone plans and embedded plans.

Before you begin

Configure write credentials

Before you start:

Configure write credentials for your target data source connection.
Set at least one set of write credentials as the default.

The database user account used for write credentials must have sufficient permissions to write data to existing tables. If you plan to create new tables, the account must also have permissions to create tables in the target schema or database.

If write credentials are not configured, you’ll see a warning message when configuring the Database output step. To resolve this:

Go to Catalog > Sources.
Open your data source and go to the Connections tab.
Edit the connection and add write credentials in the Write credentials section.

For detailed instructions specific to your connection type, see the connection documentation in the Supported Connectors reference.

Check connector support

Creating new catalog items is available only for database connectors. For file storage connectors, use the File Export Step instead.

Supported database connectors

Amazon Aurora MySQL
Amazon Aurora PostgreSQL
Amazon Redshift
Azure Synapse Analytics
BigQuery
MariaDB
MSSQL Server
MySQL
Oracle
PostgreSQL
SAP HANA
Snowflake
Sybase
Teradata

Configure the Database output step

Add a Database output step to your plan.
Connect your transformation steps to the Database output step.
Choose how you want to save the transformed data:
- Write to an existing catalog item
- Create a new catalog item

Write to an existing catalog item

To save data to an existing table:

In the step configuration, select Select catalog item.
Choose an existing table from the catalog as the output destination.
Select the Data write strategy:
- Append: Adds new records to the table, keeping all existing data.
- Replace: Removes all existing data and writes only the transformed data.

Create a new catalog item

Create a catalog item to save the transformed data into a new table.

When you create a new catalog item, you are creating a physical database table directly in your data source. The table persists in your database and can be accessed by other applications and tools. For required permissions, see Configure write credentials.

After creating a table, use your database’s native management tools to modify its structure or delete it. ONE can’t manage tables created through this step directly.

To create a new table and save data to it:

In the step configuration, select Create new catalog item.
Specify the following:
- Source: The data source and connection where the table will be created.
- Schema: The schema name (if applicable to your data source).
- Catalog item name: A unique name for the new table.
- (Optional) Change default column sizes: Customize column widths.
Select the Data write strategy:
- Append: Adds new records to the table, keeping all existing data.
- Replace: Removes all existing data and writes only the transformed data.
Select Create.

After you select Create:

The step creates a new database table in the connected source with columns matching the step input (attribute names and data types), using the configured write credentials.
If the table is created successfully, it’s imported into the Catalog as a new catalog item.
The step configuration automatically switches to reference this new catalog item for subsequent runs.