JDBC Driver for Tableau CRM Analytics

Build 22.0.8462

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 Analytics 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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462