Skip to content

Data Destination

Data Destination allows users to write data from a workspace to a target destination like S3 or MinIO. This enables acting on insights by automating the output to execution systems — for example, sending churn-likely customers to a CRM system.

An S3 type data destination is used when you need to write data to an S3 bucket.

From a workspace, click on Add and choose the Data Destination option.

Add menu showing the Data Destination option

Choose the S3 data destination type from the available list, then go through the following steps:

FieldDescription
File name prefixProvide a prefix for the file name to be written on S3
Select dataSelect the dataset to write
AWS access key IDProvide the AWS access key ID
AWS secret keyEnter the AWS secret key
File typeChoose file type (CSV, JSON)
Test ConnectionClick to test connection with the provided credentials
ExtensionChoose file extension (CSV, JSON, GZIP)
S3 data destination configure step with connection details
FieldDescription
WorkspaceChoose from available options
BucketSelect the target S3 bucket
Prefix for filesProvide prefix for files
Choose folderChoose folder in S3 bucket
HeaderSet to true if header is present, otherwise false
Partitioned filesEnable for partitioning the files
DelimiterChoose delimiter according to the file
EncodingSelect encoding
QuoteSingle character for escaping quoted values where the separator can be part of the value
EscapeSingle character for escaping quotes inside an already quoted value
CommentSingle character for skipping lines beginning with this character (disabled by default)
Null valueString representation of a null value
NaN valueString representation of a non-number value
Positive InfString representation of a positive infinity value
Negative InfString representation of a negative infinity value
MultilineParse one record, which may span multiple lines, per file
Quote Escape CharacterSingle character for escaping the escape for the quote character
Empty ValueString representation of an empty value
ExpressionWrite expressions to be executed while reading the data
Default machine specificationsSet to false if specific machine configuration for the write-back process is required
S3 data destination advanced settings

Select the columns from the source and provide corresponding names and data types for columns to be written at the target system (the S3 bucket).

S3 data destination column mappings configuration

This will start the write-back process. You can track the progress on the job screen displayed. After completion, the data destination object will appear in the selected workspace.