Vertica Array and Row types

Vertica Array and Row data types can be manipulated in Semarchy xDI and proceed in the data flows.

Design and Reverse Engineering

Vertica Array and Row data types are designed in the Vertica metadata. They are automatically reverse engineered with the tables or can be manually designed. See Getting Started with Vertica database.

Read data

To read data within Vertica Array and Row types:

  1. Create a mapping.

  2. Add the Vertica table containing Array and Row types as the source.

  3. Add any target datastore.

  4. Map the source columns to the target columns.

Finally, run the mapping.

Write data

The Semarchy xDI Vertica component doesn’t support writing to Array and Row types in a mapping yet. This will be added in a future version.