Bug
Unable to select a date using the Date Picker range with Google BigQuery date fields for filtering and time slider in ArcGIS Dashboards, and returns the following error message, "Error: Invalid SQL syntax[[Simba][BigQuery]."
| Bug ID Number | BUG-000149705 |
|---|---|
| Submitted | June 2, 2022 |
| Last Modified | October 3, 2024 |
| Applies to | ArcGIS Dashboards |
| Version found | 10.9.1 |
| Operating System | Windows Server |
| Operating System Version | 2019 64 Bit |
| Status | Known Limit |
Additional Information
This is a known limit. ArcGIS Platform maps the BigQuery date field type to 'esriFieldTypeDate', expecting a time component when querying. For more information, refer to https://pro.arcgis.com/en/pro-app/latest/help/data/databases/cloud-data-warehouse-data-types.htm#ESRI_SECTION1_F580D220C8494F6BA71EAE0845AFD1F2.Workaround
Use the BigQuery datetime field instead.
Steps to Reproduce
Bug ID: BUG-000149705
Software:
- ArcGIS Dashboards
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