Which feature is not supported by Snowpipe for data loading?

• A. Semi-structured data loading
• B. Detection of duplication of files while loading
• C. Transaction management
• D. PURGE copy (after loading)

Answer: (D)

Snowpipe handles automatic, continuous data ingestion from a stage into a table. It supports loading various formats, including semi-structured data, and it tracks ingested files to avoid reloading the same file if it’s seen again. Each load happens as its own operation, not as part of a larger transactional unit you manage.

What it does not do is purge the source files from the stage after loading as part of the Snowpipe process. Purging loaded files would require a separate operation outside Snowpipe. Therefore, purging copied files after loading is not supported by Snowpipe.