There are incompatible versions in the resolved dependencies

Reproduce the dependency resolution failure by running pipenv install with the provided Pipfile under Python 3.9. Inspect the firebase-admin and google-cloud-bigquery protobuf constraints shown in the resolver output. Done means establishing a compatible dependency resolution or clearly documenting the incompatibility and required versions.

[REQUIRED] Step 2: Describe your environment

• Operating System version: Mac OS 11.6
• Firebase SDK version: _____
• Firebase Product: database (auth, database, storage, etc)
• Python version: Python 3.9.2
• Pip version: 4.5.3 , 5.0.3

[REQUIRED] Step 3: Describe the problem

Steps to reproduce:

What happened? How can we make the problem occur?
could not install firebase-admin because it have package dependencies which is not compatible with google-cloud-bigquery
This could be a description, log/console output, etc.

ERROR: Could not find a version that matches protobuf<3.18.0,>=3.12.0,>=3.19.0 (from google-cloud-bigquery==2.18.0->-r /var/folders/77/x5lccrxn3zsdz6s4g8bpgqjm0000gn/T/pipenvvww65bssrequirements/pipenv-hfcpz21d-constraints.txt (line 35))
Tried: 2.0.3, 2.3.0, 2.4.1, 2.5.0, 2.6.0, 2.6.1, 3.0.0, 3.0.0, 3.1.0, 3.1.0.post1, 3.1.0.post1, 3.2.0, 3.2.0, 3.3.0, 3.4.0, 3.4.0, 3.5.0.post1, 3.5.0.post1, 3.5.1, 3.5.1, 3.5.2, 3.5.2, 3.5.2.post1, 3.5.2.post1, 3.6.0, 3.6.0, 3.6.1, 3.6.1, 3.7.0, 3.7.0, 3.7.1, 3.7.1, 3.8.0, 3.8.0, 3.9.0, 3.9.0, 3.9.1, 3.9.1, 3.9.2, 3.9.2, 3.10.0, 3.10.0, 3.11.0, 3.11.0, 3.11.1, 3.11.1, 3.11.2, 3.11.2, 3.11.3, 3.11.3, 3.12.2, 3.12.2, 3.12.4, 3.12.4, 3.13.0, 3.13.0, 3.14.0, 3.14.0, 3.15.0, 3.15.0, 3.15.1, 3.15.1, 3.15.2, 3.15.2, 3.15.3, 3.15.3, 3.15.4, 3.15.4, 3.15.5, 3.15.5, 3.15.6, 3.15.6, 3.15.7, 3.15.7, 3.15.8, 3.15.8, 3.16.0, 3.16.0, 3.17.0, 3.17.0, 3.17.1, 3.17.1, 3.17.2, 3.17.2, 3.17.3, 3.17.3, 3.18.0, 3.18.0, 3.18.1, 3.18.1, 3.19.0, 3.19.0
Skipped pre-versions: 2.0.0b0, 3.0.0a2, 3.0.0a3, 3.0.0b1, 3.0.0b1.post1, 3.0.0b1.post2, 3.0.0b2, 3.0.0b2, 3.0.0b2.post1, 3.0.0b2.post1, 3.0.0b2.post2, 3.0.0b2.post2, 3.0.0b3, 3.0.0b4, 3.0.0b4, 3.2.0rc1, 3.2.0rc1, 3.2.0rc1.post1, 3.2.0rc1.post1, 3.2.0rc2, 3.2.0rc2, 3.7.0rc2, 3.7.0rc2, 3.7.0rc3, 3.7.0rc3, 3.8.0rc1, 3.8.0rc1, 3.9.0rc1, 3.9.0rc1, 3.10.0rc1, 3.10.0rc1, 3.11.0rc1, 3.11.0rc1, 3.11.0rc2, 3.11.0rc2, 3.13.0rc3, 3.13.0rc3, 3.14.0rc1, 3.14.0rc1, 3.14.0rc2, 3.14.0rc2, 3.14.0rc3, 3.14.0rc3, 3.15.0rc1, 3.15.0rc1, 3.15.0rc2, 3.15.0rc2, 3.16.0rc1, 3.16.0rc1, 3.16.0rc2, 3.16.0rc2, 3.17.0rc1, 3.17.0rc1, 3.17.0rc2, 3.17.0rc2, 3.18.0rc1, 3.18.0rc1, 3.18.0rc2, 3.18.0rc2, 3.19.0rc1, 3.19.0rc1, 3.19.0rc2, 3.19.0rc2, 4.0.0rc1, 4.0.0rc1, 4.0.0rc2, 4.0.0rc2
There are incompatible versions in the resolved dependencies:
  protobuf<3.18.0,>=3.12.0 (from google-api-core[grpc]==1.31.3->firebase-admin==5.0.3->-r /var/folders/77/x5lccrxn3zsdz6s4g8bpgqjm0000gn/T/pipenvvww65bssrequirements/pipenv-hfcpz21d-constraints.txt (line 48))
  protobuf>=3.12.0 (from google-cloud-bigquery==2.18.0->-r /var/folders/77/x5lccrxn3zsdz6s4g8bpgqjm0000gn/T/pipenvvww65bssrequirements/pipenv-hfcpz21d-constraints.txt (line 35))
  protobuf>=3.19.0 (from proto-plus==1.19.7->google-cloud-bigquery==2.18.0->-r /var/folders/77/x5lccrxn3zsdz6s4g8bpgqjm0000gn/T/pipenvvww65bssrequirements/pipenv-hfcpz21d-constraints.txt (line 35))

how to reproduce?

Pipfile:

[[source]]
url = "https://pypi.python.org/simple"
verify_ssl = true
name = "pypi"

[packages]
beautifulsoup4 = "==4.8.2"
boto3 = "<1.19,>=1.18"
boxsdk = "==2.12.1"
celery = "==5.1.1"
coreapi = "==2.3.3"
django = "==3.2.8"
django-cacheops = "==6.0"
django-cors-headers = "==3.8.0"
django-cryptography = "==1.0"
django-excel = "==0.0.10"
django-filter = "==2.4.0"
django-health-check = "==3.16.4"
django-memoize = "==2.3.1"
django-modeltranslation = "==0.17.3"
django-nap = "==0.40.0"
django-redis = "==4.12.1"
django-rest-auth = "==0.9.5"
django-simple-history = "==3.0.0"
django-storages = "==1.12.2"
djangorestframework = "==3.12.4"
djangorestframework-jwt = "==1.11.0"
drf-nested-routers = "==0.93.4"
firebase_admin = "==5.0.3"
flower = {git = "git://github.com/mher/flower.git", editable = true, ref = "ad3a68eb7296b732f3555a6ef808987c763d8e8d"}
google-api-python-client = "==1.12.8"
google-auth = "==1.30.1"
google-auth-oauthlib = "==0.4.4"
google-cloud-bigquery = "==2.18.0"
google-cloud-storage = "==1.41.1"
googleads = "==28.0.0"
gunicorn = "==20.1.0"
isoweek = "==1.3.3"
jsonpickle = "==2.0.0"
MechanicalSoup = "==1.0.0"
oauthlib = "==3.0.0"
oauth2client = "==4.1.3"
orderedset = "==2.0.3"
ox3apiclient = "==0.6.1"
pandas = "==1.3.2"
paramiko = "==2.7.2"
Pillow = "==8.2.0"
psutil = "==5.8.0"
psycopg2-binary = "==2.9.1"
pyexcel-io = "==0.6.4"
pyexcel-xls = "==0.6.2"
pyexcel-xlsx = "==0.6.0"
PyJWT = "==1.7.1"
pyOpenSSL = "==20.0.0"
python-dateutil = "==2.8.2"
pytz = "==2021.3"
reportlab = "==3.5.68"
"requests[security]" = "==2.26.0"
retry = "==0.9.2"
schema = "==0.7.3"
sentry-sdk = "==1.3.1"
slack-sdk = "==3.9.1"
redis = "<4.0.0,>=3.5.3"

[dev-packages]
brunette = "==0.2.0"
coverage = "==6.0.2"
factory_boy = "==3.2.0"
flake8 = "==3.9.2"
isort = "==5.9.3"
mypy = "==0.910"
types-jwt = "==0.1.3"
types-python-dateutil = "==2.8.2"
types-PyYAML = "==5.4.12"
types-requests = "==2.25.11"
types-retry = "==0.9.2"
types-six = "==1.16.2"
typing-extensions = "==3.10.0.2"
pre-commit= "==2.14.0"

[requires]
python_version = "3.9"

[pipenv]
allow_prereleases = true

then install:
pipenv install

Relevant Code:

// TODO(you): code here to reproduce the problem