This page documents the functional configuration that is necessary and recommended in Anjana in order to make the most of the Snowflake integration capabilities via the tot-plugin-snowflake plugin.
Metadata extraction
The plugin is able to extract metadata from Snowflake tables, views and materialized views and incorporate it into the templates of entities of subtype DATASET and DATASET_FIELD.
For the metadata extraction to work correctly, the following mandatory attributes must be configured in the DATASET template:
|
Attribute name (name) |
Attribute type (type) |
|
catalog |
INPUT_TEXT |
|
schema |
INPUT_TEXT |
|
physicalName |
INPUT_TEXT |
|
path |
INPUT_TEXT |
|
infrastructure |
SELECT |
|
technology |
SELECT |
|
zone |
SELECT |
|
name |
INPUT_TEXT |
|
description |
ENRICHED_TEXT_AREA_INTERNATIONAL |
And the following ones in the DATASET_FIELD template:
|
Attribute name (name) |
Attribute type (type) |
|
name |
INPUT_TEXT |
|
position |
INPUT_NUMBER |
|
pk |
INPUT_CHECKBOX |
|
description |
ENRICHED_TEXT_AREA_INTERNATIONAL |
The attributes shown below are metadata available in the Snowflake API and are only incorporated into the DATASET and DATASET_FIELD templates if an attribute with the same naming exists in the template of each entity; their incorporation is optional, since they are not part of the stable contract of the plugin: