REST connector JWT issue - for Snowflake SQL REST API

[DanJ]

Hi all

We have a key line-of-business application which uses a Snowflake SQL table as its identity store. The only permitted access to this is via the SQL REST API (https://xyz.snowflakecomputing.com/api/v2/statements), authenticated with a keypair (so using a JWT).

We need to create a REST connection to the snowflake SQL REST API to reconcile, but we cannot create the token inside the connector JSON. In fact we can't even get it to connect with a hardcoded string for the JWT. Has anyone else done this? The REST developer handbook documentation is not very helpful on this matter.

The above works fine in Postman.

[SB]

There is example in the REST documentation for JWT auth. Can you check if that helps. 

Additionally, the hardcode should have worked anyway. Since this is REST, can you update ConfigJSON param in the REST connection with value {"showLogs":true}.
This will enable additional logging and may help to identify the cause. 

[Saviynt_Savvy]

Hi @DanJ 
Could you please help me on how to create a REST connection to the Snowflake SQL REST API?
I tried and haven't found the connector configuration information anywhere and also let me know what type of AUTHENCTICATION (JWT or Key-Value pair) we use in the Connection JSON.

Regards,

[rushikeshvartak]

USE DB connector for snowflake 

 https://docs.saviyntcloud.com/bundle/Snowflake-Guide/page/Content/Understanding-Integration-between-... 

[Saviynt_Savvy]

@rushikeshvartak ,
As mentioned in the Document, we can use either REST or DB connector, right!

It is said to make sure the connector type is DB in case of Snowflake integration.

If it is, could you please let me know how to pick the connector type (which type of connector should we use in which case).
If it is the DB connector, please confirm the below link that I am referring to is correct for the Snowflake integration.
https://docs.saviyntcloud.com/bundle/Database-v23x/page/Content/Using-Classic-Integration.htm