Skip to main content

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.