KNOWLEDGE BASE

Snowflake Extract Creation Not Completing


Published: 01 Apr 2020
Last Modified Date: 01 Apr 2020

Issue

When trying to create an extract of a Snowflake data source, the extract creation process may not be completed, even after many hours.

Environment

  • Tableau Desktop
  • Snowflake

Resolution

To troubleshoot this issue, try the following options:

Option 1 - Update the Snowflake driver installed to the latest version
Snowflake ODBC drivers can be downloaded from https://sfc-repo.snowflakecomputing.com/odbc/index.html

Option 2 - Use SnowCD (Connectivity Diagnostic Tool)
SnowCD can help diagnose and troubleshoot network connections to Snowflake. For information on how to install and run SnowCD, see this Snowflake document.

Option 3 - Run the extract query in another query tool that uses the Snowflake ODBC driver and is installed on the Tableau Desktop computer
  1. Find the extract query in the Tableau Desktop log files using the Tableau Log Viewer.
  2. Run the query in a query tool that uses the Snowflake ODBC driver, such as WinSQL (64-bit), to see how long the query takes to complete.

Cause

Root cause may vary in difference cases. Try the resolutions/troubleshooting steps above.
Did this article resolve the issue?