DBQLObjTbl

Database
Enthusiast

DBQLObjTbl

Hi,

I've enabled all DBQLogTbl, DBQLSQLTbl, DBQLObjTbl, DBQLStepTbl and data is being logged into all the tables but only not in DBQLObjTbl.
Any idea?

We have databases created within DBC which we access like A.Table and querying against this table also doesn't log anything in DBQLObjTbl.
I am stating this because DBQLObjTbl does not logs data for DBC.XXX. Can this be the reason?
2 REPLIES
Enthusiast

Re: DBQLObjTbl

Clarification: Data was eventually logged into DBQLObjTbl but much later than the same data (with same QueryID) logged in DBQLogTbl. In our case, after approx. 45 minutes.
Enthusiast

Re: DBQLObjTbl

And one interesting finding which isn't explicitly documented as well:

If a View is queried then the Objects working inside the View are logged e.g. Tables, Columns.

CREATE VIEW TPCH.MyCustomerView AS
SELECT C_NAME AS MyCustName FROM TPCH.CUSTOMER WHERE C_NAME like '%42%';

And if the following query is executed:
Select MyCustName from TPCH.MyCustomerView where MyCustName like '%5%';

Then Object usage will be logged for Table 'CUSTOMER' and Column 'C_NAME' and not against View 'MyCustomerView' and View Column 'MyCustName'.

Now this poses a new question. When will the data of ObjectType='Viw' (Corresponding to View) be logged?