SNOW-2127911: Issue with initializing file based cache

[mwojcik321]

Python version

Python 3.11.12 (main, Apr 16 2025, 04:16:58) [GCC 11.4.0]

Operating system and processor architecture

Linux-6.10.14-linuxkit-aarch64-with-glibc2.35

Installed packages

agate @ file:///tmp/wheels/agate-1.9.1-py2.py3-none-any.whl#sha256=1cf329510b3dde07c4ad1740b7587c9c679abc3dcd92bb1107eabc10c2e03c50
annotated-types @ file:///tmp/wheels/annotated_types-0.7.0-py3-none-any.whl#sha256=1f02e8b43a8fbbc3f3e0d4f0f4bfc8131bcb4eebe8849b8e5c773f3a1c582a53
appdirs==1.4.4
asn1crypto @ file:///tmp/wheels/asn1crypto-1.5.1-py2.py3-none-any.whl#sha256=db4e40728b728508912cbb3d44f19ce188f218e9eba635821bb4b68564f8fd67
attrs @ file:///tmp/wheels/attrs-25.3.0-py3-none-any.whl#sha256=427318ce031701fea540783410126f03899a97ffc6f61596ad581ac2e40e3bc3
azure-core @ file:///tmp/wheels/azure_core-1.34.0-py3-none-any.whl#sha256=0615d3b756beccdb6624d1c0ae97284f38b78fb59a2a9839bf927c66fbbdddd6
azure-identity @ file:///tmp/wheels/azure_identity-1.23.0-py3-none-any.whl#sha256=dbbeb64b8e5eaa81c44c565f264b519ff2de7ff0e02271c49f3cb492762a50b0
azure-storage-blob @ file:///tmp/wheels/azure_storage_blob-12.25.1-py3-none-any.whl#sha256=1f337aab12e918ec3f1b638baada97550673911c4ceed892acc8e4e891b74167
babel @ file:///tmp/wheels/babel-2.17.0-py3-none-any.whl#sha256=4d0b53093fdfb4b21c92b5213dba5a1b23885afa8383709427046b21c366e5f2
backports.tarfile @ file:///tmp/wheels/backports.tarfile-1.2.0-py3-none-any.whl#sha256=77e284d754527b01fb1e6fa8a1afe577858ebe4e9dad8919e34c862cb399bc34
boto3 @ file:///tmp/wheels/boto3-1.38.20-py3-none-any.whl#sha256=0494bafa771561c02ae5926143ce69b6ee4017f11ced22d0293a8372acb7472a
botocore @ file:///tmp/wheels/botocore-1.38.20-py3-none-any.whl#sha256=70feba9b3f73946a9739d0c16703190d79379f065cf6e29883b5d7f791b247b8
cachetools @ file:///tmp/wheels/cachetools-5.5.2-py3-none-any.whl#sha256=d26a22bcc62eb95c3beabd9f1ee5e820d3d2704fe2967cbe350e20c8ffcd3f0a
certifi @ file:///tmp/wheels/certifi-2025.1.31-py3-none-any.whl#sha256=ca78db4565a652026a4db2bcdf68f2fb589ea80d0be70e03929ed730746b84fe
cffi @ file:///tmp/wheels/cffi-1.17.1-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl#sha256=a1ed2dd2972641495a3ec98445e09766f077aee98a1c896dcb4ad0d303628e41
chardet==5.2.0
charset-normalizer @ file:///tmp/wheels/charset_normalizer-3.4.2-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl#sha256=aa88ca0b1932e93f2d961bf3addbb2db902198dca337d88c89e1559e066e7645
click @ file:///tmp/wheels/click-8.2.1-py3-none-any.whl#sha256=61a3265b914e850b85317d0b3109c7f8cd35a670f963866005d6ef1d5175a12b
colorama @ file:///tmp/wheels/colorama-0.4.6-py2.py3-none-any.whl#sha256=4f1d9991f5acc0ca119f9d443620b77f9d6b33703e51011c16baf57afb285fc6
cryptography @ file:///tmp/wheels/cryptography-45.0.2-cp311-abi3-manylinux_2_34_aarch64.whl#sha256=b2de529027579e43b6dc1f805f467b102fb7d13c1e54c334f1403ee2b37d0059
daff @ file:///tmp/wheels/daff-1.4.2-py3-none-any.whl#sha256=88981a21d065e4378b5c4bd40b975dbfdea9b7ff540071f3bb5e20cc8b3590b5
dbt-adapters @ file:///tmp/wheels/dbt_adapters-1.15.3-py3-none-any.whl#sha256=8419db1ccb19de28791350aa17e96724ab5b73748e755e8ac73e5bc05c0150fc
dbt-common @ file:///tmp/wheels/dbt_common-1.25.0-py3-none-any.whl#sha256=857a206efccbe9754787f2b9baa9040ba1f1ddfd04168440224d3864e943251e
dbt-core @ file:///tmp/wheels/dbt_core-1.9.4-py3-none-any.whl#sha256=9af5e426a3d574b0c912e64f998f0d96d9ddddb768365c7fb4f6d12893210620
dbt-extractor @ file:///tmp/wheels/dbt_extractor-0.6.0-cp39-abi3-manylinux_2_17_aarch64.manylinux2014_aarch64.whl#sha256=af451633390ac19669d3bde6c79822e657d32f5d903b3388bb00d56333fd52d5
dbt-loom @ file:///tmp/wheels/dbt_loom-0.8.0-py3-none-any.whl#sha256=187b49d72c25edd392508739607301e81986c3f57c1b5c51bc8a9688b45a852e
dbt-meshify==0.5.5
dbt-protos @ file:///tmp/wheels/dbt_protos-1.0.305-py3-none-any.whl#sha256=24dad5ff5348286994a24486894928de5b1dffa7cb5e0a8bac7a502b1efc1cc3
dbt-semantic-interfaces @ file:///tmp/wheels/dbt_semantic_interfaces-0.7.4-py3-none-any.whl#sha256=63965478ef27056f20a8c9a0f59b1355ebbc15133c1a6f0d368d93996a31dd5d
dbt-snowflake @ file:///tmp/wheels/dbt_snowflake-1.9.4-py3-none-any.whl#sha256=baa8fc83091783cf9dd05f46f25318e3e7c564caaec54f96288dd963338939e4
deepdiff @ file:///tmp/wheels/deepdiff-7.0.1-py3-none-any.whl#sha256=447760081918216aa4fd4ca78a4b6a848b81307b2ea94c810255334b759e1dc3
diff_cover==9.3.1
distro==1.9.0
filelock @ file:///tmp/wheels/filelock-3.18.0-py3-none-any.whl#sha256=c401f4f8377c4464e6db25fff06205fd89bdd83b65eb0488ed1b160f780e21de
google-api-core @ file:///tmp/wheels/google_api_core-2.25.0rc1-py3-none-any.whl#sha256=9826900d88358ad3ac8978ad324e46793ad8137efe6d48ec51e259c0c40e3000
google-auth @ file:///tmp/wheels/google_auth-2.40.1-py2.py3-none-any.whl#sha256=ed4cae4f5c46b41bae1d19c036e06f6c371926e97b19e816fc854eff811974ee
google-cloud-core @ file:///tmp/wheels/google_cloud_core-2.4.3-py2.py3-none-any.whl#sha256=5130f9f4c14b4fafdff75c79448f9495cfade0d8775facf1b09c3bf67e027f6e
google-cloud-storage @ file:///tmp/wheels/google_cloud_storage-2.19.0-py2.py3-none-any.whl#sha256=aeb971b5c29cf8ab98445082cbfe7b161a1f48ed275822f59ed3f1524ea54fba
google-crc32c @ file:///tmp/wheels/google_crc32c-1.7.1-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl#sha256=ee6547b657621b6cbed3562ea7826c3e11cab01cd33b74e1f677690652883e77
google-resumable-media @ file:///tmp/wheels/google_resumable_media-2.7.2-py2.py3-none-any.whl#sha256=3ce7551e9fe6d99e9a126101d2536612bb73486721951e9562fee0f90c6ababa
googleapis-common-protos @ file:///tmp/wheels/googleapis_common_protos-1.70.0-py3-none-any.whl#sha256=b8bfcca8c25a2bb253e0e0b0adaf8c00773e5e6af6fd92397576680b807e0fd8
idna @ file:///tmp/wheels/idna-3.10-py3-none-any.whl#sha256=946d195a0d259cbba61165e88e65941f16e9b36ea6ddb97f00452bae8b1287d3
importlib-metadata @ file:///tmp/wheels/importlib_metadata-6.11.0-py3-none-any.whl#sha256=f0afba6205ad8f8947c7d338b5342d5db2afbfd82f9cbef7879a9539cc12eb9b
iniconfig==2.1.0
isodate @ file:///tmp/wheels/isodate-0.6.1-py2.py3-none-any.whl#sha256=0751eece944162659049d35f4f549ed815792b38793f07cf73381c1c87cbed96
jaraco.classes @ file:///tmp/wheels/jaraco.classes-3.4.0-py3-none-any.whl#sha256=f662826b6bed8cace05e7ff873ce0f9283b5c924470fe664fff1c2f00f581790
jaraco.context @ file:///tmp/wheels/jaraco.context-6.0.1-py3-none-any.whl#sha256=f797fc481b490edb305122c9181830a3a5b76d84ef6d1aef2fb9b47ab956f9e4
jaraco.functools @ file:///tmp/wheels/jaraco.functools-4.1.0-py3-none-any.whl#sha256=ad159f13428bc4acbf5541ad6dec511f91573b90fba04df61dafa2a1231cf649
jeepney @ file:///tmp/wheels/jeepney-0.9.0-py3-none-any.whl#sha256=97e5714520c16fc0a45695e5365a2e11b81ea79bba796e26f9f1d178cb182683
Jinja2 @ file:///tmp/wheels/jinja2-3.1.6-py3-none-any.whl#sha256=85ece4451f492d0c13c5dd7c13a64681a86afae63a5f347908daf103ce6d2f67
jinja2-simple-tags==0.6.1
jmespath @ file:///tmp/wheels/jmespath-1.0.1-py3-none-any.whl#sha256=02e2e4cc71b5bcab88332eebf907519190dd9e6e82107fa7f83b1003a6252980
jsonschema @ file:///tmp/wheels/jsonschema-4.23.0-py3-none-any.whl#sha256=fbadb6f8b144a8f8cf9f0b89ba94501d143e50411a1278633f56a7acf7fd5566
jsonschema-specifications @ file:///tmp/wheels/jsonschema_specifications-2025.4.1-py3-none-any.whl#sha256=4653bffbd6584f7de83a67e0d620ef16900b390ddc7939d56684d6c81e33f1af
keyring @ file:///tmp/wheels/keyring-25.6.0-py3-none-any.whl#sha256=552a3f7af126ece7ed5c89753650eec89c7eaae8617d0aa4d9ad2b75111266bd
leather @ file:///tmp/wheels/leather-0.4.0-py2.py3-none-any.whl#sha256=18290bc93749ae39039af5e31e871fcfad74d26c4c3ea28ea4f681f4571b3a2b
loguru==0.7.3
maison==2.0.0
MarkupSafe @ file:///tmp/wheels/MarkupSafe-3.0.2-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl#sha256=2cb8438c3cbb25e220c2ab33bb226559e7afb3baec11c4f218ffa7308603c832
mashumaro @ file:///tmp/wheels/mashumaro-3.14-py3-none-any.whl#sha256=c12a649599a8f7b1a0b35d18f12e678423c3066189f7bc7bd8dd431c5c8132c3
more-itertools @ file:///tmp/wheels/more_itertools-10.7.0-py3-none-any.whl#sha256=d43980384673cb07d2f7d2d918c616b30c659c089ee23953f601d6609c67510e
msal @ file:///tmp/wheels/msal-1.32.3-py3-none-any.whl#sha256=b2798db57760b1961b142f027ffb7c8169536bf77316e99a0df5c4aaebb11569
msal-extensions @ file:///tmp/wheels/msal_extensions-1.3.1-py3-none-any.whl#sha256=96d3de4d034504e969ac5e85bae8106c8373b5c6568e4c8fa7af2eca9dbe6bca
msgpack @ file:///tmp/wheels/msgpack-1.1.0-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl#sha256=8e59bca908d9ca0de3dc8684f21ebf9a690fe47b6be93236eb40b99af28b6ea6
networkx @ file:///tmp/wheels/networkx-3.4.2-py3-none-any.whl#sha256=df5d4365b724cf81b8c6a7312509d0c22386097011ad1abe274afd5e9d3bbc5f
numpy @ file:///tmp/wheels/numpy-2.2.6-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl#sha256=b64d8d4d17135e00c8e346e0a738deb17e754230d7e0810ac5012750bbd85a5a
ordered-set @ file:///tmp/wheels/ordered_set-4.1.0-py3-none-any.whl#sha256=046e1132c71fcf3330438a539928932caf51ddbc582496833e23de611de14562
packaging @ file:///tmp/wheels/packaging-25.0-py3-none-any.whl#sha256=29572ef2b1f17581046b3a2227d5c611fb25ec70ca1ba8554b24b0e69331a484
parsedatetime @ file:///tmp/wheels/parsedatetime-2.6-py3-none-any.whl#sha256=cb96edd7016872f58479e35879294258c71437195760746faffedb692aef000b
pathspec @ file:///tmp/wheels/pathspec-0.12.1-py3-none-any.whl#sha256=a0d503e138a4c123b27490a4f7beda6a01c6f288df0e4a8b79c7eb0dc7b4cc08
platformdirs @ file:///tmp/wheels/platformdirs-4.3.8-py3-none-any.whl#sha256=ff7059bb7eb1179e2685604f4aaf157cfd9535242bd23742eadc3c13542139b4
pluggy==1.6.0
proto-plus @ file:///tmp/wheels/proto_plus-1.26.1-py3-none-any.whl#sha256=13285478c2dcf2abb829db158e1047e2f1e8d63a077d94263c2b88b043c75a66
protobuf @ file:///tmp/wheels/protobuf-5.29.4-cp38-abi3-manylinux2014_aarch64.whl#sha256=aec4962f9ea93c431d5714ed1be1c93f13e1a8618e70035ba2b0564d9e633f2e
pyasn1 @ file:///tmp/wheels/pyasn1-0.6.1-py3-none-any.whl#sha256=0d632f46f2ba09143da3a8afe9e33fb6f92fa2320ab7e886e2d0f7672af84629
pyasn1_modules @ file:///tmp/wheels/pyasn1_modules-0.4.2-py3-none-any.whl#sha256=29253a9207ce32b64c3ac6600edc75368f98473906e8fd1043bd6b5b1de2c14a
pycparser @ file:///tmp/wheels/pycparser-2.22-py3-none-any.whl#sha256=c3702b6d3dd8c7abc1afa565d7e63d53a1d0bd86cdc24edd75470f4de499cfcc
pydantic @ file:///tmp/wheels/pydantic-2.11.4-py3-none-any.whl#sha256=d9615eaa9ac5a063471da949c8fc16376a84afb5024688b3ff885693506764eb
pydantic_core @ file:///tmp/wheels/pydantic_core-2.33.2-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl#sha256=dc46a01bf8d62f227d5ecee74178ffc448ff4e5197c756331f71efcc66dc980f
Pygments==2.19.1
PyJWT @ file:///tmp/wheels/PyJWT-2.10.1-py3-none-any.whl#sha256=dcdd193e30abefd5debf142f9adfcdd2b58004e644f25406ffaebd50bd98dacb
pyOpenSSL @ file:///tmp/wheels/pyopenssl-25.1.0-py3-none-any.whl#sha256=2b11f239acc47ac2e5aca04fd7fa829800aeee22a2eb30d744572a157bd8a1ab
pytest==8.3.5
python-dateutil @ file:///tmp/wheels/python_dateutil-2.9.0.post0-py2.py3-none-any.whl#sha256=a8b2bc7bffae282281c8140a97d3aa9c14da0b136dfe83f850eea9a5f7470427
python-slugify @ file:///tmp/wheels/python_slugify-8.0.4-py2.py3-none-any.whl#sha256=276540b79961052b66b7d116620b36518847f52d5fd9e3a70164fc8c50faa6b8
pytimeparse @ file:///tmp/wheels/pytimeparse-1.1.8-py2.py3-none-any.whl#sha256=04b7be6cc8bd9f5647a6325444926c3ac34ee6bc7e69da4367ba282f076036bd
pytz @ file:///tmp/wheels/pytz-2025.2-py2.py3-none-any.whl#sha256=5ddf76296dd8c44c26eb8f4b6f35488f3ccbf6fbbd7adee0b7262d43f0ec2f00
PyYAML @ file:///tmp/wheels/PyYAML-6.0.2-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl#sha256=5d225db5a45f21e78dd9358e58a98702a0302f2659a3c6cd320564b75b86f47c
referencing @ file:///tmp/wheels/referencing-0.36.2-py3-none-any.whl#sha256=e8699adbbf8b5c7de96d8ffa0eb5c158b3beafce084968e2ea8bb08c6794dcd0
regex==2024.11.6
requests @ file:///tmp/wheels/requests-2.32.3-py3-none-any.whl#sha256=70761cfe03c773ceb22aa2f671b4757976145175cdfca038c02654d061d6dcc6
rpds-py @ file:///tmp/wheels/rpds_py-0.25.1-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl#sha256=d4ca54b9cf9d80b4016a67a0193ebe0bcf29f6b0a96f09db942087e294d3d4c2
rsa @ file:///tmp/wheels/rsa-4.9.1-py3-none-any.whl#sha256=68635866661c6836b8d39430f97a996acbd61bfa49406748ea243539fe239762
ruamel.yaml==0.17.40
ruamel.yaml.clib==0.2.12
ruyaml==0.91.0
s3transfer @ file:///tmp/wheels/s3transfer-0.12.0-py3-none-any.whl#sha256=35b314d7d82865756edab59f7baebc6b477189e6ab4c53050e28c1de4d9cce18
SecretStorage @ file:///tmp/wheels/SecretStorage-3.3.3-py3-none-any.whl#sha256=f356e6628222568e3af06f2eba8df495efa13b3b63081dafd4f7d9a7b7bc9f99
six @ file:///tmp/wheels/six-1.17.0-py2.py3-none-any.whl#sha256=4721f391ed90541fddacab5acf947aa0d3dc7d27b2e1e8eda2be8970586c3274
snowflake-connector-python @ file:///tmp/wheels/snowflake_connector_python-3.15.0-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl#sha256=9dbd35265af54ad045cadbed5bfbc76816d2e4d95902f3312365d54c08a33ec3
snowplow-tracker @ file:///tmp/wheels/snowplow_tracker-1.1.0-py3-none-any.whl#sha256=24ea32ddac9cca547421bf9ab162f5f33c00711c6ef118ad5f78093cee962224
sortedcontainers @ file:///tmp/wheels/sortedcontainers-2.4.0-py2.py3-none-any.whl#sha256=a163dcaede0f1c021485e957a39245190e74249897e2ae4b2aa38595db237ee0
sqlfluff==3.2.5
sqlfluff-templater-dbt==3.2.5
sqlglot==25.34.1
sqlparse @ file:///tmp/wheels/sqlparse-0.5.3-py3-none-any.whl#sha256=cf2196ed3418f3ba5de6af7e82c694a9fbdbfecccdfc72e281548517081f16ca
tblib==3.1.0
text-unidecode @ file:///tmp/wheels/text_unidecode-1.3-py2.py3-none-any.whl#sha256=1311f10e8b895935241623731c2ba64f4c455287888b18189350b67134a822e8
toml==0.10.2
tomlkit @ file:///tmp/wheels/tomlkit-0.13.2-py3-none-any.whl#sha256=7a974427f6e119197f670fbbbeae7bef749a6c14e793db934baefc1b5f03efde
tqdm==4.67.1
types-networkx @ file:///tmp/wheels/types_networkx-3.4.2.20250515-py3-none-any.whl#sha256=3cbed973948448efc713550956fc21aa423d85e4419d96b14c4fcfbbe7953a9c
types-PyYAML @ file:///tmp/wheels/types_pyyaml-6.0.12.20250516-py3-none-any.whl#sha256=8478208feaeb53a34cb5d970c56a7cd76b72659442e733e268a94dc72b2d0530
typing-inspection @ file:///tmp/wheels/typing_inspection-0.4.0-py3-none-any.whl#sha256=50e72559fcd2a6367a19f7a7e610e6afcb9fac940c650290eed893d61386832f
typing_extensions @ file:///tmp/wheels/typing_extensions-4.13.2-py3-none-any.whl#sha256=a439e7c04b49fec3e5d3e2beaa21755cadbbdc391694e28ccdd36ca4a1408f8c
urllib3 @ file:///tmp/wheels/urllib3-2.4.0-py3-none-any.whl#sha256=4e16665048960a0900c702d4a66415956a584919c03361cac9f1df5c5dd7e813
yamlfix==1.17.0
zipp @ file:///tmp/wheels/zipp-3.21.0-py3-none-any.whl#sha256=ac1bbe05fd2991f160ebce24ffbac5f6d11d83dc90891255885223d42b3cd931

What did you do?

import snowflake.connector

con = snowflake.connector.connect(
    user='XXXX',
    authenticator="externalbrowser",
    account='XXXX',
    warehouse="XXXX",
    database="XXXX",
    schema="XXXX",
    client_store_temporary_credential=True
)

What did you expect to see?

When running the script for the first time, I expect it to open a new browser tab for authentication, complete the authentication process, and then execute successfully. On subsequent executions, the script should not open a new tab because the authentication should be cached. However, what we are currently experiencing is:

Warning: Failed to initialize file based token cache. You might experience multiple authentication pop ups while using ExternalBrowser/OAuth/MFA Authenticator.

The issue was first observed when running dbt within a Docker container. It can also be reproduced using the provided script. This problem does not occur in previous versions (tested with 3.14.0).

Can you set logging to DEBUG and collect the logs?

import logging
import os

for logger_name in ('snowflake.connector',):
    logger = logging.getLogger(logger_name)
    logger.setLevel(logging.DEBUG)
    ch = logging.StreamHandler()
    ch.setLevel(logging.DEBUG)
    ch.setFormatter(logging.Formatter('%(asctime)s - %(threadName)s %(filename)s:%(lineno)d - %(funcName)s() - %(levelname)s - %(message)s'))
    logger.addHandler(ch)

[sfc-gh-sghosh]

Hello @mwojcik321 ,

Thanks for raising the issue, we will work on eliminating it.

Regards,
Sujan

[barberadam]

It looks like the issue is this line introduced in this PR

The directory/file is created with 0o755 but this check is too strict.

Edit: We've currently worked around it by creating ~/.cache/snowflake with 700, but the check should probably be updated.

[amodig]

The above workaround doesn't seem to work with more complex setups, as the ownership is also checked. E.g. in JupyterHub with user namespace remapping:

• os.getuid() returns 1000
• Created directories are owned by UID 50006 (mapped UID)
• In the Snowflake connector logs: 2025-07-09 12:05:43,087 - snowflake.connector.token_cache - DEBUG - Cache directory validation failed for /home/jovyan/.cache/snowflake due to error 'Cache dir /home/jovyan/.cache/snowflake has incorrect owner. 1000 != 50006'. Skipping it in cache directory lookup.

This makes token caching impossible in environments with UID namespace remapping

[mrj0]

I have the same problem as well in a coder pod running in kubernetes. My ~/.cache/snowflake directory got the group special bit set somehow on a clean install. I didn't do that. 🤷

fixed:

chmod g-s ~/.cache/snowflake/

This error should at best be a warning and the cache used if it's readable. Or, less awesome, the cache permissions check needs an option to disable it. The token existing on the filesystem with wider permissions may or may not be a problem, but refusing to use the valid cached token doesn't increase security.