4.5 Ensure that the REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION account parameter is set to true

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.

See Also

https://workbench.cisecurity.org/benchmarks/14781

Item Details

Category: AUDIT AND ACCOUNTABILITY, SYSTEM AND INFORMATION INTEGRITY

References: 800-53|AU-11, 800-53|SI-12

Plugin: Snowflake

Control ID: 5bd14e6ba7b99d4eda5890fbe394f35abcedb1d307fc31979ab831e84f8db807