Monitor your Vertica Metrics in Prometheus Using the New Vertica Prometheus Exporter

Monitor your Vertica Metrics in Prometheus Using the New Vertica Prometheus Exporter
Posted October 31, 2022 by Amrita Akshay , Information Developer
LinkedIn
Looking to visualize Vertica metrics in your favorite monitoring tool that supports Prometheus? You can now do it with the Vertica Prometheus Exporter!
We are happy to announce the Vertica Prometheus Exporter, an open-source project now available on Vertica’s GitHub . The exporter uses the vertica-sql-go driver to connect to Vertica.
Prometheus is a monitoring system that collects metrics and stores it in a time series database.
With the new Vertica exporter, you can get your metrics from Vertica into Prometheus and use the Prometheus dashboard to display and visualize data as tables and graphs or use a third-party tool that supports Prometheus for a detailed view of your metrics.
These metrics are defined in collector files, and you can easily set up multiple collector files each with its own configuration. So, you can fully customize what metrics you want to collect, the scrape frequency, how to label, whether to cache metrics, and manage visualization. It comes with other features such as verbose logging with adjustable retention, sample collectors, and extensive documentation.
The Vertica Prometheus exporter not only enables you to ingest Vertica metrics into a unified dashboard but also control the number of connections to Vertica and optimize queries for your environment.
Our GitHub page has Exporter related content including the Readme, sample collector files, configurations, tips and techniques, docker builds, and troubleshooting to make best use of the exporter.
We encourage you to contribute to this open-source project by submitting your metrics collector files or enhancements that will help the Vertica community and others who are interested in using the exporter.
Amrita Akshay
Information Developer
With over a decade of technical writing experience, I currently author and maintain the Knowledge Base for Big Data Partner Engineering. I have experience authoring software documentation both offline and online including knowledge of various aspects of information development such as web content, blog posts, UI design, and work processes. My main focus is user-centered documentation and I strongly believe in 'right information at the right place'.
Enter your email address to receive the monthly Vertica newsletter.
See More Vertica Blog Posts
Amrita Akshay , Information Developer
October 11, 2022
DataSpider Servista easily integrates and connects data across a wide variety of systems and applications – including cloud and on-premises systems, IoT integrations, and business intelligence – all with a simple GUI. To make use of DataSpider features with Vertica data, you can connect using either a JDBC or an ODBC driver. To know more,...
Amrita Akshay , Information Developer
April 29, 2022
Good news for GitLab users! You can now integrate GitLab with Vertica to run your SQL scripts in GitLab CI/CD itself with GitLab runner. Alternatively, you can integrate using only Linux or a Git supported database IDE. These integrations are explained in detail in the Vertica and GitLab: Technical Exploration in our Knowledge Base.
Amrita Akshay , Information Developer
October 29, 2021
We are very excited to announce our end-to-end analytics of Vertica with Alteryx Designer. You can now process and analyze your entire dataset easily and quickly. Vertica enables you to run your analytics in the database from the models that you create in Alteryx Designer. You can create a predictive model in Alteryx Designer and...
Jeremiah Morrow , Senior Industry Product Marketing Manager
September 2, 2021
Vertica is participating in the BIG 5G Event 2021 in Denver next week. In addition to our virtual and in-person booth, as a part of the show, I’m joining some great speakers in a panel discussion on how AI & ML will enhance the customer experience in the 5G era. Telecom operators have leveraged predictive...
End User License Agreement
Read carefully before downloading the software
You may not use more than 1TB (including Parquet and ORC External Tables) and 3 nodes.
You may not use software to provide services to third parties.
You may not distribute, resell, share or sublicense software to third parties.
You may not download and use patches, enhancements, bug fixes, or similar updates unless you have a license to the underlying software.  Community Edition license does not give you a right to receive such updates.
You may not copy the Software or make it available on a public or external distributed network.
You may copy the Software for archival purposes or when it is an essential step in authorized use so long as You retain any product identification, trademark, copyright or other notices in the Software.
You may not modify, reverse engineer, disassemble, decrypt, decompile or make derivative works of the Software.  If you have a right to do so under law, you must first inform Microfocus in writing about such modifications.
You may not disclose to any third-party performance information or analysis (including, without limitation, benchmarks and performance tests) from any source relating to the Software.
Support is not included. Additional information regarding the software may be available from the Vertica Community at https://forum.vertica.com. Vertica has no obligation to provide You with any bug fixes, upgrades, patches, new versions, new releases, or support.
You consent to the collection of anonymous analytics.
What are we collecting? We collect anonymized data including the date and timestamp, number of nodes, data size, storage size, version #, OS and other data. We’re collecting this information to learn how we can make the product better for you in the future.
How is this information stored and processed? We store and process all information on our secure servers. No third-party has access to any of this data.
What about my personal information? We do not track or store any personal data. All data collected is anonymized, including your IP address.