IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Back to discussions
Expand all | Collapse all

Snowflake Connection Issue(Get Rows)

  • 1.  Snowflake Connection Issue(Get Rows)

    Posted Sat September 18, 2021 02:58 AM

    Hi,

    We are trying to connect to snowflake via webMethods. However, when we try to run a query "Select count(1) from <

    >. we are able to get the results. But when we try to run it as “Get Rows” then we get an error as
    “No active warehouse selected in the current session. Select an active warehouse with the ‘use warehouse’ command.”

    Can you please help in letting us know how do we set the Warehouse while trying to get rows from Snowflake?
    Regards,
    Nitin


    #webMethods-io-Integration
    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: Snowflake Connection Issue(Get Rows)

    Posted Sat September 18, 2021 11:37 AM

    This appears to be an issue on Snowflake’s side (user privileges, mostly), from a Google search.

    Example - Snowflake Community

    Search online and see if any articles help you.

    KM


    #Integration-Server-and-ESB
    #webMethods-io-Integration
    #webMethods


Related Content