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.
| Bug ID Number | BUG-000156089 |
|---|---|
| Submitted | February 24, 2023 |
| Last Modified | June 6, 2025 |
| Applies to | ArcGIS Pro |
| Version found | 3.1 |
| Operating System | Windows OS |
| Operating System Version | N/A |
| Version Fixed | 3.2 |
| Status | Fixed |
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
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App