postgresql - 从 Redshift 卸载到 S3 : Authentication not working

Question

我正在使用以下脚本:

UNLOAD ('SELECT * FROM table WHERE
UPPER(description) LIKE \'%something%\' AND
transaction_date=\'2014-01-01\'')
TO 's3://yourdirectory/jan14.txt' CREDENTIALS 
'aws_access_key_id=xxxx;
aws_secret_access_key=xxx'
PARALLEL OFF

但是它返回这个错误:

执行SQL命令时出现错误:UNLOAD ('SELECT * FROM yi_base_views.card_panel WHEREUPPER(描述)像\'%LULULEMON%\' ANDtransaction_date=\'2014-01-01\'')TO 's3://yourdirec...

错误:凭据无效。必须采用以下格式:credentials 'aws_access_key_id=;aws_secret_access_key=[;token=]' 详情:

---

错误:凭据无效。必须采用以下格式:credentials 'aws_access_key_id=;aws_secret_access_key=[;token=]' 代码:8001 上下文:
查询: 0 位置:aws_credentials_parser.cpp:59 进程:padbmaster [pid=43295]

---

Answer 1

删除访问 key 和 secret key 之间的换行符，它应该可以工作。