Question 1

How does setup differ from standard Redshift?

Accepted Answer

Meaningfully. Standard Redshift takes a host, port and database user, optionally over SSH, and accepts either an access key or an IAM role for S3. Serverless instead uses IAM role authorization, identifies a workgroup, database and region, and connects through either the Redshift Data API or a Serverless VPC endpoint.

Question 2

What do I need to configure for writes?

Accepted Answer

Bind the IAM role to a Redshift database role, and make sure Redshift is permitted to assume that role. This is the step most often missed, and when it is missing the resulting permission errors tend to look like connectivity problems, which sends people debugging the wrong thing.

Question 3

Do I still need an S3 bucket?

Accepted Answer

Yes, and it has to be in the same region. Both standard Redshift and Serverless stage through S3, so there is no configuration of this pairing that avoids provisioning a bucket. Serverless removes the cluster, not the staging storage.

Question 4

Is the load process different?

Accepted Answer

No. Serverless delegates to the same bulk writer standard Redshift uses. Polytomic writes temporary chunked JSON files to S3, optionally creates manifests, runs COPY with format as JSON, merges or rebuilds the destination table, then clears up the staging files and manifests. If you know how ETL loads behave on standard Redshift, you already know how they behave here.

Question 5

Why move Postgres data into a data warehouse at all?

Accepted Answer

Usually because the analytical queries started hurting the application. Teams commonly run reporting against their production database until scans get slow enough to notice, then move that workload to a data warehouse and leave Postgres serving the product. Redshift Serverless is that move without a cluster to size in advance.

Sync PostgreSQL to Redshift Serverless

Sync PostgreSQL to Redshift Serverless with Polytomic

IAM role authorization

The same proven load path

Data API or VPC endpoint

Or sync Redshift Serverless to PostgreSQL

Trusted by businesses worldwide

Step-by-step integration guide

Connect PostgreSQL in Polytomic

Connect Redshift Serverless in Polytomic

Create a sync between PostgreSQL and Redshift Serverless

Map fields and enable the sync

Frequently asked questions

The sync and ETL platform that does it all

Powerful data sync

Advanced analytics

Enterprise security

Easy setup

Ready to connect PostgreSQL with Redshift Serverless?