COPY INTO snowflake table not loading data even with Force command and also no error

Question

I am trying loading data from s3 bucket to snowflake table & using the copy into command. This is my command:

copy into "BUSINESS_DB"."BI_REPORTING"."MODELING_FEATS_PH_RAW"
from s3://ph-stage-data-model-pipeline-magneto/experiment/modeling_feats.csv credentials=(aws_key_id='XXXXXXXXX' aws_secret_key='XXXXXX')
FILE_FORMAT = (type = csv field_delimiter = ',' skip_header = 1 
FIELD_OPTIONALLY_ENCLOSED_BY = '\042' EMPTY_FIELD_AS_NULL = TRUE 
NULL_IF = ('NULL','null','')) ON_ERROR = CONTINUE PURGE=TRUE FORCE=TRUE
;

The first time it worked perfectly, when I tried to reload it again it its throwing error:Copy executed with 0 files processed. Could some please help me out

Answer 1

You used PURGE=TRUE which would remove your files from the stage. Have you checked the files are still present on the stage?

Try using LIST to see if you still have the files on the stage.