Streamlit Cloud - "We were unable to open a browser window for you"

Streamlit and Snowflake
1

Hello,

Log is attached below. I am successful running my python script with the external browser authenticator on local machine using the command streamlit run pythonapplication2.py

I run into this issue when deploying this to the cloud. It appears the external browser authentication is running into an issue. And when I copy paste that path to the browser it tells me “localhost cannot be reached”. And even if I could get a link like the logs ask I did not see a way to paste it into a terminal. Any help is appreciated. Thanks!

[ UTC ] Logs for https://noahelliottph-test-test-4zqba7.streamlitapp.com/
────────────────────────────────────────────────────────────────────────────────────────
[21:05:42] :desktop_computer: Provisioning machine…
[21:05:48] :control_knobs: Preparing system…
[21:05:53] :chains: Spinning up manager process…
[21:06:00] :balloon: Inflating balloons…
[21:06:07] :open_book: Unpacking Comic Sans RAR files…
[21:06:06] :rocket: Starting up repository: ‘streamlitph’, branch: ‘main’, main module: ‘PythonApplication2.py’
[21:06:06] :octopus: Cloning repository…
[21:06:07] :octopus: Cloning into ‘/app/streamlitph’…

[21:06:07] :octopus: Cloned repository!
[21:06:07] :octopus: Pulling code changes from Github…
[21:06:08] :package: Processing dependencies…

──────────────────────────────────────── pip ───────────────────────────────────────────

Collecting asn1crypto==1.5.1
Downloading asn1crypto-1.5.1-py2.py3-none-any.whl (105 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 105.0/105.0 KB 6.5 MB/s eta 0:00:00[2022-10-11 21:06:09.568929]
Collecting certifi==2022.6.15
Downloading certifi-2022.6.15-py3-none-any.whl (160 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 160.2/160.2 KB 24.0 MB/s eta 0:00:00[2022-10-11 21:06:09.619863]
Collecting cffi==1.15.0
Downloading cffi-1.15.0-cp38-cp38-manylinux_2_12_x86_64.manylinux2010_x86_64.whl (446 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 446.7/446.7 KB 58.2 MB/s eta 0:00:00[2022-10-11 21:06:09.851978]
Collecting charset-normalizer==2.0.12
Downloading charset_normalizer-2.0.12-py3-none-any.whl (39 kB)
Collecting cryptography==36.0.2
Downloading cryptography-36.0.2-cp36-abi3-manylinux_2_24_x86_64.whl (3.6 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 3.6/3.6 MB 188.0 MB/s eta 0:00:00[2022-10-11 21:06:10.226612]
Collecting idna==3.3
Downloading idna-3.3-py3-none-any.whl (61 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 61.2/61.2 KB 242.1 MB/s eta 0:00:00[2022-10-11 21:06:10.266353]
Collecting oscrypto==1.3.0
Downloading oscrypto-1.3.0-py2.py3-none-any.whl (194 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 194.6/194.6 KB 276.5 MB/s eta 0:00:00[2022-10-11 21:06:10.305040]
Collecting pycparser==2.21
Downloading pycparser-2.21-py2.py3-none-any.whl (118 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 118.7/118.7 KB 243.4 MB/s eta 0:00:00[2022-10-11 21:06:10.337956]
Collecting pycryptodomex==3.15.0
Downloading pycryptodomex-3.15.0-cp35-abi3-manylinux2010_x86_64.whl (2.3 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2.3/2.3 MB 174.1 MB/s eta 0:00:00[2022-10-11 21:06:10.532356]
Collecting PyJWT==2.4.0
Downloading PyJWT-2.4.0-py3-none-any.whl (18 kB)
Collecting pyOpenSSL==22.0.0
Downloading pyOpenSSL-22.0.0-py2.py3-none-any.whl (55 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 55.8/55.8 KB 173.5 MB/s eta 0:00:00[2022-10-11 21:06:10.616047]
Collecting pytz==2022.1
Downloading pytz-2022.1-py2.py3-none-any.whl (503 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 503.5/503.5 KB 274.9 MB/s eta 0:00:00[2022-10-11 21:06:10.705766]
Collecting requests==2.28.0
Downloading requests-2.28.0-py3-none-any.whl (62 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 62.8/62.8 KB 175.3 MB/s eta 0:00:00[2022-10-11 21:06:10.770976]
Collecting urllib3==1.26.9
Downloading urllib3-1.26.9-py2.py3-none-any.whl (138 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 139.0/139.0 KB 241.8 MB/s eta 0:00:00[2022-10-11 21:06:10.829283]
Collecting snowflake-connector-python==2.7.9
Downloading snowflake_connector_python-2.7.9-cp38-cp38-manylinux_2_12_x86_64.manylinux2010_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl (16.5 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 16.5/16.5 MB 219.4 MB/s eta 0:00:00[2022-10-11 21:06:11.085392]
Collecting snowflake-snowpark-python
Downloading snowflake_snowpark_python-0.11.0-py3-none-any.whl (245 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 245.4/245.4 KB 265.5 MB/s eta 0:00:00[2022-10-11 21:06:11.198304]
Collecting setuptools>34.0.0
Downloading setuptools-65.4.1-py3-none-any.whl (1.2 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.2/1.2 MB 267.6 MB/s eta 0:00:00[2022-10-11 21:06:11.648338]
Collecting wheel
Downloading wheel-0.37.1-py2.py3-none-any.whl (35 kB)
Collecting typing-extensions>=4.1.0
Downloading typing_extensions-4.4.0-py3-none-any.whl (26 kB)
Collecting snowflake-snowpark-python
Downloading snowflake_snowpark_python-0.10.0-py3-none-any.whl (233 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 233.4/233.4 KB 258.1 MB/s eta 0:00:00[2022-10-11 21:06:11.780641]
Downloading snowflake_snowpark_python-0.9.0-py3-none-any.whl (224 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 224.1/224.1 KB 260.9 MB/s eta 0:00:00[2022-10-11 21:06:11.811201]
Downloading snowflake_snowpark_python-0.8.0-py3-none-any.whl (212 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 212.7/212.7 KB 266.6 MB/s eta 0:00:00[2022-10-11 21:06:11.852962]
Collecting cloudpickle<=2.0.0,>=1.6.0
Downloading cloudpickle-2.0.0-py3-none-any.whl (25 kB)
Installing collected packages: pytz, asn1crypto, wheel, urllib3, typing-extensions, setuptools, PyJWT, pycryptodomex, pycparser, oscrypto, idna, cloudpickle, charset-normalizer, certifi, requests, cffi, cryptography, pyOpenSSL, snowflake-connector-python, snowflake-snowpark-python
Attempting uninstall: wheel
Found existing installation: wheel 0.37.1
Uninstalling wheel-0.37.1:
Successfully uninstalled wheel-0.37.1
Attempting uninstall: setuptools
Found existing installation: setuptools 65.3.0
Uninstalling setuptools-65.3.0:
Successfully uninstalled setuptools-65.3.0
Successfully installed PyJWT-2.4.0 asn1crypto-1.5.1 certifi-2022.6.15 cffi-1.15.0 charset-normalizer-2.0.12 cloudpickle-2.0.0 cryptography-36.0.2 idna-3.3 oscrypto-1.3.0 pyOpenSSL-22.0.0 pycparser-2.21 pycryptodomex-3.15.0 pytz-2022.1 requests-2.28.0 setuptools-65.4.1 snowflake-connector-python-2.7.9 snowflake-snowpark-python-0.8.0 typing-extensions-4.4.0 urllib3-1.26.9 wheel-0.37.1
WARNING: You are using pip version 22.0.3; however, version 22.2.2 is available.
You should consider upgrading via the ‘/home/appuser/venv/bin/python -m pip install --upgrade pip’ command.
Checking if Streamlit is installed

────────────────────────────────────────────────────────────────────────────────────────

[21:06:15] :snake: Python dependencies were installed from /app/streamlitph/requirements.txt using pip.
Check if streamlit is installed

──────────────────────────────── Installing Streamlit ──────────────────────────────────

Collecting streamlit
Downloading streamlit-1.13.0-py2.py3-none-any.whl (9.2 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 9.2/9.2 MB 124.8 MB/s eta 0:00:00[2022-10-11 21:06:16.317782]
Collecting cachetools>=4.0
Downloading cachetools-5.2.0-py3-none-any.whl (9.3 kB)
Collecting tzlocal>=1.1
Downloading tzlocal-4.2-py3-none-any.whl (19 kB)
Collecting click>=7.0
Downloading click-8.1.3-py3-none-any.whl (96 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 96.6/96.6 KB 219.7 MB/s eta 0:00:00[2022-10-11 21:06:16.464045]
Collecting packaging>=14.1
Downloading packaging-21.3-py3-none-any.whl (40 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 40.8/40.8 KB 45.8 MB/s eta 0:00:00[2022-10-11 21:06:16.514359]
Collecting pyarrow>=4.0
Downloading pyarrow-9.0.0-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (35.3 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 35.3/35.3 MB 231.4 MB/s eta 0:00:00[2022-10-11 21:06:16.810246]
Collecting importlib-metadata>=1.4
Downloading importlib_metadata-5.0.0-py3-none-any.whl (21 kB)
Collecting gitpython!=3.1.19
Downloading GitPython-3.1.29-py3-none-any.whl (182 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 182.5/182.5 KB 231.1 MB/s eta 0:00:00[2022-10-11 21:06:16.998499]
Collecting validators>=0.2
Downloading validators-0.20.0.tar.gz (30 kB)
Preparing metadata (setup.py): started
Preparing metadata (setup.py): finished with status ‘done’
Collecting typing-extensions>=3.10.0.0
Downloading typing_extensions-4.4.0-py3-none-any.whl (26 kB)
Collecting altair>=3.2.0
Downloading altair-4.2.0-py3-none-any.whl (812 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 812.8/812.8 KB 283.0 MB/s eta 0:00:00[2022-10-11 21:06:17.363355]
Collecting tornado>=5.0
Downloading tornado-6.2-cp37-abi3-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl (423 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 424.0/424.0 KB 285.2 MB/s eta 0:00:00[2022-10-11 21:06:17.445804]
Collecting pympler>=0.9
Downloading Pympler-1.0.1-py3-none-any.whl (164 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 164.8/164.8 KB 241.1 MB/s eta 0:00:00[2022-10-11 21:06:17.482893]
Collecting semver
Downloading semver-2.13.0-py2.py3-none-any.whl (12 kB)
Collecting numpy
Downloading numpy-1.23.3-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (17.1 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 17.1/17.1 MB 238.8 MB/s eta 0:00:00[2022-10-11 21:06:17.973832]
Collecting python-dateutil
Downloading python_dateutil-2.8.2-py2.py3-none-any.whl (247 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 247.7/247.7 KB 264.7 MB/s eta 0:00:00[2022-10-11 21:06:18.034362]
Collecting pydeck>=0.1.dev5
Downloading pydeck-0.8.0b3-py2.py3-none-any.whl (4.7 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 4.7/4.7 MB 260.7 MB/s eta 0:00:00[2022-10-11 21:06:18.098280]
Collecting pillow>=6.2.0
Downloading Pillow-9.2.0-cp38-cp38-manylinux_2_28_x86_64.whl (3.2 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 3.2/3.2 MB 232.0 MB/s eta 0:00:00[2022-10-11 21:06:18.444238]
Collecting requests>=2.4
Downloading requests-2.28.1-py3-none-any.whl (62 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 62.8/62.8 KB 187.0 MB/s eta 0:00:00[2022-10-11 21:06:18.516311]
Collecting pandas>=0.21.0
Downloading pandas-1.5.0-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (12.2 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 12.2/12.2 MB 242.6 MB/s eta 0:00:00[2022-10-11 21:06:18.788501]
Collecting toml
Downloading toml-0.10.2-py2.py3-none-any.whl (16 kB)
Collecting protobuf!=3.20.2,<4,>=3.12
Downloading protobuf-3.20.3-cp38-cp38-manylinux_2_5_x86_64.manylinux1_x86_64.whl (1.0 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.0/1.0 MB 268.4 MB/s eta 0:00:00[2022-10-11 21:06:19.145910]
Collecting blinker>=1.0.0
Downloading blinker-1.5-py2.py3-none-any.whl (12 kB)
Collecting watchdog
Downloading watchdog-2.1.9-py3-none-manylinux2014_x86_64.whl (78 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 78.4/78.4 KB 230.8 MB/s eta 0:00:00[2022-10-11 21:06:19.260618]
Collecting rich>=10.11.0
Downloading rich-12.6.0-py3-none-any.whl (237 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 237.5/237.5 KB 259.7 MB/s eta 0:00:00[2022-10-11 21:06:19.375895]
Collecting jsonschema>=3.0
Downloading jsonschema-4.16.0-py3-none-any.whl (83 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 83.1/83.1 KB 236.6 MB/s eta 0:00:00[2022-10-11 21:06:19.445461]
Collecting entrypoints
Downloading entrypoints-0.4-py3-none-any.whl (5.3 kB)
Collecting jinja2
Downloading Jinja2-3.1.2-py3-none-any.whl (133 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 133.1/133.1 KB 250.8 MB/s eta 0:00:00[2022-10-11 21:06:19.518159]
Collecting toolz
Downloading toolz-0.12.0-py3-none-any.whl (55 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 55.8/55.8 KB 218.7 MB/s eta 0:00:00[2022-10-11 21:06:19.558749]
Collecting gitdb<5,>=4.0.1
Downloading gitdb-4.0.9-py3-none-any.whl (63 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 63.1/63.1 KB 237.2 MB/s eta 0:00:00[2022-10-11 21:06:19.610618]
Collecting zipp>=0.5
Downloading zipp-3.9.0-py3-none-any.whl (5.8 kB)
Collecting pyparsing!=3.0.5,>=2.0.2
Downloading pyparsing-3.0.9-py3-none-any.whl (98 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 98.3/98.3 KB 197.1 MB/s eta 0:00:00[2022-10-11 21:06:19.744253]
Collecting pytz>=2020.1
Downloading pytz-2022.4-py2.py3-none-any.whl (500 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 500.8/500.8 KB 278.5 MB/s eta 0:00:00[2022-10-11 21:06:19.846132]
Collecting six>=1.5
Downloading six-1.16.0-py2.py3-none-any.whl (11 kB)
Collecting urllib3<1.27,>=1.21.1
Downloading urllib3-1.26.12-py2.py3-none-any.whl (140 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 140.4/140.4 KB 253.0 MB/s eta 0:00:00[2022-10-11 21:06:20.031723]
Collecting certifi>=2017.4.17
Downloading certifi-2022.9.24-py3-none-any.whl (161 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 161.1/161.1 KB 262.1 MB/s eta 0:00:00[2022-10-11 21:06:20.079296]
Collecting charset-normalizer<3,>=2
Downloading charset_normalizer-2.1.1-py3-none-any.whl (39 kB)
Collecting idna<4,>=2.5
Downloading idna-3.4-py3-none-any.whl (61 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 61.5/61.5 KB 225.5 MB/s eta 0:00:00[2022-10-11 21:06:20.179736]
Collecting commonmark<0.10.0,>=0.9.0
Downloading commonmark-0.9.1-py2.py3-none-any.whl (51 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 51.1/51.1 KB 209.8 MB/s eta 0:00:00[2022-10-11 21:06:20.224487]
Collecting pygments<3.0.0,>=2.6.0
Downloading Pygments-2.13.0-py3-none-any.whl (1.1 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.1/1.1 MB 259.4 MB/s eta 0:00:00[2022-10-11 21:06:20.284743]
Collecting backports.zoneinfo
Downloading backports.zoneinfo-0.2.1-cp38-cp38-manylinux1_x86_64.whl (74 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 74.0/74.0 KB 205.2 MB/s eta 0:00:00[2022-10-11 21:06:20.344156]
Collecting pytz-deprecation-shim
Downloading pytz_deprecation_shim-0.1.0.post0-py2.py3-none-any.whl (15 kB)
Collecting decorator>=3.4.0
Downloading decorator-5.1.1-py3-none-any.whl (9.1 kB)
Collecting smmap<6,>=3.0.1
Downloading smmap-5.0.0-py3-none-any.whl (24 kB)
Collecting MarkupSafe>=2.0
Downloading MarkupSafe-2.1.1-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (25 kB)
Collecting attrs>=17.4.0
Downloading attrs-22.1.0-py2.py3-none-any.whl (58 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 58.8/58.8 KB 216.5 MB/s eta 0:00:00[2022-10-11 21:06:20.636791]
Collecting importlib-resources>=1.4.0
Downloading importlib_resources-5.10.0-py3-none-any.whl (34 kB)
Collecting pkgutil-resolve-name>=1.3.10
Downloading pkgutil_resolve_name-1.3.10-py3-none-any.whl (4.7 kB)
Collecting pyrsistent!=0.17.0,!=0.17.1,!=0.17.2,>=0.14.0
Downloading pyrsistent-0.18.1-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (119 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 119.8/119.8 KB 266.5 MB/s eta 0:00:00[2022-10-11 21:06:20.772547]
Collecting tzdata
Downloading tzdata-2022.4-py2.py3-none-any.whl (336 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 336.7/336.7 KB 282.5 MB/s eta 0:00:00[2022-10-11 21:06:20.926963]
Building wheels for collected packages: validators
Building wheel for validators (setup.py): started
Building wheel for validators (setup.py): finished with status ‘done’
Created wheel for validators: filename=validators-0.20.0-py3-none-any.whl size=19579 sha256=80675b6c61335df116ba6b9ff5a83e400898a26cd275155992c372c03e70a10f
Stored in directory: /tmp/pip-ephem-wheel-cache-3lz8xl0y/wheels/19/09/72/3eb74d236bb48bd0f3c6c3c83e4e0c5bbfcbcad7c6c3539db8
Successfully built validators
Installing collected packages: pytz, commonmark, zipp, watchdog, urllib3, tzdata, typing-extensions, tornado, toolz, toml, smmap, six, semver, pyrsistent, pyparsing, pympler, pygments, protobuf, pkgutil-resolve-name, pillow, numpy, MarkupSafe, idna, entrypoints, decorator, click, charset-normalizer, certifi, cachetools, blinker, backports.zoneinfo, attrs, validators, rich, requests, pytz-deprecation-shim, python-dateutil, pyarrow, packaging, jinja2, importlib-resources, importlib-metadata, gitdb, tzlocal, pydeck, pandas, jsonschema, gitpython, altair, streamlit
Attempting uninstall: pytz
Found existing installation: pytz 2022.1
Uninstalling pytz-2022.1:
Successfully uninstalled pytz-2022.1
Attempting uninstall: urllib3
Found existing installation: urllib3 1.26.9
Uninstalling urllib3-1.26.9:
Successfully uninstalled urllib3-1.26.9
Attempting uninstall: typing-extensions
Found existing installation: typing_extensions 4.4.0
Uninstalling typing_extensions-4.4.0:
Successfully uninstalled typing_extensions-4.4.0
Attempting uninstall: idna
Found existing installation: idna 3.3
Uninstalling idna-3.3:
Successfully uninstalled idna-3.3
Attempting uninstall: charset-normalizer
Found existing installation: charset-normalizer 2.0.12
Uninstalling charset-normalizer-2.0.12:
Successfully uninstalled charset-normalizer-2.0.12
Attempting uninstall: certifi
Found existing installation: certifi 2022.6.15
Uninstalling certifi-2022.6.15:
Successfully uninstalled certifi-2022.6.15
Attempting uninstall: requests
Found existing installation: requests 2.28.0
Uninstalling requests-2.28.0:
Successfully uninstalled requests-2.28.0
ERROR: pip’s dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts.
snowflake-connector-python 2.7.9 requires charset-normalizer~=2.0.0, but you have charset-normalizer 2.1.1 which is incompatible.
Successfully installed MarkupSafe-2.1.1 altair-4.2.0 attrs-22.1.0 backports.zoneinfo-0.2.1 blinker-1.5 cachetools-5.2.0 certifi-2022.9.24 charset-normalizer-2.1.1 click-8.1.3 commonmark-0.9.1 decorator-5.1.1 entrypoints-0.4 gitdb-4.0.9 gitpython-3.1.29 idna-3.4 importlib-metadata-5.0.0 importlib-resources-5.10.0 jinja2-3.1.2 jsonschema-4.16.0 numpy-1.23.3 packaging-21.3 pandas-1.5.0 pillow-9.2.0 pkgutil-resolve-name-1.3.10 protobuf-3.20.3 pyarrow-9.0.0 pydeck-0.8.0b3 pygments-2.13.0 pympler-1.0.1 pyparsing-3.0.9 pyrsistent-0.18.1 python-dateutil-2.8.2 pytz-2022.4 pytz-deprecation-shim-0.1.0.post0 requests-2.28.1 rich-12.6.0 semver-2.13.0 six-1.16.0 smmap-5.0.0 streamlit-1.13.0 toml-0.10.2 toolz-0.12.0 tornado-6.2 typing-extensions-4.4.0 tzdata-2022.4 tzlocal-4.2 urllib3-1.26.12 validators-0.20.0 watchdog-2.1.9 zipp-3.9.0
WARNING: You are using pip version 22.0.3; however, version 22.2.2 is available.
You should consider upgrading via the ‘/home/appuser/venv/bin/python -m pip install --upgrade pip’ command.

────────────────────────────────────────────────────────────────────────────────────────

[21:06:31] :package: Processed dependencies!

Collecting usage statistics. To deactivate, set browser.gatherUsageStats to False.

/home/appuser/venv/lib/python3.8/site-packages/snowflake/connector/options.py:96: UserWarning: You have an incompatible version of ‘pyarrow’ installed (9.0.0), please install a version that adheres to: ‘pyarrow<6.1.0,>=6.0.0; extra == “pandas”’
warn_incompatible_dep(
2022-10-11 21:06:54.684 Snowflake Connector for Python Version: 2.7.9, Python Version: 3.8.14, Platform: Linux-5.10.133±x86_64-with-glibc2.2.5
2022-10-11 21:06:54.684 This connection is in OCSP Fail Open Mode. TLS Certificates would be checked for validity and revocation status. Any other Certificate Revocation related exceptions or OCSP Responder failures would be disregarded in favor of connectivity.
2022-10-11 21:06:54.684 Setting use_openssl_only mode to False
Initiating login request with your identity provider. A browser window should have opened for you to complete the login. If you can’t see it, check existing browser windows, or your OS settings. Press CTRL+C to abort and try again…
We were unable to open a browser window for you, please open the following url manually then paste the URL you are redirected to into the terminal.
URL:

2

Hey there, it looks like the error is coming from the version of Pyarrow.

/home/appuser/venv/lib/python3.9/site-packages/snowflake/connector/options.py:96: UserWarning: You have an incompatible version of 'pyarrow' installed (9.0.0), please install a version that adheres to: 'pyarrow<6.1.0,>=6.0.0; extra == "pandas"'

I would try pinning the Pyarrow version

3

Thanks Caroline, I added pyarrow==6.0.1 to my requirements.txt and that issue seems to be resolved. Still getting the same error about the external browser authentication when attempting to connect to snowflake. We use SSO. Here are the logs for the newest attempt at deployment. When I paste that URL into my browser it tells me that the localhost cannot be reached.

Thank you again!

[ UTC ] Logs for noahelliottph-test-test-23ta49.streamlitapp.com/
────────────────────────────────────────────────────────────────────────────────────────
[12:27:48] :desktop_computer: Provisioning machine…
[12:27:53] :control_knobs: Preparing system…
[12:27:59] :chains: Spinning up manager process…
[12:28:06] :balloon: Inflating balloons…
[12:28:13] :open_book: Unpacking Comic Sans RAR files…
[12:28:20] :construction: Loading “Under construction” GIF…
[12:28:25] :hammer_and_wrench: Compiling tags…
[12:28:15] :rocket: Starting up repository: ‘test’, branch: ‘main’, main module: ‘test.py’
[12:28:15] :octopus: Cloning repository…
[12:28:16] :octopus: Cloning into ‘/app/test’…

[12:28:16] :octopus: Cloned repository!
[12:28:16] :octopus: Pulling code changes from Github…
[12:28:17] :package: Processing dependencies…

──────────────────────────────────────── pip ───────────────────────────────────────────

Collecting asn1crypto==1.5.1
Downloading asn1crypto-1.5.1-py2.py3-none-any.whl (105 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 105.0/105.0 KB 7.5 MB/s eta 0:00:00[2022-10-13 12:28:18.866205]
Collecting certifi==2022.6.15
Downloading certifi-2022.6.15-py3-none-any.whl (160 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 160.2/160.2 KB 26.5 MB/s eta 0:00:00[2022-10-13 12:28:18.923830]
Collecting cffi==1.15.0
Downloading cffi-1.15.0-cp38-cp38-manylinux_2_12_x86_64.manylinux2010_x86_64.whl (446 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 446.7/446.7 KB 66.0 MB/s eta 0:00:00[2022-10-13 12:28:19.167828]
Collecting charset-normalizer==2.0.12
Downloading charset_normalizer-2.0.12-py3-none-any.whl (39 kB)
Collecting cryptography==36.0.2
Downloading cryptography-36.0.2-cp36-abi3-manylinux_2_24_x86_64.whl (3.6 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 3.6/3.6 MB 183.9 MB/s eta 0:00:00[2022-10-13 12:28:19.624542]
Collecting idna==3.3
Downloading idna-3.3-py3-none-any.whl (61 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 61.2/61.2 KB 196.2 MB/s eta 0:00:00[2022-10-13 12:28:19.668608]
Collecting oscrypto==1.3.0
Downloading oscrypto-1.3.0-py2.py3-none-any.whl (194 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 194.6/194.6 KB 254.1 MB/s eta 0:00:00[2022-10-13 12:28:19.706171]
Collecting pycparser==2.21
Downloading pycparser-2.21-py2.py3-none-any.whl (118 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 118.7/118.7 KB 217.1 MB/s eta 0:00:00[2022-10-13 12:28:19.740144]
Collecting pycryptodomex==3.15.0
Downloading pycryptodomex-3.15.0-cp35-abi3-manylinux2010_x86_64.whl (2.3 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2.3/2.3 MB 257.5 MB/s eta 0:00:00[2022-10-13 12:28:19.960182]
Collecting PyJWT==2.4.0
Downloading PyJWT-2.4.0-py3-none-any.whl (18 kB)
Collecting pyOpenSSL==22.0.0
Downloading pyOpenSSL-22.0.0-py2.py3-none-any.whl (55 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 55.8/55.8 KB 213.0 MB/s eta 0:00:00[2022-10-13 12:28:20.051804]
Collecting pytz==2022.1
Downloading pytz-2022.1-py2.py3-none-any.whl (503 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 503.5/503.5 KB 256.9 MB/s eta 0:00:00[2022-10-13 12:28:20.149231]
Collecting requests==2.28.0
Downloading requests-2.28.0-py3-none-any.whl (62 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 62.8/62.8 KB 211.0 MB/s eta 0:00:00[2022-10-13 12:28:20.216755]
Collecting urllib3==1.26.9
Downloading urllib3-1.26.9-py2.py3-none-any.whl (138 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 139.0/139.0 KB 244.1 MB/s eta 0:00:00[2022-10-13 12:28:20.279439]
Collecting snowflake-connector-python==2.7.9
Downloading snowflake_connector_python-2.7.9-cp38-cp38-manylinux_2_12_x86_64.manylinux2010_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl (16.5 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 16.5/16.5 MB 245.2 MB/s eta 0:00:00[2022-10-13 12:28:20.539034]
Collecting altair
Downloading altair-4.2.0-py3-none-any.whl (812 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 812.8/812.8 KB 266.5 MB/s eta 0:00:00[2022-10-13 12:28:20.603112]
Collecting pandas
Downloading pandas-1.5.0-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (12.2 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 12.2/12.2 MB 203.2 MB/s eta 0:00:00[2022-10-13 12:28:20.905608]
Collecting streamlit
Downloading streamlit-1.13.0-py2.py3-none-any.whl (9.2 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 9.2/9.2 MB 219.8 MB/s eta 0:00:00[2022-10-13 12:28:21.067550]
Collecting pyarrow==6.0.1
Downloading pyarrow-6.0.1-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (25.6 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 25.6/25.6 MB 214.8 MB/s eta 0:00:00[2022-10-13 12:28:21.353255]
Collecting setuptools>34.0.0
Downloading setuptools-65.4.1-py3-none-any.whl (1.2 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.2/1.2 MB 261.2 MB/s eta 0:00:00[2022-10-13 12:28:21.824584]
Collecting numpy>=1.16.6
Downloading numpy-1.23.4-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (17.1 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 17.1/17.1 MB 167.4 MB/s eta 0:00:00[2022-10-13 12:28:22.381160]
Collecting entrypoints
Downloading entrypoints-0.4-py3-none-any.whl (5.3 kB)
Collecting toolz
Downloading toolz-0.12.0-py3-none-any.whl (55 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 55.8/55.8 KB 139.2 MB/s eta 0:00:00[2022-10-13 12:28:22.514975]
Collecting jsonschema>=3.0
Downloading jsonschema-4.16.0-py3-none-any.whl (83 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 83.1/83.1 KB 221.3 MB/s eta 0:00:00[2022-10-13 12:28:22.583345]
Collecting jinja2
Downloading Jinja2-3.1.2-py3-none-any.whl (133 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 133.1/133.1 KB 224.6 MB/s eta 0:00:00[2022-10-13 12:28:22.639861]
Collecting python-dateutil>=2.8.1
Downloading python_dateutil-2.8.2-py2.py3-none-any.whl (247 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 247.7/247.7 KB 248.8 MB/s eta 0:00:00[2022-10-13 12:28:22.707266]
Collecting validators>=0.2
Downloading validators-0.20.0.tar.gz (30 kB)
Preparing metadata (setup.py): started
Preparing metadata (setup.py): finished with status ‘done’
Collecting tzlocal>=1.1
Downloading tzlocal-4.2-py3-none-any.whl (19 kB)
Collecting click>=7.0
Downloading click-8.1.3-py3-none-any.whl (96 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 96.6/96.6 KB 218.1 MB/s eta 0:00:00[2022-10-13 12:28:23.416921]
Collecting pillow>=6.2.0
Downloading Pillow-9.2.0-cp38-cp38-manylinux_2_28_x86_64.whl (3.2 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 3.2/3.2 MB 241.3 MB/s eta 0:00:00[2022-10-13 12:28:23.794537]
Collecting pympler>=0.9
Downloading Pympler-1.0.1-py3-none-any.whl (164 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 164.8/164.8 KB 254.3 MB/s eta 0:00:00[2022-10-13 12:28:23.837387]
Collecting pydeck>=0.1.dev5
Downloading pydeck-0.8.0b4.dev1-py2.py3-none-any.whl (4.7 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 4.7/4.7 MB 289.5 MB/s eta 0:00:00[2022-10-13 12:28:23.905798]
Collecting rich>=10.11.0
Downloading rich-12.6.0-py3-none-any.whl (237 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 237.5/237.5 KB 171.9 MB/s eta 0:00:00[2022-10-13 12:28:24.065318]
Collecting semver
Downloading semver-2.13.0-py2.py3-none-any.whl (12 kB)
Collecting cachetools>=4.0
Downloading cachetools-5.2.0-py3-none-any.whl (9.3 kB)
Collecting gitpython!=3.1.19
Downloading GitPython-3.1.29-py3-none-any.whl (182 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 182.5/182.5 KB 155.3 MB/s eta 0:00:00[2022-10-13 12:28:24.234724]
Collecting toml
Downloading toml-0.10.2-py2.py3-none-any.whl (16 kB)
Collecting importlib-metadata>=1.4
Downloading importlib_metadata-5.0.0-py3-none-any.whl (21 kB)
Collecting packaging>=14.1
Downloading packaging-21.3-py3-none-any.whl (40 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 40.8/40.8 KB 197.1 MB/s eta 0:00:00[2022-10-13 12:28:24.437021]
Collecting protobuf!=3.20.2,<4,>=3.12
Downloading protobuf-3.20.3-cp38-cp38-manylinux_2_5_x86_64.manylinux1_x86_64.whl (1.0 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.0/1.0 MB 218.6 MB/s eta 0:00:00[2022-10-13 12:28:24.822047]
Collecting typing-extensions>=3.10.0.0
Downloading typing_extensions-4.4.0-py3-none-any.whl (26 kB)
Collecting tornado>=5.0
Downloading tornado-6.2-cp37-abi3-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl (423 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 424.0/424.0 KB 154.6 MB/s eta 0:00:00[2022-10-13 12:28:25.012139]
Collecting blinker>=1.0.0
Downloading blinker-1.5-py2.py3-none-any.whl (12 kB)
Collecting watchdog
Downloading watchdog-2.1.9-py3-none-manylinux2014_x86_64.whl (78 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 78.4/78.4 KB 220.4 MB/s eta 0:00:00[2022-10-13 12:28:25.153565]
Collecting gitdb<5,>=4.0.1
Downloading gitdb-4.0.9-py3-none-any.whl (63 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 63.1/63.1 KB 179.9 MB/s eta 0:00:00[2022-10-13 12:28:25.220886]
Collecting zipp>=0.5
Downloading zipp-3.9.0-py3-none-any.whl (5.8 kB)
Collecting importlib-resources>=1.4.0
Downloading importlib_resources-5.10.0-py3-none-any.whl (34 kB)
Collecting attrs>=17.4.0
Downloading attrs-22.1.0-py2.py3-none-any.whl (58 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 58.8/58.8 KB 207.5 MB/s eta 0:00:00[2022-10-13 12:28:25.443021]
Collecting pkgutil-resolve-name>=1.3.10
Downloading pkgutil_resolve_name-1.3.10-py3-none-any.whl (4.7 kB)
Collecting pyrsistent!=0.17.0,!=0.17.1,!=0.17.2,>=0.14.0
Downloading pyrsistent-0.18.1-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (119 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 119.8/119.8 KB 262.7 MB/s eta 0:00:00[2022-10-13 12:28:25.528666]
Collecting pyparsing!=3.0.5,>=2.0.2
Downloading pyparsing-3.0.9-py3-none-any.whl (98 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 98.3/98.3 KB 244.0 MB/s eta 0:00:00[2022-10-13 12:28:25.611043]
Collecting MarkupSafe>=2.0
Downloading MarkupSafe-2.1.1-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (25 kB)
Collecting six>=1.5
Downloading six-1.16.0-py2.py3-none-any.whl (11 kB)
Collecting pygments<3.0.0,>=2.6.0
Downloading Pygments-2.13.0-py3-none-any.whl (1.1 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.1/1.1 MB 282.6 MB/s eta 0:00:00[2022-10-13 12:28:25.882331]
Collecting commonmark<0.10.0,>=0.9.0
Downloading commonmark-0.9.1-py2.py3-none-any.whl (51 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 51.1/51.1 KB 205.4 MB/s eta 0:00:00[2022-10-13 12:28:25.922568]
Collecting backports.zoneinfo
Downloading backports.zoneinfo-0.2.1-cp38-cp38-manylinux1_x86_64.whl (74 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 74.0/74.0 KB 141.8 MB/s eta 0:00:00[2022-10-13 12:28:25.992073]
Collecting pytz-deprecation-shim
Downloading pytz_deprecation_shim-0.1.0.post0-py2.py3-none-any.whl (15 kB)
Collecting decorator>=3.4.0
Downloading decorator-5.1.1-py3-none-any.whl (9.1 kB)
Collecting smmap<6,>=3.0.1
Downloading smmap-5.0.0-py3-none-any.whl (24 kB)
Collecting tzdata
Downloading tzdata-2022.5-py2.py3-none-any.whl (336 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 336.7/336.7 KB 267.8 MB/s eta 0:00:00[2022-10-13 12:28:26.382553]
Building wheels for collected packages: validators
Building wheel for validators (setup.py): started
Building wheel for validators (setup.py): finished with status ‘done’
Created wheel for validators: filename=validators-0.20.0-py3-none-any.whl size=19579 sha256=7af92d372ef5da39864de2175df94cf8bb88c8b796a6ef639a775a85805ecc8a
Stored in directory: /tmp/pip-ephem-wheel-cache-cjgr_fbe/wheels/19/09/72/3eb74d236bb48bd0f3c6c3c83e4e0c5bbfcbcad7c6c3539db8
Successfully built validators
Installing collected packages: pytz, commonmark, asn1crypto, zipp, watchdog, urllib3, tzdata, typing-extensions, tornado, toolz, toml, smmap, six, setuptools, semver, pyrsistent, pyparsing, pympler, PyJWT, pygments, pycryptodomex, pycparser, protobuf, pkgutil-resolve-name, pillow, oscrypto, numpy, MarkupSafe, idna, entrypoints, decorator, click, charset-normalizer, certifi, cachetools, blinker, backports.zoneinfo, attrs, validators, rich, requests, pytz-deprecation-shim, python-dateutil, pyarrow, packaging, jinja2, importlib-resources, importlib-metadata, gitdb, cffi, tzlocal, pydeck, pandas, jsonschema, gitpython, cryptography, pyOpenSSL, altair, streamlit, snowflake-connector-python
Attempting uninstall: setuptools
Found existing installation: setuptools 65.3.0
Uninstalling setuptools-65.3.0:
Successfully uninstalled setuptools-65.3.0
Successfully installed MarkupSafe-2.1.1 PyJWT-2.4.0 altair-4.2.0 asn1crypto-1.5.1 attrs-22.1.0 backports.zoneinfo-0.2.1 blinker-1.5 cachetools-5.2.0 certifi-2022.6.15 cffi-1.15.0 charset-normalizer-2.0.12 click-8.1.3 commonmark-0.9.1 cryptography-36.0.2 decorator-5.1.1 entrypoints-0.4 gitdb-4.0.9 gitpython-3.1.29 idna-3.3 importlib-metadata-5.0.0 importlib-resources-5.10.0 jinja2-3.1.2 jsonschema-4.16.0 numpy-1.23.4 oscrypto-1.3.0 packaging-21.3 pandas-1.5.0 pillow-9.2.0 pkgutil-resolve-name-1.3.10 protobuf-3.20.3 pyOpenSSL-22.0.0 pyarrow-6.0.1 pycparser-2.21 pycryptodomex-3.15.0 pydeck-0.8.0b4.dev1 pygments-2.13.0 pympler-1.0.1 pyparsing-3.0.9 pyrsistent-0.18.1 python-dateutil-2.8.2 pytz-2022.1 pytz-deprecation-shim-0.1.0.post0 requests-2.28.0 rich-12.6.0 semver-2.13.0 setuptools-65.4.1 six-1.16.0 smmap-5.0.0 snowflake-connector-python-2.7.9 streamlit-1.13.0 toml-0.10.2 toolz-0.12.0 tornado-6.2 typing-extensions-4.4.0 tzdata-2022.5 tzlocal-4.2 urllib3-1.26.9 validators-0.20.0 watchdog-2.1.9 zipp-3.9.0
WARNING: You are using pip version 22.0.3; however, version 22.2.2 is available.
You should consider upgrading via the ‘/home/appuser/venv/bin/python -m pip install --upgrade pip’ command.
Checking if Streamlit is installed
Found Streamlit version 1.13.0 in the environment
Streamlit 1.13.0 is present. Installing click 8
Collecting click==8
Downloading click-8.0.0-py3-none-any.whl (96 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 96.9/96.9 KB 6.2 MB/s eta 0:00:00[2022-10-13 12:28:42.342044]
Installing collected packages: click
Attempting uninstall: click
Found existing installation: click 8.1.3
Uninstalling click-8.1.3:
Successfully uninstalled click-8.1.3
Successfully installed click-8.0.0
WARNING: You are using pip version 22.0.3; however, version 22.2.2 is available.
You should consider upgrading via the ‘/home/appuser/venv/bin/python -m pip install --upgrade pip’ command.
Streamlit 1.13.0 is present. Installing protobuf 3.20.1
Collecting protobuf==3.20.1
Downloading protobuf-3.20.1-cp38-cp38-manylinux_2_5_x86_64.manylinux1_x86_64.whl (1.0 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.0/1.0 MB 25.2 MB/s eta 0:00:00[2022-10-13 12:28:44.131126]
Installing collected packages: protobuf
Attempting uninstall: protobuf
Found existing installation: protobuf 3.20.3
Uninstalling protobuf-3.20.3:
Successfully uninstalled protobuf-3.20.3
Successfully installed protobuf-3.20.1
WARNING: You are using pip version 22.0.3; however, version 22.2.2 is available.
You should consider upgrading via the ‘/home/appuser/venv/bin/python -m pip install --upgrade pip’ command.

────────────────────────────────────────────────────────────────────────────────────────

[12:28:45] :snake: Python dependencies were installed from /app/test/requirements.txt using pip.
Check if streamlit is installed
Streamlit is already installed
[12:28:46] :package: Processed dependencies!

Collecting usage statistics. To deactivate, set browser.gatherUsageStats to False.

2022-10-13 12:29:00.401 Snowflake Connector for Python Version: 2.7.9, Python Version: 3.8.14, Platform: Linux-5.10.133±x86_64-with-glibc2.2.5
2022-10-13 12:29:00.401 This connection is in OCSP Fail Open Mode. TLS Certificates would be checked for validity and revocation status. Any other Certificate Revocation related exceptions or OCSP Responder failures would be disregarded in favor of connectivity.
2022-10-13 12:29:00.401 Setting use_openssl_only mode to False
Initiating login request with your identity provider. A browser window should have opened for you to complete the login. If you can’t see it, check existing browser windows, or your OS settings. Press CTRL+C to abort and try again…
We were unable to open a browser window for you, please open the following url manually then paste the URL you are redirected to into the terminal.
URL: Sign in to your account

4

Unfortunately, I don’t believe there’s a way to get Streamlit running on cloud to be able to open a browser window for authentication for Snowflake. Did you try opening the url that was listed in the logs?

5

When I paste that URL into my browser it tells me that the localhost cannot be reached. Does that mean that Snowflake’s SSO is not supported by streamlit cloud? Is there another form of authentication I should be using rather than “authenticator = externalbrowser” with SSO?

6

Hi @noah.elliott,

If you take out that configuration parameter, you can just add your Snowflake credentials to your app via secrets and pass them to the Snowflake connector via secrets.

7

@Caroline Thanks Caroline. The issue is that currently our organization only has SSO for our snowflake logins enabled. So there are no passwords at the moment. But I may be able to ask around and see if they can be assigned. I appreciate the help!

8

This worked for me. My requirements file looks as this:

-r https://raw.githubusercontent.com/snowflakedb/snowflake-connector-python/v2.9.0/tested_requirements/requirements_39.reqs
pyarrow==8.0.0

9

Hi @blackary, I have the same problem.
I tried pasting the URL that was listed in logs but it is not working

10

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.