Redshift

Steps to complete:

1. Run SQL script and create schema for Datafold
2. Configure your data connection in Datafold

​

Run SQL script and create schema for Datafold

To connect to Amazon Redshift, create a user for Datafold with two permissions:

• Read access (SELECT) to the schemas and tables you want to diff. Datafold only reads from your main database.
• Write access to one dedicated temporary schema, which Datafold uses to materialize scratch work and keep data processing in your warehouse.

Create the temporary schema, create the user, and grant these permissions with the script below. Repeat the two GRANT ... <myschema> statements for each schema you want Datafold to read.

/* Create the temporary schema Datafold uses for scratch work */

CREATE SCHEMA datafold_tmp;

/* Create the datafold user */

CREATE USER datafold PASSWORD 'SOMESECUREPASSWORD';

/* Give the datafold user write access to the temporary schema */

GRANT ALL ON SCHEMA datafold_tmp TO datafold;

/* Give the datafold user read access to each schema you want to diff */

GRANT USAGE ON SCHEMA <myschema> TO datafold;
GRANT SELECT ON ALL TABLES IN SCHEMA <myschema> TO datafold;

Grant read access to every schema you want to diff. If Datafold references a schema the user cannot read, diffs against that schema will fail.

​

Configure in Datafold

Field Name	Description
Connection name	A name given to the data connection within Datafold
Host	The hostname of your cluster. (Go to Redshift in your AWS console, select your cluster, the hostname is the endpoint listed at the top of the page)
Port	Redshift connection port; default value is 5439
Username	The user created in our SQL script, named datafold
Password	The password created in our SQL script
Database	The name of the Redshift database you want to connect to
Schema path for temporary tables	<database_name>.datafold_tmp: the database plus the schema created in our SQL script

Click Save. Your data connection is ready!