Library that allows connection to Snowflake through REST API, authenticating through JWT Key Pair value.

Requirements (configured as Settings):

• Snowflake_AccountIdentifier
  • Account Identifier is your Snowflake account identifier.
• Snowflake_JsonWebKey
  • JSON Web Key (JWK) that represents a cryptographic key.
• Snowflake_PublicKeyFingerprint
  • Public Key Fingerprint is the fingerprint that you generated in the previous step. (e.g.: SHA256:CyQ7fJuP...vomB3tsoVl)
• Snowflake_User
  • User is your Snowflake user name.

Available actions:

• Statement_CheckStatus
  • Check the Status of the Statement Execution and Retrieving the Data
• Statement_Execute
  • Query Snowflake by sending a query statement
• Statement_GetPartition
  • Send a StatementHandleId and the partition that you want to access.

    The Snowflake SQL API returns data in partitions. The first partition is returned in JSON format and contains metadata about all of the partitions returned for a specific query. Your application can use this partition metadata to determine how to handle the partitions returned for subsequent requests.