* creates linting-typing.cfg in presubmit* attempt to filter out linting and typing tests from presubmit* lints and blackens this commit* revise environmental variables* Update noxfile.py* Update noxfile.py* Update noxfile.py* Update noxfile.py* Update noxfile.py* Update noxfile.py* Update .kokoro/presubmit/linting-typing.cfg* Update .kokoro/presubmit/linting-typing.cfg* Update .kokoro/presubmit/linting-typing.cfg* Update .kokoro/presubmit/presubmit.cfg* Update .kokoro/presubmit/presubmit.cfg

* chore(deps): update all dependencies* 🦉 Updates from OwlBot post-processorSeehttps://github.com/googleapis/repo-automation-bots/blob/main/packages/owl-bot/README.md* pin pycparser==2.21 for python 3.7---------Co-authored-by: Owl Bot <gcf-owl-bot[bot]@users.noreply.github.com>Co-authored-by: Chalmer Lowe <chalmerlowe@google.com>Co-authored-by: Lingqing Gan <lingqing.gan@gmail.com>

* feat: support range in queries as dict* fix sys tests* lint* fix typo

* chore(deps): update all dependencies* 🦉 Updates from OwlBot post-processorSeehttps://github.com/googleapis/repo-automation-bots/blob/main/packages/owl-bot/README.md* revert pinned requirement version and add triple equal"===" prevents dependabot from attempting to upgrade it in the future---------Co-authored-by: Owl Bot <gcf-owl-bot[bot]@users.noreply.github.com>Co-authored-by: Lingqing Gan <lingqing.gan@gmail.com>

* Add ZSTD to compression types* feat: adds tests re Compression types* revise datatype from Enum to object* adds license text and docstring* change object back to enum datatype* updates compression object comparison* updates Compression class* jsonify and sort the input and output for testing* Update tests/unit/job/test_extract.py* moved json import statement* removed enums test and file---------Co-authored-by: Ethan Steinberg <ethan.steinberg@gmail.com>Co-authored-by: Tim Sweña (Swast) <swast@google.com>

* chore(deps): update all dependencies* 🦉 Updates from OwlBot post-processorSeehttps://github.com/googleapis/repo-automation-bots/blob/main/packages/owl-bot/README.md---------Co-authored-by: Owl Bot <gcf-owl-bot[bot]@users.noreply.github.com>Co-authored-by: Chalmer Lowe <chalmerlowe@google.com>

* chore(python): bump idna from 3.4 to 3.7 in .kokoroSource-Link:googleapis/synthtool@d50980ePost-Processor: gcr.io/cloud-devrel-public-resources/owlbot-python:latest@sha256:5a4c19d17e597b92d786e569be101e636c9c2817731f80a5adec56b2aa8fe070* Apply changes fromgoogleapis/synthtool#1950---------Co-authored-by: Owl Bot <gcf-owl-bot[bot]@users.noreply.github.com>Co-authored-by: Chalmer Lowe <chalmerlowe@google.com>Co-authored-by: Anthonios Partheniou <partheniou@google.com>

#1898)…PI_FIELDThank you for opening a Pull Request! Before submitting your PR, there are a few things you can do to make sure it goes smoothly:- [ ] Make sure to open an issue as a [bug/issue](https://togithub.com/googleapis/python-bigquery/issues/new/choose) before writing your code!  That way we can discuss the change, evaluate designs, and agree on the general idea- [ ] Ensure the tests and linter pass- [ ] Code coverage does not decrease (if any source code was changed)- [ ] Appropriate docs were updated (if necessary)Fixes #<issue_number_goes_here> 🦕

* fix: add types to DatasetReference constructor* fix: add types to DatasetReference constructor* fix: DatasetReference.from_string test coverage---------Co-authored-by: Karel Serruys <karel.serruys@foodpairing.com>Co-authored-by: Chalmer Lowe <chalmerlowe@google.com>Co-authored-by: meredithslota <meredithslota@google.com>Co-authored-by: Tim Sweña (Swast) <swast@google.com>

…ady finished (#1900)fix: retry query job after ambiguous failuresCo-authored-by: Chalmer Lowe <chalmerlowe@google.com>

Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>