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 […] The post Unveiling the Most Recent Version of the Vertica Grafana Data Source Plugin appeared first on OpenText™ Vertica™.| OpenText™ Vertica™
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 […] The post Setting Session Authorization to Troubleshoot appeared first on OpenText™ Vertica™.| OpenText™ Vertica™
Vertica provides two functions, UNNEST and EXPLODE to expand arrays into one or more rows. These functions offer the same functionality with subtle differences in syntax and output. Let’s understand […] The post UNNEST vs EXPLODE Functions appeared first on OpenText™ Vertica™.| OpenText™ Vertica™
In Eon Mode, when a query is executed and if the ROS containers associated to the tables in the query are not present in depot, it will fetch results from […] The post Checklist for Inconsistent Execution Time of Same Query in Eon Mode appeared first on OpenText™ Vertica™.| OpenText™ Vertica™
Authored by Badr Ouali and Umar Farooq Ghumman Welcome to VerticaPyLab, a transformative solution that paves the way for effortless Machine Learning and Data Analytics. If the world of Python’s […] The post Exploring VerticaPyLab: A Quick Start to ML, Data Analytics, and Vertica appeared first on OpenText™ Vertica™.| OpenText™ Vertica™
Co-authored with Oussama Chakri. Update – The upgraded dbt-vertica adapter is now available! It supports dbt-core version 1.5.0 with Vertica 23.3. We added new features, and the adapter works well […] The post Updated – Unlock the Potential of Your Data in Vertica with dbt: Experience ETL-Free Data Transformation appeared first on OpenText™ Vertica™.| OpenText™ Vertica™
Co-authored with Oussama Chakri. Update – The upgraded DataHub-Vertica Plugin is now available! It is updated with Datahub 0.10.5.4V. You’ll see improved performance while getting metadata into DataHub. Check out […] The post Updated – Unlock the Potential of Data Discovery in Vertica with DataHub: Master Metadata and Accelerate Data Access appeared first on OpenText™ Vertica™.| OpenText™ Vertica™
You might have come across this. You would have obtained a huge set of time stamped log data or sensor data that you would like to understand. Millions of rows […] The post How to Group Timeseries Data at Any Granularity appeared first on OpenText™ Vertica™.| OpenText™ Vertica™
Thanks to its sophisticated optimizer and extremely efficient query engine Vertica can process data aggregations order of magnitudes faster than traditional Database Management Systems. To further boost data aggregation performance, […] The post How to Use UDx to Extend Vertica Live Aggregate Projections appeared first on OpenText™ Vertica™.| OpenText™ Vertica™
The latest release of the Vertica analytical database, now OpenTextTM VerticaTM includes a lot of features that Vertica customers have been eagerly awaiting like: Resharding the database as needed Rollback snapshots that capture a moment in time without a whole other data copy Workload routing so you can automate directing specific queries to just the right compute for that type of job. And more ...| OpenText™ Vertica™
