Storage Flashcards
What is a storage integration
A snowflake object that stores a generated identity and access management entity for your external cloud storage, along with an optional set of allowed or blocked storage locations. This allows users to avoid supplying credentials when creating stages or when loading or unloading data.
T/F A single storage integration cannot support multiple external stages.
False
If your cloud storage is located on a different cloud platform from your Snowflake account, where must the storage location be
In the public cloud and not a virtual private environment.
T/F Snowflake does not charge for ingress data
True
What is the DDL syntax for creating storage integration
CREATE [ OR REPLACE ] STORAGE INTEGRATION [IF NOT EXISTS]
<name>
TYPE = EXTERNAL_STAGE
cloudProviderParams
ENABLED = { TRUE | FALSE }
STORAGE_ALLOWED_LOCATIONS = ('<cloud>://<bucket>/<path>/' [ , '<cloud>://<bucket>/<path>/' ... ] )
[ STORAGE_BLOCKED_LOCATIONS = ('<cloud>://<bucket>/<path>/' [ , '<cloud>://<bucket>/<path>/' ... ] ) ]
[ COMMENT = '<string_literal>' ]
</string_literal></path></bucket></cloud></path></bucket></cloud></path></bucket></cloud></path></bucket></cloud></name>
If you recreate a storage integration, what happens to any stage that references it?
the association is broken because there is a hidden key behind the scenes that will be regenerated.