Skip to content

/AWS1/CL_APFSNOWFLAKECNCTORP00

The connector-specific profile properties required when using Snowflake.

CONSTRUCTOR

IMPORTING

Required arguments:

iv_warehouse TYPE /AWS1/APFWAREHOUSE /AWS1/APFWAREHOUSE

The name of the Snowflake warehouse.

iv_stage TYPE /AWS1/APFSTAGE /AWS1/APFSTAGE

The name of the Amazon S3 stage that was created while setting up an Amazon S3 stage in the Snowflake account. This is written in the following format: < Database>< Schema>.

iv_bucketname TYPE /AWS1/APFBUCKETNAME /AWS1/APFBUCKETNAME

The name of the Amazon S3 bucket associated with Snowflake.

Optional arguments:

iv_bucketprefix TYPE /AWS1/APFBUCKETPREFIX /AWS1/APFBUCKETPREFIX

The bucket path that refers to the Amazon S3 bucket associated with Snowflake.

iv_privatelinkservicename TYPE /AWS1/APFPVTLINKSERVICENAME /AWS1/APFPVTLINKSERVICENAME

The Snowflake Private Link service name to be used for private data transfers.

iv_accountname TYPE /AWS1/APFACCOUNTNAME /AWS1/APFACCOUNTNAME

The name of the account.

iv_region TYPE /AWS1/APFREGION /AWS1/APFREGION

The Amazon Web Services Region of the Snowflake account.


Queryable Attributes

warehouse

The name of the Snowflake warehouse.

Accessible with the following methods

Method Description
GET_WAREHOUSE() Getter for WAREHOUSE, with configurable default
ASK_WAREHOUSE() Getter for WAREHOUSE w/ exceptions if field has no value
HAS_WAREHOUSE() Determine if WAREHOUSE has a value

stage

The name of the Amazon S3 stage that was created while setting up an Amazon S3 stage in the Snowflake account. This is written in the following format: < Database>< Schema>.

Accessible with the following methods

Method Description
GET_STAGE() Getter for STAGE, with configurable default
ASK_STAGE() Getter for STAGE w/ exceptions if field has no value
HAS_STAGE() Determine if STAGE has a value

bucketName

The name of the Amazon S3 bucket associated with Snowflake.

Accessible with the following methods

Method Description
GET_BUCKETNAME() Getter for BUCKETNAME, with configurable default
ASK_BUCKETNAME() Getter for BUCKETNAME w/ exceptions if field has no value
HAS_BUCKETNAME() Determine if BUCKETNAME has a value

bucketPrefix

The bucket path that refers to the Amazon S3 bucket associated with Snowflake.

Accessible with the following methods

Method Description
GET_BUCKETPREFIX() Getter for BUCKETPREFIX, with configurable default
ASK_BUCKETPREFIX() Getter for BUCKETPREFIX w/ exceptions if field has no value
HAS_BUCKETPREFIX() Determine if BUCKETPREFIX has a value

privateLinkServiceName

The Snowflake Private Link service name to be used for private data transfers.

Accessible with the following methods

Method Description
GET_PRIVATELINKSERVICENAME() Getter for PRIVATELINKSERVICENAME, with configurable default
ASK_PRIVATELINKSERVICENAME() Getter for PRIVATELINKSERVICENAME w/ exceptions if field has
HAS_PRIVATELINKSERVICENAME() Determine if PRIVATELINKSERVICENAME has a value

accountName

The name of the account.

Accessible with the following methods

Method Description
GET_ACCOUNTNAME() Getter for ACCOUNTNAME, with configurable default
ASK_ACCOUNTNAME() Getter for ACCOUNTNAME w/ exceptions if field has no value
HAS_ACCOUNTNAME() Determine if ACCOUNTNAME has a value

region

The Amazon Web Services Region of the Snowflake account.

Accessible with the following methods

Method Description
GET_REGION() Getter for REGION, with configurable default
ASK_REGION() Getter for REGION w/ exceptions if field has no value
HAS_REGION() Determine if REGION has a value