How To Write Custom SQL Logs In Elasticsearch/ Kibana?

How to write custom SQL logs in Elasticsearch/ Kibana ?

Below approaches which can be taken to consideration:

  • Orchestrator API calls
  • or to create a project in Studio which uses SQL database activities to write the custom SQL logs in ElasticSearch/ Kibana and it does the following:
    • connects to SQL database (specify Connection Configurations & the DatabaseConnection output variable)
    • executes SQL query (modify the needed SQL query)
    • iterates through each line & column through the SQL log data table
    • assigns a variable for each found element and writes it to ElasticSearch/ Kibana

Final result (SQL vs Kibana):