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

Setting up the Snowflake Connector for PostgreSQL using Snowsight

Installation of the Connector using Snowsight.

Snowflake Administrator

Set up connectivity

The configuration of the network access to Snowflake. A sub-task of Setting up the Snowflake Connector for PostgreSQL Agent container.

Network 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

Reviewing data

Review the following to examine Snowflake Connector for PostgreSQL data

Task

Description

Viewing PostgreSQL data in Snowflake

Viewing data ingested using the connector.