Adhoc request

Database
KVB
Enthusiast

Adhoc request

Hi

 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

Which columns

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?

1 REPLY
Enthusiast

Re: Adhoc request

Hi,

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.