D https://community.snowflake.com/s/question/0D5Do00000IaDSDKA3/if-the-internal-stage-is-forcibly-dropped-can-snowflakes-support-team-recover-it-to-failsafe-functionality
D. Recreate the dropped stage.
https://docs.snowflake.com/en/user-guide/data-time-travel#introduction-to-time-travel
Using Time Travel, you can perform the following actions within a defined period of time:
Query data in the past that has since been updated or deleted.
Create clones of entire tables, schemas, and databases at or before specific points in the past.
Restore tables, schemas, and databases that have been dropped.
Doesn't look like you can restore a dropped stage using UNDROP and time travel. Looks like you just need to recreate it using your SQL definition.
Confirmed that C is not possible:
USE ROLE SYSADMIN;
USE DATABASE TIME_TRAVEL_TEST;
USE SCHEMA PUBLIC;
CREATE STAGE images_stage URL = 's3://photos/national_parks/us/yosemite/';
SELECT GET_STAGE_LOCATION(@images_stage);
SHOW PARAMETERS like '%DATA_RETENTION_TIME_IN_DAYS%' in schema PUBLIC;
DROP STAGE images_stage;
UNDROP STAGE images_stage;
---000002 (0A000): Unsupported feature 'UNDROP not supported for objects of type STAGE'.
https://docs.snowflake.com/en/sql-reference/sql/undrop
You can undrop DB, SCHEMA, TABLE, also ACCOUNT and TAG
upvoted 2 times
...
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.
aemilka
3 weeks, 6 days agoSnowProAdv
5 months, 2 weeks agonicholascz
6 months ago0e504b5
9 months ago0e504b5
9 months agoicegrandpa
8 months, 1 week ago0e504b5
9 months ago