Stages (internal and external) in Snowflake - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create an internal stage named 'mystage'.

Snowflake

CREATE STAGE mystage [1];

Drag options to blanks, or click blank then click option'

AEXTERNAL

BTEMPORARY

CINTERNAL

DPERMANENT

Attempts:

3 left

💡 Hint

Common Mistakes

Using EXTERNAL instead of INTERNAL

Omitting the stage type keyword

Internal stages are created using the keyword INTERNAL.

2fill in blank

medium

Complete the code to create an external stage using an S3 bucket named 'mybucket'.

Snowflake

CREATE STAGE mystage URL='s3://[1]';

Drag options to blanks, or click blank then click option'

Ainternalbucket

Bmybucket

Csnowflakebucket

Dexternalbucket

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect bucket names

Forgetting to include the bucket name in the URL

The URL for an external stage must point to the correct S3 bucket name.

3fill in blank

hard

Fix the error in the code to create an external stage with AWS credentials.

Snowflake

CREATE STAGE mystage URL='s3://mybucket' CREDENTIALS=([1]='AKIA...');

Drag options to blanks, or click blank then click option'

AAWS_ACCESS_KEY_ID

BAWS_SECRET_KEY

CAWS_KEY

DACCESS_KEY

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect credential key names

Misspelling the AWS credential keys

The correct credential key for AWS access key is AWS_ACCESS_KEY_ID.

4fill in blank

hard

Fill both blanks to create an external stage with AWS credentials and region.

Snowflake

CREATE STAGE mystage URL='s3://mybucket' CREDENTIALS=([1]='AKIA...', [2]='us-west-2');

Drag options to blanks, or click blank then click option'

AAWS_ACCESS_KEY_ID

BAWS_SECRET_KEY

CAWS_REGION

DREGION

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect keys for credentials

Confusing region key names

Use AWS_ACCESS_KEY_ID for the access key and AWS_REGION for the region.

5fill in blank

hard

Fill all three blanks to create an external stage with AWS credentials, region, and file format.

Snowflake

CREATE STAGE mystage URL='s3://mybucket' CREDENTIALS=([1]='AKIA...', [2]='secretkey123') FILE_FORMAT = (TYPE = [3]);

Drag options to blanks, or click blank then click option'

AAWS_ACCESS_KEY_ID

BAWS_SECRET_KEY

C'CSV'

D'JSON'

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up credential keys

Using file format types without quotes

Use AWS_ACCESS_KEY_ID and AWS_SECRET_KEY for credentials, and specify 'CSV' as the file format type.