Hi,
Has anyone successfully connected and viewed spatial data from a database stored in Amazon RedShift database using the new feature ArcGIS Pro 2.9.3?
We have installed the necessary ODBC driver Amazon Redshift (x64) to enable viewing the spatial data. We can view both table and spatial features using DBWeaver, FME. Prior to 2.9.3, we have been converting into a feature class using FME and it worked fine.
Now, we would like to use the ArcGIS Pro 2.9.3 feature that allows direct connection to an Amazon Redshift database (New database connection option). The tables can be seen and viewable but we are not able to view the spatial features of the feature class.
We have created 2 views in Redshift. One with a GEOMETRY and another with a GEOGRAPHY shape field.
When viewing the table the tables using the Redshift connection in ArcGIS Pro, only the table with GEOMETRY column is shown as a spatially-enabled table. When trying to add the same (GEOMETRY column table) to the map we get the error "Stream not found".