snowflakedb / snowflake-connector-python

Snowflake Connector for Python
https://pypi.python.org/pypi/snowflake-connector-python/
Apache License 2.0
599 stars 473 forks source link

Execution failed on sql 'SELECT name FROM sqlite_master WHERE type='table' AND name=?;' #1228

Closed Vaunorage closed 11 months ago

Vaunorage commented 2 years ago

Please answer these questions before submitting your issue. Thanks!

1. What version of Python are you using?

python 3.8

2. What operating system and processor architecture are you using?

Windows-10-10.0.19044-SP0

3. What are the component versions in the environment (pip freeze)?

backports.zoneinfo @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/71/1a/62/9085821058bcfe08a06807ec8e41c81aae5142f52ebc4911a8c6fbeec0/backports.zoneinfo-0.2.1-cp38-cp38-win_amd64.whl beautifulsoup4 @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/ce/13/0d/ce3a1461e71c67309bbfb28e32ea8186ff7c831d213170cdb54055ea84/beautifulsoup4-4.11.1-py3-none-any.whl
black @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/18/bc/3a/6cfdf9339b6fa38c87d43cbab9a1c29a97a977cdcf7785d1c3b323469b/black-22.6.0-cp38-cp38-win_amd64.whl
bleach @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/2d/1e/3c/8aa430e833f4c2b93943c56c48c62d369bc094eb59c23858703e9c5025/bleach-5.0.1-py3-none-any.whl
cachetools @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/cf/2f/fa/12fd4c4101879d8d9546d20040298b14509c39fce2f4ccaa9a5c86ad44/cachetools-5.2.0-py3-none-any.whl
category-encoders @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/89/5c/77/e5f5557a9df039a29c78490b5a1813ba25420fe03ef9dda3382423642c/category_encoders-2.5.0-py2.py3-none-any.whl certifi @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/0f/59/de/e5e6d69facca7b107575f87c21dfaf9a9407da4d9e72ae24b880961a24/certifi-2022.6.15-py3-none-any.whl cffi @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/7d/26/a2/6695b21ce04407fbecceb61a88eaae991c2069deb1f071d3de97929651/cffi-1.15.1-cp38-cp38-win_amd64.whl chardet @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/47/b7/82/19c2b887f87f3adbaf4e34c55189388e5132c78f6929d7001a78b0209b/chardet-4.0.0-py2.py3-none-any.whl charset-normalizer @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/ae/14/8e/087a104edb7ec627884755272de815d8ee4fd53b8745fdb12a087dd2e1/charset_normalizer-2.0.12-py3-none-any.whl click @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/bd/9c/91/fc982221d93312eb60d91ed31ec2945771bec0eb111953316ae8293dce/click-8.1.3-py3-none-any.whl cloudpickle @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/99/92/aa/a3c8b451c40f019f140bb60eb90df799a7d1a35108f7ef3a316d036200/cloudpickle-2.1.0-py3-none-any.whl colorama @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/95/5f/1b/2d38970ff67aebb4a9eac917b8b8a32098cbd020d743aa91e508f5bfae/colorama-0.4.5-py2.py3-none-any.whl colour @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/1f/e9/63/f4cf77031cc99829b741e183478017bf3301354934c5a581807e1c2a53/colour-0.1.5-py2.py3-none-any.whl configobj @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/9a/ed/ad/f341d51dfaa132e24c9ad2e200149a85793ed31ed33bd562c7601b2a4f/configobj-5.0.6.tar.gz create-doc @ file:///C:/Users/gen06917/PycharmProjects/MKT_EXPECTEDLIFETIME/create_doc cryptography @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/68/91/40/ea547ba43a50a0918ae5d69a7b8626b210d36a0b11abd69472e2676419/cryptography-36.0.2-cp36-abi3-win_amd64.whl cycler @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/37/9c/25/cbaf98f95cc74b0a7617cef17520e3f063dbabd9f0f8a04f93a15f6632/cycler-0.11.0-py3-none-any.whl db-dtypes @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/17/4a/38/bcebec6c51f1fdbc65604918542aa3948e34795424c21d72edeeee80a0/db_dtypes-1.0.3-py2.py3-none-any.whl deap @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/24/c4/e1/b22bf995ec036b19fd7b9919da05402d1e35116f55127a26f34ad4dd8e/deap-1.3.3-cp38-cp38-win_amd64.whl debugpy @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/67/ae/18/c169b3951a9e3be94c5d7bc674e0572bc29d854a21066a26d227471dcf/debugpy-1.6.3-cp38-cp38-win_amd64.whl decorator @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/b2/51/d1/b9c4dde2f3db3d279275d6fb62182a7076ecacc9e25c450e4af1e428ba/decorator-5.1.1-py3-none-any.whl deepchecks @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/b1/ec/aa/0ad6be953bab4a8410ead21bef437b32f5580b38b28afb4229c72dbd3b/deepchecks-0.6.4-py3-none-any.whl defusedxml @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/15/b0/94/888992ee7b1de9fbc975b6afd17d34f441df6e96172df8d4eba95c9432/defusedxml-0.7.1-py2.py3-none-any.whl Deprecated @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/a1/54/60/4388a99c14cd296d410c6caa1d625df8f20eabdff83d77e46c3bb305cd/Deprecated-1.2.13-py2.py3-none-any.whl docker-pycreds @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/d8/39/1e/e7e74a2508ba56c50439f59cedea0b0b83433255ecfa7626aae74aef70/docker_pycreds-0.4.0-py2.py3-none-any.whl dtreeviz @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/72/5c/a8/ca2f6165d9fa4c267471ee1090aa215fb72398002bf87d7b762b1e9d29/dtreeviz-1.3.7.tar.gz entrypoints @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/e1/87/5c/599600a1c57c18ae8d12a6b599957cfbe1667774faa8167ca7c152c988/entrypoints-0.4-py3-none-any.whl et-xmlfile @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/54/fd/16/7449f65d172d97e10b198adf308f9254ed6c37e55795a24184502b4883/et_xmlfile-1.1.0-py3-none-any.whl etl==0.1.3 fastjsonschema @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/b5/52/a9/c3423189c77c44bc674149278003c67dc1f9221633f3f90c37f53d782e/fastjsonschema-2.16.1-py3-none-any.whl feature-engine @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/73/b2/a9/38a56552ca7faee9dab0757a8ce18b3f7faeeb9451333f4fe7bb6855de/feature_engine-1.4.1-py2.py3-none-any.whl fire @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/a5/c6/8e/787aeae2abb2e89ea98a95e4a3122303096e22cdb2a47ef6a483e106d1/fire-0.4.0.tar.gz fonttools @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/0d/f9/0b/52018901c988c61a743f2c0427765fc5257f2f827948924037a1321f88/fonttools-4.35.0-py3-none-any.whl future @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/d9/62/dc/809bb3ddfe360ddc60ebb287ad6b0eaf71aef98937f0ea0c466d44aa19/future-0.18.2.tar.gz gitdb @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/2f/1b/c6/e19d782b5981117a4bd0a9874a94aeab968aea4df14fffb4826191727e/gitdb-4.0.9-py3-none-any.whl GitPython @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/be/09/4d/21ed377572c6dd1bbeb575a06cce2f0b2319e360eef7a5c1ce31e19320/GitPython-3.1.27-py3-none-any.whl google-api-core @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/4e/a5/b8/05eda4e51fd5c4af463251256de5b6c9493dcab46de820a312f70c4443/google_api_core-2.8.2-py3-none-any.whl google-auth @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/ee/88/b3/4b78369e48218a255a3018edc281574db358114b27c208064c48ebf405/google_auth-2.10.0-py2.py3-none-any.whl google-auth-oauthlib @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/eb/ec/7f/df6b9cbb3681aa3d4f521a50168d41b8b7ab8cf89be5c6d4f8bd7dbb9e/google_auth_oauthlib-0.5.2-py2.py3-none-any.whl
google-cloud-bigquery @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/1c/6e/11/e331d5e4166eeb74f1b823c50ccbfd06f325b7644f441b26f199b32903/google_cloud_bigquery-3.3.1-py2.py3-none-any.whl
google-cloud-bigquery-storage @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/20/51/0c/ee102870fc3a325890a499717786b48a539f0c651d87946a29b4ee8209/google_cloud_bigquery_storage-2.14.2-py2.py3-n one-any.whl google-cloud-core @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/ae/e5/55/368b6eb91d46979fe0289ff820a091bcbbf1a358f006bf1b84852e4066/google_cloud_core-2.3.2-py2.py3-none-any.whl google-cloud-storage @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/9e/63/3e/a74cb764939f27dfc50121f0623885b73abf22bc2c0b8abcd1bf857a74/google_cloud_storage-2.5.0-py2.py3-none-any.whl
google-crc32c @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/d7/bd/97/3d4dde121929ccd92bad652b6082553872af5a1ce6e608dd11e6692626/google_crc32c-1.3.0-cp38-cp38-win_amd64.whl google-resumable-media @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/09/ed/28/99029e9a10af305c05ef24b097ea87fb03b0408f981bb83e7e60dc5aec/google_resumable_media-2.3.3-py2.py3-none-any.whl
googleapis-common-protos @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/42/b9/d1/e5eda5dbaeaca6d26d3851f19d1d1dcd162111e39cac4acccc143d10b2/googleapis_common_protos-1.56.4-py2.py3-none-any.wh l graphviz @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/07/f3/01/71ceecb94fac560d602cc40e639a8f975bdf4221532f968d4f5e562689/graphviz-0.20.1-py3-none-any.whl greenlet @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/dc/90/85/9e265b0d17b2a2519719be69dd9fc70b33d777befaa80fac08b137c43c/greenlet-1.1.2-cp38-cp38-win_amd64.whl grpcio @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/a3/47/e0/1917867946b4bf22474e2ff2c9709c8cecb93565d0ba33227c1d542d9a/grpcio-1.48.0-cp38-cp38-win_amd64.whl grpcio-status @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/5c/97/3e/1f054cab54d2cd4d01ba0ddfb7686207c9973c25f832f21669c36ecad9/grpcio_status-1.48.0-py3-none-any.whl htmlmin @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/a4/20/9d/da87f9f085be5561e2ff5f80e1f69d9112dba51ea3f40c385231af8a96/htmlmin-0.1.12.tar.gz idna @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/f7/09/c9/8e80952436ff87855ddff4891a35ecf913b2b5dc97911f02a070ff2b1f/idna-3.3-py3-none-any.whl ImageHash @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/cc/3d/b3/836163a57e7590f2aeddc0edfa5a5b487bf45033bd73729a7b04c44598/ImageHash-4.2.1.tar.gz importlib-metadata @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/b7/69/e6/0e47ff96020133a615ce04b3b4a1eaeed54ca2b4782beda4456395f6f5/importlib_metadata-4.12.0-py3-none-any.whl importlib-resources @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/3a/2d/e2/c2b4e3cba9abf8b94f4e269203d9798fd7eb42b5b9d240203f3ebbe692/importlib_resources-5.9.0-py3-none-any.whl iniconfig @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/ac/f9/da/e990ffcd9ec361a68676a5916e391286e1ea5d1b8907ae887e141a71f5/iniconfig-1.1.1-py2.py3-none-any.whl ipykernel @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/f9/3d/4c/dfe358db1fa15e960c9527f5f76c330dea70ae61b7d48609b4a83d754f/ipykernel-6.15.1-py3-none-any.whl ipython @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/23/41/b6/aa949fb4292f57f9362248da634e90c34dac7e02d718a02cfabc81097a/ipython-7.34.0-py3-none-any.whl ipython-genutils @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/e6/8e/a3/8f37e14310c0072b3fcc4240490bcb42630aa695d069aee89953ebd9f8/ipython_genutils-0.2.0-py2.py3-none-any.whl ipywidgets @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/e5/49/2d/e5d895e7da81ebd502cbca867691b32d96ac0a8acfa8a0f3e48a2f54bc/ipywidgets-7.7.1-py2.py3-none-any.whl jedi @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/ae/67/fa/6c67b583f86d79757de2d88d5a7eafd656de0024925509ab85892cba18/jedi-0.18.1-py2.py3-none-any.whl Jinja2 @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/33/db/47/0926a99dba6f131e3566591eed52f286b44bcfddcbe351f4116fc4d26f/Jinja2-3.1.2-py3-none-any.whl joblib @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/9b/a3/77/11a58dff170042277b83b2abf4a83664b0ef3c048f0cccee2b204ed842/joblib-1.1.0-py2.py3-none-any.whl jsonpickle @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/58/e1/a6/aab5f4f68aae771f4ab9858ac46782de7f4e75e4de2e032bc2f784a7ee/jsonpickle-2.2.0-py2.py3-none-any.whl jsonschema @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/2b/bf/40/106d26c9746afb337e706455dca4b2b740975db306eed34ac3c05d3bc7/jsonschema-4.10.0-py3-none-any.whl jupyter==1.0.0 jupyter-client @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/d8/c7/e8/b56016f90af1a87a7da86ed391952b84841051ed91f804f4d288f7c685/jupyter_client-7.3.4-py3-none-any.whl jupyter-console==6.4.4 jupyter-core @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/2e/18/67/438e6689569534f2de78ef6b11846237c132aa0b1cf35d8775a14a669b/jupyter_core-4.11.1-py3-none-any.whl jupyterlab-pygments @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/5d/7d/db/cba1b9a8cf001153758a074ebc48837fbb609c2b1742b95a81c6a40e00/jupyterlab_pygments-0.2.2-py2.py3-none-any.whl jupyterlab-widgets @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/e0/91/d9/04137640a44a4e917a1cfb60e598e442fc5303be4252b131da09e6b569/jupyterlab_widgets-1.1.1-py3-none-any.whl kiwisolver @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/cd/f9/9a/2e8f5f04837f730e3b65b90ebec89d44d106c8b668413dc063c5a3bddc/kiwisolver-1.4.4-cp38-cp38-win_amd64.whl lightgbm @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/2b/8f/19/8877947c33fe4da67101a2c6fe17bc1deb9ca67bc0a92b7d94709274ec/lightgbm-3.3.2-py3-none-win_amd64.whl llvmlite @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/c5/9d/bb/d9cb5a8ec1b5a28e3be2b61fbf946bfc61006d571ff153a336f411fd30/llvmlite-0.39.0-cp38-cp38-win_amd64.whl logger @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/95/5c/ac/61f0ce99f373ad93801e6a3d7a2a8a168fa4be14ff6d08d95c916bb8cc/logger-1.4.tar.gz lxml @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/27/30/96/50e9d1ee1034017a8f9b7ade859cf27820ddfaba370ceb60caffacbeaa/lxml-4.9.1-cp38-cp38-win_amd64.whl MarkupSafe @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/d8/11/ad/312c5ad0ec37ff1f23c616c0055e9914932e944bd2a447fff8cc2aa317/MarkupSafe-2.1.1-cp38-cp38-win_amd64.whl matplotlib @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/36/bc/d6/71904e258a20c1708993f7f885c0d8a701e6c231f1a9e0db33d2dbaff2/matplotlib-3.5.3-cp38-cp38-win_amd64.whl matplotlib-inline @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/99/9e/a7/697624e74ebe7195097dbec4fe8bff67cf73c04390b69235ab5d6433b3/matplotlib_inline-0.1.3-py3-none-any.whl missingno @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/a1/1d/fc/6a2363fc627037e5dd7d6f55c79deccf174d4a9f6414b45edbdd5c5872/missingno-0.5.1-py3-none-any.whl mistune @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/d9/d8/5c/8eac14aaa95c3aa81409d56b7423ff6dd88eb398f551c1bf0b8c05b916/mistune-0.8.4-py2.py3-none-any.whl msgpack @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/a3/43/c9/4e64d3793ae48bc835db66a6014c74df65f0a791be6f0bb8a2d24679a8/msgpack-1.0.4-cp38-cp38-win_amd64.whl multimethod @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/6a/11/ae/ecac83a47392a0f6c001a5bfd23bbe5d8cdb2428981ef8223bddcb696f/multimethod-1.8-py3-none-any.whl mypy-extensions @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/b6/a0/b0/a5dc9acd6fd12aba308634f21bb7cf0571448f20848797d7ecb327aa12/mypy_extensions-0.4.3-py2.py3-none-any.whl nbclient @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/cc/07/a6/cc31e39d756acb773f004faa61ca5e192be3ee092745e676de9f862d10/nbclient-0.6.6-py3-none-any.whl nbconvert @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/bd/7b/f3/2b5a5a449cb99b87dd91526ddcab5678625e6de7a0856d58e7bbca69d7/nbconvert-6.5.3-py3-none-any.whl nbformat @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/7f/55/35/e6a72e112518ca33fa6e2da96ce9a95a1d9e1cb016e96e588bd916ae61/nbformat-5.4.0-py3-none-any.whl nest-asyncio @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/51/a8/46/70eaf0cb1ba8190f78ba507985de7e6ff3452acdd4376903e4f94a6a1f/nest_asyncio-1.5.5-py3-none-any.whl networkx @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/d1/98/e3/a5b4c92c26659577dd1b27db5563b94301fefb3b722ee754fa3c0379b0/networkx-2.8.5-py3-none-any.whl notebook @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/d4/52/e3/c901706e59e81191771bf3b4ba47aae5bfddf303f1ed8f88d51e526321/notebook-6.4.12-py3-none-any.whl numba @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/e5/0b/58/0c0fe7fd6428c0a12d30c1b185f01696e825189222a6cba487b0479bdf/numba-0.56.0-cp38-cp38-win_amd64.whl numpy @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/da/e5/43/c9f1c76937041a82d90adc798327606f154b0aaf34ff6b09392f852c01/numpy-1.21.6-cp38-cp38-win_amd64.whl nzpy @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/b7/f8/18/33135b31040c8b81129ec7881bf6cfe0ea880316b8f246b6475b43fe50/nzpy-1.15-py3-none-any.whl oauthlib @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/43/bc/3b/1a36adc390b3467c0225e7a3916302237d10f6277ce9186bfb214a88ea/oauthlib-3.2.0-py3-none-any.whl openpyxl @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/ef/ed/04/1267cefa422ffaa4d20b789af864ddd4905a6547126771445c1d89b4de/openpyxl-3.0.10-py2.py3-none-any.whl oscrypto @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/fa/09/ec/82e4d008b6f82f622a06957e77c24f7a56feba605e6421e945b46cc399/oscrypto-1.3.0-py2.py3-none-any.whl p2j @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/bb/cc/29/2d028d6c3788ede3027071f5a5722733a0df6d8837828f34c24cd82447/p2j-1.3.2-py3-none-any.whl packaging @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/7f/d5/4c/1d3c4776012fc0bbe1f86e69bde2c5e36d2d32caa2e4845ac1fc08ab3f/packaging-21.3-py3-none-any.whl pandas @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/b8/0b/c4/a599d2e4e6abc9a607daec90559d3f449aee5d959772409239387d6760/pandas-1.4.3-cp38-cp38-win_amd64.whl pandas-gbq @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/c6/f6/15/d4aa8436a8dee4d7d8def01fc53091de6484ccc0f92df91947ecaa44db/pandas_gbq-0.17.8-py2.py3-none-any.whl pandas-profiling @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/e3/ab/d0/e2e6c0e189c12659c67d777563c6d6413496429cfc19617353e2af1b6d/pandas_profiling-3.2.0-py2.py3-none-any.whl pandasql @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/93/5a/8a/847eb50977b39a8c4175c81748e0594793fd84f654d3398bba1bffe126/pandasql-0.7.3.tar.gz pandocfilters @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/a0/1a/aa/08b056cf02efdac22abd6440fea5dbb93be4fe8c9c1f33c6d6f8795de7/pandocfilters-1.5.0-py2.py3-none-any.whl parso @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/6a/f4/ea/0e13aa5b67a5bf677f3cdb783604966525a765034fe82747e81bfcb3a7/parso-0.8.3-py2.py3-none-any.whl pathspec @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/04/91/14/294ed2ee6c852b0d466bdd15d393127eff4168b35ae81cedf5a03fe348/pathspec-0.9.0-py2.py3-none-any.whl pathtools @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/db/27/0c/42fa00f22356328dc3bd6da21aae59384ad7f36690fe5ca5495586560f/pathtools-0.1.2.tar.gz patsy @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/2f/83/4f/b90b0cf3390e15237c17f52738e883fa9b154336962504fbbbbce2e73d/patsy-0.5.2-py2.py3-none-any.whl pefile @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/34/3e/8d/ce95fdf4c8007412ff7c9b9d794dbb2db1a66155527ce1ae39662f256d/pefile-2022.5.30.tar.gz phik @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/7a/c7/44/8271e3b6923a4e12a3ac96f11863b971db501e832cf94522093091390d/phik-0.12.2-cp38-cp38-win_amd64.whl pickleshare @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/27/b2/0a/93a92c700a1993b2923519262ddf76a629bd459a0597c0ae28bf80c7a6/pickleshare-0.7.5-py2.py3-none-any.whl Pillow @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/ca/47/60/9e1ddfa1474f814bd322de612edd24209faf5f5a2d05cc90695a9c33d6/Pillow-9.2.0-cp38-cp38-win_amd64.whl pkgutil_resolve_name @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/b6/24/83/d7863ebc54462770c1d46c1129ee935880eb88dc9dd4f3ecffb74dbaeb/pkgutil_resolve_name-1.3.10-py3-none-any.whl platformdirs @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/b5/2d/85/5731320d09aa7d79d5fe59f4499ce7adb2ef1a32312399e35a105d5229/platformdirs-2.5.2-py3-none-any.whl plotly @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/ef/8a/18/1489e1f6ca452f3710c4511bbd1bb4049559ae0c6c7b0e4e403f1e504f/plotly-5.5.0-py2.py3-none-any.whl pluggy @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/38/05/d7/70e2b0d553c780097b692ed658b0f553a28f16028d848a98174b1a2249/pluggy-1.0.0-py2.py3-none-any.whl prometheus-client @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/03/e7/ec/732d5385f02e64236dcd0a7c2341b0d6d885f8dbe4e5652d804fd2ad63/prometheus_client-0.14.1-py3-none-any.whl promise @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/0f/4f/91/54827555a9ce3597aca6d8a5ca3066e4cbdeb55dfc09e7dd69e113cec7/promise-2.3.tar.gz prompt-toolkit @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/19/b8/7a/a390ecec062bb04004353dfbe02d9ee571d4af9cfa1548538aa0e2a2cb/prompt_toolkit-3.0.30-py3-none-any.whl proto-plus @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/1b/9b/a3/2341bb05469b04dc8bfd9ec2a48259c4c130004b1aa6033c4520b5b210/proto_plus-1.22.0-py3-none-any.whl protobuf @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/3c/46/e0/7742b0b7627781e7066eb324e31f8ba232b9a164e68d140583660c957c/protobuf-3.20.1-cp38-cp38-win_amd64.whl psutil @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/1f/43/b1/45273fff47847356951133a9eb4f711cdba790cc8674b78621e3d3802b/psutil-5.9.1-cp38-cp38-win_amd64.whl py @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/ab/b4/c3/a3971fd0d6ab5a2e40a43ad7b809005422d7cf333f7be6ccdfe9002e1b/py-1.11.0-py2.py3-none-any.whl py2nb @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/2e/3f/ae/066fbb74878a5a28fca9a316d7b67d51e44987d5ea2f59470a7aa3bb4f/py2nb-1.0.0.tar.gz pyarrow @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/57/cf/a6/18ea0849fc042602a3845fb095a378d93364795c5cf21fe8630855d11f/pyarrow-6.0.1-cp38-cp38-win_amd64.whl pyasn1 @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/a6/f7/5e/59a43ec23ade0888631b3f24244da7f5d5a0b6b40849c86b8c6b4c54d1/pyasn1-0.4.8-py2.py3-none-any.whl pyasn1-modules @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/09/f6/56/0e33158234b3e9b9e5d8eb01e7a96670a99ab43b3dbe89b0f129477a59/pyasn1_modules-0.2.8-py2.py3-none-any.whl pycparser @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/7a/f7/3b/fd50e9d7e1c02d2d2e8631fca716f6b6ffe3742f322e4a170eb3f2f41b/pycparser-2.21-py2.py3-none-any.whl pycryptodomex @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/03/ed/cb/f19101e3bd22b1b2020f84018c0d072dd727a7b84f91cca590766a6114/pycryptodomex-3.15.0-cp35-abi3-win_amd64.whl pydantic @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/79/37/c0/f0399783287f6d5a77fe49fadf08e95014bb11d7636de3c779c450c913/pydantic-1.9.2-cp38-cp38-win_amd64.whl pydata-google-auth @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/e1/ef/8c/9a743c963a4a1b6301321706cc6569a0814afa373d57ba4052e082e4f2/pydata_google_auth-1.4.0-py2.py3-none-any.whl Pygments @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/50/ed/a0/a55a60598d9c638ef286c22b0dc2910531cd519a240f67840e1c6f92f5/Pygments-2.13.0-py3-none-any.whl pyinstaller @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/2d/6c/b0/e4f0b4a4c5c91b675b43332a52f5b4839e8c5f77911bf230091cb60cdb/pyinstaller-5.3-py3-none-win_amd64.whl pyinstaller-hooks-contrib @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/68/74/73/5cbb62c75e6acf800027cdb5cca34a6f8b6e2e358a76046ec4ae92b680/pyinstaller_hooks_contrib-2022.8-py2.py3-none-any. whl PyJWT @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/bf/ef/af/e0ee06850543fe58aad1584b2e49fc84d188cd3729e75502fe7aad9b96/PyJWT-2.4.0-py3-none-any.whl PyNomaly @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/96/2c/0d/36d6650716f8455253119470c33d0c07c98920b04839370bc7483790c3/PyNomaly-0.3.3.tar.gz pyodbc @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/ea/a7/75/71a5ad3bb6932623c1e1425132ff337f99e03e597f06af465ccffe790c/pyodbc-4.0.34-cp38-cp38-win_amd64.whl pyOpenSSL @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/54/33/bb/0c2669857467b4f12cfa13be72d2f62e03f84470e68079a116fb264999/pyOpenSSL-22.0.0-py2.py3-none-any.whl pyparsing @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/4a/b9/34/28557b740fb51bd635f6794a95d02e23de02724e07f03c3ad49cebcf86/pyparsing-3.0.9-py3-none-any.whl PyPika @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/82/fd/ae/5f1999c5ef986a09c2d78a9530fea2307c4ee77b24b84c23c2ff9f2e53/PyPika-0.48.9.tar.gz pyrsistent @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/c2/63/74/6e8fd4d3298141b35f247a85e2a18ded8c388202298015ddcdc37f787d/pyrsistent-0.18.1-cp38-cp38-win_amd64.whl pytest @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/90/e1/d5/985c1b371486cf5749ce1ec1beac04524dacb0642a52d916fd1aa82671/pytest-6.2.5-py3-none-any.whl python-crontab @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/5f/ba/e3/ec2f2bbaca6e6671a76109d24fd521f7f2b19ad5fb99d3c7a75790ba5b/python-crontab-2.6.0.tar.gz python-dateutil @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/0f/f1/e2/e1d3399cea26388e2ed5b93ea3e7c137d2b4027c5ba14c64ab839294ed/python_dateutil-2.8.2-py2.py3-none-any.whl python-utils @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/cf/ba/e4/24256fdc4fff786b7745d3abb86db2d97b5664eeeca276288012de6cfb/python_utils-3.3.3-py2.py3-none-any.whl pytz @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/b5/83/0e/d65ae350cfddb0d4a8d07e6daddca2bb66d64182a43074f43d1051f80c/pytz-2022.2.1-py2.py3-none-any.whl pytz-deprecation-shim @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/76/16/7b/4d1ca0f1ad2780cff55cac2a295ab01207736e7bf115be1a2a4a692ec6/pytz_deprecation_shim-0.1.0.post0-py2.py3-none-any.whl PyWavelets @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/bb/00/b0/66bacff811fb917fe292730ea89063d4030be30df2bdd178e73ceac3bf/PyWavelets-1.3.0-cp38-cp38-win_amd64.whl pywin32 @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/68/40/e8/c26fb29b167a5ea95ef4dc22f567c44b73d09a6afb4439e3d36a7495f1/pywin32-304-cp38-cp38-win_amd64.whl pywin32-ctypes @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/c4/57/86/cc8068e94d53318f6d13c4c1d21de585603bd9b276533dec8c51856528/pywin32_ctypes-0.2.0-py2.py3-none-any.whl pywinpty @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/16/5c/9a/0783238fddd48f31aecd49124dfe1d31c7c67bd3b3c414f1e9825b2470/pywinpty-2.0.7-cp38-none-win_amd64.whl PyYAML @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/f7/e8/05/c16a713e7ee8d7b7dff0acfe3bfd713a63078d60be83d2ebb0f09288c3/PyYAML-6.0-cp38-cp38-win_amd64.whl pyzmq @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/1b/91/35/e7f4017fa4a3c3f52f5212960d747f199930ae7a253f37d363974bdea3/pyzmq-23.2.1-cp38-cp38-win_amd64.whl qtconsole==5.3.1 QtPy==2.2.0 randomname @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/d6/ed/a2/be094bfbb95ee9781e5a871dbf4ee2742c87db879f16d9ec14a7d60fcf/randomname-0.1.5.tar.gz requests @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/73/b6/11/8a5136f9e1ac320567e50227250ded8bfa8942970419dd6c48eea64899/requests-2.28.1-py3-none-any.whl requests-oauthlib @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/7a/ca/bd/b98220e9fdd9fd3ceaf57892a8c53682dd8c516ac0d0815118c2a9a9d8/requests_oauthlib-1.3.1-py2.py3-none-any.whl rpy2 @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/8f/4d/03/d87739f5c479ec8ab6d2ece02659c2c58c81807a8b3c695bc1a9e78052/rpy2-3.5.3.tar.gz rsa @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/2b/1a/68/c6c12bebcb63cb60ed1a7670b2ab056e652f4dcab2229ba8aeb665a33d/rsa-4.9-py3-none-any.whl schedule @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/f2/b8/39/25f345c789afdcd83855065166e944820e52647f514136246e3f14fdc8/schedule-1.1.0-py2.py3-none-any.whl scikit-learn @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/40/56/37/c619a65aea66d73b8b4dc4d5c29b5595a23bd3082cea9e51e58db6964d/scikit_learn-1.1.2-cp38-cp38-win_amd64.whl scikit-plot @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/a2/1a/0a/58e1d542e9fa99db1f08123727643a92f7cb36dcf79593c1353c453d05/scikit_plot-0.3.7-py3-none-any.whl scipy @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/49/8e/c9/b6945e0b6ab19a3aae8a59d339969b560910bafe290227bcedb66c68df/scipy-1.8.1-cp38-cp38-win_amd64.whl scramp @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/10/4c/2c/09c7037f2480db00dffb8f41db1d7357acc187166915a1440f8771f52a/scramp-1.1.0-py3-none-any.whl seaborn @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/49/c9/44/e61a087050daed8338ae0e6af2f97df6010b8bc382e397edc10116b7be/seaborn-0.11.2-py3-none-any.whl Send2Trash @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/04/75/07/732af573e27a23b54c8ecd612eadc3725f0ce6428aee277184a4d0c780/Send2Trash-1.8.0-py3-none-any.whl sentry-sdk @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/5e/2a/56/7d6fd9641981021d3ada22587de30b3727d426ac9d2c5c6bf1c1b50ae6/sentry_sdk-1.9.5-py2.py3-none-any.whl setproctitle @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/98/51/f6/d788270b43f96a43234342fc49f460c21d2ec6bc9401267031b219d17d/setproctitle-1.3.2-cp38-cp38-win_amd64.whl setuptools-scm @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/e6/44/32/64b792477e12ac4db04f7195b7a5e9b011013d630ced2cc609ef1bbb27/setuptools_scm-6.4.2-py3-none-any.whl shap @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/8d/9d/ec/fcf20622249298128d465591f2f20da6757e4b756b65a574b766d2eab0/shap-0.39.0-cp38-cp38-win_amd64.whl shortuuid @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/b1/bf/95/cd8ae74ba8f3b1f736931c16ffce983065e88ca8b70e4a7a7c5e935be0/shortuuid-1.0.9-py3-none-any.whl six @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/48/e6/04/8118155ae3ec3a16dd2a213bbf7a7d8a62c596b2e90f73a22c896269f1/six-1.16.0-py2.py3-none-any.whl sktime @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/3a/2f/fa/a83c8f44b437ebc32734ba13a939bb282faede88caa3d6a5b9ace039b5/sktime-0.11.4-py3-none-any.whl slicer @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/13/7c/df/1c4053e5b79134286030ae6c7fd27cfe91a2592f7304b2496822046a73/slicer-0.0.7-py3-none-any.whl smmap @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/34/fa/bc/0bc422588046236494cd142256f75a2c2b4c0c5c5c9500cce5e886b75b/smmap-5.0.0-py3-none-any.whl snowflake-connector-python @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/b1/78/fd/370f323d6ca58d3988a951b03634ad42c92def7ec8136693adf9bd85c1/snowflake_connector_python-2.7.9-cp38-cp38-win_am d64.whl snowflake-sqlalchemy @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/9a/d1/e6/287a684c80ba48b53fc77910fc7b036d27f14a8e194a138b3362ba60c1/snowflake_sqlalchemy-1.4.0-py2.py3-none-any.whl
soupsieve @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/b4/47/4f/214202b36a5b60c4ab10c2fc16dc96b3ced1dd697a73871df11150ff41/soupsieve-2.3.2.post1-py3-none-any.whl SQLAlchemy @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/89/e8/03/c25b16861d01c025d69948dbd83d923908f1690cfcff7f00351460d98c/SQLAlchemy-1.4.40-cp38-cp38-win_amd64.whl sqlite-connector @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/bc/df/41/246f0d715af2d1acf2705c6bedd241b73885882158a06c77524c0f1f20/sqlite_connector-0.1.0-py3-none-any.whl sqlparse @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/bd/30/d0/940567a036c6ea57abe7098acbd123f8c8985ccc27713365ae80d28f89/sqlparse-0.4.2-py3-none-any.whl statsmodels @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/7f/ba/43/21e6680740cb7b567dabf9289caaacd42cb5168a0a3c6f0b6c5c908283/statsmodels-0.13.2-cp38-cp38-win_amd64.whl stopit @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/3d/ac/9a/a9c1fdda24440e22467c2b864f1ca124e584e86536009a3565e0c8203a/stopit-1.1.2.tar.gz tabulate @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/65/4b/69/80b67bdcfa4197b36a7a6fc03a403d14e60895dc4db7e65baefe1938c5/tabulate-0.8.10-py3-none-any.whl tangled-up-in-unicode @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/4c/f4/b7/57d068c6e15d19773b97aed578ed027ec5e493c817032224ed4408034f/tangled_up_in_unicode-0.2.0-py3-none-any.whl tenacity @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/44/71/21/397279f8fca199d048595a0942e6b22859b07f13d4e7496ddf932be65d/tenacity-8.0.1-py3-none-any.whl termcolor @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/33/6b/61/45ca85fe93f3295319a6eb1d6a8d2d449b6fa6d17c2ed2ec1810196a4a/termcolor-1.1.0.tar.gz terminado @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/28/00/7a/66e4952264f33a1d61a034346be7cc504ec56bf739c8042a2abaea798a/terminado-0.15.0-py3-none-any.whl threadpoolctl @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/fb/a0/f2/467222d3d5d3bbb11a035f84e7d45c68a472d14b113b73e6e2f94bf7bf/threadpoolctl-3.1.0-py3-none-any.whl tinycss2 @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/fb/5d/b3/cb0776067457d8d9a09666e07036bbe3a8fd792340da5f0f9cab979cee/tinycss2-1.1.1-py3-none-any.whl toml @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/9f/8c/c3/7b4f6778d60f3c9fa11f8fd0e48243bbad25a04975e0a01006b6350594/toml-0.10.2-py2.py3-none-any.whl tomli @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/36/bd/11/98fa2af866c73d00f2498ade62c7fcf28db8656714b7b7a44e9cb2f855/tomli-2.0.1-py3-none-any.whl tornado @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/a0/b4/94/566b74779d07f69a4685006c6127a4dc03c938533a6cde934badb51fe5/tornado-6.2-cp37-abi3-win_amd64.whl tqdm @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/0f/74/cd/a2ed528f2003187ed0adf3ad1f88faf43d991f72331e2c2f9c42766f24/tqdm-4.64.0-py2.py3-none-any.whl traitlets @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/60/1e/48/fa3bbbbe5bad6ef23ddd920e092507be7d67033fdfe8db2b40b377b3e0/traitlets-5.3.0-py3-none-any.whl typing_extensions @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/69/7e/7f/bd6599df2b6884385c80a4e64d8140b85cde607b3747b4fc324cb353aa/typing_extensions-4.3.0-py3-none-any.whl tzdata @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/2c/9f/9c/679c79f792ea1f989b15a1f426b1e2b9890b791db6060d353e9a0f5844/tzdata-2022.2-py2.py3-none-any.whl tzlocal @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/3e/22/a0/b45f7e19dba2244fd94ace8ad83ff546049b0a81a0658b9e137a741e3d/tzlocal-4.2-py3-none-any.whl unicode @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/57/f5/83/201ab450357b6038be490e4da5804cfac37db337c834d46a52a2d75ac9/unicode-2.9-py2.py3-none-any.whl Unidecode @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/cd/b2/72/1b4289ffb4b7d48a18678e9f5f16f6d80f5c5b0e2358fa50f87eeb8dd1/Unidecode-1.3.4-py3-none-any.whl update-checker @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/40/38/29/2363f38343c8cd3e585e8cf1c70ee13646bd816363d06f94c0ff75c74a/update_checker-0.18.0-py3-none-any.whl urllib3 @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/a6/3e/4b/91785d5c5fc776403a7bc46ce41b512c735200638748ff9d04c5a3c98e/urllib3-1.26.11-py2.py3-none-any.whl visions @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/b7/d9/08/5d2f94bb4aa7df34506216379e268f3670b8af18d0af5321f6fe1b7da7/visions-0.7.4-py3-none-any.whl wandb @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/3d/e1/fe/ea6ae64bc9dce00dfea1f538d56fb481a6f04b2056c58ca4c8b1fa7b02/wandb-0.12.21-py2.py3-none-any.whl wcwidth @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/36/68/e2/7232f431072d5e8aeec124120b9a1d095d45da10311d271fac10982473/wcwidth-0.2.5-py2.py3-none-any.whl webencodings @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/60/1e/b4/eff9915b6506bb01a5ad61dfae3fa4f0302be9e2ad45eaccc833925b95/webencodings-0.5.1-py2.py3-none-any.whl widgetsnbextension @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/c7/3d/05/d20f8b8b3be12d69241d5256c851e8204d466fb50d72e196e2301c1e0d/widgetsnbextension-3.6.1-py2.py3-none-any.whl wrapt @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/64/7b/2a/2bc74e5ef5d26076ba7ffafbc47d10fe40af3156a1326f4815aa085f3c/wrapt-1.14.1-cp38-cp38-win_amd64.whl xgboost @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/7a/c5/01/e68e229b1a0dad4660b163133724d5693a7205554cbbd79637f9dee604/xgboost-1.6.1-py3-none-win_amd64.whl zipp @ file:///C:/Users/gen06917/AppData/Local/pypoetry/Cache/artifacts/ef/71/dc/0e9422352b09eece487024896087a249c33de33e053fbb185ac7c3684d/zipp-3.8.1-py3-none-any.whl

  1. What did you do?

When I use the python-connector with pandas to_sql, I get :

DatabaseError: Execution failed on sql 'SELECT name FROM sqlite_master WHERE type='table' AND name=?;': not all arguments converted during string formatting

import snowflake
from snowflake import connector 

def connection(self):
    # TODO review: create the connection only once inside init and don't initialize object you don't use in run (use injection for that)
    return snowflake.connector.connect(
        user="xxxxx@ssss.com",
        account="ssq.canada-central.azure",
        authenticator="externalbrowser",
        database="xxxxxx",
        schema="xxxxx"
    )

con = connection()
df.columns = map(lambda x: unidecode.unidecode(str(x)).upper(), df.columns)
tbl_name = tbl_name.upper()
df.to_sql(name=tbl_name, con=con, if_exists=method, index=False)

TypeError Traceback (most recent call last) ~\PycharmProjects\mkt_closing\closing.venv\lib\site-packages\pandas\io\sql.py in execute(self, *args, *kwargs) 2019 try: -> 2020 cur.execute(args, **kwargs) 2021 return cur

~\PycharmProjects\mkt_closing\closing.venv\lib\site-packages\snowflake\connector\cursor.py in execute(self, command, params, _bind_stage, timeout, _exec_async, _no_retry, _do_reset, _put_callback, _put_azure_callback, _put_callback_output_stream, _get_callback, _get_azure_callback, _get_callback_output_stream, _show_progress_bar, _statement_params, _is_internal, _describe_only, _no_results, _is_put_get, _raise_put_get_error, _force_put_overwrite, file_stream) 675 ): --> 676 query = command % processed_params 677 else:

TypeError: not all arguments converted during string formatting

The above exception was the direct cause of the following exception:

DatabaseError Traceback (most recent call last) ~\AppData\Local\Temp\ipykernel_25668\595907315.py in <cell line: 11>() 9 tbl_name = 'TMP_ANALYSIS_TBL_UPTICK_IN_UNVERIFIED_CALLS' 10 ---> 11 query_processor.db_strategy['SNOWFLAKE'].save_table(res_df, tbl_name)

~\PycharmProjects\mkt_closing\etl_mkt\etl_mkt\query_processor.py in save_table(self, df, tbl_name) 94 95 def save_table(self, df: pd.DataFrame, tbl_name: str): ---> 96 self._save_table(df, tbl_name, method='replace') 97 98 def insert(self, df: pd.DataFrame, tbl_name: str):

~\PycharmProjects\mkt_closing\etl_mkt\etl_mkt\query_processor.py in _save_table(self, df, tbl_name, method) 91 # df = df.astype(str) 92 tbl_name = tbl_name.upper() ---> 93 df.to_sql(name=tbl_name, con=con, if_exists=method, index=False) 94 95 def save_table(self, df: pd.DataFrame, tbl_name: str):

~\PycharmProjects\mkt_closing\closing.venv\lib\site-packages\pandas\core\generic.py in to_sql(self, name, con, schema, if_exists, index, index_label, chunksize, dtype, method) 2949 from pandas.io import sql 2950 -> 2951 return sql.to_sql( 2952 self, 2953 name,

~\PycharmProjects\mkt_closing\closing.venv\lib\site-packages\pandas\io\sql.py in to_sql(frame, name, con, schema, if_exists, index, index_label, chunksize, dtype, method, engine, **engine_kwargs) 695 ) 696 --> 697 return pandas_sql.to_sql( 698 frame, 699 name,

~\PycharmProjects\mkt_closing\closing.venv\lib\site-packages\pandas\io\sql.py in to_sql(self, frame, name, if_exists, index, index_label, schema, chunksize, dtype, method, **kwargs) 2187 dtype=dtype, 2188 ) -> 2189 table.create() 2190 return table.insert(chunksize, method) 2191

~\PycharmProjects\mkt_closing\closing.venv\lib\site-packages\pandas\io\sql.py in create(self) 829 830 def create(self): --> 831 if self.exists(): 832 if self.if_exists == "fail": 833 raise ValueError(f"Table '{self.name}' already exists.")

~\PycharmProjects\mkt_closing\closing.venv\lib\site-packages\pandas\io\sql.py in exists(self) 813 814 def exists(self): --> 815 return self.pd_sql.has_table(self.name, self.schema) 816 817 def sql_schema(self):

~\PycharmProjects\mkt_closing\closing.venv\lib\site-packages\pandas\io\sql.py in has_table(self, name, schema) 2195 query = f"SELECT name FROM sqlite_master WHERE type='table' AND name={wld};" 2196 -> 2197 return len(self.execute(query, [name]).fetchall()) > 0 2198 2199 def get_table(self, table_name: str, schema: str | None = None):

~\PycharmProjects\mkt_closing\closing.venv\lib\site-packages\pandas\io\sql.py in execute(self, *args, **kwargs) 2030 2031 ex = DatabaseError(f"Execution failed on sql '{args[0]}': {exc}") -> 2032 raise ex from exc 2033 2034 @staticmethod

DatabaseError: Execution failed on sql 'SELECT name FROM sqlite_master WHERE type='table' AND name=?;': not all arguments converted during string formatting

5. What did you expect to see?

I expected to have my data saved in snowflake

shacker commented 1 year ago

I'm currently blocked by the same error in the same situation. Trying to do this without sqlalchemy as the docs say you no longer need it, but can't get it working natively.

sfc-gh-aalam commented 1 year ago

@shacker @Vaunorage could either one of you provide more details to reproduce the issue on my end. For example, add details on how to create the dataframe you are using, the columns and sample rows in your dataframe. What is the value you added for if_exists.

Also, have you tried to do this using snowflake-snowpark-python?