PostgreSQL
PostgreSQL is an open-source relational database system known for its reliability and feature robustness. As a development environment in Paradime, PostgreSQL enables dbt™️ development from Paradime's Code IDE.
IP RESTRICTIONS
Make sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.
👉 See also: Paradime IP addresses.
Setup Instructions
Click the gear Icon (⚙️) on the top right of the Paradime interface to access Account Settings
In the left sidebar, click "Connections"
Click "Add New" next to the Code IDE section
Select "PostgreSQL"
In the Profile Configuration field, add at least these required parameters. For additional configuration options, see the Profile Fields Reference section.
After adding the configuration, ensure it's properly formatted using a YAML formatter like YAML Formatter.
Provide a dbt™ Profile Name (This should match with the profile name set in your
dbt_project.yml
).In the Target field, enter "dev". This is the default target your dbt project will use for development work.
The "Schema" field is pre-configured, but you can change it to specify the schema where dbt will build objects.
The "Threads" value is pre-configured to 1, but you can adjust this number to specify how many parallel operations your dbt project can run.
Example Profile Configuration
Profile Fields Reference
host
Database server hostname or IP address
db.company.com
None
✅
user
PostgreSQL authentication username
postgres_user
None
✅
password
User authentication password
your_password
None
✅
port
PostgreSQL server port number
5432
5432
✅
dbname
Name of the target database
analytics
None
✅
schema
Name of the target schema. This is configured in the UI "Schema" field
public
public
✅
threads
Number of concurrent operations. This is configured in the UI "Threads" field
4
1
✅
keepalives_idle
Time in seconds between connection keepalive pings
60
0
❌
connect_timeout
Seconds to wait for connection establishment
10
10
❌
retries
Number of times to retry failed connections
3
1
❌
search_path
Order of schemas Postgres will search through
public , prod
$user,public
❌
role
PostgreSQL role to assume when executing queries
analytics_role
None
❌
sslmode
Level of SSL connection security
verify-full
prefer
❌
sslcert
Path to client SSL certificate file
/path/to/cert
None
❌
sslkey
Path to client SSL private key file
/path/to/key
None
❌
sslrootcert
Path to SSL root certificate authority file
/path/to/root.crt
None
❌
Last updated