/AWS1/CL_CRMSNOWFLAKETBLSCHV1

The Snowflake table schema.

CONSTRUCTOR

IMPORTING

Required arguments:

iv_columnname TYPE /AWS1/CRMCOLUMNNAME /AWS1/CRMCOLUMNNAME

The column name.

iv_columntype TYPE /AWS1/CRMCOLUMNTYPESTRING /AWS1/CRMCOLUMNTYPESTRING

The column's data type. Supported data types: ARRAY, BIGINT, BOOLEAN, CHAR, DATE, DECIMAL, DOUBLE, DOUBLE PRECISION, FLOAT, FLOAT4, INT, INTEGER, MAP, NUMERIC, NUMBER, REAL, SMALLINT, STRING, TIMESTAMP, TIMESTAMP_LTZ, TIMESTAMP_NTZ, DATETIME, TINYINT, VARCHAR, TEXT, CHARACTER.

---

Queryable Attributes

columnName

The column name.

Accessible with the following methods

Method	Description
GET_COLUMNNAME()	Getter for COLUMNNAME, with configurable default
ASK_COLUMNNAME()	Getter for COLUMNNAME w/ exceptions if field has no value
HAS_COLUMNNAME()	Determine if COLUMNNAME has a value

columnType

The column's data type. Supported data types: ARRAY, BIGINT, BOOLEAN, CHAR, DATE, DECIMAL, DOUBLE, DOUBLE PRECISION, FLOAT, FLOAT4, INT, INTEGER, MAP, NUMERIC, NUMBER, REAL, SMALLINT, STRING, TIMESTAMP, TIMESTAMP_LTZ, TIMESTAMP_NTZ, DATETIME, TINYINT, VARCHAR, TEXT, CHARACTER.

Accessible with the following methods

Method	Description
GET_COLUMNTYPE()	Getter for COLUMNTYPE, with configurable default
ASK_COLUMNTYPE()	Getter for COLUMNTYPE w/ exceptions if field has no value
HAS_COLUMNTYPE()	Determine if COLUMNTYPE has a value

Public Local Types In This Class

Internal table types, representing arrays and maps of this class, are defined as local types:

TT_SNOWFLAKETABLESCHEMALIST

TYPES TT_SNOWFLAKETABLESCHEMALIST TYPE STANDARD TABLE OF REF TO /AWS1/CL_CRMSNOWFLAKETBLSCHV1 WITH DEFAULT KEY
.