Bug
Publishing a query layer created from the Snowflake database fails, and an error occurs when 'materialized view' is selected in the Share As Web Layer window.
| Bug ID Number | BUG-000148202 |
|---|---|
| Submitted | April 4, 2022 |
| Last Modified | June 6, 2024 |
| Applies to | ArcGIS Pro |
| Version found | 2.9 |
| Operating System | Windows OS |
| Operating System Version | N/A |
| Version Fixed | 3.1 |
| Status | Fixed |
Additional Information
There are some limitations in Snowflake regarding the creation of materialized views. With some query syntax, a materialized view cannot be created, causing publishing to fail. The logic in a sharing analyzer is adjusted to better inform when a materialized view cannot be supported. The same logic is used in the New Query Layer dialog when the materialized view checkbox is selected. When publishing data in Snowflake, the default configuration option is changed to 'access data directly'.Workaround
- In the Share as Web Layer window, select the Configuration tab.
- Select the Configuration Parameters icon.
- The Data Source section displays 'materialized view' by default. Switch to the option 'access data directly'.
Publishing is successful.
Steps to Reproduce
Bug ID: BUG-000148202
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