KNOWLEDGE BASE

Error Code: EACD3C9A Occurred after Using Dateparse Function When Using Live Connection to Snowflake


Published: 28 Nov 2023
Last Modified Date: 29 Nov 2023

Issue

The following error occurred after adding a calculation field containing the DATEPARSE function in which the string data is parsed to datetime when connecting live to Snowflake data.

An example of a DATEPARSE calculation:

DATEPARSE('yyyy/MM/dd hh:mm:ss.SSSSSS',"2023/08/31 22:42:12.739000")

Sample error:

Unable to complete action
Bad Connection: Tableau could not connect to the data source.
Error Code: EACD3C9A
Can't parse '2023/08/31 22:42:12.739000' as timestamp with format 'YYYY/MM/DDDD HH12:MI:SS.FF6'
SELECT TO_TIMESTAMP('2023/08/31 22:42:12.739000', 'YYYY/MM/DDDD HH12:MI:SS.FF6') AS "Calculation_438819513837039616",
  '2023/08/31 22:42:12.739000' AS "Calculation_438819513837465601",
  TO_TIMESTAMP('2023/08/31', 'YYYY/MM/DD') AS "Calculation (Copy)_438819513837846530"
FROM "TESTV1"."PUBLIC"."BATTERS" "BATTERS"
HAVING (COUNT(1) > 0)



With a connection to Snowflake data via a virtual connection,  the following error message example can occur:

Unable to complete action
Bad Connection: Tableau could not connect to the data source.
Error Code: 305B73A6
Unknown error
<logical-query><query-tag lqctx-batch-query-id='0' lqctx-root-activity-id='FbCU0rWlEdIL8HZpxc+obV' query-category='Data' /><selects><field>[Calculation_423338390129680384]</field><field>[Calculation_423338390129803265]</field><field>[Calculation_423338390134525955]</field></selects><domainOp class='logical-operator' type='snowflake'><projectOp class='logical-operator'><expressions><binding name='[Calculation_423338390129680384]'><literalExp charset='0' class='logical-expression' collation='LROOT' datatype='string' value='&quot;2023/08/31 22:42:12.739000&quot;' /></binding><binding name='[Calculation_423338390129803265]'><funcallExp class='logical-expression' function='DATEPARSE' shape='scalar'><literalExp charset='0' class='logical-
expression' collation='LROOT' datatype='string' value='&quot;yyyy/MM/dd hh:mm:ss&quot;' /><literalExp charset='0' class='logical-expression' collation='LROOT' datatype='string' value='&quot;2023/08/31 22:42:12&quot;' /></funcallExp></binding><binding name='[Calculation_423338390134525955]'><funcallExp class='logical-expression' function='DATEPARSE' shape='scalar'><literalExp charset='0' class='logical-expression' collation='LROOT' datatype='string' value='&quot;yyyy/MM/dddd hh:mm:ss.SSSSSS&quot;' />etc...

Environment

  • Tableau Desktop 2023.2
  • Snowflake

Resolution

Change the part of parsing the hour from "hh" to HH:

DATEPARSE('yyyy/MM/dd HH:mm:ss.SSSSSS',"2023/08/31 22:42:12.739000")

Cause

The use of hour using "hh" (12 hour) instead of HH (24 hour) time with Snowflake data causes this error.
Did this article resolve the issue?