Skip to main content
Print bookPrint book

Workflow Save Data in Postgres

Site: STRATIO Training & Certification
Course: Generative AI Data Processing Practice (14.8)
Book: Workflow Save Data in Postgres
Printed by: Invitado
Date: Friday, 24 July 2026, 6:23 AM

Table of contents

1. Output postgres

Postgres Output

Now we will replace the "print" output of the workflow with a Postgres-type output.

In the new Postgres output box, we need to configure the connection using the predefined environment variable.



We must ensure that in the box preceding the database output, we correctly specify the table name we want to save:

For example, cat_clientes_riesgo_[id_unico] and select the append mode before the first execution.

NOTE: If this is the first time executing and the table has not been created yet, we must check the "Check if empty dataframe before saving it" box. If we run the workflow multiple times and the table is already created, we should switch to "overwrite" mode to replace the records.

2. Ejecución del workflow

Workflow Execution

Once the workflow is completed:

We can execute the workflow using:

and we will see it appear in the "Executions" section.

If everything is correct, we should see a "Completed" status after some time, meaning the records should be stored in Postgres.

3. Validar carga en postgres

Workflow Execution

Validate Load in Postgres

In this practice environment, we have configured a direct connection to Postgres in Discovery, where we have loaded the table.

It may take some time for the created table to appear. A more direct way to check is to run a query: New -> SQL Query -> certification_postgres_database (WRITE).

The table name is the one set in the box before the output, for example:

Thus, the query should look something like this:

And we should obtain records.