I would like to upload multiple csv files from AWS S3 using aws_s3.table_import_from_s3 into PostgreSQL, something like

SELECT aws_s3.table_import_from_s3(
‘Sarma_MobileData’, ”, ‘(format csv, header true, escape ”””)’,
‘My.data.source’,
‘/old-My-data/MobileData/2022.07.01/*.csv’,
‘ap-south-1’,
‘AKIA47CRYMJANxxxx’, ‘MeOmJVuc9VKWDw+KbCaYu3hTtdArpxxxx’);

Observe 2022.07.01/*.csv (asterisk). If there are multiple csv files at this location, all csv files should get loaded into Postgres

Itried the same above command, but got error as “ERROR: HTTP 404. No response body.”