4.6 Ensure that the REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION account parameter is set to true

Information

Ensure that loading data from or unloading data to a private cloud storage location requires using a named external stage that references a storage integration object.

If this parameter is not set, then users can specify the explicit cloud provider credentials directly in the COPY statement.

Using storage integration removes the need to supply credentials when loading and unloading data from external stages or when loading or unloading data to a private cloud storage location. This reduces the risk of 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:

Set the REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION on the account level to true :

ALTER ACCOUNT
SET REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION=true;

NOTE:

To avoid disruption of existing workflow relying on external stages not referencing a storage integration, all such workflows should be identified and migrated to external stages referencing storage integrations.

Impact:

Setting the REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION account level parameter to true can break existing manual and automated flows relying on loading or unloading data to 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: f81d42926c2fe31b5c152ef16da86949c285921c4a9a53d25f03801cb071163c