# Snowflake - specify temp table location/schema **URL:** \ **Category:** CData Sync\ **Tags:** question, snowflake, bulk-api\ **Created:** [October 23, 2023, 6:54pm UTC](https://community.cdata.com/t/snowflake-specify-temp-table-location-schema/480 "2023-10-23T18:54:09Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![DougN\_Nouria](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@DougN\_Nouria](https://community.cdata.com/u/DougN_Nouria)\ **Post date:** [October 23, 2023, 6:54pm UTC](https://community.cdata.com/t/snowflake-specify-temp-table-location-schema/480/1 "2023-10-23T18:54:09Z")
When bulk loading to Snowflake, data is uploaded to a temp table (named by CData) and then insert/merged into the final target table. Is there a way to specify, either at the Connection level, or the Job level, what Database or Schema should be used to store those tables? By default it just puts them in the target schema, but it would be nice to split those out so we can more quickly clean anything up after an aborted job. ---
**Author:** ![Ankit\_Singh](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ankit_singh/32/1614_2.png) [@Ankit\_Singh](https://community.cdata.com/u/Ankit_Singh)\ **Post date:** [November 8, 2023, 11:00am UTC](https://community.cdata.com/t/snowflake-specify-temp-table-location-schema/480/2 "2023-11-08T11:00:20Z")
Hi @DougN_Nouria From what I know, it should be creating the Temp table in the same schema you select at the Task level settings for each table. Is that not the case in your testing? ---
**Author:** ![DougN\_Nouria](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@DougN\_Nouria](https://community.cdata.com/u/DougN_Nouria)\ **Post date:** [November 8, 2023, 12:52pm UTC](https://community.cdata.com/t/snowflake-specify-temp-table-location-schema/480/3 "2023-11-08T12:52:33Z")
Indeed, it is creating the temp tables in the same schema.  I would like to pick a different schema for where the temp tables go (like a WORKING schema) so that I have one place to look for any crashed-job manual cleanup work. ---
**Author:** ![DougN\_Nouria](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@DougN\_Nouria](https://community.cdata.com/u/DougN_Nouria)\ **Post date:** [November 16, 2023, 3:49pm UTC](https://community.cdata.com/t/snowflake-specify-temp-table-location-schema/480/4 "2023-11-16T15:49:35Z")
One other benefit, for Snowflake purposes:  If you can specify a single schema for temporary tables that CData creates, you can create that schema as a TRANSIENT schema.  This disables the fail-save/time-travel features, to reduce your storage costs.