Snowflake Error: InboundNamedPipe GetOverlappedResult: The pipe has been ended.

[JonathanAllenby]

Quick post based on a Support Case I've just been involved with:

Snowflake Input Error: Designer x64: The Designer x64 reported: InboundNamedPipe GetOverlappedResult: The pipe has been ended.

Issue

When extracting more than a few hundred rows of data or data with a large number of columns from Snowflake using the Input or IN-DB tools, you may receive the following error:

Error: Designer x64: The Designer x64 reported: InboundNamedPipe GetOverlappedResult:  The pipe has been ended.

Environment Details

Observed in:

• Alteryx Designer 2021.3.8.17680 
• Alteryx Server 2021.3.8.17680

Cause

The official Simba Snowflake driver on the licensing portal has compatibility issues and does not line up with the 'Validated On' version in the Snowflake documentation.

Resolution

Install an older version of the Simba Snowflake driver.

Simba Snowflake 2.25.5.1019 validated on Alteryx Designer 2021.3.8.17680.

1. On the Drivers download page, instead of selecting Snowflake, scroll down to find Snowflake Previous Versions.
   
   
   

2. At the bottom are the version that is listed on the Alteryx Snowflake documentation, as well as a version we used to resolve our support case.

    

Additional Resources

• Alteryx Snowflake Documentation

[JonathanAllenby]

I don't seem to be able to update my post, so here is some extra information:

UPDATE 12th June 2023:

Environment:

Also observed in:

• Alteryx Designer 2021.2.1
• Snowflake ODBC Driver 2.25.11.00 (https://sfc-repo.snowflakecomputing.com/odbc/win64/2.25.11/snowflake64_odbc-2.25.11.msi)

Resolution:

Also confirmed to be resolved by downloading 2.25.5 directly from the Snowflake repo:

• https://sfc-repo.snowflakecomputing.com/odbc/win64/2.25.5/snowflake64_odbc-2.25.5.msi

[JonathanAllenby]

UPDATE 9th August 2023:

There is now an official KB for this here:

• https://alteryx.my.site.com/knowledgecenter/s/article/Error-message-InboundNamedPipe-GetOverlappedRe...