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

SNOW-1170204: Connection using $SNOWFLAKE_HOME/connections.toml doesn't work when session_parameters is passed #1889

Closed
cpcloud opened this issue Feb 28, 2024 · 2 comments

Comments

@cpcloud
Copy link

cpcloud commented Feb 28, 2024

Python version

Python 3.11.7 (main, Dec 4 2023, 18:10:11) [GCC 13.2.0]

Operating system and processor architecture

Linux-6.1.79-x86_64-with-glibc2.38

Installed packages

I'm not using pip, so here's the poetry export output:

Installed packages
❯ poetry export --extras all --with dev --with test --with docs --without-hashes --no-ansi
aiohttp==3.9.3 ; python_version >= "3.9" and python_version < "4.0"
aiosignal==1.3.1 ; python_version >= "3.9" and python_version < "4.0"
altair==5.2.0 ; python_version >= "3.10" and python_version < "3.13"
annotated-types==0.6.0 ; python_version >= "3.10" and python_version < "3.13"
anywidget==0.9.2 ; python_version >= "3.10" and python_version < "3.13"
appdirs==1.4.4 ; python_version >= "3.9" and python_version < "4.0"
appnope==0.1.4 ; python_version >= "3.10" and python_version < "3.13" and platform_system == "Darwin"
asn1crypto==1.5.1 ; python_version >= "3.9" and python_version < "4.0"
asttokens==2.4.1 ; python_version >= "3.9" and python_version < "4.0"
async-timeout==4.0.3 ; python_version >= "3.9" and python_version < "3.11"
atpublic==4.0 ; python_version >= "3.9" and python_version < "4.0"
attrs==23.2.0 ; python_version >= "3.9" and python_version < "4.0"
beartype==0.17.2 ; python_version >= "3.10" and python_version < "3.13"
beautifulsoup4==4.12.3 ; python_version >= "3.10" and python_version < "3.13"
bidict==0.23.1 ; python_version >= "3.9" and python_version < "4.0"
bitarray==2.9.2 ; python_version >= "3.9" and python_version < "4.0"
black==24.2.0 ; python_version >= "3.9" and python_version < "4.0"
bqplot==0.12.42 ; python_version >= "3.10" and python_version < "3.13"
branca==0.7.1 ; python_version >= "3.10" and python_version < "3.13"
build==1.0.3 ; python_version >= "3.9" and python_version < "4.0"
cachecontrol[filecache]==0.13.1 ; python_version >= "3.9" and python_version < "4.0"
cachetools==5.3.2 ; python_version >= "3.9" and python_version < "4.0"
certifi==2024.2.2 ; python_version >= "3.9" and python_version < "4.0"
cffi==1.16.0 ; python_version >= "3.9" and python_version < "4.0"
cfgv==3.4.0 ; python_version >= "3.9" and python_version < "4.0"
chardet==5.2.0 ; python_version >= "3.9" and python_version < "4.0"
charset-normalizer==3.3.2 ; python_version >= "3.9" and python_version < "4.0"
cleo==2.1.0 ; python_version >= "3.9" and python_version < "4.0"
click-plugins==1.1.1 ; python_version >= "3.9" and python_version < "4.0"
click==8.1.7 ; python_version >= "3.9" and python_version < "4.0"
clickhouse-connect[arrow,numpy,pandas]==0.7.0 ; python_version >= "3.9" and python_version < "4.0"
cligj==0.7.2 ; python_version >= "3.9" and python_version < "4"
cloudpickle==3.0.0 ; python_version >= "3.9" and python_version < "4.0"
codespell[hard-encoding-detection,toml]==2.2.6 ; python_version >= "3.9" and python_version < "4.0"
colorama==0.4.6 ; python_version >= "3.9" and python_version < "4.0" and (sys_platform == "win32" or platform_system == "Windows" or python_version >= "3.10" or os_name == "nt") and (sys_platform == "win32" or platform_system == "Windows" or os_name == "nt" or python_version < "3.13")
colour==0.1.5 ; python_version >= "3.10" and python_version < "3.13"
comm==0.2.1 ; python_version >= "3.10" and python_version < "3.13"
contourpy==1.2.0 ; python_version >= "3.10" and python_version < "3.13"
coverage[toml]==7.4.1 ; python_version >= "3.9" and python_version < "4.0"
crashtest==0.4.1 ; python_version >= "3.9" and python_version < "4.0"
cryptography==41.0.7 ; python_version >= "3.9" and python_version < "4.0"
cycler==0.12.1 ; python_version >= "3.10" and python_version < "3.13"
dask==2024.2.0 ; python_version >= "3.10" and python_version < "3.13"
dask[array,dataframe]==2024.2.0 ; python_version >= "3.9" and python_version < "4.0"
datafusion==35.0.0 ; python_version >= "3.9" and python_version < "4.0"
db-dtypes==1.2.0 ; python_version >= "3.9" and python_version < "4.0"
debugpy==1.8.1 ; python_version >= "3.10" and python_version < "3.13"
decorator==5.1.1 ; python_version >= "3.9" and python_version < "4.0"
deltalake==0.15.3 ; python_version >= "3.9" and python_version < "4.0"
distlib==0.3.8 ; python_version >= "3.9" and python_version < "4.0"
distributed==2024.2.0 ; python_version >= "3.10" and python_version < "3.13"
duckdb==0.9.2 ; python_version >= "3.9" and python_version < "4.0"
dulwich==0.21.7 ; python_version >= "3.9" and python_version < "4.0"
dunamai==1.19.2 ; python_version >= "3.9" and python_version < "4.0"
exceptiongroup==1.2.0 ; python_version >= "3.9" and python_version < "3.11"
execnet==2.0.2 ; python_version >= "3.9" and python_version < "4.0"
executing==2.0.1 ; python_version >= "3.9" and python_version < "4.0"
fastjsonschema==2.19.1 ; python_version >= "3.9" and python_version < "4.0"
filelock==3.13.1 ; python_version >= "3.9" and python_version < "4.0"
fiona==1.9.5 ; python_version >= "3.9" and python_version < "4.0"
folium==0.15.1 ; python_version >= "3.10" and python_version < "3.13"
fonttools==4.49.0 ; python_version >= "3.10" and python_version < "3.13"
frozenlist==1.4.1 ; python_version >= "3.9" and python_version < "4.0"
fsspec==2024.2.0 ; python_version >= "3.9" and python_version < "4.0"
gcsfs==2024.2.0 ; python_version >= "3.9" and python_version < "4.0"
gdown==5.1.0 ; python_version >= "3.10" and python_version < "3.13"
geojson==3.1.0 ; python_version >= "3.10" and python_version < "3.13"
geopandas==0.14.3 ; python_version >= "3.9" and python_version < "4.0"
google-api-core==2.17.1 ; python_version >= "3.9" and python_version < "4.0"
google-api-core[grpc]==2.17.1 ; python_version >= "3.9" and python_version < "4.0"
google-auth-oauthlib==1.2.0 ; python_version >= "3.9" and python_version < "4.0"
google-auth==2.28.0 ; python_version >= "3.9" and python_version < "4.0"
google-cloud-bigquery-storage==2.24.0 ; python_version >= "3.9" and python_version < "4.0"
google-cloud-bigquery==3.17.2 ; python_version >= "3.9" and python_version < "4.0"
google-cloud-core==2.4.1 ; python_version >= "3.9" and python_version < "4.0"
google-cloud-storage==2.14.0 ; python_version >= "3.9" and python_version < "4.0"
google-crc32c==1.5.0 ; python_version >= "3.9" and python_version < "4.0"
google-resumable-media==2.7.0 ; python_version >= "3.9" and python_version < "4.0"
googleapis-common-protos==1.62.0 ; python_version >= "3.9" and python_version < "4.0"
graphviz==0.20.1 ; python_version >= "3.9" and python_version < "4.0"
greenlet==3.0.3 ; python_version >= "3.9" and python_version < "4.0" and (platform_machine == "aarch64" or platform_machine == "ppc64le" or platform_machine == "x86_64" or platform_machine == "amd64" or platform_machine == "AMD64" or platform_machine == "win32" or platform_machine == "WIN32")
griffe==0.40.1 ; python_version >= "3.10" and python_version < "3.13"
grpcio-status==1.60.1 ; python_version >= "3.9" and python_version < "4.0"
grpcio==1.60.1 ; python_version >= "3.9" and python_version < "4.0"
humanize==4.9.0 ; python_version >= "3.9" and python_version < "4.0"
hypothesis==6.98.8 ; python_version >= "3.9" and python_version < "4.0"
identify==2.5.35 ; python_version >= "3.9" and python_version < "4.0"
idna==3.6 ; python_version >= "3.9" and python_version < "4.0"
importlib-metadata==7.0.1 ; python_version >= "3.9" and python_version < "4.0"
importlib-resources==6.1.1 ; python_version >= "3.9" and python_version < "4.0"
impyla==0.19.0 ; python_version >= "3.9" and python_version < "4.0"
iniconfig==2.0.0 ; python_version >= "3.9" and python_version < "4.0"
installer==0.7.0 ; python_version >= "3.9" and python_version < "4.0"
ipyevents==2.0.2 ; python_version >= "3.10" and python_version < "3.13"
ipyfilechooser==0.6.0 ; python_version >= "3.10" and python_version < "3.13"
ipykernel==6.29.2 ; python_version >= "3.10" and python_version < "3.13"
ipyleaflet==0.18.2 ; python_version >= "3.10" and python_version < "3.13"
ipython==8.18.1 ; python_version >= "3.9" and python_version < "4.0"
ipytree==0.2.2 ; python_version >= "3.10" and python_version < "3.13"
ipywidgets==8.1.2 ; python_version >= "3.10" and python_version < "3.13"
itables==1.6.4 ; python_version >= "3.10" and python_version < "3.13"
jaraco-classes==3.3.1 ; python_version >= "3.9" and python_version < "4.0"
jedi==0.19.1 ; python_version >= "3.9" and python_version < "4.0"
jeepney==0.8.0 ; python_version >= "3.9" and python_version < "4.0" and sys_platform == "linux"
jinja2==3.1.3 ; python_version >= "3.9" and python_version < "4.0"
joblib==1.3.2 ; python_version >= "3.9" and python_version < "4.0"
jsonschema-specifications==2023.12.1 ; python_version >= "3.10" and python_version < "3.13"
jsonschema==4.21.1 ; python_version >= "3.10" and python_version < "3.13"
jupyter-client==8.6.0 ; python_version >= "3.10" and python_version < "3.13"
jupyter-core==5.7.1 ; python_version >= "3.10" and python_version < "3.13"
jupyterlab-widgets==3.0.10 ; python_version >= "3.10" and python_version < "3.13"
keyring==24.3.0 ; python_version >= "3.9" and python_version < "4.0"
kiwisolver==1.4.5 ; python_version >= "3.10" and python_version < "3.13"
leafmap==0.31.2 ; python_version >= "3.10" and python_version < "3.13"
locket==1.0.0 ; python_version >= "3.9" and python_version < "4.0"
lonboard==0.6.0 ; python_version >= "3.10" and python_version < "3.13"
lz4==4.3.3 ; python_version >= "3.9" and python_version < "4.0"
markdown-it-py==3.0.0 ; python_version >= "3.9" and python_version < "4.0"
markupsafe==2.1.5 ; python_version >= "3.9" and python_version < "4.0"
matplotlib-inline==0.1.6 ; python_version >= "3.9" and python_version < "4.0"
matplotlib==3.8.3 ; python_version >= "3.10" and python_version < "3.13"
mdurl==0.1.2 ; python_version >= "3.9" and python_version < "4.0"
mizani==0.9.3 ; python_version >= "3.10" and python_version < "3.13"
more-itertools==10.2.0 ; python_version >= "3.9" and python_version < "4.0"
msgpack==1.0.7 ; python_version >= "3.9" and python_version < "4.0"
multidict==6.0.5 ; python_version >= "3.9" and python_version < "4.0"
mypy-extensions==1.0.0 ; python_version >= "3.9" and python_version < "4.0"
nbclient==0.9.0 ; python_version >= "3.10" and python_version < "3.13"
nbformat==5.9.2 ; python_version >= "3.10" and python_version < "3.13"
nest-asyncio==1.6.0 ; python_version >= "3.10" and python_version < "3.13"
nodeenv==1.8.0 ; python_version >= "3.9" and python_version < "4.0"
numpy==1.26.4 ; python_version >= "3.9" and python_version < "4.0"
oauthlib==3.2.2 ; python_version >= "3.9" and python_version < "4.0"
oracledb==2.0.1 ; python_version >= "3.9" and python_version < "4.0"
packaging==23.2 ; python_version >= "3.9" and python_version < "4.0"
palettable==3.3.3 ; python_version >= "3.10" and python_version < "3.13"
pandas==2.1.4 ; python_version >= "3.9" and python_version < "4.0"
parso==0.8.3 ; python_version >= "3.9" and python_version < "4.0"
parsy==2.1 ; python_version >= "3.9" and python_version < "4.0"
partd==1.4.1 ; python_version >= "3.9" and python_version < "4.0"
pathspec==0.12.1 ; python_version >= "3.9" and python_version < "4.0"
patsy==0.5.6 ; python_version >= "3.10" and python_version < "3.13"
pexpect==4.9.0 ; python_version >= "3.9" and python_version < "4.0"
pillow==10.2.0 ; python_version >= "3.10" and python_version < "3.13"
pins[gcs]==0.8.4 ; python_version >= "3.9" and python_version < "4.0"
pkginfo==1.9.6 ; python_version >= "3.9" and python_version < "4.0"
platformdirs==3.11.0 ; python_version >= "3.9" and python_version < "4.0"
plotly==5.19.0 ; python_version >= "3.10" and python_version < "3.13"
plotnine==0.12.4 ; python_version >= "3.10" and python_version < "3.13"
pluggy==1.4.0 ; python_version >= "3.9" and python_version < "4.0"
plum-dispatch==2.3.2 ; python_version >= "3.10" and python_version < "3.13"
poetry-core==1.8.1 ; python_version >= "3.9" and python_version < "4.0"
poetry-dynamic-versioning==1.2.0 ; python_version >= "3.9" and python_version < "4.0"
poetry-plugin-export==1.6.0 ; python_version >= "3.9" and python_version < "4.0"
poetry==1.7.1 ; python_version >= "3.9" and python_version < "4.0"
polars==0.20.10 ; python_version >= "3.9" and python_version < "4.0"
pprintpp==0.4.0 ; python_version >= "3.9" and python_version < "4.0"
pre-commit==3.6.2 ; python_version >= "3.9" and python_version < "4.0"
prompt-toolkit==3.0.43 ; python_version >= "3.9" and python_version < "4.0"
proto-plus==1.23.0 ; python_version >= "3.9" and python_version < "4.0"
protobuf==4.25.3 ; python_version >= "3.9" and python_version < "4.0"
psutil==5.9.8 ; python_version >= "3.10" and python_version < "3.13"
psycopg2==2.9.9 ; python_version >= "3.9" and python_version < "4.0"
psygnal==0.9.5 ; python_version >= "3.10" and python_version < "3.13"
ptyprocess==0.7.0 ; python_version >= "3.9" and python_version < "4.0"
pure-eval==0.2.2 ; python_version >= "3.9" and python_version < "4.0"
pure-sasl==0.6.2 ; python_version >= "3.9" and python_version < "4.0"
py-cpuinfo==9.0.0 ; python_version >= "3.9" and python_version < "4.0"
py4j==0.10.9.7 ; python_version >= "3.9" and python_version < "4.0"
pyarrow-hotfix==0.6 ; python_version >= "3.9" and python_version < "4.0"
pyarrow==15.0.0 ; python_version >= "3.9" and python_version < "4.0"
pyasn1-modules==0.3.0 ; python_version >= "3.9" and python_version < "4.0"
pyasn1==0.5.1 ; python_version >= "3.9" and python_version < "4"
pycparser==2.21 ; python_version >= "3.9" and python_version < "4.0"
pydantic-core==2.16.2 ; python_version >= "3.10" and python_version < "3.13"
pydantic==2.6.1 ; python_version >= "3.10" and python_version < "3.13"
pydata-google-auth==1.8.2 ; python_version >= "3.9" and python_version < "4.0"
pydeps==1.12.18 ; python_version >= "3.9" and python_version < "4.0"
pydruid[sqlalchemy]==0.6.6 ; python_version >= "3.9" and python_version < "4.0"
pyexasol[pandas]==0.25.2 ; python_version >= "3.9" and python_version < "4.0"
pygments==2.17.2 ; python_version >= "3.9" and python_version < "4.0"
pyinstrument==4.6.2 ; python_version >= "3.9" and python_version < "4.0"
pyjwt==2.8.0 ; python_version >= "3.9" and python_version < "4.0"
pymysql==1.1.0 ; python_version >= "3.9" and python_version < "4.0"
pyodbc==5.1.0 ; python_version >= "3.9" and python_version < "4.0"
pyopenssl==23.3.0 ; python_version >= "3.9" and python_version < "4.0"
pyparsing==3.1.1 ; python_version >= "3.10" and python_version < "3.13"
pyproj==3.6.1 ; python_version >= "3.9" and python_version < "4.0"
pyproject-hooks==1.0.0 ; python_version >= "3.9" and python_version < "4.0"
pyshp==2.3.1 ; python_version >= "3.10" and python_version < "3.13"
pysocks==1.7.1 ; python_version >= "3.10" and python_version < "3.13"
pyspark==3.5.0 ; python_version >= "3.9" and python_version < "4.0"
pystac-client==0.7.5 ; python_version >= "3.10" and python_version < "3.13"
pystac[validation]==1.9.0 ; python_version >= "3.10" and python_version < "3.13"
pytest-benchmark==4.0.0 ; python_version >= "3.9" and python_version < "4.0"
pytest-clarity==1.0.1 ; python_version >= "3.9" and python_version < "4.0"
pytest-cov==4.1.0 ; python_version >= "3.9" and python_version < "4.0"
pytest-httpserver==1.0.9 ; python_version >= "3.9" and python_version < "4.0"
pytest-mock==3.12.0 ; python_version >= "3.9" and python_version < "4.0"
pytest-randomly==3.15.0 ; python_version >= "3.9" and python_version < "4.0"
pytest-repeat==0.9.3 ; python_version >= "3.9" and python_version < "4.0"
pytest-snapshot==0.9.0 ; python_version >= "3.9" and python_version < "4.0"
pytest-xdist==3.5.0 ; python_version >= "3.9" and python_version < "4.0"
pytest==8.0.1 ; python_version >= "3.9" and python_version < "4.0"
python-box==7.1.1 ; python_version >= "3.10" and python_version < "3.13"
python-dateutil==2.8.2 ; python_version >= "3.9" and python_version < "4.0"
pytz==2024.1 ; python_version >= "3.9" and python_version < "4.0"
pywin32-ctypes==0.2.2 ; python_version >= "3.9" and python_version < "4.0" and sys_platform == "win32"
pywin32==306 ; sys_platform == "win32" and platform_python_implementation != "PyPy" and python_version >= "3.10" and python_version < "3.13"
pyyaml==6.0.1 ; python_version >= "3.9" and python_version < "4.0"
pyzmq==25.1.2 ; python_version >= "3.10" and python_version < "3.13"
quartodoc==0.7.2 ; python_version >= "3.10" and python_version < "3.13"
rapidfuzz==3.6.1 ; python_version >= "3.9" and python_version < "4.0"
referencing==0.33.0 ; python_version >= "3.10" and python_version < "3.13"
regex==2023.12.25 ; python_version >= "3.9" and python_version < "4.0"
requests-oauthlib==1.3.1 ; python_version >= "3.9" and python_version < "4.0"
requests-toolbelt==1.0.0 ; python_version >= "3.9" and python_version < "4.0"
requests==2.31.0 ; python_version >= "3.9" and python_version < "4.0"
requests[socks]==2.31.0 ; python_version >= "3.10" and python_version < "3.13"
rich==13.7.0 ; python_version >= "3.9" and python_version < "4.0"
rpds-py==0.18.0 ; python_version >= "3.10" and python_version < "3.13"
rsa==4.9 ; python_version >= "3.9" and python_version < "4"
ruff==0.2.2 ; python_version >= "3.9" and python_version < "4.0"
scikit-learn==1.4.1.post1 ; python_version >= "3.10" and python_version < "3.13"
scipy==1.12.0 ; python_version >= "3.10" and python_version < "3.13"
scooby==0.9.2 ; python_version >= "3.10" and python_version < "3.13"
seaborn==0.13.2 ; python_version >= "3.10" and python_version < "3.13"
secretstorage==3.3.3 ; python_version >= "3.9" and python_version < "4.0" and sys_platform == "linux"
setuptools==69.1.0 ; python_version >= "3.9" and python_version < "4.0"
shapely==2.0.3 ; python_version >= "3.9" and python_version < "4.0"
shellingham==1.5.4 ; python_version >= "3.9" and python_version < "4.0"
six==1.16.0 ; python_version >= "3.9" and python_version < "4.0"
snowflake-connector-python==3.7.0 ; python_version >= "3.9" and python_version < "4.0"
sortedcontainers==2.4.0 ; python_version >= "3.9" and python_version < "4.0"
soupsieve==2.5 ; python_version >= "3.10" and python_version < "3.13"
sphobjinv==2.3.1 ; python_version >= "3.10" and python_version < "3.13"
sqlalchemy==2.0.27 ; python_version >= "3.9" and python_version < "4.0"
sqlglot==20.11.0 ; python_version >= "3.9" and python_version < "4.0"
stack-data==0.6.3 ; python_version >= "3.9" and python_version < "4.0"
statsmodels==0.14.1 ; python_version >= "3.10" and python_version < "3.13"
stdlib-list==0.10.0 ; python_version >= "3.9" and python_version < "4.0"
tabulate==0.9.0 ; python_version >= "3.10" and python_version < "3.13"
tblib==3.0.0 ; python_version >= "3.10" and python_version < "3.13"
tenacity==8.2.3 ; python_version >= "3.10" and python_version < "3.13"
threadpoolctl==3.3.0 ; python_version >= "3.10" and python_version < "3.13"
thrift-sasl==0.4.3 ; python_version >= "3.9" and python_version < "4.0"
thrift==0.16.0 ; python_version >= "3.9" and python_version < "4.0"
tomli==2.0.1 ; python_version >= "3.9" and python_version < "4.0"
tomlkit==0.12.3 ; python_version >= "3.9" and python_version < "4.0"
toolz==0.12.1 ; python_version >= "3.9" and python_version < "4.0"
tornado==6.4 ; python_version >= "3.10" and python_version < "3.13"
tqdm==4.66.2 ; python_version >= "3.9" and python_version < "4.0"
traitlets==5.14.1 ; python_version >= "3.9" and python_version < "4.0"
traittypes==0.2.1 ; python_version >= "3.10" and python_version < "3.13"
trino==0.328.0 ; python_version >= "3.9" and python_version < "4.0"
trove-classifiers==2024.1.31 ; python_version >= "3.9" and python_version < "4.0"
typing-extensions==4.9.0 ; python_version >= "3.9" and python_version < "4.0"
tzdata==2024.1 ; python_version >= "3.9" and python_version < "4.0"
tzlocal==5.2 ; python_version >= "3.9" and python_version < "4.0"
urllib3==1.26.18 ; python_version >= "3.9" and python_version < "4.0"
virtualenv==20.25.0 ; python_version >= "3.9" and python_version < "4.0"
watchdog==4.0.0 ; python_version >= "3.10" and python_version < "3.13"
wcwidth==0.2.13 ; python_version >= "3.9" and python_version < "4.0"
websocket-client==1.7.0 ; python_version >= "3.9" and python_version < "4.0"
werkzeug==3.0.1 ; python_version >= "3.9" and python_version < "4.0"
whitebox==2.3.1 ; python_version >= "3.10" and python_version < "3.13"
whiteboxgui==2.3.0 ; python_version >= "3.10" and python_version < "3.13"
widgetsnbextension==4.0.10 ; python_version >= "3.10" and python_version < "3.13"
xattr==0.10.1 ; python_version >= "3.9" and python_version < "4.0" and sys_platform == "darwin"
xxhash==3.4.1 ; python_version >= "3.9" and python_version < "4.0"
xyzservices==2023.10.1 ; python_version >= "3.10" and python_version < "3.13"
yarl==1.9.4 ; python_version >= "3.9" and python_version < "4.0"
zict==3.0.0 ; python_version >= "3.10" and python_version < "3.13"
zipp==3.17.0 ; python_version >= "3.9" and python_version < "4.0"
zstandard==0.22.0 ; python_version >= "3.9" and python_version < "4.0"

What did you do?

In [1]: import snowflake.connector as sc

In [2]: con = sc.connect(session_parameters={"JSON_INDENT": 0})
...
ProgrammingError: 251005: User is empty

What did you expect to see?

The same thing I get when I don't pass session_parameters, which is no error:

In [3]: con = sc.connect()

In [4]:

Can you set logging to DEBUG and collect the logs?

In [12]: con = sc.connect(session_parameters={"JSON_INDENT": 0})
2024-02-28 12:59:43,869 - MainThread connection.py:386 - __init__() - INFO - Snowflake Connector for Python Version: 3.7.0, Python Version: 3.11.7, Platform: Linux-6.1.79-x86_64-with-glibc2.38
2024-02-28 12:59:43,870 - MainThread connection.py:681 - connect() - DEBUG - connect
2024-02-28 12:59:43,870 - MainThread connection.py:1060 - __config() - DEBUG - __config
...
ProgrammingError: 251005: 251005: User is empty
@github-actions github-actions bot changed the title Connection using SNOWFLAKE_HOME/connections.toml doesn't work when session_parameters is passed SNOW-1170204: Connection using SNOWFLAKE_HOME/connections.toml doesn't work when session_parameters is passed Feb 28, 2024
@cpcloud cpcloud changed the title SNOW-1170204: Connection using SNOWFLAKE_HOME/connections.toml doesn't work when session_parameters is passed SNOW-1170204: Connection using $SNOWFLAKE_HOME/connections.toml doesn't work when session_parameters is passed Feb 28, 2024
@sfc-gh-yixie
Copy link
Collaborator

@cpcloud you either need to pass all parameters to connect, or pass no parameter to use connections.toml.

@cpcloud
Copy link
Author

cpcloud commented Feb 29, 2024

Thanks, is that documented somewhere? Perhaps an error message to that effect would be a nice improvement.

@cpcloud cpcloud closed this as not planned Won't fix, can't repro, duplicate, stale Mar 5, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants