A user creates a stage using the following command:
CREATE STAGE mystage -
DIRECTORY = (ENABLE = TRUE)
FILE_FORMAT = myformat;
What will be the outcome?
A user creates a stage using the following command:
CREATE STAGE mystage -
DIRECTORY = (ENABLE = TRUE)
FILE_FORMAT = myformat;
What will be the outcome?
A stage with a directory table that has metadata that must be manually refreshed will be created. This is because directory tables on internal stages require manual metadata refreshes according to Snowflake documentation. The given command creates an internal Snowflake stage as it does not specify an external cloud storage location.
Answer is B. https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage#label-directory-table-refreshes Directory tables on internal stages require manual metadata refreshes. This command creates an internal Snowflake stage since it doesn't specify an external cloud storage location. I ran this command in Snowflake and it was valid and using SHOW STAGES; I validated that it was an internal stage, so the answer is B
Answer is A, test it in your snow account.
Checked on Snowflake
B. https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage "Directory tables on internal stages require manual metadata refreshes." https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage#label-directory-table-auto-refreshes "You can automatically refresh the metadata for a directory table by using the event messaging service for your cloud storage service."