# Uppercasing the destination table name in Snowflake

**URL:** <https://community.cdata.com/t/uppercasing-the-destination-table-name-in-snowflake/439>\
**Category:** CData Sync\
**Tags:** question, cdata-sync\
**Created:** [October 6, 2023, 12:05pm UTC](https://community.cdata.com/t/uppercasing-the-destination-table-name-in-snowflake/439 "2023-10-06T12:05:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**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 6, 2023, 12:05pm UTC](https://community.cdata.com/t/uppercasing-the-destination-table-name-in-snowflake/439/1 "2023-10-06T12:05:00Z")

</div>

Hello,

Snowflake seems to be case-sensitive with table names, sort of.&nbsp; If the incoming table name from Sync gets created with lower or mixed case, it gets created that way in Snowflake, and you have to reference them with quotes later on when querying.&nbsp; Like&nbsp; &nbsp; **select \* from “my\_table"**.&nbsp; Whereas if it were created as MY\_TABLE, you wouldn’t need to bother adding quotes.

Some data sources (a SQL server database we have, Active Directory, etc.) have lower or mixed case tables as exposed in CData.

Is there a way to uppercase these either on the source as the metadata is read, or, when created in the destination?

thank you!

---

<div class="post-metadata">

**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:** [October 6, 2023, 1:13pm UTC](https://community.cdata.com/t/uppercasing-the-destination-table-name-in-snowflake/439/2 "2023-10-06T13:13:26Z")

</div>

Hi @DougN_Nouria

There isn’t an automated way to modify all the tables the way you desire at the moment. However, you can manually customize this on the **Overview** tab of each Task in the Job:

1.) Navigate to _ **Jobs →&nbsp;\<your table name\> →&nbsp;Overview →&nbsp;Edit Destination:** _

 ![ef1346ea-1698-4894-821d-8961fc9a58e5.png](https://us1.discourse-cdn.com/cdata/original/2X/5/5088f99dc15d9aa9c37db11416d87e40970c2599.png)

2.) Once the&nbsp; **Destination Information** window pops up, you can rename the Table in the destination whatever you want.

 ![6b7761be-5f2c-4d1a-989e-3cb9a2aa54b6.png](https://us1.discourse-cdn.com/cdata/original/2X/0/0c3e2c481b35faefbc0f37d67f7b7e971ac660f0.png)

---

<div class="post-metadata">

**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 6, 2023, 2:47pm UTC](https://community.cdata.com/t/uppercasing-the-destination-table-name-in-snowflake/439/3 "2023-10-06T14:47:01Z")

</div>

Thank you for the tip.&nbsp; I will enter an enhancement request for future consideration.&nbsp; 🙂