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.
Updated 4 months ago