CODEWITHSUNDEEP
snowflake-cloud-data-platform
Posty
Posty

Reputation: 23

snowflake copy into statement not purging from blob store

Im running the below copy statement into snowflake destination table with a precreated external stage for the existing blob store account. The copy works correctly and rows are then visible in destination snowflake table. The purge of the corresponding folder 'D_CALENDER' in azure blob store doesn't process though. No error, just doesnt process. Any ideas perhaps?                                          

COPY INTO "STAGING"."D_CALENDAR"
FROM @STAGE/D_CALENDAR/
FILE_FORMAT = CSV_IMPORT ON_ERROR = CONTINUE PURGE = TRUE;

Regards Posty

Upvotes: 1

Views: 309

Answers (1)

Posty
Posty

Reputation: 23

Found the issue. The shared access signature for the blob container in question only had read permissions ticked when it was set up a while back. The external stage was then set up with that access token which is why selecting into snowflake destination worked fine but the purge didnt. Created a new shared access sig with read write and delete, recreated stage using this token ran the copy/purge and voila.

Upvotes: 1

Related Questions