Connect Teradata

Connect your Teradata source to Bigeye.

1. Create a Teradata read-only user

Bigeye recommends creating a read-only user to connect to your database. Here is a sample of GRANT statement for creating a read-only user:

GRANT SELECT ON <schema> to bigeye_read_only;

2. Grant select privileges to the schemas that Bigeye can access

As an example, the below query will generate the grant statements to run against the Teradata instance

SELECT 'GRANT SELECT ON '||databaseName||' TO bigeye_read_only;'
FROM dbc.databasesV
WHERE databaseName like 'EDW%'

3. Configure the agent to connect to Teradata

Follow instructions in the link below to configure the agent Agent Connection
Instructions to download the Teradata JDBC driver and configuration can be found at Teradata JDBC Driver Download and Configuration

A sample configuration to connect to Teradata is published in agent.yaml.tmpl.

4. Next Steps

After you've configured the source, Bigeye loads and profiles your tables. It can take up to 24 hours for the profiling to complete.