Snowflake

Snowflake is a cloud-based data warehousing platform that provides scalable and flexible data storage, processing, and analytics. It enables organizations to consolidate and analyze large volumes of data from various sources efficiently, leveraging its unique architecture and cloud-native capabilities.

Default hierarchy

In the chart below, you will find the organizational structure of Snowflake objects. Objects are in represented in green and folders are in yellow.

Object types

Database

Maps to Snowflake Database object type.

Source Attribute	Target Attribute in Dawiso
NAME	Name
COMMENT	Scanned Description
DATABASE_OWNER	Owner
IS_TRANSIENT	Is Transient
CREATED	Created
LAST_ALTERED	Last Altered
RETENTION_TIME	Retention Time

Schema

Maps to Snowflake Schema object type.

Source Attribute	Target Attribute in Dawiso
NAME	Name
COMMENT	Scanned Description
CATALOG_NAME	Catalog
SCHEMA_OWNER	Owner
IS_TRANSIENT	Is Transient
CREATED	Created
LAST_ALTERED	Last Altered
RETENTION_TIME	Retention Time

External Table

Maps to Snowflake External Table object type.

Source Attribute	Target Attribute in Dawiso
NAME	Name
COMMENT	Scanned Description
TABLE_CATALOG	Catalog
TABLE_SCHEMA	Schema
TABLE_OWNER	Owner
TABLE_TYPE	Type
IS_TRANSIENT	Is Transient
CLUSTERING_KEY	Clustering Key
CREATED	Created
LAST_ALTERED	Last Altered
LAST_DDL	Last DDL
LAST_DDL_BY	Last DDL By
ROW_COUNT	Row Count
BYTES	Bytes
RETENTION_TIME	Retention Time
AUTO_CLUSTERING_ON	Is Auto Clustering On
LOCATION	Location
FILE_FORMAT_NAME	File Format Name
FILE_FORMAT_TYPE	File Format Type

External Table Column

Maps to Snowflake External Table Column object type.

Source Attribute	Target Attribute in Dawiso
NAME	Name
COMMENT	Scanned Description
TABLE_CATALOG	Catalog
TABLE_SCHEMA	Schema
TABLE_NAME	Table
ORDINAL_POSITION	Id
COLUMN_DEFAULT	Default Value
IS_NULLABLE	Is Nullable
DATA_TYPE	Data Type
CHARACTER_MAXIMUM_LENGTH	Character Maximum Length
CHARACTER_OCTET_LENGTH	Character Octet Length
NUMERIC_PRECISION	Numeric Precision
NUMERIC_PRECISION_RADIX	Numeric Precision Radix
NUMERIC_SCALE	Numeric Scale
COLLATION_NAME	Collation
IS_IDENTITY	Is Identity
IDENTITY_GENERATION	Identity Generation
IDENTITY_START	Identity Start
IDENTITY_INCREMENT	Identity Increment
IDENTITY_CYCLE	Identity Cycle

File Format

Maps to Snowflake File Format object type.

Source Attribute	Target Attribute in Dawiso
NAME	Name
COMMENT	Scanned Description
FILE_FORMAT_CATALOG	Catalog
FILE_FORMAT_SCHEMA	Schema
FILE_FORMAT_OWNER	Owner
FILE_FORMAT_TYPE	Type
CREATED	Created
LAST_ALTERED	Last Altered
RECORD_DELIMITER	Record Delimiter
FIELD_DELIMITER	Field Delimiter
SKIP_HEADER	Skip Header Rows
DATE_FORMAT	Date Format
TIME_FORMAT	Time Format
TIMESTAMP_FORMAT	Time Stamp Format
BINARY_FORMAT	Binary Format
ESCAPE	Escape
ESCAPE_UNENCLOSED_FIELD	Escape Unenclosed Fields
TRIM_SPACE	Trim Space
FIELD_OPTIONALLY_ENCLOSED_BY	Field Optionally Enclosed By
NULL_IF	Null If
COMPRESSION	Compression
ERROR_ON_COLUMN_COUNT_MISMATCH	Error On Column Count Mismatch

Function

Maps to Snowflake Function object type.

Source Attribute	Target Attribute in Dawiso
NAME	Name
COMMENT	Scanned Description
FUNCTION_CATALOG	Catalog
FUNCTION_SCHEMA	Schema
FUNCTION_OWNER	Owner
FILE_FORMAT_TYPE	Type
CREATED	Created
LAST_ALTERED	Last Altered
ARGUMENT_SIGNATURE	Argument Signature
DATA_TYPE	Data Type
CHARACTER_MAXIMUM_LENGTH	Character Maximum Length
CHARACTER_OCTET_LENGTH	Character Octet Length
NUMERIC_PRECISION	Numeric Precision
NUMERIC_PRECISION_RADIX	Numeric Precision Radix
NUMERIC_SCALE	Numeric Scale
FUNCTION_LANGUAGE	Language
FUNCTION_DEFINITION	Definition
VOLATILITY	Volatility
IS_NULL_CALL	Is Null Call
IS_SECURE	Is Secure
IS_EXTERNAL	Is External
API_INTEGRATION	API Integration
CONTEXT_HEADERS	Context Headers
MAX_BATCH_ROWS	Max Batch Rows
COMPRESSION	Compression
PACKAGES	Packages
RUNTIME_VERSION	Runtime Version
INSTALLED_PACKAGES	Installed Packages
IS_MEMOIZABLE	Is Memoizable

Pipe

Maps to Snowflake Pipe object type.

Source Attribute	Target Attribute in Dawiso
NAME	Name
COMMENT	Scanned Description
PIPE_CATALOG	Catalog
PIPE_SCHEMA	Schema
PIPE_OWNER	Owner
CREATED	Created
LAST_ALTERED	Last Altered
DEFINITION	Definition
IS_AUTOINGEST_ENABLED	Data Type
NOTIFICATION_CHANNEL_NAME	Character Maximum Length
PATTERN	Character Octet Length

Procedure

Maps to Snowflake Procedure object type.

Source Attribute	Target Attribute in Dawiso
NAME	Name
COMMENT	Scanned Description
PROCEDURE_CATALOG	Catalog
PROCEDURE_SCHEMA	Schema
PROCEDURE_OWNER	Owner
ARGUMENT_SIGNATURE	Argument Signature
CREATED	Created
LAST_ALTERED	Last Altered
DATA_TYPE	Data Type
CHARACTER_MAXIMUM_LENGTH	Character Maximum Length
CHARACTER_OCTET_LENGTH	Character Octet Length
NUMERIC_PRECISION	Numeric Precision
NUMERIC_PRECISION_RADIX	Numeric Precision Radix
NUMERIC_SCALE	Numeric Scale
FUNCTION_LANGUAGE	Language
FUNCTION_DEFINITION	Definition
VOLATILITY	Volatility

Sequence

Maps to Snowflake Sequence object type.

Source Attribute	Target Attribute in Dawiso
NAME	Name
COMMENT	Scanned Description
SEQUENCE_CATALOG	Catalog
SEQUENCE_SCHEMA	Schema
SEQUENCE_OWNER	Owner
CREATED	Created
LAST_ALTERED	Last Altered
DATA_TYPE	Data Type
NUMERIC_PRECISION	Numeric Precision
NUMERIC_PRECISION_RADIX	Numeric Precision Radix
NUMERIC_SCALE	Numeric Scale
START_VALUE	Start Value
MINIMUM_VALUE	Min Value
MAXIMUM_VALUE	Max Value
NEXT_VALUE	Next Value
INCREMENT	Increment
CYCLE_OPTION	Cycle Option

Stage

Maps to Snowflake Stage object type.

Source Attribute	Target Attribute in Dawiso
NAME	Name
COMMENT	Scanned Description
STAGE_CATALOG	Catalog
STAGE_SCHEMA	Schema
STAGE_OWNER	Owner
CREATED	Created
LAST_ALTERED	Last Altered
STAGE_URL	Url
STAGE_REGION	Region
STAGE_TYPE	Type

Table

Maps to Snowflake Table object type.

Source Attribute	Target Attribute in Dawiso
NAME	Name
COMMENT	Scanned Description
TABLE_CATALOG	Catalog
TABLE_SCHEMA	Schema
TABLE_OWNER	Owner
TABLE_TYPE	Type
IS_TRANSIENT	Is Transient
CLUSTERING_KEY	Clustering Key
CREATED	Created
LAST_ALTERED	Last Altered
LAST_DDL	Last DDL
LAST_DDL_BY	Last DDL By
ROW_COUNT	Row Count
BYTES	Bytes
RETENTION_TIME	Retention Time
AUTO_CLUSTERING_ON	Is Auto Clustering On

Table Column

Maps to Snowflake Table Column object type.

Source Attribute	Target Attribute in Dawiso
NAME	Name
COMMENT	Scanned Description
TABLE_CATALOG	Catalog
TABLE_SCHEMA	Schema
TABLE_NAME	Table
ORDINAL_POSITION	Id
COLUMN_DEFAULT	Default Value
IS_NULLABLE	Is Nullable
DATA_TYPE	Data Type
CHARACTER_MAXIMUM_LENGTH	Character Maximum Length
CHARACTER_OCTET_LENGTH	Character Octet Length
NUMERIC_PRECISION	Numeric Precision
NUMERIC_PRECISION_RADIX	Numeric Precision Radix
NUMERIC_SCALE	Numeric Scale
COLLATION_NAME	Collation
IS_IDENTITY	Is Identity
IDENTITY_GENERATION	Identity Generation
IDENTITY_START	Identity Start
IDENTITY_INCREMENT	Identity Increment
IDENTITY_CYCLE	Identity Cycle

View

Maps to Snowflake View object type.

Source Attribute	Target Attribute in Dawiso
NAME	Name
COMMENT	Scanned Description
TABLE_CATALOG	Catalog
TABLE_SCHEMA	Schema
TABLE_OWNER	Owner
TABLE_TYPE	Type
CREATED	Created
LAST_ALTERED	Last Altered
LAST_DDL	Last DDL
LAST_DDL_BY	Last DDL By
VIEW_DEFINITION	Definition
IS_SECURE	Is Secure

View Column

Maps to Snowflake View Column object type.

Source Attribute	Target Attribute in Dawiso
NAME	Name
COMMENT	Scanned Description
TABLE_CATALOG	Catalog
TABLE_SCHEMA	Schema
TABLE_NAME	Table
ORDINAL_POSITION	Id
COLUMN_DEFAULT	Default Value
IS_NULLABLE	Is Nullable
DATA_TYPE	Data Type
CHARACTER_MAXIMUM_LENGTH	Character Maximum Length
CHARACTER_OCTET_LENGTH	Character Octet Length
NUMERIC_PRECISION	Numeric Precision
NUMERIC_PRECISION_RADIX	Numeric Precision Radix
NUMERIC_SCALE	Numeric Scale
COLLATION_NAME	Collation
IS_IDENTITY	Is Identity
IDENTITY_GENERATION	Identity Generation
IDENTITY_START	Identity Start
IDENTITY_INCREMENT	Identity Increment
IDENTITY_CYCLE	Identity Cycle