Import from S3

POST {{HDB_ENDPOINT}}

This operation allows users to import CSV or JSON files from an AWS S3 bucket as an insert, update, or upsert.

• operation (required) - must always be import_from_s3

• action (optional) - type of action you want to perform - 'insert', 'update', or 'upsert'. The default is 'insert'.

• schema (required) - name of the schema where you are loading your data

• table (required) - name of the table where you are loading your data

• s3 (required) - object containing required AWS S3 bucket infor for operation
  

  • aws_access_key_id - AWS access key for authenticating into your S3 bucket

  • aws_secret_access_key - AWS secret for authenticating into your S3 bucket

  • bucket - AWS S3 bucket to import from

  • key - the name of the file to import - the file must include a valid file extension ('.csv' or '.json')

  • region - the region of the bucket

Request Body

{"operation"=>"import_from_s3", "action"=>"insert", "schema"=>"dev", "table"=>"dog", "s3"=>{"aws_access_key_id"=>"YOUR_KEY", "aws_secret_access_key"=>"YOUR_SECRET_KEY", "bucket"=>"BUCKET_NAME", "key"=>"OBJECT_NAME", "region"=>"BUCKET_REGION"}}

HEADERS

RESPONSES

status: OK

{"message":"Starting job with id 062a1892-6a0a-4282-9791-0f4c93b12e16"}