laptop and a wrench

Bogue

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.

Dernière publication: December 20, 2022 ArcGIS Pro
Numéro d’ID de bogue BUG-000148202
EnvoiApril 4, 2022
Dernière modificationJune 6, 2024
S’applique àArcGIS Pro
Version trouvée2.9
Système d’exploitationWindows OS
Version du système d’exploitationN/A
Version de correction3.1
StatutFixed

Informations supplémentaires

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'.

Solution de contournement

  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.

Étapes pour reproduire

ID de bogue: BUG-000148202

Logiciel:

  • ArcGIS Pro

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement