Postgres

Authentification and configuration options for Postgres.

Authentification

Postgres projects require the following configuration settings:

  • Hostname. This would be in the form [name].[id].[region].redshift.amazonaws.com if you are using AWS.
  • Port (usually 5432 )
  • Username and password
  • Database name
Dataform's IP addresses must be whitelisted in order to access your Postgres instance. Dataform's IP addresses are 35.233.106.210 and 104.196.10.242 .

Dataform web features for Postgres

Real time query validation

Dataform validates the compiled script you are editing against Postgres in real time. It will let you know if the query is valid (or won’t run) before having to run it.

Getting help

If you are using Dataform web and are having trouble connecting to Postgres, please reach out to us by using the intercom messenger at the bottom right.

If you have other questions related to Postgres, you can join our slack community and ask question on the #Postgres channel.

What's next

Snowflake

Authentification, configuration options, and content for Snowflake.

Google BigQuery

Authentification, configuration options, and content for BigQuery.

Amazon Redshift

Authentification, configuration options, and content for Redshift.

Azure SQL Data Warehouse

Authentification and configuration options for Azure SQL Data Warehouse.