

# Creating a Vertica source node
<a name="creating-vertica-source-node"></a>

## Prerequisites needed
<a name="creating-vertica-source-node-prerequisites"></a>
+ A Vertica type AWS Glue Data Catalog connection, {{connectionName}} and a temporary Amazon S3 location, {{tempS3Path}}, as described in the previous section, [Creating a Vertica connection](creating-vertica-connection.md).
+ A Vertica table you would like to read from, {{tableName}}, or query {{targetQuery}}.

## Adding a Vertica data source
<a name="creating-vertica-source-node-add"></a>

**To add a **Data source – Vertica** node:**

1.  Choose the connection for your Vertica data source. Since you have created it, it should be available in the dropdown. If you need to create a connection, choose **Create Vertica connection**. For more information see the previous section, [Creating a Vertica connection](creating-vertica-connection.md). 

    Once you have chosen a connection, you can view the connection properties by clicking **View properties**. 

1. Choose the **Database** containing your table.

1. Choose the **Staging area in Amazon S3**, enter an S3A URI to {{tempS3Path}}.

1. Choose the **Vertica Source**.
   +  **Choose a single table** – access all data from a single table. 
   +  **Enter custom query ** – access a dataset from multiple tables based on your custom query. 

1.  If you chose a single table, enter {{tableName}} and optionally select a **Schema**. 

    If you chose **Enter custom query**, enter a SQL SELECT query and optionally select a **Schema**. 

1.  In **Custom Vertica properties**, enter parameters and values as needed. 