Amazon Data Pipeline: como usar um argumento de script em um SqlActivity?
Ao tentar usar um argumento de script no sqlActivity:
{
"id" : "ActivityId_3zboU",
"schedule" : { "ref" : "DefaultSchedule" },
"scriptUri" : "s3://location_of_script/unload.sql",
"name" : "unload",
"runsOn" : { "ref" : "Ec2Instance" },
"scriptArgument" : [ "'s3://location_of_unload/#format(minusDays(@scheduledStartTime,1),'YYYY/MM/dd/hhmm/')}'", "'aws_access_key_id=????;aws_secret_access_key=*******'" ],
"type" : "SqlActivity",
"dependsOn" : { "ref" : "ActivityId_YY69k" },
"database" : { "ref" : "RedshiftCluster" }
}
onde o script unload.sql contém:
unload ('
select *
from tbl1
')
to ?
credentials ?
delimiter ',' GZIP;
ou:
unload ('
select *
from tbl1
')
to ?::VARCHAR(255)
credentials ?::VARCHAR(255)
delimiter ',' GZIP;
processo falha:
syntax error at or near "$1" Position
Alguma idéia do que estou fazendo de errado?