https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage
After you create a stage with a directory table, you must execute ALTER STAGE … REFRESH to manually refresh the directory table metadata.
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."
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
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
d22770a
1 month agoYiouk
5 months, 3 weeks agoahadh7621
5 months, 3 weeks agoicegrandpa
8 months, 1 week agoNachoPrendes
8 months, 2 weeks ago