Rachel House

Hi @MaxTh0ma1s, thanks for creating this issue. I discussed the error and behavior internally with Engineering today - they're now aware of it, but I don't know when a fix...

Hey @NehaNRane @sfan0704, Austin handed this issue over to me - I'm going to investigate and try to reproduce the error you're getting.

@sfan0704 @NehaNRane Ok, I've tested in two different virtual environments matching your dependencies and have not been able to replicate the error - the `expect_column_values_to_be_of_type` Expectation runs without issue on...

Hi @NehaNRane, thanks for retrying with a fresh install and including the stacktrace. Can you please also share your GX workflow code from `all_expectation_testing.py` that generates this error?

I've tested this Expectation (`expect_column_values_to_of_type`) against a collection differently cased Snowflake table columns, but still have not reproduced an error. At this point, I am suspicious that this behavior might...

@NehaNRane, looks like the issue is that you're using outdated code - the use of `RuntimeBatchRequest` is deprecated. Can you try updating your code to use [Fluent Data Sources](https://docs.greatexpectations.io/docs/oss/guides/connecting_to_your_data/fluent/database/connect_sql_source_data/?sql-database-type=snowflake)? Here...

Thanks @NehaNRane, those details are very helpful - I'm now able to consistently generate an error when using a Snowflake table with a mixed case name, a `QueryAsset`, and `expect_column_values_to_be_of_type`....

Hi @NehaNRane @sfan0704, Engineering and I dug further into this error, and the problem is caused by Snowflake tables that have a `MixedCaseName` name identifier [that needs to be quoted](https://docs.snowflake.com/en/sql-reference/identifiers-syntax#double-quoted-identifiers)...

Hi @kujaska, thanks for reporting this behavior. Are you using Table or Query Assets to connect to your MS SQL Server data? I dug into this today and was able...

Hi @kujaska, thanks for confirming that you're using a Query Asset. If you use a Query Asset and **do not** set `create_temp_table` to `False`, are you able to connect to...