vertica

What problem does it solve?

This Skill helps you write, review, debug, and optimize Vertica SQL so your DDL/DML is correct and your queries perform efficiently on Vertica’s execution model.

Core Features & Use Cases

• Vertica-specific SQL patterns: covers DDL and DML including COPY-based bulk loads, CRUD operations, and Vertica upsert/update/delete workflows.
• Projection, segmentation, and partitioning guidance: explains how to choose ORDER BY, SEGMENTED BY keys, and PARTITION BY expressions to enable pruning and avoid expensive resegmentation.
• Query optimization and troubleshooting: provides EXPLAIN/ANALYZE_STATISTICS tactics and projection-hinting so you can fix slow plans and missing coverage.

Use case example: When loading a monthly fact table, generate the correct CREATE TABLE with segmentation and partitioning, load data via COPY (DIRECT for large volumes), then apply incremental changes using MERGE while keeping partition pruning effective.

Quick Start

Ask the AI to produce Vertica SQL for an incremental upsert into a partitioned, segmented table using MERGE, including staging deduplication and performance checks with EXPLAIN and ANALYZE_STATISTICS.