Connection Parameters
Overview
Tokern Lineage Engine supports the following databases:
- PostgreSQL
- AWS Redshift
- Snowflake
The connection parameters required for each of these databases are described below.
PostgreSQL
Specify the following parameters to connect to PostgreSQL.
- username
- password
- uri
- database
- port
Ensure role has permissions to read metadata from INFORMATION SCHEMA
Run the following command to give user permissions to read metadata for all columns in a schema.
GRANT SELECT ON ALL TABLES IN SCHEMA <schema name> TO <username>;
AWS Redshift
Specify the following parameters to connect to PostgreSQL.
- username
- password
- uri
- database
- port
Ensure user has SYSLOG ACCESS
Run the following command to give user permissions to read metadata for all columns in a schema.
ALTER USER <username> WITH SYSLOG ACCESS UNRESTRICED;
For more information check AWS Redshift documentation
Snowflake
Specify the following parameters to connecto to Snowflake
- account
- username
- password
- database
- warehouse
- role
account is account_identifier of your Snowflake account
Typically, the account identifier will have the following format:
<account-identifier>.snowflakecomputing.com
Specify only the first part of the url.