Postgres

Connect & Ingest data from / to a Postgres database

Sling CLI Setup
The following credentials keys are accepted:
host (required) -> The hostname / ip of the instance
user (required) -> The username to access the instance
database (required) -> The database name of the instance
schema (optional) -> The default schema to use
password (optional) -> The password to access the instance
port (optional) -> The port of the instance. Default is 5432.
sslmode (optional) -> The sslmode of the instance. Default is disable.
Here is an example of setting a connection named POSTGRES. We must provide the type=postgres property:
$ sling conns set POSTGRES type=postgres host=<host> user=<user> database=<database> password=<password> port=<port> 
​
# OR use url
$ sling conns set POSTGRES url=postgresql://myuser:[email protected]:5432/mydatabase?sslmode=require
Environment Variable
export POSTGRES='postgresql://myuser:[email protected]:5432/mydatabase?sslmode=require'
Sling Cloud Setup
In Sling Cloud, click the Connections link on the left sidebar.
On top, click New Connection.
Search for "Postgres". Click on it.
Input the needed information.
Click Test to verify connectivity.
Click Save to save the connection.
Database user creation
To allow Sling to access your database, we need to create a user with the proper privileges. Please follow the steps below:
1.Create a user sling (or whatever you prefer) by running:
CREATE USER sling WITH PASSWORD '<password>';
2.If you are planning to load data into this connection, grant the following privileges to that user:
GRANT CREATE ON DATABASE <database_name> TO sling;
3.If you are planning to extract data from this connection, you need to give permission to read the tables you'd like Sling to extract.
-- Need this to read table & column names 
GRANT SELECT ON ALL TABLES IN SCHEMA information_schema TO sling;
GRANT SELECT ON ALL TABLES IN SCHEMA pg_catalog TO sling;
​
-- run this to grant SELECT permission to all tables in schema `marketing` to user sling
GRANT SELECT ON ALL TABLES IN SCHEMA marketing TO sling;
IP Address Whitelisting
If your database instance is secured behind a cloud firewall, please whitelist the IP addresses listed here. We may not be able to establish a connection without this step.
If you are facing issues connecting, please reach out to us at [email protected].

Oracle

Redshift

Last modified 1mo ago