Vertica is a columnar analytical database designed for large-scale data warehousing and real-time analytics. It is optimized for fast query performance on large datasets through its columnar storage engine and massively parallel processing (MPP) architecture. Vertica is commonly used as a high-performance analytical layer fed by ETL pipelines from operational databases.
Default hierarchy
In the chart below, you will find the organizational structure of Vertica objects. Objects are in represented in green and folders are in yellow.
Object types
Database
Maps to Vertica Database object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| database_name | Nameame |
| database_owner | Database Owner |
Schema
Maps to Vertica Schema object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| schema_name | Name |
| schema_owner | Schema Owner |
| create_timestamp | Created |
Table
Maps to Vertica Table object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| table_name | Name |
| table_owner | Table Owner |
| description | Description |
| is_temp_table | Is Temporary Table |
| is_flextable | Is Flextable |
| partition_expression | Partition Expression |
| create_timestamp | Created |
Table column
Maps to Vertica Table Column object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| column_name | Name |
| description | Description |
| data_type | Data Type |
| data_type_lenght | Data Type Length |
| ordinal_position | Ordinal Position |
| is_nullable | Is Nullable |
| column_default | Column Default |
| numeric_precision | Precision |
| numeric_scale | Scale |
| is_identity | Is Identity Column |
View
Maps to Vertica View object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| view_name | Name |
| view_owner | Table Owner |
| description | Description |
| definition | View Definition |
| create_timestamp | Created |
View column
Maps to Vertica View Column object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| column_name | Name |
| description | Description |
| data_type | Data Type |
| data_type_lenght | Data Type Length |
| ordinal_position | Ordinal Position |
| is_nullable | Is Nullable |
| column_default | Column Default |
| numeric_precision | Precision |
| numeric_scale | Scale |
| is_identity | Is Identity Column |
Projection
Maps to Vertica Projection object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| projection_name | Name |
| projection_owner | Projection Owner |
| anchor_table | Anchor Table |
| definition | Projection Definition |
| is_super_projection | Is Super Projection |
| is_segmented | Is Segmented |
| is_up_to_date | Is Up To Date |
| create_type | Create Type |
Function
Maps to Vertica Function object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| function_name | Name |
| function_owner | Function Owner |
| description | Description |
| definition | Function Definition |
| function_return_type | Function Return Type |
| function_argument_type | Function Argument Type |
| volatility | Volatility |
| is_strict | Is Strict |
Procedure
Maps to Vertica Procedure object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| procedure_name | Name |
| procedure_owner | Procedure Owner |
| procedure_definition | Definition |
| language | Procedure Language |
| arguments | Procedure Arguments |
| security | Security Type |