szymon_dybczak
Esteemed Contributor III

Hi @DoredlaCharan ,

Maybe that file was already read? To check if that's the case you can first try to use force option.
Add COPY_OPTIONS('force' = 'true') to your code.

COPY INTO nxt_dev.raw_vam_viraf.fact_servicer_report
FROM (
  SELECT
    ...
  FROM 's3://snowbergsandbox/raw_vam_viraf/fact_servicer_report/VAM VIRAF PTC_Servicer Report_20260216_167309_387664.csv'
)
FILEFORMAT = CSV
FORMAT_OPTIONS ('header' = 'true')
COPY_OPTIONS ('force' = 'true');

 Another thing that is worth checking - spaces in your S3 path. The filename has spaces (VAM VIRAF PTC_Servicer Report...).
Try to get rid of that spaces from filename of try URL-encoding them VAM%20VIRAF%20PTC_Servicer%20Report...) 

View solution in original post