Vertica Blog

OpenText Vertica 23.3 – the Smarter Data Lakehouse

Posted July 31, 2023 by Paige Roberts, Vertica Open Source Relations Manager

Read More

Unveiling the Most Recent Version of the Vertica Grafana Data Source Plugin

Amrita Akshay, Information Developer
October 12, 2023

With over 380K downloads, the Vertica Grafana Data Source plugin just got an upgrade! The plugin was migrated from the deprecated older Grafana toolkit to align with Grafana's new Create-Plugin tool. This accelerates the plugin development with their modern build set up that requires no additional configuration. Additionally, the Vertica SQL Go driver received an...
Quick Tip on a blue enter key on a keyboard

Setting Session Authorization to Troubleshoot

Sruthi Anumula, Senior Database Support Engineer
September 29, 2023

There are possible scenarios in which a dbadmin would want to run queries as another user to troubleshoot or test. You can use SET SESSION AUTHORIZATION to impersonate another user and run queries. Let's understand this with an example. Here we create a user named test, resource pool named userpool, and make this a default...
Three 3D arrows, different colors pointing in different directions

North East Database Day Conference

Vertica Technical Team
February 15, 2018

This blog post was authored by Eden Zik. On January 19th, Vertica engineers joined the North East database community for the North East Database Day conference organized annually at MIT, sponsored by Facebook and Microsoft and featuring Turing award winner Michael Stonebraker. The full conference program can be found here: http://mitdbg.github.io/nedbday/2018/ This year Styliani Pantela...

Vertica Quick Tip: Viewing Query Error Information

Soniya Shah, Information Developer
February 15, 2018

This blog post was authored by Jim Knicely. The V_MONITOR.ERROR_MESSAGES system table tracks error and warning messages encountered while processing queries. If you need a bit more info, like the cursor position of a syntax error, you can query the data collector table DC_ERRORS. Have fun!