I have two connections, one with the normal Snowflake connector and one with the Snowflake Key Pair. The normal Snowflake connector works fine but the Key pair connector is not returning any number values. The string fields are returning values, it's just the number fields that are null. They are different users, but the users have the same role. The query is exactly the same for both connections. Has anyone experienced this before?
