laptop and a wrench

Bug

In Google BigQuery from ArcGIS, the error message, “Failed to load data. Invalid query: Could not cast literal “<datetime>” to type DATE” is returned when working with a query layer containing a unique identifier of the Date data type.

Last Published: March 20, 2023 ArcGIS Pro
Bug ID Number BUG-000156089
SubmittedFebruary 24, 2023
Last ModifiedJune 5, 2024
Applies toArcGIS Pro
Version found3.1
Operating SystemWindows OS
Operating System VersionN/A
Version Fixed3.2
StatusFixed

Additional Information

This issue is addressed in ArcGIS Pro 3.2.

Workaround

Pick a different unique identifier other than the Date field.

Steps to Reproduce

Bug ID: BUG-000156089

Software:

  • ArcGIS Pro

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options