Snowflake key pair

Basketballfan1

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?

GrantSmith

Have you tried using the same account for both connection methods and confirming the data you're getting back is the same or different?

Basketballfan1

No, I haven't but, the users have the exact same role

Basketballfan1

Just tried and getting the same results regardless of the user.