Database Setup

This page provides an overview on setting up a Vertica database . For complete details see Configuring the Database.

Prepare SQL Scripts and Data Files

Prepare the following files before installing Vertica:

Create the Database

Create the database after installing Vertica on at least one host:

Test the Empty Database

Test the Partially-Loaded Database

Complete the Fact Table Load

Set up Security

For security-related tasks, see Security and Authentication .

Set up Incremental Loads

Set up periodic (trickle) loads, see Trickle Loading