Skip to content

Error while export using aws_s3.query_export_to_s3 function. #33

@Magvegva

Description

@Magvegva

Hello! I'm just trying to use your aws_s3 extention.

When runing this query

SELECT * FROM aws_s3.query_export_to_s3(
query => '
select
json_agg(post_main_approved)
from asmo.post_main_approved
limit 10 ;
',
bucket => 'arn:aws:s3:::asmo-ij-json',
file_path => 'test.json',
region => 'eu-central-1a',
access_key => '<access_key>',
secret_key => '<secret_key>'
);

then get this error:

error fetching next item from iterator. spiexceptions.SyntaxError: syntax error at or near ";"

Can you help to deal with this issue? Thanks!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions