PostgreSQL
PostgreSQL is an open-source database. PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance.
NOTE: You need to allowlist Savant’s IP addresses to let our systems contact your warehouse. Reference our IP Addresses docs to determine which IPs you need to whitelist.
Connecting Savant to PostgreSQL requires some setup in both platforms. Most of the setup occurs in Savant, but you need access to PostgreSQL for information like your host, port, database name, and credentials.
Set Up PostgreSQL in Savant
In PostgreSQL
Create a Savant User in PostgreSQL
We recommend creating a specific user and role for Savant with permission to access the required table(s) in PostgreSQL. If you already have a user and role created with appropriate permissions, you can skip this step.
Create a database user for Savant’s exclusive use.
Open a connection to your PostgreSQL database in a PostgreSQL console (such as a SQL workbench or psql).
Create a user for Savant by executing the following SQL command. Replace
{Password}with password of your choice.
CREATE USER savant WITH PASSWORD '{Password}';Grant the Savant user read-only access to all tables by running the following commands:
GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON ALL TABLES IN SCHEMA {schema} TO savant; GRANT SELECT ON ALL SEQUENCES IN SCHEMA {schema} TO savant; GRANT CREATE, USAGE ON SCHEMA {schema} TO savant;
In Savant
In the Server field, enter your database Server name.
Enter your database instance's port number.
Enter the name of your database.
Enter the Savant-specific user that you created.
Enter the password for the Savant-specific user that you created.
Click Authenticate.
SSL/TLS
Use the checkbox to enable SSL/TLS on your database connection.
SSH Tunnel
Additional properties can be seen when the SSH Tunnel checkbox is selected. Click here to learn more about configuring SSH Tunneling in Savant.
Please refer to the below demo for the connection setup
Read Data from a PostgreSQL Database
Learn how to create datasets from Savant’s PostgreSQL connector here.
Write Data to PostgreSQL
Learn how to write data to PostgreSQL using Savant’s PostgreSQL connector here.
Understanding PostgreSQL Limitations
There are no known limitations to Savant’s PostgreSQL connector.