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

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

snowflakedb / snowflake-connector-python