# Adding KCQL properties delays S3 sink

**URL:** <https://ask.lenses.io/t/adding-kcql-properties-delays-s3-sink/197>\
**Category:** Lenses\
**Tags:** kafka-connect\
**Created:** [February 23, 2024, 1:54pm UTC](https://ask.lenses.io/t/adding-kcql-properties-delays-s3-sink/197 "2024-02-23T13:54:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![shaik\_ahmed](https://dub1.discourse-cdn.com/flex017/user_avatar/ask.lenses.io/shaik_ahmed/32/108_2.png) [@shaik\_ahmed](https://ask.lenses.io/u/shaik_ahmed)\
**Post date:** [February 23, 2024, 1:54pm UTC](https://ask.lenses.io/t/adding-kcql-properties-delays-s3-sink/197/1 "2024-02-23T13:54:36Z")

</div>

Hi Team!

After adding the properties PROPERTIES(‘store.envelope’=true,‘partition.include.keys’=false) WITHPARTITIONER=Values WITH\_FLUSH\_SIZE=5242880 WITH\_FLUSH\_INTERVAL=30 WITH\_FLUSH\_COUNT=500 to KCQL insert, I see the records are sinked to s3 every hour. Without adding the PROPERTIES to insert statement, data sinks as per WITH\_FLUSH\_INTERVAL. What could be the issue?

Thanks,  
Samdan

---

<div class="post-metadata">

**Author:** ![stheppi](https://dub1.discourse-cdn.com/flex017/user_avatar/ask.lenses.io/stheppi/32/30_2.png) [@stheppi](https://ask.lenses.io/u/stheppi)\
**Post date:** [February 23, 2024, 4:01pm UTC](https://ask.lenses.io/t/adding-kcql-properties-delays-s3-sink/197/2 "2024-02-23T16:01:52Z")

</div>

Hi shaik\_ahmed,

Our documentation [here](https://docs.lenses.io/5.4/connectors/sinks/s3sinkconnector/#kcql-kafka-connect-query-language) provides the KCQL syntax:

```auto
INSERT INTO bucketAddress[:pathPrefix]
SELECT *
FROM kafka-topic
[PARTITIONBY (partition[, partition] ...)]
[STOREAS storage_format]
[WITH_FLUSH_SIZE = flush_size]
[WITH_FLUSH_INTERVAL = flush_interval]
[WITH_FLUSH_COUNT = flush_count]
[PROPERTIES(
  'property.1'=x,
  'property.2'=x,
)]

```

At the moment the keywords order matter . In your case `properties` is set before the flushing options so the flushing options are ignored by the grammar tokenizer.

Stefan

---

<div class="post-metadata">

**Author:** ![shaik\_ahmed](https://dub1.discourse-cdn.com/flex017/user_avatar/ask.lenses.io/shaik_ahmed/32/108_2.png) [@shaik\_ahmed](https://ask.lenses.io/u/shaik_ahmed)\
**Post date:** [February 23, 2024, 6:37pm UTC](https://ask.lenses.io/t/adding-kcql-properties-delays-s3-sink/197/3 "2024-02-23T18:37:31Z")

</div>

Thank you for the documentation!