postgresql - aws_s3.table_import_from_s3 returns error - Stack Overflow

Attempting to import CSV to postgres table, I got this error.ERROR:missing data for column "b&q

Attempting to import CSV to postgres table, I got this error.

ERROR:  missing data for column "b"
CONTEXT:  COPY test, line 2: "<Error><Code>AccessDenied</Code><Message>User: arn:aws:sts::23534534233:assumed-role/abcRole..."
SQL statement "copy test  from '/rdsdbdata/extensions/aws_s3/amazon-s3-fifo-56756-34535354534-0' with (FORMAT CSV, HEADER, DELIMITER ',')"
SQL statement "SELECT aws_s3.table_import_from_s3(
        'test', 
        '', 
        '(FORMAT CSV, HEADER, DELIMITER '','')',
        'sample',
        '3_row.CSV',
        'us-east-1'
    )"
PL/pgSQL function load_csv_from_s3() line 3 at PERFORM 

SQL state: 22P04

This is my sample CSV file.

"a","b","fname","lname","c"
"2024","19","John","Smith","DWEFFFFFF"

Please help in identifying cause of the error.

发布者:admin,转转请注明出处:http://www.yc00.com/questions/1745350270a4623790.html

相关推荐

  • postgresql - aws_s3.table_import_from_s3 returns error - Stack Overflow

    Attempting to import CSV to postgres table, I got this error.ERROR:missing data for column "b&q

    3小时前
    20

发表回复

评论列表(0条)

  • 暂无评论

联系我们

400-800-8888

在线咨询: QQ交谈

邮件:admin@example.com

工作时间:周一至周五,9:30-18:30,节假日休息

关注微信