I have a doubt regarding the following things in Teradata.If I have a particular table then how am i going to find the below things.Do we require a special privilege to look after these or we can achieve using any data dictionary objects?
Who all are accessing the table / view
How frequent they are accessing
What is the source for the data
How frequent is the data loaded
What is total volume of the data in the table
What tables are populated from this? (How many level should we go up?) maybe one level up..?
Could anyone please help me in this regard?
You can get these things,
sel * from dbc.DBQLSqlTbl where SQLTEXTINFO LIKE '%TABLENAME%' -- To get the Queries used against the Table
SEL * FROM DBC.TABLES WHERE TABLENAME=<<TABLENAME>>; - To get the Table Definition.
sel * from dbc.TableSize where tablename='<<TABLENAME>>'; -- To get the Table Size
Thanks & Regards,
Adharssh Hospet Srinivasa Rao.