PostgreSQL Execute using Stored Procedure

This example pipeline demonstrates how to create a stored procedure and call the stored procedure to insert a record in an existing table. This pipeline runs an SQL query containing a JOIN command to collate data between two PostgreSQL tables.

• PostgreSQL Execute
• PostgreSQL Select

Execute a SQL Query with Join Command

This example pipeline demonstrates how to use PostgreSQL Execute Snap using a JOIN command to collate data between two PostgreSQL tables.

• PostgreSQL Execute

PostgreSQL Bulk Upsert with Conditional Delete, Insert, and Update

This example pipeline demonstrates a database workflow that creates a PostgreSQL table, populates it with initial data, performs bulk upsert operations using CSV data, and retrieves the final results. The pipeline showcases database table management, data insertion, conditional updates, and data retrieval operations in a sequential manner.

• PostgreSQL Bulk Upsert
• PostgreSQL Multi Execute
• PostgreSQL Select
• CSV Generator

Insert Record Into a Table Using a Stored Procedure

This example pipeline demonstrates how to create a stored procedure and call the stored procedure to insert a record in an existing table. This pipeline runs an SQL query containing a JOIN command to collate data between two PostgreSQL tables.

• PostgreSQL Insert
• Mapper

Execute multiple statements using PostgreSQL Multi Execute Snap

This example pipeline performs database table management operations on a PostgreSQL database. It executes multiple SQL statements in a sequence—it drops an existing table if it exists, creates a new table with specific schema, and inserts initial data into the newly created table.

• PostgreSQL Multi Execute