Hello Esri Community - I am reaching out to seek your advice on optimising layer drawing speed in ArcGIS Pro when connected to a Snowflake data source.
I am currently working on a project where we are using Snowflake as our primary data storage, and we need to visualise and interact with large datasets in ArcGIS Pro. However, we have been facing massive performance issues, as the layers are taking a significant amount of time to render and update (15+ seconds). The data is small and not complex (10,000 points, ABP data) and when we query the data I can see Snowflake is responding in under 1 second, so it's Esri side that is slowing it down (roughly 15-20 seconds to draw). Same experience when the layer is published to Enterprise, still very slow.
Here is a brief overview of our setup and what we have tried so far:
- ArcGIS Pro Version: 3.0
- Snowflake Connector: ODBC Driver (64 bit)
- Data Structure: Address Base Premium (OS) point data
- System Specifications: Windows 10 Enterprise with 16gb RAM
We have already attempted the following approaches to improve the drawing speed:
- Applied spatial indexing on the relevant Snowflake tables.
- Reduced the number of features being drawn by implementing definition queries.
- Optimized map scale settings and display settings.
- Ensured that the system meets the minimum hardware requirements for ArcGIS Pro.
Unfortunately, despite these efforts, we are still experiencing slow drawing speeds. If anybody has any known limitations or workarounds for connecting Snowflake data sources with ArcGIS Pro, it'd be much appreciated.
Thanks in advance,
Sam