About Collectors
Pre-requisites
-
Python 3.6 - 3.10
-
Access to K landing directory
-
Access to Teradata
Step 1: Create Teradata permission
This step is performed by the Teradata Admin.
-
Login to Teradata
-
Create a KADA_USER account with read access to the following tables
dbc.DBQLOGTBL
dbc.DBQLSQLTBL
dbc.TABLESV
dbc.COLUMNSV
dbc.INDICESV
dbc.ALL_RI_CHILDRENV
dbc.TVM
dbc.DBASE
dbc.TABLES
dbc.TEXTTBL -
If you have PDCR enabled then also need to access to these tables
pdcrinfo.DBQLOGTBL_HST
pdcrinfo.DBQLSQLTBL_HST -
SHOW command access on tables, macros, procedures.