Storage Flashcards

1
Q

What is a storage integration

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

In the public cloud and not a virtual private environment.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

T/F Snowflake does not charge for ingress data

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is the DDL syntax for creating storage integration

A

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>

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly