POST
|
Hello, I've attempted to create a connection to a Data Store using the BETA Data Pipelines in ArcGIS Online. The data store is Snowflake. On every occasion I insert the requirement parameters, Server Username/Password Database Schema Warehouse Role I've confirmed outside of AGOL that the credentials and parameters work and connetion is successful. however, in AGOL I continue to get 'Validation Failed" Any ideas? Is there a specific driver I need?
... View more
12-06-2023
06:49 AM
|
0
|
3
|
422
|
IDEA
|
When connecting to a cloud data warehouse (Snowflake) some tables could have multiple GEOGRAPHY columns depending on if the table is a header table (rolled up view of mutiple pieces of information). Esri does not allow one to select which GEOGRAPHY column should be used in the dialog IDEA: Enhancing the dialog to flag user multiple spatial columns, or maybe even add an option to choose the spatial column to use.
... View more
06-07-2022
02:18 PM
|
1
|
0
|
265
|
IDEA
|
When connecting to Snowflake as the data source and adding a spatial table to the map, Pro chooses a field as the Unique identifier, most often the user has to override this default field to the correct unique identifier from the table. If the unique identifier for the table is a DOUBLE data type, ArcPro throws an error “Failed to Load Page of Rows” when attempting to open the attribute table, this error also prohibits the ‘identify’ tool to work in Pro. This attribute is set as an integer NUMBER(12,0) data type at the source oracle database, denodo database, and snowflake level As a workaround I was able to use the CAST function in the query to change the DOUBLE to a TEXT. Example: cast(uspip_id as varchar(50)) as uspip_id,WKT,GEOGRAPHY from Request is for Pro to support a DOUBLE data type as the Unique Identifier when using Cloud Data Warehouses such as Snowflake. Otherwise the end user needs to implement a work around to eliminate the error being thrown in Pro.
... View more
03-04-2022
12:33 PM
|
3
|
0
|
390
|
Title | Kudos | Posted |
---|---|---|
1 | 06-07-2022 02:18 PM | |
3 | 03-04-2022 12:33 PM |
Online Status |
Offline
|
Date Last Visited |
12-07-2023
05:52 PM
|