AWS S3: CSV Import
Import audiences and activity data into Lytics via a CSV file directly from your AWS S3 bucket.
- Implementation Type: Server-side.
- Type: REST API.
- Frequency: One-time or scheduled batch, frequency can be configured.
- Resulting Data: Raw events or User profiles once the imported data is mapped via LQL.
This integration uses the Amazon S3 API to read the CSV file selected for the import. Each run of the job will proceed as follows:
- Query for a list of objects in the bucket selected in the configuration step.
- Read the selected CSV file.
- Import all the fields that are chosen during configuration. If configured to diff the files, it will compare the file to the data imported from the previous run.
- Send the fields to the configured data stream.
- Schedule the next run of import if configured to run continuously.
Please see Custom Data Ingestion for more information on file naming, field formatting, headers, timestamps, etc.
Once you choose the CSV file to import from your S3 bucket during configuration, Lytics will read the file and list all the fields that can be imported. You can then select the fields that you want to import.
Follow these steps to set up and configure an AWS S3 CSV import job in Lytics.
- From Data > Jobs, click the Create New Job button.
- Select Amazon Web Services.
- Select Import Audiences and Activity Data (S3).
- Select the authorization you previously created or add a new one.
- (Optional) In the Label text field, enter how you would like to name this job.
- (Optional) In the Description text field, enter a short description for this job.
- From the Stream box, enter or select the data stream you want to import the file(s) into.
- From the Bucket drop-down list, select the bucket to import from. If there is an error fetching buckets, your credentials may not have permission to list buckets. You can type the Bucket Name where the CSV file is.
- (Optional) Using the Directory drop-down, select the folder where the CSV file is located. If loading the directory takes too long, you can type the folder name as well.
- From the File drop-down, select the file to import. Listing files may take up to a couple minutes after the bucket is chosen. If you have permission for some specific file, you can type in the File Name.
- (Optional) In the Custom Delimiter text field, enter the delimiter of the file. Default delimiter is a comma,
,. For tab delimited files enter
- (Optional) Using the Timestamps drop-down list, select the column in the CSV file that contains the timestamp of an event. If no fields are specified, the event will be time stamped with the time of the import.
- (Optional) Using the Fields input, select fields to import. The fields listed in the left side are available for the import. If nothing is selected, all fields will be imported. If no field names appear, check to ensure the CSV file has an appropriate header row or the delimiter may need to be changed.
- (Optional) Select the Keep Updated checkbox to run this import continuously.
- (Optional) Select the Diff checkbox to compare file contents to the previous file contents during continuous import and import only rows that have changed. This is useful when large amounts of data remain unchanged in each file.
- Click the Show Advanced Options button.
- (Optional) Using the Time of Day drop-down, select the time of day to start import.
- (Optional) Using the Timezone drop-down, select the timezone for the time of day you selected above.
- (Optional) Using the File Upload Frequency drop-down, select how often to check for a new file.
- Click Start Import.