JDBC Driver for Tableau CRM

Build 21.0.7930

HandleAPINullIssues

A boolean indicating if the provider should handle known issues with Tableau CRM nulls.

Data Type

bool

Default Value

true

Remarks

Tableau CRM has documented some known issues with nulls. This includes rows being excluded from results when there would be nulls on a columns used in both Order By and Group By. For instance:

SELECT Product_Name FROM Dataset_DTC_Opportunity_SAMPLE GROUP BY Product_Name

Will normally not return the entries that are null. This causes issues for aggregations especially. To handle this, CData JDBC Driver for Tableau CRM will instead handle operations that would normally cause a problem with nulls internally instead of having the Tableau CRM execute them. This will cause worse performance, but results will be accurate. Set HandleAPINullIssues to false if null entries are not a problem for you, or if in cases where performance is more important.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930