数据管道中的Redshift drop / create / select查询失败(Redshift drop/create/select query failing in Data Pipeline

我正在尝试使用Data Pipeline在Redshift中运行每日迁移脚本。 当我使用SQL Workbench / J直接运行脚本时，脚本按预期工作，但在通过Data Pipeline触发时失败。

我用这个简单的代码重现了这个问题：

drop table if exists image_stg;
create table image_stg (like image_full); 
select * from image_stg;
 
 当我在Data Pipeline中运行它时，我收到此错误： 
 
 
 
 [亚马逊]（500310）操作无效：关系“image_stg”不存在; 
 
 
 我也有一次这个错误，对于完全相同的代码，没有改变任何东西： 
 
 
 
 [亚马逊]（500310）操作无效：与OID 108425的关系不存在。 
 
 
 这是两个错误消息的屏幕截图： 
 
  
 
 我在AWS论坛上发现了这个帖子，但它没有帮助： 管道开始在简单的Redshift SqlActivity和临时表上失败 
 
 导致此错误的原因是什么？ 有解决方法吗？ 
I'm trying to run a daily migration script in Redshift using Data Pipeline. The script works as expected when I run it directly using SQL Workbench/J, but fails when triggered through Data Pipeline.
 
I have reproduced the problem with this simple code:
 
drop table if exists image_stg;
create table image_stg (like image_full); 
select * from image_stg;
 
When I run it in Data Pipeline, I get this error:
 
 
 
[Amazon](500310) Invalid operation: relation "image_stg" does not exist;
 
 
I also got this error once, for the exact same code, without changing anything:
 
 
 
[Amazon](500310) Invalid operation: Relation with OID 108425 does not exist.;
 
 
Here's a screenshot of the two error messages:
 
 
I've found this thread on the AWS forums, but it didn't help: Pipeline started failing on simple Redshift SqlActivity and temp table
 
What is causing this error? Is there a workaround?
                
最满意答案
                
                    
                        
 我已经联系了亚马逊，它看起来像数据管道中的一个问题。  他们确实提出了一个似乎在我的情况下工作的解决方法：将JDBC连接字符串从jdbc: redshift ://…更改为jdbc: postgresql ://… 
I've contacted Amazon, and it looks like a problem in Data Pipeline. They did suggest a workaround that seems to work in my case: Change the JDBC connection string from jdbc:redshift://… to jdbc:postgresql://… .