Testing: reduce / remove warning spew

[tseaver]

$ nox -re unit-3.6
nox > Running session unit-3.6
nox > Re-using existing virtual environment at .nox/unit-3-6.
nox > pip install mock pytest google-cloud-testutils pytest-cov freezegun
nox > pip install grpcio
nox > pip install -e .[all,fastparquet]
nox > pip install ipython
nox > py.test --quiet --cov=google.cloud.bigquery --cov=tests.unit --cov-append --cov-config=.coveragerc --cov-report= --cov-fail-under=0 tests/unit
........................................................................ [  5%]
........................................................................ [ 10%]
........................................................................ [ 15%]
........................................................................ [ 20%]
........................................................................ [ 25%]
........................................................................ [ 30%]
..ss.....s.............................................................. [ 35%]
........................................................................ [ 40%]
........................................................................ [ 45%]
........................................................................ [ 50%]
........................................................................ [ 55%]
........................................................................ [ 60%]
........................................................................ [ 65%]
........................................................................ [ 70%]
........................................................................ [ 75%]
........................................................................ [ 80%]
........................................................................ [ 85%]
........................................................................ [ 90%]
........................................................................ [ 95%]
.....................................................................    [100%]
=============================== warnings summary ===============================
tests/unit/test__pandas_helpers.py::test_bq_to_arrow_data_type_w_struct[RECORD]
tests/unit/test__pandas_helpers.py::test_bq_to_arrow_data_type_w_struct[record]
tests/unit/test__pandas_helpers.py::test_bq_to_arrow_data_type_w_struct[STRUCT]
tests/unit/test__pandas_helpers.py::test_bq_to_arrow_data_type_w_struct[struct]
  /home/tseaver/projects/agendaless/Google/src/python-bigquery/tests/unit/test__pandas_helpers.py:302: FutureWarning: num_children is deprecated, use num_fields
    assert actual.num_children == len(fields)

tests/unit/test__pandas_helpers.py::test_bq_to_arrow_data_type_w_array_struct[RECORD]
tests/unit/test__pandas_helpers.py::test_bq_to_arrow_data_type_w_array_struct[record]
tests/unit/test__pandas_helpers.py::test_bq_to_arrow_data_type_w_array_struct[STRUCT]
tests/unit/test__pandas_helpers.py::test_bq_to_arrow_data_type_w_array_struct[struct]
  /home/tseaver/projects/agendaless/Google/src/python-bigquery/tests/unit/test__pandas_helpers.py:347: FutureWarning: num_children is deprecated, use num_fields
    assert actual.value_type.num_children == len(fields)

tests/unit/test__pandas_helpers.py::test_bq_to_arrow_schema_w_unknown_type
  /home/tseaver/projects/agendaless/Google/src/python-bigquery/google/cloud/bigquery/_pandas_helpers.py:195: UserWarning: Unable to determine type for field 'field3'.
    warnings.warn("Unable to determine type for field '{}'.".format(bq_field.name))

tests/unit/test_client.py::TestClient::test__call_api_applying_custom_retry_on_timeout
tests/unit/test_client.py::TestClient::test_create_bqstorage_client_missing_dependency
tests/unit/test_magics.py::test_bigquery_magic_without_optional_arguments
  /home/tseaver/projects/agendaless/Google/src/python-bigquery/.nox/unit-3-6/lib/python3.6/site-packages/google/auth/_default.py:69: UserWarning: Your application has authenticated using end user credentials from Google Cloud SDK without a quota project. You might receive a "quota exceeded" or "API not enabled" error. We recommend you rerun `gcloud auth application-default login` and make sure a quota project is added. Or you can use service accounts instead. For more information about service accounts, see https://cloud.google.com/docs/authentication/
    warnings.warn(_CLOUD_SDK_CREDENTIALS_WARNING)

tests/unit/test_client.py::TestClientUpload::test_load_table_from_dataframe_wo_pyarrow_custom_compression
  /home/tseaver/projects/agendaless/Google/src/python-bigquery/tests/unit/test_client.py:7477: PyarrowMissingWarning: Loading dataframe data without pyarrow installed is deprecated and will become unsupported in the future. Please install the pyarrow package.
    parquet_compression="gzip",

tests/unit/test_client.py::TestClientUpload::test_load_table_from_dataframe_wo_pyarrow_custom_compression
  /home/tseaver/projects/agendaless/Google/src/python-bigquery/tests/unit/test_client.py:7477: PendingDeprecationWarning: job_config.schema is set, but not used to assist in identifying correct types for data serialization. Please install the pyarrow package.
    parquet_compression="gzip",

tests/unit/test_job.py::TestLoadJobConfig::test_time_partitioning_hit
tests/unit/test_job.py::TestLoadJobConfig::test_time_partitioning_setter
  /home/tseaver/projects/agendaless/Google/src/python-bigquery/google/cloud/bigquery/table.py:2034: PendingDeprecationWarning: TimePartitioning.require_partition_filter will be removed in future versions. Please use Table.require_partition_filter instead.
    self.require_partition_filter = require_partition_filter

tests/unit/test_job.py::TestQueryJob::test_to_dataframe_column_date_dtypes_wo_pyarrow
  /home/tseaver/projects/agendaless/Google/src/python-bigquery/google/cloud/bigquery/job.py:3383: PyarrowMissingWarning: Converting to a dataframe without pyarrow installed is often slower and will become unsupported in the future. Please install the pyarrow package.
    date_as_object=date_as_object,

tests/unit/test_table.py::TestRowIterator::test_to_arrow_w_unknown_type
  /home/tseaver/projects/agendaless/Google/src/python-bigquery/google/cloud/bigquery/_pandas_helpers.py:195: UserWarning: Unable to determine type for field 'sport'.
    warnings.warn("Unable to determine type for field '{}'.".format(bq_field.name))

tests/unit/test_table.py::TestRowIterator::test_to_dataframe_concat_categorical_dtype_wo_pyarrow
  /home/tseaver/projects/agendaless/Google/src/python-bigquery/tests/unit/test_table.py:3500: PyarrowMissingWarning: Converting to a dataframe without pyarrow installed is often slower and will become unsupported in the future. Please install the pyarrow package.
    categories=["low", "medium", "high"], ordered=False,

tests/unit/test_table.py::TestRowIterator::test_to_dataframe_progress_bar_wo_pyarrow
tests/unit/test_table.py::TestRowIterator::test_to_dataframe_progress_bar_wo_pyarrow
tests/unit/test_table.py::TestRowIterator::test_to_dataframe_progress_bar_wo_pyarrow
  /home/tseaver/projects/agendaless/Google/src/python-bigquery/tests/unit/test_table.py:2373: PyarrowMissingWarning: Converting to a dataframe without pyarrow installed is often slower and will become unsupported in the future. Please install the pyarrow package.
    df = row_iterator.to_dataframe(progress_bar_type=progress_bar_type)

tests/unit/test_table.py::TestRowIterator::test_to_dataframe_w_bqstorage_v1beta1_no_streams
  /home/tseaver/projects/agendaless/Google/src/python-bigquery/google/cloud/bigquery/_pandas_helpers.py:645: DeprecationWarning: Support for BigQuery Storage v1beta1 clients is deprecated, please consider upgrading the client to BigQuery Storage v1 stable version.
    category=DeprecationWarning,

tests/unit/test_table.py::TestRowIterator::test_to_dataframe_w_empty_results_wo_pyarrow
  /home/tseaver/projects/agendaless/Google/src/python-bigquery/tests/unit/test_table.py:2502: PyarrowMissingWarning: Converting to a dataframe without pyarrow installed is often slower and will become unsupported in the future. Please install the pyarrow package.
    df = row_iterator.to_dataframe()

tests/unit/test_table.py::TestRowIterator::test_to_dataframe_w_no_results_wo_pyarrow
  /home/tseaver/projects/agendaless/Google/src/python-bigquery/tests/unit/test_table.py:2525: PyarrowMissingWarning: Converting to a dataframe without pyarrow installed is often slower and will become unsupported in the future. Please install the pyarrow package.
    df = row_iterator.to_dataframe()

-- Docs: https://docs.pytest.org/en/latest/warnings.html


1434 passed, 3 skipped, 25 warnings in 37.53s