Snowflake Connector for PostgreSQL installation and configuration tasks¶

Note

The Snowflake Connector for PostgreSQL is subject to the Connector Terms.

Working with the Snowflake Connector for PostgreSQL includes the following common task areas:

It’s important to carefully review each of the installation and configuration steps, before enabling data replication.

Installing and configuring the connector¶

Perform the following tasks to install and configure the Snowflake Connector for PostgreSQL.

After all prerequisites are satisfied you can install and configure your Snowflake Connector for PostgreSQL using either SQL or Snowsight.

Task	Description	Area Involved
Prerequisites for Snowflake Connector for PostgreSQL datasources	The configuration of the source database instance to enable data replication.	Source Database Administrator
Opening required ports for Snowflake Connector for PostgreSQL	The configuration of the network access to Snowflake.	Network Administrator
Setting up the Snowflake Connector for PostgreSQL using Snowsight	Installation of the Connector using Snowsight.	Snowflake Administrator
Setting up the Snowflake Connector for PostgreSQL Agent container	Installation and configuring the Snowflake Connector for PostgreSQL agent.	Developer and Operations
Setting up Email Notifications for the PostgreSQL connector	The configuration of email notifications for the connector.	Snowflake Administrator
Configuring replication for the Snowflake Connector for PostgreSQL	Configure connector replication	Developer and Operations

Review the following to examine Snowflake Connector for PostgreSQL data

Task	Description
Viewing PostgreSQL data in Snowflake	Viewing data ingested using the connector.