Teradata - How to get number acces by table and by month

671 Views Asked by At

I am tring to get an user number per table and per month.

I am trying to get read access (select and no update delete) Do you know if it is possible to get this with view like dbc.tables ?

Database    |   Table   |   Date (YYYYMM)   |   Number of access | Number of distinct access
------------|-----------|-------------------|----------------------------------------------
PROD        | SALES     | 202004            | 500                | 300 
PROD        | SALES     | 202003            | 550                | 330
DEV         | SALES     | 202004            | 15                 | 10

P.S : English isn't my native langage => sorry

1

There are 1 best solutions below

1
Abasesha On

"Accesscount" column in dbc.tables will give you the number of times a particular object has been accessed.