AWS - S3 to RDS(postgres) import using aws_s3 extension (provided by RDS) is failing

I have successfully created a role with policy attached to that role which allows required actions on the bucket. Policy document is:

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Sid": "s3import",
            "Action": [
                "s3:GetObject",
                "s3:ListBucket"
            ],
            "Effect": "Allow",
            "Resource": [
                "arn:aws:s3:::my-bucket",
                "arn:aws:s3:::my-bucket/*"
            ]
        }
    ]
}

And then i attached this role to my RDS instance with feature s3Import.

This is the command i ran.

SELECT aws_s3.table_import_from_s3(
   'table name',
   '', 
   'DELIMITER ''|''',
   aws_commons.create_s3_uri(
       'bucket-name',
       'file.csv',
       'region')
);

I am getting this error:

SQL Error [XX000]: ERROR: HTTP 404. Requested file does not exist.

Is anything missing here ?