> ## Documentation Index
> Fetch the complete documentation index at: https://docs.blinkops.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Vertica

> The column-oriented Vertica Analytics Platform is designed to manage large, fast-growing volumes of data and with fast query performance for data warehouses and other query-intensive applications.

## Creating a Vertica connection

Select one of the following methods to create a GCP connection:

* [Using an account](#using-an-account)
* [Using a data source name](#using-a-data-source-name)

## Using an account

To create the connection you need:

* Access to your Vertica cluster
* Define which account and database you wish to connect with

### Creating your connection

1. In the Blink platform, navigate to the **Connections** page > **Add connection.** A New Connection dialog box opens displaying icons of external service providers available.

2. Select the **Vertica** icon. A dialog box with name of the connection and connection methods appears.

3. (Optional) Edit the name of the connection. At a later stage you cannot edit the name.

4. Select **Password** as the method to make the connection.

5. Fill in the parameters:

   * *Username* of the user to use for authentication.
   * *Password* of the user to use for authentication.
   * The *Hostname* of the Vertica server, without a protocol. Can be an IP or a domain name, but must be accessible to your runner.
   * The *Port* number of the server to connect to.
   * Name of the *Database* you wish you operate on.

6. (Optional) Click **Test Connection** to test it.

7. Click **Create connection**. The new connection appears on the **Connections** page.

## Using a data source name

If you want to use a different type of authentication, you can use a custom DSN (Data Source Name) for Blink.

View the [Go Vertica Documentation](https://github.com/vertica/vertica-sql-go#creating-a-connection) on how to format the connection string.

### Creating your connection

1. In the Blink platform, navigate to the **Connections** page > **Add connection**. A New Connection dialog box opens displaying icons of external service providers available.
2. Select the **Vertica** icon. A dialog box with name of the connection and connection methods appears.
3. (Optional) Edit the name of the connection. At a later stage you cannot edit the name.
4. Select **DSN** as the method to make the connection.
5. Fill in the parameters:
   * The full *DSN* string to use for connection.
6. (Optional) Click **Test Connection** to test it.
7. Click **Create connection**. The new connection appears on the **Connections** page.