Storage

Question 1

What is a storage integration

Answer 1

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.

Question 2

T/F A single storage integration cannot support multiple external stages.

Answer 2

False

Question 3

If your cloud storage is located on a different cloud platform from your Snowflake account, where must the storage location be

Answer 3

In the public cloud and not a virtual private environment.

Question 4

T/F Snowflake does not charge for ingress data

Answer 4

True

Question 5

What is the DDL syntax for creating storage integration

Answer 5

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>

Question 6

If you recreate a storage integration, what happens to any stage that references it?

Answer 6

the association is broken because there is a hidden key behind the scenes that will be regenerated.