Updating pipenv venv can be achieved by setting the desired python version in the pipfile, followed by running the command pipenv install --python

count in cosmos container SELECT COUNT(1) FROM c