Information
Ensure that creating an external stage to access a private cloud storage location requires referencing a storage integration object as cloud credentials.
Using storage integration removes the need to supply credentials when creating external stages or when loading or unloading data. This reduces the risk of those credentials being leaked and data compromised.
Requiring a storage integration when creating a new stage reduces the risk or data exfiltration by accidentally exporting sensitive data to an external stage that does not have the appropriate network security, access control, or encryption security and is not approved by the organization's security team.
Solution
Programmatically:
In a Snowsight worksheet or from the SNOWSQL cli, run the following command to set the parameter value to true :
ALTER ACCOUNT
SET REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION=true;
Note: To avoid disruption of existing workflow relying on creation of external stages not referencing a storage integration, all such workflows should be identified and migrated to creation of external stages referencing storage integrations.
Impact:
Setting the REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION account level parameter to true can break existing manual and automated flows relying on creation of external stages not backed by a storage integration.