Snowflake key pair

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?

Tagged:

Answers

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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • No, I haven't but, the users have the exact same role

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