Relative Content

Tag Archive for amazon-s3amazon-redshift

Redshift COPY all PARQUET files from folder but not json files

We have a vendor that’s putting JSON files into folders that have our target PARQUET files we want to load. The folders have timestamps, so we have to load the whole folder. But, COPY is failing when trying to also load those JSON files. Is there a way to exclude the JSON files but load all the PARQUET files in the folder?