Hey everyone :wave: I'm using target-snowflake to ...
# getting-started
b
Hey everyone 👋 I'm using target-snowflake to load data from mysql using tap-mysql to snowflake, it was running without any issue .. today I was running some tests (against the same data, nothing has been changed, same pipeline configs, same snowflake account) .. and now having this issue
Copy code
2023-08-05T16:36:59.379356Z [info] self.connector.prepare_table() cmd_type=loader name=target-snowflake run_id=730b5b38-ebc7-463c-a4f6-be70a50b4ba1 state_id=mysql-to-snowflake stdio=stderr
2023-08-05T16:36:59.379822Z [info] File "/project/.meltano/loaders/target-snowflake/venv/lib/python3.9/site-packages/singer_sdk/connectors/sql.py", line 753, in prepare_table cmd_type=loader name=target-snowflake run_id=730b5b38-ebc7-463c-a4f6-be70a50b4ba1 state_id=mysql-to-snowflake stdio=stderr
2023-08-05T16:36:59.380289Z [info] self.create_empty_table() cmd_type=loader name=target-snowflake run_id=730b5b38-ebc7-463c-a4f6-be70a50b4ba1 state_id=mysql-to-snowflake stdio=stderr
2023-08-05T16:36:59.380753Z [info] File "/project/.meltano/loaders/target-snowflake/venv/lib/python3.9/site-packages/singer_sdk/connectors/sql.py", line 689, in create_empty_table cmd_type=loader name=target-snowflake run_id=730b5b38-ebc7-463c-a4f6-be70a50b4ba1 state_id=mysql-to-snowflake stdio=stderr
2023-08-05T16:36:59.381227Z [info] self.to_sql_type(property_jsonschema), cmd_type=loader name=target-snowflake run_id=730b5b38-ebc7-463c-a4f6-be70a50b4ba1 state_id=mysql-to-snowflake stdio=stderr
2023-08-05T16:36:59.381697Z [info] File "/project/.meltano/loaders/target-snowflake/venv/lib/python3.9/site-packages/target_snowflake/connector.py", line 264, in to_sql_type cmd_type=loader name=target-snowflake run_id=730b5b38-ebc7-463c-a4f6-be70a50b4ba1 state_id=mysql-to-snowflake stdio=stderr
2023-08-05T16:36:59.382265Z [info] num_scale = SnowflakeConnector._get_numeric_scale(jsonschema_type) cmd_type=loader name=target-snowflake run_id=730b5b38-ebc7-463c-a4f6-be70a50b4ba1 state_id=mysql-to-snowflake stdio=stderr
2023-08-05T16:36:59.382788Z [info] File "/project/.meltano/loaders/target-snowflake/venv/lib/python3.9/site-packages/target_snowflake/connector.py", line 242, in _get_numeric_scale cmd_type=loader name=target-snowflake run_id=730b5b38-ebc7-463c-a4f6-be70a50b4ba1 state_id=mysql-to-snowflake stdio=stderr
2023-08-05T16:36:59.383249Z [info] precision = max(precision, len(str(jsonschema_type[attrib]).split(".")[1])) cmd_type=loader name=target-snowflake run_id=730b5b38-ebc7-463c-a4f6-be70a50b4ba1 state_id=mysql-to-snowflake stdio=stderr
2023-08-05T16:36:59.383718Z [info] IndexError: list index out of range cmd_type=loader name=target-snowflake run_id=730b5b38-ebc7-463c-a4f6-be70a50b4ba1 state_id=mysql-to-snowflake stdio=stderr
2023-08-05T16:36:59.427859Z [info] 2023-08-05 16:36:59,427 | INFO | snowflake.connector.connection | closed cmd_type=loader name=target-snowflake run_id=730b5b38-ebc7-463c-a4f6-be70a50b4ba1 state_id=mysql-to-snowflake stdio=stderr
2023-08-05T16:36:59.428509Z [info] 2023-08-05 16:36:59,427 | INFO | snowflake.connector.connection | No async queries seem to be running, deleting session cmd_type=loader name=target-snowflake run_id=730b5b38-ebc7-463c-a4f6-be70a50b4ba1 state_id=mysql-to-snowflake stdio=stderr
2023-08-05T16:36:59.452900Z [info] 2023-08-05 16:36:59,452 | INFO | snowflake.connector.connection | closed cmd_type=loader name=target-snowflake run_id=730b5b38-ebc7-463c-a4f6-be70a50b4ba1 state_id=mysql-to-snowflake stdio=stderr
Just wondering if the recent changes to snowflake's repo maybe caused it thinkspin
e
b
@edgar_ramirez_mondragon Thanks .. I realized that I posted it in the wrong channel 😅