idea Support Mixed Case Snowflake Tables in ArcGIS Pro Ideas

Support Mixed Case Snowflake Tables

tSteve_SchunzelAtTacoma — Thu, 12 May 2022 23:59:48 GMT

Please support mixed case Snowflake tables. After investigating with support, we found that ArcGIS Pro will not open Snowflake views whose underlying tables have a mixed case naming scheme - it will only open underlying tables with an ALL_CAPS naming scheme. Our entire Snowflake environment was built in mixed case, so until Pro can support mixed case we have to use other clients for analysis.

Re: Support Mixed Case Snowflake Tables

BruceHarold — Mon, 16 May 2022 15:27:21 GMT

We do support table naming in mixed case unless the tables were created with delimited names, like "Type", people sometimes do this to protect reserved words for example. Is this your situation? Delimited names are not supported, however Data Inteoperability extension can read tables with delimited names.

Re: Support Mixed Case Snowflake Tables

tSteve_SchunzelAtTacoma — Thu, 26 May 2022 22:34:19 GMT

Thanks Bruce. No this isn't our situation. I worked with both Esri & Snowflake support to determine this shortcoming and the Esri support analyst was able to replicate it, which is who recommended I submit this idea for a future enhancement. And yes, we have a workaround with FME, but the point of my Idea was to have Pro support this naming convention natively without more workarounds or purchasing additional software. This functionality was promoted heavily at the 2022 Dev Summit, yet this is a major flaw, IMO. Sorry, I'm just venting a bit as every other Desktop client we have that can read our Snowflake environment doesn't have this issue - just Pro. Hopefully it'll be resolved soon.

Re: Support Mixed Case Snowflake Tables

VanessaSimps — Thu, 17 Nov 2022 21:53:37 GMT

Has there been any movement on this idea?