search

snowflakedb / qgis-snowflake-connector

QGIS Connector for Snowflake
MIT License
5 stars 1 forks source link

list index out of range #2

Closed philehot closed 3 weeks ago

philehot commented 1 month ago

OS: Windows QGIS version: 3.14.10.-Prizren

I can't load any layer. I can establish connexion but I'm getting an error for every single table I'm trying to load 2 types of error: 1) SFConvertColumnToLayerTask run failed: list index out of range. Same error if I execute as a SQL query. I add a where clause and I select the geopgraphy type 2) Running snowflake convert column to layer task failed. SQL Compilation error: error line x at position XX, invlaid indetifier 'SHAPEFILE/CENTROID/SHAPE_AREA/STOPTIME/METERS" The invalid identifier is not related to the geopgragy column. I'm not able to identify why it fails on those specific fields.

sfc-gh-obielov commented 1 month ago

Hey @philehot, please try out the latest version and let me know if it's still reproducible. If it still reproducible, please let me know what Windows version do you use

philehot commented 3 weeks ago

I thought initially we had some tables in our WH already converted to GEOGRAPHY but turns out this was not the case. Once I updated a geo column to TO_GEOGRAPHY, the table showed up in QGIS. Closing this as it was not an issue.