Exporting to Amazon S3

Learn more about Amazon's Simple Storage Service (S3) and its data consistency model.

INFO

Datameer X is not able to export Data without the permission 'PutObject' and 'DeleteObject' to the location one wants to export data to.

Configuring Amazon S3 as a Connection

An Amazon S3 connection with Datameer must be created before exporting data.

Learn about setting up a connection between Datameer and Amazon S3.

Exporting a Worksheet to S3

To export a worksheet through an S3 connector:

  1. Click the + (Plus) button and choose Export job, right-click on a folder, select Create New then choose Export Job, or right-click on the workbook to export from and select New export job.
  2. Select the workbook to export from in the browser.
  3. Select the worksheet to export from the drop-down menu.
  4. Select the S3 connector and choose the file type used to export.

  5. Fill out the data details including path in the S3 file system. 

    When the Replace data checkbox is marked, if the data is being exported to an existing file path, the previous data is written over by the current export. If the data is being exported to a new file path, the previous data is not written over.

    Example:
    /exports/%year%%month%%day%T%hour%:%min%/12354-%id%.csv
    The above file is being written to a new directly each time the export job runs. A new file is created each time and the old file is not deleted.

    /exports/12354/%year%%month%%day%T%hour%%min%-%id%.csv
    The above file is being written to the same directly each time the export job runs. The incoming export job overwrites the previous export job.



  6. Look over the preview and select how to handle invalid data.

  7.  Select the schedule method for when the export job runs.

  8. If needed, add a description and click Save.