KNOWLEDGE BASE

​​​​​​​Error "Error parsing filter for field 'field name' ignoring filter" Refreshing Extracts Or Blank Views Display Using Integers for Boolean Fields from Snowflake


Published: 27 Jun 2019
Last Modified Date: 28 Jun 2019

Issue

When refreshing Snowflake extracts that contain integers for boolean fields, the below error will occur. If connecting live, blank views will display. 
 
Connectionless Failure 
An error occurred when refreshing extracts for the workbook. Errors occurred while reloading the data source.
Error parsing filter for flied 'field name' ignoring filter

Environment

  • Tableau Online
  • Snowflake 
  • Boolean fields

Resolution

To work around the issue, try the below options. 

Option 1 Update the Snowflake driver and remove calculations which convert boolean fields from integers to boolean 
  1. Install version 2.18.3 of the Snowflake driver. 
  2. Open the affected workbook in Tableau Desktop. 
  3. Remove any calculations which convert boolean fields to integers. 
  4. Publish the workbook to Tableau Online. 
Option 2 Update the Snowflake driver and change calculations that convert booleans to integers 
  1. Install version 2.18.3 of the Snowflake driver. 
  2. Open an affected workbook in Tableau Desktop. 
  3. Edit the calculation which converts integers to boolean. 
  4. Change the integer value to boolean and publish the workbook to Tableau Online. For example:
Change IIF([boolean field]=1,TRUE,FALSE) to IIF([boolean field]=TRUE,TRUE,FALSE)

Cause

The Snowflake driver in Tableau Online was updated to 2.18.3, which supports booleans. Earlier versions of the driver did not support boolean fields and required converting them from integer to boolean in Tableau. 

Additional Information

When viewing the calculation in Tableau Desktop using version 2.16.2 or similar Snowflake driver, the below error may display: 
Can't compare integer and boolean values
Did this article resolve the issue?