You can translate the question and the replies:

Store logs in csv format S3

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 https://community.denodo.com/kb/view/document/How%20to%20store%20Denodo%20logs%20in%20Amazon%20S3?category=Operation
AWS S3 query logs log4j2.xml logging
user
08-09-2020 07:00:27 -0400
code

1 Answer

Hi, To store the log activity in the CSV file formate, I would use the** Denodo Log Custom Wrapper ** available under “**Downloads > Denodo Connects**” section of the Support Site. After downloading, create a base view top of the custom data source in Virtual DataPort. Then use the **Denodo Scheduler**,to export the result periodically in the **CSV** file format. Finally, create a script to automate the uploading of the exported file to Amazon S3 using the Amazon CLI. For more information, you could refer to the following section, * [Denodo Log Custom Wrapper - User Manual](https://community.denodo.com/docs/html/document/denodoconnects/8.0/Denodo%20Log%20Custom%20Wrapper%20-%20User%20Manual) * [Reading the VDP logs with Denodo Log Custom Wrapper](https://community.denodo.com/kb/view/document/Reading%20the%20VDP%20logs%20with%20Denodo%20Log%20Custom%20Wrapper?category=Custom+Elements). * [Exporters Section](https://community.denodo.com/docs/html/browse/8.0/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/postprocessing_section_exporters). Hope this helps!
Denodo Team
10-09-2020 04:03:05 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here