Q&A BY TAG 'query logs'

You must sign in to ask a question. If you do not have an account, you can register here

Fetching View's underlying query
answered 16-10-2020 08:53:59 -0400

Hi Denodo team, I have a requirement of fetching view and also the query through which this view is created if that view is created by query.I have tried GET_VIEWS(), CATALOG_VDP_METADATA_VIEWS() and CATALOG_METADATA_VIEWS() procedures.But none of them...

Answers: 1

Base view Stored Procedures query logs Denodo view

Store logs in csv format S3
answered 10-09-2020 04:03:05 -0400

Hello, I have set up the log4j.xml file to store the VDP-queries log to S3 location. I can see that the files stored are in an unreadable format. Can you please let me know if I can store them in csv format? I have followed the below link to set it up...

Answers: 1

AWS S3 query logs logging log4j2.xml

Change the delimiter in Denodo VDP-Queries logs
answered 12-08-2020 07:29:58 -0400

Hello, We are working on reporting the Queries used by the users. We have edited the Logj4.xml file to get the queries logged into VDP-Queries.log file. But the rows are being delimited by tabs. Can you please help us in what we need to change in the ...

Answers: 2

delimiter VDP-Queries query logs

Logging of User Queries via ODBC
answered 11-08-2020 15:01:04 -0400

Hello, We have lots of users querying Denodo views via ODBC connection in Power BI. Is there an option to get the information of the different queries run by them via Denodo to report them.

Answers: 1

user queries ODBC logging query logs

change query-log values
answered 20-08-2018 00:05:52 -0400

Hi, by exploring the logfiles, in vdp-queries.log is one column called "server_name", having the value "vdp" in all logfiles. Is it possible to configure denodo to show the physical name of the server in this column?

Answers: 5

query logs