Forum Discussion

talluri's avatar
talluri
New Contributor
3 years ago
Solved

Can we integrate snowflake with ready API

Hello, 

 

 I just want to check if ready api can be integrated with Snowflake ?. I know we can do SQl and which i am already implementing that but as snowflake is more like UI and based on url I want to know how we can connect to ready api and data validation. Any recommendation will be  appreciated. Thanks.

 

Assertions
data-driven testing
Function Tests
integrations
Reporting
REST
  • nmrao's avatar
    nmrao
    3 years ago

    No idea about Snowflake.

    If you can query data from Snowflake using SQL then you can do that from ReadyAPI. You need the snowflake driver to be copied under READYAPI_HOME/bin/ext and restart tool.

    Use jdbc test step to query data from Snowflake..

  • nmrao's avatar
    nmrao
    3 years ago

    Suggest you to check for the Snowflake's documentation and look for connection string.

4 Replies

  • nmrao's avatar
    nmrao
    Community Hero
    3 years ago

    No idea about Snowflake.

    If you can query data from Snowflake using SQL then you can do that from ReadyAPI. You need the snowflake driver to be copied under READYAPI_HOME/bin/ext and restart tool.

    Use jdbc test step to query data from Snowflake..

  • talluri's avatar
    talluri
    New Contributor
    3 years ago


    I would like to know why driver is not showing in the jdbc list when snowflake jar file is added to READYAPI_HOME/bin/ext. Is there any other existing drive i have to choose which works for this driver Also do i need to add as new driver in preference to show up in the list ?

     

     

     

     

     

     

     

     

     

  • nmrao's avatar
    nmrao
    Community Hero
    3 years ago

    Suggest you to check for the Snowflake's documentation and look for connection string.

  • talluri's avatar
    talluri
    New Contributor
    3 years ago

    I have looked Document there is examples and steps to pick a string but not exactly what string works for snowflake . I have driver but having hard time to pick which one. not sure if cloudscape will wor on snowflake ..