REFRESH updates an existing Snowpipe so it detects eligible files that were already in cloud storage before the pipe was created. It complements event-driven ingestion, which otherwise responds only to newly arriving files. section 5.3.3
Use REFRESH with these operational boundaries:
- Run `ALTER PIPE SPEEDY_PIPE REFRESH;` after creating the pipe to discover previously uploaded files. section 5.3.3
- Detection is limited to files uploaded within the previous seven days; load older files with a bulk `COPY` command. section 5.3.3
- Allow a few minutes for ingestion, then query the target staging table to verify loaded rows. section 5.3.3
- Check execution state, pending files, and the last ingestion through `SYSTEM$PIPE_STATUS`; inspect table load history with `COPY_HISTORY`. section 5.3.3 section 5.5
alter pipe SPEEDY_PIPE refresh;
Run the pipe alteration to refresh discovery of files already present in the configured cloud-storage location. section 5.3.3
