- Install the Teradata plugin for DataHub in the environment where you have DataHub installed
pip install 'acryl-datahub[teradata]'
- Setup a Teradata user and set privileges to allow that user to read the dictionary tables
CREATE USER datahub FROM <database> AS PASSWORD = <password> PERM = 20000000;
GRANT SELECT ON DBC.DatabasesV TO datahub;
GRANT SELECT ON DBC.TablesV TO datahub;
GRANT SELECT ON DBC.ColumnsV TO datahub;
GRANT SELECT ON DBC.IndicesV TO datahub;
GRANT SELECT ON dbc.TableTextV TO datahub;
GRANT SELECT ON DBC.All_RI_ChildrenV TO datahub;
-- if lineage or usage extraction is enabled
GRANT SELECT ON dbc.dbqlogtbl TO datahub;
GRANT SELECT ON dbc.QryLogV TO datahub;
GRANT SELECT ON dbc.QryLogSqlV TO datahub;
-
If you want to run profiling, you need to grant select permission on all the tables you want to profile.
-
If you want to extract lineage or usage metadata, query logging must be enabled and it is set to size which will fit for your queries (the default query text size Teradata captures is max 200 chars) An example how you can set it for all users:
-- set up query logging on all
REPLACE QUERY LOGGING WITH SQL LIMIT SQLTEXT=2000 ON ALL;