Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
This article outlines how to use the copy activity in a data pipeline to copy data from Vertica.
To use Vertica connector, install the Vertica ODBC driver on the machine by following these steps:
Download the Vertica client setup for ODBC driver from Client Drivers | OpenText™ Vertica™. Take Windows system setup as an example:
Open the downloaded .exe to begin the installation process.
Select ODBC driver under Vertica Component List, then select Next to start the installation.
After the installation process is successfully completed, you can go to Start -> ODBC Data Source Administrator to confirm the successful installation.
For the configuration of each tab under the copy activity, go to the following sections respectively.
For General tab configuration, go to General.
The following properties are supported for Vertica under the Source tab of a copy activity.
The following three properties are required:
If you select Table:
Table: Specify the name of the Vertica table to read data. Select the table from the drop-down list or select Enter manually to enter the schema and table name.
If you select Query:
Query: Specify the custom SQL query to read data. For example: SELECT * FROM MyTable
.
Under Advanced, you can specify the following fields:
For the Mapping tab configuration, go to Configure your mappings under mapping tab.
For the Settings tab configuration, go to Configure your other settings under settings tab.
The following table contains more information about the copy activity in Vertica.
Name | Description | Value | Required | JSON script property |
---|---|---|---|---|
Connection | Your connection to the source data store. | <your connection> | Yes | connection |
Use query | The way to read data. Apply Table to read data from the specified table or apply Query to read data using SQL queries. | • Table • Query |
Yes | / |
For Table | ||||
schema name | Name of the schema. | < your schema name > | No | schema |
table name | Name of the table. | < your table name > | No | table |
For Query | ||||
Query | Specify the custom SQL query to read data. For example: SELECT * FROM MyTable . |
< SQL queries > | No | query |
Additional columns | Add additional data columns to store source files' relative path or static value. Expression is supported for the latter. | - Name - Value |
No | additionalColumns: - name - value |
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register today