Specifies the name of a custom stage for bulk write operations in Snowflake. Supports internal stages (within Snowflake) and external stages on AWS S3, Azure Blob Storage, or Google Cloud Storage.

Data Type

string

Default Value

""

Remarks

If the stage is external, provide the corresponding AWS, Azure, or GCP credentials via ExternalStageAWSAccessKey/ExternalStageAWSSecretKey, ExternalStageAzureSASToken, or ExternalStageGCPAccessToken.

If the external stage uses client-side encryption, set ExternalStageEncryptionType to CSE and provide the key in ExternalStageMasterKey.

When the CustomStage property is left unspecified, the provider generates a temporary stage automatically during the upload process and delete it after the upload is complete.

To avoid parsing errors with the generated CSV, you should include the FIELD_OPTIONALLY_ENCLOSED_BY parameter on the stage definition and set it to the double quote character. Otherwise, you may face parsing issues if you have string values that contain special characters in CSV (such as commas or double quotes).

For example:

CREATE STAGE "TEST_STAGE_CDATA" FILE_FORMAT = (FIELD_OPTIONALLY_ENCLOSED_BY='\"' )

Use internal stages for small to medium-sized data or external stages for integrating with cloud storage systems like AWS S3, Azure Blob Storage, or Google Cloud Storage.