Fix: Snowflake column selection

[eogilvy12]

when running on Snowflake, if the schema and table name are lowercase, the generate base model returns the structure but without returning the column names.

If you update the schema to be capitalized an the table to have capitalized identifier then it works as expected

[clrcrl]

Thanks @eogilvy12.

Out of interest, what are your quoting configs in your Snowflake project? I'm trying to figure out why the test passed, but IRL is doesn't work.

Either way, I should probably be throwing an error when dbt can't find any columns, rather than letting it silently fail.

[eogilvy12]

up until this morning this project didn't have any quoting configs specified (! which I just changed)

I have to wait to merge some code in but can test this for you on whether it works with proper configuration

[eogilvy12]

@clrcrl once I added proper quoting to their dbt_project.yml the run-operation returns results!

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.

[github-actions]

Although we are closing this issue as stale, it's not gone forever. Issues can be reopened if there is renewed community interest. Just add a comment to notify the maintainers.