Redshift

Connect & Ingest data from / to a Redshift database

Sling CLI Setup
The following credentials keys are accepted:
host (required) -> The hostname / ip of the instance
user (required) -> he username to access the instance
database (required) -> The database name of the instance
aws_bucket (required) -> The name of the S3 Bucket for Bulk Loading / Unloading
aws_access_key_id (required) -> The AWS Access Key ID to access the bucket for Bulk Loading / Unloading
aws_secret_access_key (required) -> The AWS Secret Key to access the bucket for Bulk Loading / Unloading
schema (optional) -> The default schema to use when loading
password (optional) -> The password to access the instance
port (optional) -> The port of the instance. Default is 5439.
Here is an example of setting a connection named REDSHIFT. We must provide the type=redshift property:
$ sling conns set REDSHIFT type=redshift host=<host> user=<user> database=<database> password=<password> port=<port> aws_bucket=<aws_bucket> aws_access_key_id=<aws_access_key_id> aws_secret_access_key=<aws_secret_access_key>
​
# OR use url
$ sling conns set REDSHIFT url=redshift://myuser:[email protected]:5439/mydatabase aws_bucket=<aws_bucket> aws_access_key_id=<aws_access_key_id> aws_secret_access_key=<aws_secret_access_key>
Environment Variable
export REDSHIFT='redshift://myuser:[email protected]:5439/mydatabase'
export AWS_BUCKET='<aws_bucket> '
export AWS_ACCESS_KEY_ID='<aws_access_key_id> '
export AWS_SECRET_ACCESS_KEY='<aws_secret_access_key> '
Sling Cloud Setup
In Sling Cloud, click the Connections link on the left sidebar.
On top, click New Connection.
Search for "Redshift". 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].

Postgres

SQLite

Last modified 1mo ago