# JSON to parquet/AVRO sink using S3 Connector

**URL:** <https://ask.lenses.io/t/json-to-parquet-avro-sink-using-s3-connector/244>\
**Category:** Apache Kafka Connectors\
**Created:** [May 31, 2024, 6:17pm UTC](https://ask.lenses.io/t/json-to-parquet-avro-sink-using-s3-connector/244 "2024-05-31T18:17:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Edward\_k](https://avatars.discourse-cdn.com/v4/letter/e/b5a626/32.png) [@Edward\_k](https://ask.lenses.io/u/Edward_k)\
**Post date:** [May 31, 2024, 6:17pm UTC](https://ask.lenses.io/t/json-to-parquet-avro-sink-using-s3-connector/244/1 "2024-05-31T18:17:22Z")

</div>

I would like to know if it’s possible to sink JSON messages into parquet using the S3 sink?

---

<div class="post-metadata">

**Author:** ![grudtnerv](https://dub1.discourse-cdn.com/flex017/user_avatar/ask.lenses.io/grudtnerv/32/101_2.png) [@grudtnerv](https://ask.lenses.io/u/grudtnerv)\
**Post date:** [May 31, 2024, 6:20pm UTC](https://ask.lenses.io/t/json-to-parquet-avro-sink-using-s3-connector/244/2 "2024-05-31T18:20:06Z")

</div>

Hello Edward\_k,

Yes, you can indeed convert JSON messages to Parquet/AVRO, but you’ll need to add some parameters like `store.envelope=true` and `JsonConverter`:

```auto
connect.s3.kcql=INSERT INTO bucket:folder SELECT * FROM topic STOREAS `PARQUET` PROPERTIES('store.envelope'=true)
value.converter=org.apache.kafka.connect.json.JsonConverter

```

Check the documentation for more details on message conversion and storage format: [Kafka to AWS S3 open source connector | Lenses.io Documentation](https://docs.lenses.io/5.5/connectors/sinks/s3sinkconnector/#data-storage-format)

Cheers!