Vertica Database Management in VS Code

Overview

Vertica (now OpenText Analytics Database) is a columnar, massively parallel processing (MPP) analytics database built for large-scale data warehousing and high-concurrency analytical workloads. It’s known for:

• Columnar MPP architecture: Column storage with projections for fast analytical queries over very large datasets
• Projections: Physical, pre-optimized storage structures that Vertica tunes for query performance
• Scale and concurrency: Designed for petabyte-scale warehouses and many concurrent analytical users
• SQL with analytics extensions: ANSI SQL plus a rich set of in-database analytic functions
• Deployment flexibility: Runs on-premises, in the cloud, and in Eon mode with separated compute and storage

Vertica suits organizations running data warehousing, BI, and large-scale analytics where query performance over big data matters.

Connecting

To connect to Vertica in DBCode:

1. Open the DBCode Extension: Launch Visual Studio Code and open the DBCode extension.
2. Add a New Connection: Click on the “Add Connection” icon.
3. Complete the connection form: Select Vertica as the database type and enter:
   • Host address (default port: 5433)
   • Authentication credentials (username/password)
   • Database name
   • SSL options (if required)
4. Connect: Click save to connect to your Vertica database.
5. Start Managing Your Database: Once connected, browse schemas, tables, views, projections, and run queries.

For detailed instructions on connecting, refer to the Connect article.

DBCode Features for Vertica

With DBCode, you can perform these essential tasks when working with Vertica:

• Schema Browser: Navigate schemas, tables, views, columns, constraints, projections, sequences, and functions
• Data Editing: Edit table data with support for Vertica data types
• Query Execution: Run analytical queries with full SQL support, including EXPLAIN execution plans
• Server Monitoring: Inspect sessions, locks, and resource pool usage
• DDL Scripting: Generate object DDL via Vertica’s EXPORT_OBJECTS
• Read-Only Connections: Open a connection in read-only mode to guard against accidental changes
• Bulk Data Import/Export: Import from CSV, Excel, and JSON files

By using Vertica with DBCode, you can manage your analytics database directly within the familiar VS Code environment.

For more information about Vertica, check out OpenText Analytics Database (Vertica).