How do Data360 DQ+ and Vertica Interact?

The general flow of data is as follows:

1) The data view is a table created in Vertica based on a datastore.

2) The Vertica table has the pattern: ds_devEnvId_owningMemberId_(5 to 8)digitsOfdataViewName_******

3) So you would typically see tables such as ds_1000_1000_8a5d086_1849008e9 where 8a5d086 is pulled from the UID of the datastore.

4) If you specify the ‘Table Name Prefix’ on the DV creation screen, the table name would be of the type ds_tablenameprefix_devEnvId_owningMemberId_****

Once the table is created, with all the selected fields, dimensions, calculated fields, etc. the dashboards query these tables to get the results and display.