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

Can't publish data from Marketplace listings #73

Open
sfc-gh-obielov opened this issue Jan 17, 2025 · 0 comments
Open

Can't publish data from Marketplace listings #73

sfc-gh-obielov opened this issue Jan 17, 2025 · 0 comments

Comments

@sfc-gh-obielov
Copy link
Collaborator

sfc-gh-obielov commented Jan 17, 2025

When publishing data loaded from marketplace listing, in my case from CARTO_ACADEMY__DATA_FOR_TUTORIALS.CARTO.CELL_TOWERS_WORLDWIDE, I'm getting the following error:

QGIS version: 3.40.2-Bratislava
QGIS code revision: 14826ca1e4a
Qt version: 5.15.2
Python version: 3.9.5
GDAL version: 3.3.2
GEOS version: 3.9.1-CAPI-1.14.2
PROJ version: Rel. 8.1.1, September 1st, 2021
PDAL version: 2.3.0 (git-version: Release)
Algorithm started at: 2025-01-17T10:27:04
Algorithm 'Export to Snowflake' starting…
Input parameters:
{ 'CONNECTION_DYN_CB' : '["WEBINAR", "WEBINAR", "PUBLIC", "selltowers_test"]', 'GEOMETRY_COLUMN' : 'geom', 'INPUT' : 'snowflakedb://connection_name=SNOWFLAKE sql_query= schema_name=CARTO table_name=CELL_TOWERS_WORLDWIDE srid=4326 geom_column=GEOM geometry_type=POINT geo_column_type=GEOGRAPHY' }

Traceback (most recent call last):
File "/Users/obielov/Library/Application Support/QGIS/QGIS3/profiles/default/python/plugins/qgis-snowflake-connector/qgis_snowflake_connector_algorithm.py", line 249, in processAlgorithm
cur = self.sf_data_provider.execute_query(query, selected_connection)
File "/Users/obielov/Library/Application Support/QGIS/QGIS3/profiles/default/python/plugins/qgis-snowflake-connector/providers/sf_data_source_provider.py", line 87, in execute_query
return self.connection_manager.execute_query(
File "/Users/obielov/Library/Application Support/QGIS/QGIS3/profiles/default/python/plugins/qgis-snowflake-connector/managers/sf_connection_manager.py", line 180, in execute_query
raise e
File "/Users/obielov/Library/Application Support/QGIS/QGIS3/profiles/default/python/plugins/qgis-snowflake-connector/managers/sf_connection_manager.py", line 177, in execute_query
cursor.execute(query)
File "/Applications/QGIS.app/Contents/MacOS/lib/python3.9/site-packages/snowflake/connector/cursor.py", line 1097, in execute
Error.errorhandler_wrapper(self.connection, self, error_class, errvalue)
File "/Applications/QGIS.app/Contents/MacOS/lib/python3.9/site-packages/snowflake/connector/errors.py", line 284, in errorhandler_wrapper
handed_over = Error.hand_to_other_handler(
File "/Applications/QGIS.app/Contents/MacOS/lib/python3.9/site-packages/snowflake/connector/errors.py", line 339, in hand_to_other_handler
cursor.errorhandler(connection, cursor, error_class, error_value)
File "/Applications/QGIS.app/Contents/MacOS/lib/python3.9/site-packages/snowflake/connector/errors.py", line 215, in default_errorhandler
raise error_class(
snowflake.connector.errors.ProgrammingError: 100256 (P0000): Error parsing Geo input: . Did not recognize valid GeoJSON, (E)WKT or (E)WKB.

Execution failed after 3.86 seconds

Loading resulting layers

The query is look like this:

INSERT INTO "WEBINAR"."PUBLIC"."new_test" (geo,RADIO,MCC,NET,AREA,CELL,UNIT,LON,LAT,RANGE,SAMPLES,CHANGEABLE,CREATED,UPDATED,AVERAGESIGNAL,_META_LOADED_AT,_META_SOURCE_FILE_NAME) VALUES 
('','GSM',302.0,610.0,45000.0,37752.0,0.0,-78.877466,43.951368,1959.0,22.0,1.0,1388529053.0,1478186863.0,0.0,'2023-11-22 14:47:37','CARTO_DEMO_TABLES/carto-demo-data.demo_tables.cell_towers_worldwide/carto-demo-data.demo_tables.cell_towers_worldwide_000000000017.parquet'),
('','GSM',302.0,610.0,45000.0,37755.0,0.0,-78.87825,43.952408,1000.0,9.0,1.0,1388895107.0,1424327623.0,0.0,'2023-11-22 14:47:37','CARTO_DEMO_TABLES/carto-demo-data.demo_tables.cell_towers_worldwide/carto-demo-data.demo_tables.cell_towers_worldwide_000000000017.parquet'),

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

1 participant