Skip to main content
INFOColumn-level Lineage is not currently supported for Teradata.
Steps to complete:
  1. Configure user in Teradata
  2. Create a temporary database for Datafold
  3. Configure data connection in Datafold

​
Configure user in Teradata

To connect to Teradata, create a user with read-only access to all databases you may wish to diff, including the login database: 
CREATE USER DATAFOLD AS PERMANENT=1000000000 BYTES PASSWORD= <PASSWORD> COLLATION = ASCII TIME ZONE ='GMT';
GRANT EXECUTE FUNTION ON DB1 TO DATAFOLD;
GRANT SELECT ON DB1 TO DATAFOLD;
...
GRANT SELECT ON DB9 TO DATAFOLD;

​
Create a temporary database for Datafold

Datafold requires a database to store temporary data with full permissions: 
CREATE DATABASE DATAFOLD_TMP AS PERMANENT=10000000000 BYTES;
GRANT ALL ON DATAFOLD_TMP TO DATAFOLD;

​
Configure data connection in Datafold

Field NameDescription
Connection NameA name given to the data connection within Datafold.
HostThe hostname for your Teradata instance (e.g., account-name-2e3ba8b32qac9d.env.clearscape.teradata.com for Teradata SaaS).
PortTeradata endpoint port; the default value is 1025.
User IDUser ID, e.g., DATAFOLD.
PasswordPassword from above.
DatabaseThe connection database, e.g., DB1 from above.
Database for Temporary TablesThe temporary database, e.g., DATAFOLD_TMP from above.
Click Create. Your data connection is now ready!