# Turning off creating temporary tables with ClickHouse

**URL:** <https://discourse.greatexpectations.io/t/turning-off-creating-temporary-tables-with-clickhouse/808>\
**Category:** Archive\
**Tags:** help-wanted, databricks\
**Created:** [June 30, 2021, 1:25pm UTC](https://discourse.greatexpectations.io/t/turning-off-creating-temporary-tables-with-clickhouse/808 "2021-06-30T13:25:55Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mrkoloev](https://avatars.discourse-cdn.com/v4/letter/m/e8c25b/32.png) [@mrkoloev](https://discourse.greatexpectations.io/u/mrkoloev)\
**Post date:** [June 30, 2021, 1:25pm UTC](https://discourse.greatexpectations.io/t/turning-off-creating-temporary-tables-with-clickhouse/808/1 "2021-06-30T13:25:55Z")

</div>

Hello everyone. I duplicate my question from [GE slack channel.](https://greatexpectationstalk.slack.com/archives/CUUMYDJAX/p1624971699009900)

I’m trying to use GE with Clickhouse. So I managed to connect to CH, but have some problems with creating temporary tables. I guess it creates temp table within one session and execute other commands within another session and thats why the error occurs that temp table doesn’t exist.

I’m trying to turn it off by using ‘create\_temp\_table’ = False in ‘batch\_kwargs’ but getting the same error (see the pic). What am i doing wrong?

 ![ge_ch](https://canada1.discourse-cdn.com/flex031/uploads/greatexpectations/original/1X/e4b1a3ca0380961882d48b0af69032cecf766fdb.png)

p.s. how to add custom tag to my topic? I want to add #clickhouse