PostgreSQL-Snowflake Openflow Migration

I am moving a single, fully structured PostgreSQL dataset (in the 1 TB – 10 TB range) into Snowflake and want the entire flow handled through Snowflake Openflow so that future incremental loads can piggy-back on the same orchestration.

You will start by designing the Openflow pipeline, mapping every PostgreSQL schema, table, and index to its Snowflake equivalent, and putting in place the monitoring hooks Snowflake recommends for high-volume transfers. The goal is a like-for-like copy—no transformations—so row counts, constraints, and data types must match exactly once the job completes.

Because of the data volume I need solid strategies for parallelisation, fault tolerance, and restartability. Please plan for a test run on a reduced slice, followed by a full push, and finish with a quick validation script so I have an auditable trail that the migration completed without loss.

Deliverables
• Openflow job definition(s) and any helper scripts or SQL files
• Clear, step-by-step execution guide so I can rerun or extend the pipeline later
• Post-migration validation report (row counts, failed row log, timing)

I have admin-level access to both the source PostgreSQL instance and the target Snowflake account and can provide connection details as soon as we start. If you have completed similar high-volume migrations before, detail your approach and any relevant Snowflake optimisations you would bring in.