Amazon S3 sink connector Use this Amazon S3 Connector to send data from Decodable to an Amazon S3 bucket. If you are looking for information about how to create a connection to get data into Decodable from Amazon S3, see Amazon S3 source connector in the Connect to a data source chapter. Documentation for the legacy Amazon S3 connector can be found here. That connector is deprecated and should not be used for new connections. Features Delivery guarantee Exactly once Prerequisites Before you can create the Amazon S3 connection, you must have an Identity and Access Management (IAM) role with the following policies. See the Setting up an IAM user section for more information. A Trust Policy that allows access from Decodable’s AWS account. The ExternalId must match your Decodable account name. A Permissions Policy with read and write permissions for the destination bucket. Setting up an IAM user The following is an example of what the Trust Policy should look like. Replace the <MY_DECODABLE_ACCOUNT_NAME> with your own. In the example, 671293015970 is Decodable’s AWS account ID and cannot be changed. { "Version": "2012-10-17", "Statement": [ { "Effect": "Allow", "Principal": { "AWS": "arn:aws:iam::671293015970:root" }, "Action": "sts:AssumeRole", "Condition": { "StringEquals": { "sts:ExternalId": "<MY_DECODABLE_ACCOUNT_NAME>" } } } ] } To allow several Decodable Accounts (say, in different AWS Regions) to write to the same bucket, use an array of Account names for the ExternalId value: { "sts:ExternalId": ["my-acct-1", "my-acct-2"] } See The confused deputy problem for more information about why the ExternalId value is required. You must also have read and write permissions on the destination S3 bucket. See the following list of permissions and replace <YOUR_BUCKET> and /some/dir appropriately. If you want to send data directly at the root level of the bucket, then leave the path blank with the trailing /* included. { "Version": "2012-10-17", "Statement": [ { "Effect": "Allow", "Action": ["s3:PutObject", "s3:GetObject", "s3:DeleteObject"], "Resource": "arn:aws:s3:::<YOUR_BUCKET>/some/dir/*" }, { "Effect": "Allow", "Action": ["s3:ListBucket"], "Resource": "arn:aws:s3:::<YOUR_BUCKET>" } ] } Steps If you have an existing connection using the older version of the Amazon S3 Connector and would like to switch to the newest version, then do the following steps. If you are not upgrading an existing connection, skip these steps. Stop the existing Amazon S3 connection. Stop any pipelines that are using it. From the Connections page, select the Amazon S3 Connector and complete the following fields. If you want to use the Decodable CLI or API to create the connection, you can refer to the Property Name column for information about what the underlying property names are. The connector name is s3-v2 (not s3, which is a deprecated version of the connector). UI Field Property Name Description AWS Region region The AWS region that your S3 bucket is located in. If not specified, defaults to your Decodable account region. For example, us-west-2. Path path The file path to the bucket or directory that you want to send data to. For example, s3://bucket/directory. IAM Role ARN role-arn The AWS ARN of the IAM role. For example, arn:aws:iam::111222333444:role/decodable-s3-access. Partition Template partition-cols The field names that you want to use to partition your data. For example, if you want to partition your data based on the datetime field, then enter datetime. See the S3 object key partitioning section for more information. Value Format format The format for data in the Amazon S3 destination. You can select one of the following: JSON: See JSON format properties for information on what additional properties you can specify when using JSON format. Parquet: See Parquet format properties for information on what additional properties you can specify when using Parquet format. Raw Rolling Policy: File Size sink.rolling-policy.file-size The maximum file size in Amazon S3. If a file reaches this maximum size while Decodable is streaming data to it, then the file closes and a new file with the same object prefix is created. Rolling Policy: Interval sink.rolling-policy.rollover-interval The maximum amount of time that a file in an S3 bucket can stay open. If a file has been open for this length of time while Decodable is streaming data to it, then the file closes and a new file with the same object name prefix is created. Compact multiple writer files before upload auto-compaction (Optional) When enabled, compacts many small files into fewer large files. Defaults to false. Compaction target file size compaction.file-size (Optional) The target file size. This is the maximum file size that compacted files can be. Select which stream contains the records that you’d like to send to Amazon S3. Then, select Next. Give the newly created connection a Name and Description and select Save. If you are replacing an existing Amazon S3 connection, then restart any pipelines that were processing data for the previous connection. Reference JSON format properties The following properties are only applicable when format=json. Property Required? Description json.timestamp-format.standard Optional Specify the timestamp format for TIMESTAMP and TIMESTAMP_LTZ types. Defaults to ISO-8601 SQL will use a "yyyy-MM-dd HH:mm:ss.SSS" format, e.g "2020-12-30 12:13:14.123"ISO-8601 will parse input TIMESTAMP in "yyyy-MM-ddTHH:mm:ss.SSS" format, e.g "2020-12-30T12:13:14.123" json.encode.decimal-as-plain-number Optional Must be true or false, defaults to false. When true, always encode numbers without scientific notation. For example, a number encoded 2.7E-8 by default would be encoded 0.000000027. Parquet format properties The following properties are only applicable when format=parquet. Property Description parquet.compression Options are SNAPPY, GZIP and LZO. Defaults to no compression. Other parquet options are available. See ParquetOutputFormat for more information. S3 object key partitioning You can partition the S3 Object key paths by value using the partition-cols connection property. When you specify a field to partition with, that field will be used as a prefix to organize the data in the S3 bucket. For example, a common pattern is to partition based on a date, and a subsequent partition for an hour of the day. Given a schema with datetime=DATE and hour=INTEGER fields, by setting the partition-cols property to be datetime,hour the resulting bucket entries will look like: s3://my-path/datetime=2023-01-01/hour=0/<file> s3://my-path/datetime=2023-01-01/hour=1/<file> ... s3://my-path/datetime=2023-01-01/hour=23/<file> s3://my-path/datetime=2023-01-02/hour=0/<file> The fields that are used as partition columns will be removed from the resulting payload in the file in Amazon S3. If you are using any query systems downstream that are relying on those fields, you will need to configure them to read the value from the file path instead. S3 object key formation The following is an example of what your object keys look like in Amazon S3. Let’s assume that your Amazon S3 Connection has the following configuration: S3 bucket or path: my-awesome-bucket Format: JSON Partition template or partition-cols: datetime Sink.rolling-policy.file-size: 5 minutes Compression is not set. When you start the connection, the Amazon S3 Connector opens a file with a name like part-123e4567-e89b-12d3-a456-426614174000-0.json in the datetime=01-25-2023 subfolder in the my-awesome-bucket S3 bucket and starts streaming data to that file. Once 5 minutes have elapsed, then the part-123e4567-e89b-12d3-a456-426614174000-0.json file is closed and a new file named part-123e4567-e89b-12d3-a456-426614174000-1.json is opened. The Amazon S3 Connector then starts sending data to this newly opened file instead. In summary, the S3 object parts are joined as: <path>/<partition-col>=<value>/part-<unique-id>-<N>