The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

HTTP Export

Hello, is there a way to send the result of an sql query through and HTTP POST request with vertica, something like the KafkaExport method but via HTTP


Best Answer

  • Bryan_HBryan_H Vertica Employee Administrator
    Answer ✓

    There is not a built-in way to do this, but I can think of a few ways to implement:
    Within Vertica, develop a UDTF that will send rows via HTTP POST. KafkaExport is itself a C++ UDTF. See documentation at
    Outside Vertica, use command-line tools to run SQL and pipe to HTTP POST, e.g. vsql -c | curl -H "Content-Type: text/csv" -X POST --data-binary @- http://api
    There may be third-party ETL or batch tools that can also push SQL results over HTTP POST.
    You can also submit a feature request via support or your account team.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file