# DestinationS3Glue


## Fields

| Field                                                                                                                                                                                                                                                           | Type                                                                                                                                                                                                                                                            | Required                                                                                                                                                                                                                                                        | Description                                                                                                                                                                                                                                                     | Example                                                                                                                                                                                                                                                         |
| --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `format`                                                                                                                                                                                                                                                        | [models.DestinationS3GlueOutputFormat](../models/destinations3glueoutputformat.md)                                                                                                                                                                              | :heavy_check_mark:                                                                                                                                                                                                                                              | Format of the data output. See <a href="https://docs.airbyte.com/integrations/destinations/s3/#supported-output-schema">here</a> for more details                                                                                                               |                                                                                                                                                                                                                                                                 |
| `glue_database`                                                                                                                                                                                                                                                 | *str*                                                                                                                                                                                                                                                           | :heavy_check_mark:                                                                                                                                                                                                                                              | Name of the glue database for creating the tables, leave blank if no integration                                                                                                                                                                                | airbyte_database                                                                                                                                                                                                                                                |
| `s3_bucket_name`                                                                                                                                                                                                                                                | *str*                                                                                                                                                                                                                                                           | :heavy_check_mark:                                                                                                                                                                                                                                              | The name of the S3 bucket. Read more <a href="https://docs.aws.amazon.com/AmazonS3/latest/userguide/create-bucket-overview.html">here</a>.                                                                                                                      | airbyte_sync                                                                                                                                                                                                                                                    |
| `s3_bucket_path`                                                                                                                                                                                                                                                | *str*                                                                                                                                                                                                                                                           | :heavy_check_mark:                                                                                                                                                                                                                                              | Directory under the S3 bucket where data will be written. Read more <a href="https://docs.airbyte.com/integrations/destinations/s3#:~:text=to%20format%20the-,bucket%20path,-%3A">here</a>                                                                      | data_sync/test                                                                                                                                                                                                                                                  |
| `access_key_id`                                                                                                                                                                                                                                                 | *Optional[str]*                                                                                                                                                                                                                                                 | :heavy_minus_sign:                                                                                                                                                                                                                                              | The access key ID to access the S3 bucket. Airbyte requires Read and Write permissions to the given bucket. Read more <a href="https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys">here</a>.              | A012345678910EXAMPLE                                                                                                                                                                                                                                            |
| `destination_type`                                                                                                                                                                                                                                              | [models.S3Glue](../models/s3glue.md)                                                                                                                                                                                                                            | :heavy_check_mark:                                                                                                                                                                                                                                              | N/A                                                                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                 |
| `file_name_pattern`                                                                                                                                                                                                                                             | *Optional[str]*                                                                                                                                                                                                                                                 | :heavy_minus_sign:                                                                                                                                                                                                                                              | The pattern allows you to set the file-name format for the S3 staging file(s)                                                                                                                                                                                   | {date}                                                                                                                                                                                                                                                          |
| `glue_serialization_library`                                                                                                                                                                                                                                    | [Optional[models.SerializationLibrary]](../models/serializationlibrary.md)                                                                                                                                                                                      | :heavy_minus_sign:                                                                                                                                                                                                                                              | The library that your query engine will use for reading and writing data in your lake.                                                                                                                                                                          |                                                                                                                                                                                                                                                                 |
| `s3_bucket_region`                                                                                                                                                                                                                                              | [Optional[models.DestinationS3GlueS3BucketRegion]](../models/destinations3glues3bucketregion.md)                                                                                                                                                                | :heavy_minus_sign:                                                                                                                                                                                                                                              | The region of the S3 bucket. See <a href="https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/using-regions-availability-zones.html#concepts-available-regions">here</a> for all region codes.                                                                  |                                                                                                                                                                                                                                                                 |
| `s3_endpoint`                                                                                                                                                                                                                                                   | *Optional[str]*                                                                                                                                                                                                                                                 | :heavy_minus_sign:                                                                                                                                                                                                                                              | Your S3 endpoint url. Read more <a href="https://docs.aws.amazon.com/general/latest/gr/s3.html#:~:text=Service%20endpoints-,Amazon%20S3%20endpoints,-When%20you%20use">here</a>                                                                                 | http://localhost:9000                                                                                                                                                                                                                                           |
| `s3_path_format`                                                                                                                                                                                                                                                | *Optional[str]*                                                                                                                                                                                                                                                 | :heavy_minus_sign:                                                                                                                                                                                                                                              | Format string on how data will be organized inside the S3 bucket directory. Read more <a href="https://docs.airbyte.com/integrations/destinations/s3#:~:text=The%20full%20path%20of%20the%20output%20data%20with%20the%20default%20S3%20path%20format">here</a> | ${NAMESPACE}/${STREAM_NAME}/${YEAR}_${MONTH}_${DAY}_${EPOCH}_                                                                                                                                                                                                   |
| `secret_access_key`                                                                                                                                                                                                                                             | *Optional[str]*                                                                                                                                                                                                                                                 | :heavy_minus_sign:                                                                                                                                                                                                                                              | The corresponding secret to the access key ID. Read more <a href="https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys">here</a>                                                                            | a012345678910ABCDEFGH/AbCdEfGhEXAMPLEKEY                                                                                                                                                                                                                        |