Search…
Redshift
To connect to Amazon Redshift, you need to create a user with read-only access to all tables in all schemas, write access to Datafold-specific schema for temporary tables, and the ability to access SQL logs:
1
/* Create schema for Datafold to write temporary tables to.
2
This is the only schema where Datafold will modify anything in your environment.*/
3
4
CREATE SCHEMA datafold_tmp;
5
6
/* Since Redshift does not allow granting read-nonly access to ALL schemas which
7
Datafold needs to correctly work, you need to grant superuser level privilege to
8
the datafold user: */
9
10
CREATE USER datafold CREATEUSER PASSWORD 'SOMESECUREPASSWORD';
11
12
13
/* The following permission allows Datafold to pull SQL logs and construct
14
column-level lineage */
15
16
ALTER USER datafold WITH SYSLOG ACCESS UNRESTRICTED;
Copied!
Copy link