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.
MatthieuDN
2 months, 3 weeks agod22770a
6 months agoYiouk
10 months, 3 weeks agoahadh7621
11 months agoicegrandpa
1 year, 1 month agoNachoPrendes
1 year, 1 month ago