laptop and a wrench

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.

Zuletzt veröffentlicht: December 20, 2022 ArcGIS Pro
Bug-ID-Nummer BUG-000148202
EingereichtApril 4, 2022
Zuletzt geändertJune 6, 2024
Gilt fürArcGIS Pro
Gefunden in Version2.9
BetriebssystemWindows OS
BetriebssystemversionN/A
Behoben in Version3.1
StatusFixed

Zusätzliche Informationen

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

  1. In the Share as Web Layer window, select the Configuration tab.
  2. Select the Configuration Parameters icon.
  3. The Data Source section displays 'materialized view' by default. Switch to the option 'access data directly'.

Publishing is successful.

Schritte zur Reproduzierung

Bug-ID: BUG-000148202

Software:

  • ArcGIS Pro

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln