Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Data not loading #6

Open
nhung-ER opened this issue Oct 24, 2024 · 4 comments
Open

Data not loading #6

nhung-ER opened this issue Oct 24, 2024 · 4 comments
Assignees

Comments

@nhung-ER
Copy link

Hi Team,
Like the other poster, I am able to connect and have the layers appear just fine. Issue is, I can't seem to display the data. I get the SFConvertColumnToLayerTask run failed.

Running snowflake convert column to layer task failed.

Extended error information:
QgsField(): arguments did not match any overloaded call:
overload 1: argument 2 has unexpected type 'Type'
overload 2: argument 'subType' has unexpected type 'Type'
overload 3: argument 1 has unexpected type 'str'

Not sure if it is how we store the data.

@sfc-gh-obielov
Copy link
Collaborator

@nhung-ER Could you please provide the following details:

  • OS and version
  • QGIS version
  • Does this issue occur with any type of table, or only with specific ones?
  • Steps to reproduce, if possible

@nhung-ER
Copy link
Author

Hey @sfc-gh-obielov
Apologies, of course it would help.
Microsoft - new connector in BETA atm
QGIS Version - 3.38.2
Happened with Polygon dataset I have - Can confirm type is Geography as Geometry is not yet supported for microsoft.

Some layers don't throw an error and it just does nothing and some tables I get this error:

Running snowflake convert column to layer task failed.
Extended error information:
000904 (42000): SQL compilation error: error line 1 at position 7
invalid identifier 'ACARA'

Can't provide steps unfortunately as it's a closed database.

@sfc-gh-obielov
Copy link
Collaborator

Thanks @nhung-ER, I assume you use Windows 11, is that correct?

@sfc-gh-obielov
Copy link
Collaborator

sfc-gh-obielov commented Oct 28, 2024

@nhung-ER please install the new version 0.7 of the plugin. Remove any previous version of the plugin (if installed) before installing qgis-snowflake-plugin.zip

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants