Vertica Analytics Platform

Supported versions

8, 9, 10

Supported schema elements and metadata

Dataedo reads the following metadata from Vertica Analytics Platform.

• Tables

  • Columns

    • Data type with length

    • Nullable

    • Default value

  • Primary keys

    • Columns

  • Unique indexes

    • Columns

  • Foreign keys

    • Columns

• Views

  • Columns (see tables)

  • Script

• Projections (displayed in the Views folder)

  • Columns (see tables)

  • Script

• Procedures

  • Script (SQL procedures only)

  • Parameters

• Functions

  • Script (SQL functions only)

  • Parameters

  • Returned value

Data profiling

Dataedo supports the following data profiling in Vertica:

• Tables

  • Rows count

• Column distribution

  • Distinct values

  • Non-distinct values

  • Empty

  • NULL

• Numeric columns profile

  • Minimum value

  • Maximum value

  • Average of values

  • Variance of values

  • Standard deviation

  • Span as difference between min and max value

  • Number of distinct values

• String columns profile

  • Min value as first string in alphabetical order

  • Max value as last string in alphabetical order

  • Number of distinct values

• Date columns profile

  • Min value as earliest date

  • Max value as latest date

  • Span as difference between min and max dates

  • Number of distinct dates

• Top N values

  • Top 10/100/1000 popular values

  • All values if less than 1000 distinct

  • 10 Random values

Read more about profiling in the Data Profiling documentation.