We are using the Snowflake ODBC Driver to connect to our warehouse from a series of different, completely unrelated backends.
We have Alteryx workflows and Python applications connecting to the warehouse through ODBC.
We can successfully establish a connection and access the information in our databases, however, there is a hard limit of 1000000 when selecting records from a table. It never pulls more than that. No error or warning messages either, it simply does not pull more than a million record, regardless of the source where we run the process from.
The applications and Alteryx run on completely different servers as well, so it's unlikely that it is a server issue.
I have not been able to find anything about this on the Snowflake documentation, and I'm at a lost as to where to search.
What's even more odd: We can upload more than a million records from Alteryx into Snowflake. The issue is just for when we receive the data FROM snowflake.
Any ideas on where/what to check?