Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[ADAP-372] [Bug] Address failing test_persist_docs #605

Closed
2 tasks done
mikealfare opened this issue Mar 15, 2023 · 0 comments · Fixed by #607
Closed
2 tasks done

[ADAP-372] [Bug] Address failing test_persist_docs #605

mikealfare opened this issue Mar 15, 2023 · 0 comments · Fixed by #607
Assignees
@VersusFacit
Labels
type:bug Something isn't working

Comments

@mikealfare
Copy link
Contributor

Is this a new bug in dbt-bigquery?

  • I believe this is a new bug in dbt-bigquery
  • I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

tests/functional/adapter/test_persist_docs.py::TestPersistDocsNested::test_persist_docs is failing across all OS/python versions on main during the scheduled integration tests.

Expected Behavior

All tests pass during the scheduled integration tests.

Steps To Reproduce

Run the integration tests on main. The results of the last run are here:
https://github.com/dbt-labs/dbt-bigquery/actions/runs/4425622181

Relevant log output

==================================== ERRORS ====================================
__________ ERROR at setup of TestPersistDocsNested.test_persist_docs ___________
[gw2] linux -- Python 3.11.2 /home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/bin/python

self = <test_persist_docs.TestPersistDocsNested object at 0x7f1d4b63c790>
project = <dbt.tests.fixtures.project.TestProjInfo object at 0x7f1d2be5f7d0>

    @pytest.fixture(scope="class", autouse=True)
    def setUp(self, project):
        run_dbt(["seed"])
>       run_dbt()

/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/tests/adapter/persist_docs/test_persist_docs.py:25: 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 

args = ['run', '--project-dir', '/tmp/pytest-of-runner/pytest-0/popen-gw2/project18', '--profiles-dir', '/tmp/pytest-of-runner/pytest-0/popen-gw2/profile18']
expect_pass = True

    def run_dbt(args: List[str] = None, expect_pass=True):
        # Ignore logbook warnings
        warnings.filterwarnings("ignore", category=DeprecationWarning, module="logbook")
    
        # reset global vars
        reset_metadata_vars()
    
        # The logger will complain about already being initialized if
        # we don't do this.
        log_manager.reset_handlers()
        if args is None:
            args = ["run"]
    
        print("\n\nInvoking dbt with {}".format(args))
        from dbt.flags import get_flags
    
        flags = get_flags()
        project_dir = getattr(flags, "PROJECT_DIR", None)
        profiles_dir = getattr(flags, "PROFILES_DIR", None)
        if project_dir and "--project-dir" not in args:
            args.extend(["--project-dir", project_dir])
        if profiles_dir and "--profiles-dir" not in args:
            args.extend(["--profiles-dir", profiles_dir])
        dbt = dbtRunner()
        res, success = dbt.invoke(args)
    
        if expect_pass is not None:
>           assert success == expect_pass, "dbt exit state did not match expected"
E           AssertionError: dbt exit state did not match expected

/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/tests/util.py:98: AssertionError
---------------------------- Captured stdout setup -----------------------------

=== Test project_root: /tmp/pytest-of-runner/pytest-0/popen-gw2/project18


Invoking dbt with ['seed']
11:17:34  Running with dbt=1.5.0-b3
11:17:34  Unable to do partial parsing because saved manifest not found. Starting full parse.
11:17:35  Found 2 models, 0 tests, 0 snapshots, 0 analyses, 352 macros, 0 operations, 1 seed file, 0 sources, 0 exposures, 0 metrics, 0 groups
11:17:35  
11:17:35  Concurrency: 1 threads (target='default')
11:17:35  
11:17:35  1 of 1 START seed file test16788790535351041482_test_persist_docs.seed ......... [RUN]
11:17:40  1 of 1 OK loaded seed file test16788790535351041482_test_persist_docs.seed ..... [INSERT 2 in 4.13s]
11:17:40  
11:17:40  Finished running 1 seed in 0 hours 0 minutes and 5.04 seconds (5.04s).
11:17:40  
11:17:40  Completed successfully
11:17:40  
11:17:40  Done. PASS=1 WARN=0 ERROR=0 SKIP=0 TOTAL=1


Invoking dbt with ['run']
11:17:40  Running with dbt=1.5.0-b3
11:17:40  Found 2 models, 0 tests, 0 snapshots, 0 analyses, 352 macros, 0 operations, 1 seed file, 0 sources, 0 exposures, 0 metrics, 0 groups
11:17:40  
11:17:41  Concurrency: 1 threads (target='default')
11:17:41  
11:17:41  1 of 2 START sql table model test16788790535351041482_test_persist_docs.table_model_nested  [RUN]
11:17:44  Unhandled error while executing target/run/test/models/table_model_nested.sql
400 PATCH https://bigquery.googleapis.com/bigquery/v2/projects/dbt-test-env/datasets/test16788790535351041482_test_persist_docs/tables/table_model_nested?prettyPrint=false: Policy tags can only be attached to a leaf field.
11:17:44  1 of 2 ERROR creating sql table model test16788790535351041482_test_persist_docs.table_model_nested  [ERROR in 3.09s]
11:17:44  2 of 2 START sql view model test16788790535351041482_test_persist_docs.view_model_nested  [RUN]
11:17:45  Unhandled error while executing target/run/test/models/view_model_nested.sql
400 PATCH https://bigquery.googleapis.com/bigquery/v2/projects/dbt-test-env/datasets/test16788790535351041482_test_persist_docs/tables/view_model_nested?prettyPrint=false: Policy tags can only be attached to a leaf field.
11:17:45  2 of 2 ERROR creating sql view model test16788790535351041482_test_persist_docs.view_model_nested  [ERROR in 1.09s]
11:17:45  
11:17:45  Finished running 1 table model, 1 view model in 0 hours 0 minutes and 5.12 seconds (5.12s).
11:17:45  
11:17:45  Completed with 2 errors and 0 warnings:
11:17:45  
11:17:45  400 PATCH https://bigquery.googleapis.com/bigquery/v2/projects/dbt-test-env/datasets/test16788790535351041482_test_persist_docs/tables/table_model_nested?prettyPrint=false: Policy tags can only be attached to a leaf field.
11:17:45  
11:17:45  400 PATCH https://bigquery.googleapis.com/bigquery/v2/projects/dbt-test-env/datasets/test16788790535351041482_test_persist_docs/tables/view_model_nested?prettyPrint=false: Policy tags can only be attached to a leaf field.
11:17:45  
11:17:45  Done. PASS=0 WARN=0 ERROR=2 SKIP=0 TOTAL=2
---------------------------- Captured logbook setup ----------------------------
[DEBUG] file_log: {"data": {"conn_name": "_test", "conn_type": "bigquery"}, "info": {"category": "", "code": "E005", "extra": {}, "invocation_id": "2064fd5d-5809-4fcb-b1c7-a84b04160423", "level": "debug", "msg": "Acquiring new bigquery connection '_test'", "name": "NewConnection", "pid": 2077, "thread": "MainThread", "ts": "2023-03-15T11:17:33.167658Z"}}
[DEBUG] file_log: {"data": {"relation": {"database": "dbt-test-env", "identifier": null, "schema": "test16788790535351041482_test_persist_docs"}}, "info": {"category": "", "code": "E020", "extra": {}, "invocation_id": "2064fd5d-5809-4fcb-b1c7-a84b04160423", "level": "debug", "msg": "Creating schema \"ReferenceKeyMsg(database='dbt-test-env', schema='test16788790535351041482_test_persist_docs', identifier=None)\"", "name": "SchemaCreation", "pid": 2077, "thread": "MainThread", "ts": "2023-03-15T11:17:33.168217Z"}}
[DEBUG] file_log: {"data": {"connection_state": "closed"}, "info": {"category": "", "code": "E037", "extra": {}, "invocation_id": "2064fd5d-5809-4fcb-b1c7-a84b04160423", "level": "debug", "msg": "Opening a new connection, currently in state closed", "name": "NewConnectionOpening", "pid": 2077, "thread": "MainThread", "ts": "2023-03-15T11:17:33.170345Z"}}
[DEBUG] file_log: {"data": {"conn_name": "_test", "sql": "create schema if not exists `dbt-test-env`.`test16788790535351041482_test_persist_docs`\n  "}, "info": {"category": "", "code": "E016", "extra": {}, "invocation_id": "2064fd5d-5809-4fcb-b1c7-a84b04160423", "level": "debug", "msg": "On _test: create schema if not exists `dbt-test-env`.`test16788790535351041482_test_persist_docs`\n  ", "name": "SQLQuery", "pid": 2077, "thread": "MainThread", "ts": "2023-03-15T11:17:33.223925Z"}}
[DEBUG] file_log: {"data": {"args": [], "base_msg": "https://console.cloud.google.com/bigquery?project=dbt-test-env&j=bq:US:5eb1efe3-8b03-4cbe-91d7-a12bc8cc10e2&page=queryresults", "name": "BigQuery"}, "info": {"category": "", "code": "E001", "extra": {}, "invocation_id": "2064fd5d-5809-4fcb-b1c7-a84b04160423", "level": "debug", "msg": "BigQuery adapter: https://console.cloud.google.com/bigquery?project=dbt-test-env&j=bq:US:5eb1efe3-8b03-4cbe-91d7-a12bc8cc10e2&page=queryresults", "name": "AdapterEventDebug", "pid": 2077, "thread": "MainThread", "ts": "2023-03-15T11:17:34.279890Z"}}
[INFO] stdout_log: 11:17:34  Running with dbt=1.5.0-b3
[INFO] file_log: 

============================== 2023-03-15 11:17:34.283220 | 2064fd5d-5809-4fcb-b1c7-a84b04160423 ==============================
11:17:34.283220 [info ] [MainThread]: Running with dbt=1.5.0-b3
[DEBUG] file_log: 11:17:34.283595 [debug] [MainThread]: running dbt with arguments {'cache_selected_only': 'False', 'warn_error_options': 'WarnErrorOptions(include=[], exclude=[])', 'printer_width': '80', 'partial_parse': 'True', 'introspect': 'True', 'quiet': 'False', 'no_print': 'None', 'target_path': 'None', 'profiles_dir': '/tmp/pytest-of-runner/pytest-0/popen-gw2/profile18', 'debug': 'False', 'write_json': 'True', 'fail_fast': 'False', 'version_check': 'True', 'warn_error': 'None', 'static_parser': 'True', 'log_cache_events': 'False', 'use_colors': 'True', 'log_path': '/home/runner/work/dbt-bigquery/dbt-bigquery/logs/test16788790535351041482', 'log_format': 'default', 'use_experimental_parser': 'False', 'indirect_selection': 'eager', 'send_anonymous_usage_stats': 'False'}
[DEBUG] file_log: 11:17:34.283777 [debug] [MainThread]: Connection '_test' was properly closed.
[DEBUG] file_log: 11:17:34.305142 [debug] [MainThread]: checksum: a569f769ed64d545a1d10c9475cb56dcaa4f3ee0bbe20c4c6c7feeccb092001d, vars: {}, profile: None, target: None, version: 1.5.0b3
[INFO] stdout_log: 11:17:34  Unable to do partial parsing because saved manifest not found. Starting full parse.
[INFO] file_log: 11:17:34.305581 [info ] [MainThread]: Unable to do partial parsing because saved manifest not found. Starting full parse.
[DEBUG] file_log: 11:17:34.997525 [debug] [MainThread]: 1699: static parser successfully parsed view_model_nested.sql
[DEBUG] file_log: 11:17:35.001137 [debug] [MainThread]: 1699: static parser successfully parsed table_model_nested.sql
[INFO] stdout_log: 11:17:35  Found 2 models, 0 tests, 0 snapshots, 0 analyses, 352 macros, 0 operations, 1 seed file, 0 sources, 0 exposures, 0 metrics, 0 groups
[INFO] file_log: 11:17:35.059536 [info ] [MainThread]: Found 2 models, 0 tests, 0 snapshots, 0 analyses, 352 macros, 0 operations, 1 seed file, 0 sources, 0 exposures, 0 metrics, 0 groups
[INFO] stdout_log: 11:17:35  
[INFO] file_log: 11:17:35.060425 [info ] [MainThread]: 
[DEBUG] file_log: 11:17:35.061122 [debug] [MainThread]: Acquiring new bigquery connection 'master'
[DEBUG] file_log: 11:17:35.061964 [debug] [ThreadPool]: Acquiring new bigquery connection 'list_dbt-test-env'
[DEBUG] file_log: 11:17:35.062275 [debug] [ThreadPool]: Opening a new connection, currently in state init
[DEBUG] file_log: 11:17:35.613374 [debug] [ThreadPool]: Re-using an available connection from the pool (formerly list_dbt-test-env, now list_dbt-test-env_test16788790535351041482_test_persist_docs)
[DEBUG] file_log: 11:17:35.613786 [debug] [ThreadPool]: Opening a new connection, currently in state closed
[INFO] stdout_log: 11:17:35  Concurrency: 1 threads (target='default')
[INFO] file_log: 11:17:35.973655 [info ] [MainThread]: Concurrency: 1 threads (target='default')
[INFO] stdout_log: 11:17:35  
[INFO] file_log: 11:17:35.974083 [info ] [MainThread]: 
[DEBUG] file_log: 11:17:35.975748 [debug] [Thread-221]: Began running node seed.test.seed
[INFO] stdout_log: 11:17:35  1 of 1 START seed file test16788790535351041482_test_persist_docs.seed ......... [RUN]
[INFO] file_log: 11:17:35.976162 [info ] [Thread-221]: 1 of 1 START seed file test16788790535351041482_test_persist_docs.seed ......... [RUN]
[DEBUG] file_log: 11:17:35.976819 [debug] [Thread-221]: Re-using an available connection from the pool (formerly list_dbt-test-env_test16788790535351041482_test_persist_docs, now seed.test.seed)
[DEBUG] file_log: 11:17:35.977045 [debug] [Thread-221]: Began compiling node seed.test.seed
[DEBUG] file_log: 11:17:35.977239 [debug] [Thread-221]: Timing info for seed.test.seed (compile): 2023-03-15 11:17:35.977187 => 2023-03-15 11:17:35.977189
[DEBUG] file_log: 11:17:35.977446 [debug] [Thread-221]: Began executing node seed.test.seed
[DEBUG] file_log: 11:17:35.981292 [debug] [Thread-221]: Opening a new connection, currently in state closed
[DEBUG] file_log: 11:17:39.348856 [debug] [Thread-221]: On seed.test.seed: /* {"app": "dbt", "dbt_version": "1.5.0b3", "profile_name": "test", "target_name": "default", "node_id": "seed.test.seed"} */

    alter table `dbt-test-env`.`test16788790535351041482_test_persist_docs`.`seed` set OPTIONS()
  
[DEBUG] file_log: 11:17:40.098383 [debug] [Thread-221]: BigQuery adapter: https://console.cloud.google.com/bigquery?project=dbt-test-env&j=bq:US:15fa9f67-f689-4c69-b665-d4d28474d0cd&page=queryresults
[DEBUG] file_log: 11:17:40.099291 [debug] [Thread-221]: Writing runtime SQL for node "seed.test.seed"
[DEBUG] file_log: 11:17:40.101789 [debug] [Thread-221]: Timing info for seed.test.seed (execute): 2023-03-15 11:17:35.977584 => 2023-03-15 11:17:40.101734
[INFO] stdout_log: 11:17:40  1 of 1 OK loaded seed file test16788790535351041482_test_persist_docs.seed ..... [INSERT 2 in 4.13s]
[INFO] file_log: 11:17:40.102817 [info ] [Thread-221]: 1 of 1 OK loaded seed file test16788790535351041482_test_persist_docs.seed ..... [INSERT 2 in 4.13s]
[DEBUG] file_log: 11:17:40.103260 [debug] [Thread-221]: Finished running node seed.test.seed
[DEBUG] file_log: 11:17:40.104716 [debug] [MainThread]: Connection 'master' was properly closed.
[DEBUG] file_log: 11:17:40.104966 [debug] [MainThread]: Connection 'seed.test.seed' was properly closed.
[INFO] stdout_log: 11:17:40  
[INFO] file_log: 11:17:40.105168 [info ] [MainThread]: 
[INFO] stdout_log: 11:17:40  Finished running 1 seed in 0 hours 0 minutes and 5.04 seconds (5.04s).
[INFO] file_log: 11:17:40.105442 [info ] [MainThread]: Finished running 1 seed in 0 hours 0 minutes and 5.04 seconds (5.04s).
[DEBUG] file_log: 11:17:40.105818 [debug] [MainThread]: Command end result
[INFO] stdout_log: 11:17:40  
[INFO] file_log: 11:17:40.111945 [info ] [MainThread]: 
[INFO] stdout_log: 11:17:40  Completed successfully
[INFO] file_log: 11:17:40.112319 [info ] [MainThread]: Completed successfully
[INFO] stdout_log: 11:17:40  
[INFO] file_log: 11:17:40.112603 [info ] [MainThread]: 
[INFO] stdout_log: 11:17:40  Done. PASS=1 WARN=0 ERROR=0 SKIP=0 TOTAL=1
[INFO] file_log: 11:17:40.112849 [info ] [MainThread]: Done. PASS=1 WARN=0 ERROR=0 SKIP=0 TOTAL=1
[DEBUG] file_log: 11:17:40.113139 [debug] [MainThread]: Flushing usage events
[INFO] stdout_log: 11:17:40  Running with dbt=1.5.0-b3
[INFO] file_log: 

============================== 2023-03-15 11:17:40.115998 | 2064fd5d-5809-4fcb-b1c7-a84b04160423 ==============================
11:17:40.115998 [info ] [MainThread]: Running with dbt=1.5.0-b3
[DEBUG] file_log: 11:17:40.116342 [debug] [MainThread]: running dbt with arguments {'cache_selected_only': 'False', 'warn_error_options': 'WarnErrorOptions(include=[], exclude=[])', 'printer_width': '80', 'partial_parse': 'True', 'introspect': 'True', 'quiet': 'False', 'no_print': 'None', 'target_path': 'None', 'profiles_dir': '/tmp/pytest-of-runner/pytest-0/popen-gw2/profile18', 'debug': 'False', 'write_json': 'True', 'fail_fast': 'False', 'version_check': 'True', 'warn_error': 'None', 'static_parser': 'True', 'log_cache_events': 'False', 'use_colors': 'True', 'log_path': '/home/runner/work/dbt-bigquery/dbt-bigquery/logs/test16788790535351041482', 'log_format': 'default', 'use_experimental_parser': 'False', 'indirect_selection': 'eager', 'send_anonymous_usage_stats': 'False'}
[DEBUG] file_log: 11:17:40.137524 [debug] [MainThread]: checksum: a569f769ed64d545a1d10c9475cb56dcaa4f3ee0bbe20c4c6c7feeccb092001d, vars: {}, profile: None, target: None, version: 1.5.0b3
[DEBUG] file_log: 11:17:40.457880 [debug] [MainThread]: Partial parsing enabled: 0 files deleted, 0 files added, 0 files changed.
[DEBUG] file_log: 11:17:40.458197 [debug] [MainThread]: Partial parsing enabled, no changes found, skipping parsing
[INFO] stdout_log: 11:17:40  Found 2 models, 0 tests, 0 snapshots, 0 analyses, 352 macros, 0 operations, 1 seed file, 0 sources, 0 exposures, 0 metrics, 0 groups
[INFO] file_log: 11:17:40.470168 [info ] [MainThread]: Found 2 models, 0 tests, 0 snapshots, 0 analyses, 352 macros, 0 operations, 1 seed file, 0 sources, 0 exposures, 0 metrics, 0 groups
[INFO] stdout_log: 11:17:40  
[INFO] file_log: 11:17:40.471127 [info ] [MainThread]: 
[DEBUG] file_log: 11:17:40.471854 [debug] [MainThread]: Acquiring new bigquery connection 'master'
[DEBUG] file_log: 11:17:40.472887 [debug] [ThreadPool]: Acquiring new bigquery connection 'list_dbt-test-env'
[DEBUG] file_log: 11:17:40.473272 [debug] [ThreadPool]: Opening a new connection, currently in state init
[DEBUG] file_log: 11:17:41.027906 [debug] [ThreadPool]: Re-using an available connection from the pool (formerly list_dbt-test-env, now list_dbt-test-env_test16788790535351041482_test_persist_docs)
[DEBUG] file_log: 11:17:41.028321 [debug] [ThreadPool]: Opening a new connection, currently in state closed
[INFO] stdout_log: 11:17:41  Concurrency: 1 threads (target='default')
[INFO] file_log: 11:17:41.377392 [info ] [MainThread]: Concurrency: 1 threads (target='default')
[INFO] stdout_log: 11:17:41  
[INFO] file_log: 11:17:41.377808 [info ] [MainThread]: 
[DEBUG] file_log: 11:17:41.392761 [debug] [Thread-225]: Began running node model.test.table_model_nested
[INFO] stdout_log: 11:17:41  1 of 2 START sql table model test16788790535351041482_test_persist_docs.table_model_nested  [RUN]
[INFO] file_log: 11:17:41.393190 [info ] [Thread-225]: 1 of 2 START sql table model test16788790535351041482_test_persist_docs.table_model_nested  [RUN]
[DEBUG] file_log: 11:17:41.393881 [debug] [Thread-225]: Re-using an available connection from the pool (formerly list_dbt-test-env_test16788790535351041482_test_persist_docs, now model.test.table_model_nested)
[DEBUG] file_log: 11:17:41.394110 [debug] [Thread-225]: Began compiling node model.test.table_model_nested
[DEBUG] file_log: 11:17:41.396906 [debug] [Thread-225]: Writing injected SQL for node "model.test.table_model_nested"
[DEBUG] file_log: 11:17:41.397362 [debug] [Thread-225]: Timing info for model.test.table_model_nested (compile): 2023-03-15 11:17:41.394260 => 2023-03-15 11:17:41.397305
[DEBUG] file_log: 11:17:41.397610 [debug] [Thread-225]: Began executing node model.test.table_model_nested
[DEBUG] file_log: 11:17:41.400281 [debug] [Thread-225]: Writing runtime sql for node "model.test.table_model_nested"
[DEBUG] file_log: 11:17:41.400710 [debug] [Thread-225]: Opening a new connection, currently in state closed
[DEBUG] file_log: 11:17:41.454436 [debug] [Thread-225]: On model.test.table_model_nested: /* {"app": "dbt", "dbt_version": "1.5.0b3", "profile_name": "test", "target_name": "default", "node_id": "model.test.table_model_nested"} */

  
    

    create or replace table `dbt-test-env`.`test16788790535351041482_test_persist_docs`.`table_model_nested`
      
    
    

    OPTIONS(
      description=""""""
    )
    as (
      
SELECT
    STRUCT(
        STRUCT(
            1 AS level_3_a,
            2 AS level_3_b
        ) AS level_2
    ) AS level_1
    );
  
[DEBUG] file_log: 11:17:44.056598 [debug] [Thread-225]: BigQuery adapter: https://console.cloud.google.com/bigquery?project=dbt-test-env&j=bq:US:3652b043-8a74-4719-9a34-ce17e7e374f7&page=queryresults
[DEBUG] file_log: 11:17:44.483726 [debug] [Thread-225]: Timing info for model.test.table_model_nested (execute): 2023-03-15 11:17:41.397759 => 2023-03-15 11:17:44.483632
Error:  stdout_log: 11:17:44  Unhandled error while executing target/run/test/models/table_model_nested.sql
400 PATCH https://bigquery.googleapis.com/bigquery/v2/projects/dbt-test-env/datasets/test16788790535351041482_test_persist_docs/tables/table_model_nested?prettyPrint=false: Policy tags can only be attached to a leaf field.
Error: og: 11:17:44.484519 [error] [Thread-225]: Unhandled error while executing target/run/test/models/table_model_nested.sql
400 PATCH https://bigquery.googleapis.com/bigquery/v2/projects/dbt-test-env/datasets/test16788790535351041482_test_persist_docs/tables/table_model_nested?prettyPrint=false: Policy tags can only be attached to a leaf field.
[DEBUG] file_log: 11:17:44.487580 [debug] [Thread-225]: Traceback (most recent call last):
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/task/base.py", line 387, in safe_run
    result = self.compile_and_execute(manifest, ctx)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/task/base.py", line 336, in compile_and_execute
    result = self.run(ctx.node, manifest)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/task/base.py", line 435, in run
    return self.execute(compiled_node, manifest)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/task/run.py", line 277, in execute
    result = MacroGenerator(
             ^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/clients/jinja.py", line 330, in __call__
    return self.call_macro(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/clients/jinja.py", line 257, in call_macro
    return macro(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 763, in __call__
    return self._invoke(arguments, autoescape)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 777, in _invoke
    rv = self._func(*arguments)
         ^^^^^^^^^^^^^^^^^^^^^^
  File "<template>", line 102, in macro
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/sandbox.py", line 393, in call
    return __context.call(__obj, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 298, in call
    return __obj(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/clients/jinja.py", line 330, in __call__
    return self.call_macro(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/clients/jinja.py", line 257, in call_macro
    return macro(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 763, in __call__
    return self._invoke(arguments, autoescape)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 777, in _invoke
    rv = self._func(*arguments)
         ^^^^^^^^^^^^^^^^^^^^^^
  File "<template>", line 26, in macro
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/sandbox.py", line 393, in call
    return __context.call(__obj, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 298, in call
    return __obj(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/clients/jinja.py", line 330, in __call__
    return self.call_macro(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/clients/jinja.py", line 257, in call_macro
    return macro(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 763, in __call__
    return self._invoke(arguments, autoescape)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 777, in _invoke
    rv = self._func(*arguments)
         ^^^^^^^^^^^^^^^^^^^^^^
  File "<template>", line 30, in macro
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/sandbox.py", line 393, in call
    return __context.call(__obj, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 298, in call
    return __obj(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/clients/jinja.py", line 330, in __call__
    return self.call_macro(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/clients/jinja.py", line 257, in call_macro
    return macro(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 763, in __call__
    return self._invoke(arguments, autoescape)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 777, in _invoke
    rv = self._func(*arguments)
         ^^^^^^^^^^^^^^^^^^^^^^
  File "<template>", line 22, in macro
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/sandbox.py", line 393, in call
    return __context.call(__obj, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 298, in call
    return __obj(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/clients/jinja.py", line 330, in __call__
    return self.call_macro(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/clients/jinja.py", line 257, in call_macro
    return macro(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 763, in __call__
    return self._invoke(arguments, autoescape)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 777, in _invoke
    rv = self._func(*arguments)
         ^^^^^^^^^^^^^^^^^^^^^^
  File "<template>", line 20, in macro
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/sandbox.py", line 393, in call
    return __context.call(__obj, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 298, in call
    return __obj(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/dbt/adapters/bigquery/impl.py", line 676, in update_columns
    conn.handle.update_table(new_table, ["schema"])
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/google/cloud/bigquery/client.py", line 1320, in update_table
    api_response = self._call_api(
                   ^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/google/cloud/bigquery/client.py", line 797, in _call_api
    return call()
           ^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/google/api_core/retry.py", line 349, in retry_wrapped_func
    return retry_target(
           ^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/google/api_core/retry.py", line 191, in retry_target
    return target()
           ^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/google/cloud/_http/__init__.py", line 494, in api_request
    raise exceptions.from_http_response(response)
google.api_core.exceptions.BadRequest: 400 PATCH https://bigquery.googleapis.com/bigquery/v2/projects/dbt-test-env/datasets/test16788790535351041482_test_persist_docs/tables/table_model_nested?prettyPrint=false: Policy tags can only be attached to a leaf field.

Error:  stdout_log: 11:17:44  1 of 2 ERROR creating sql table model test16788790535351041482_test_persist_docs.table_model_nested  [ERROR in 3.09s]
Error: og: 11:17:44.488093 [error] [Thread-225]: 1 of 2 ERROR creating sql table model test16788790535351041482_test_persist_docs.table_model_nested  [ERROR in 3.09s]
[DEBUG] file_log: 11:17:44.488450 [debug] [Thread-225]: Finished running node model.test.table_model_nested
[DEBUG] file_log: 11:17:44.488745 [debug] [Thread-225]: Began running node model.test.view_model_nested
[INFO] stdout_log: 11:17:44  2 of 2 START sql view model test16788790535351041482_test_persist_docs.view_model_nested  [RUN]
[INFO] file_log: 11:17:44.489515 [info ] [Thread-225]: 2 of 2 START sql view model test16788790535351041482_test_persist_docs.view_model_nested  [RUN]
[DEBUG] file_log: 11:17:44.490143 [debug] [Thread-225]: Re-using an available connection from the pool (formerly model.test.table_model_nested, now model.test.view_model_nested)
[DEBUG] file_log: 11:17:44.490362 [debug] [Thread-225]: Began compiling node model.test.view_model_nested
[DEBUG] file_log: 11:17:44.492903 [debug] [Thread-225]: Writing injected SQL for node "model.test.view_model_nested"
[DEBUG] file_log: 11:17:44.493273 [debug] [Thread-225]: Timing info for model.test.view_model_nested (compile): 2023-03-15 11:17:44.490506 => 2023-03-15 11:17:44.493217
[DEBUG] file_log: 11:17:44.493511 [debug] [Thread-225]: Began executing node model.test.view_model_nested
[DEBUG] file_log: 11:17:44.496510 [debug] [Thread-225]: Writing runtime sql for node "model.test.view_model_nested"
[DEBUG] file_log: 11:17:44.496870 [debug] [Thread-225]: Opening a new connection, currently in state closed
[DEBUG] file_log: 11:17:44.550394 [debug] [Thread-225]: On model.test.view_model_nested: /* {"app": "dbt", "dbt_version": "1.5.0b3", "profile_name": "test", "target_name": "default", "node_id": "model.test.view_model_nested"} */


  create or replace view `dbt-test-env`.`test16788790535351041482_test_persist_docs`.`view_model_nested`
  OPTIONS(
      description=""""""
    )
  
  as 
SELECT
    STRUCT(
        STRUCT(
            1 AS level_3_a,
            2 AS level_3_b
        ) AS level_2
    ) AS level_1;


[DEBUG] file_log: 11:17:45.232185 [debug] [Thread-225]: BigQuery adapter: https://console.cloud.google.com/bigquery?project=dbt-test-env&j=bq:US:4e4a5e79-32bd-412e-8ba4-9ef3ffe3aec5&page=queryresults
[DEBUG] file_log: 11:17:45.578594 [debug] [Thread-225]: Timing info for model.test.view_model_nested (execute): 2023-03-15 11:17:44.493896 => 2023-03-15 11:17:45.578497
Error:  stdout_log: 11:17:45  Unhandled error while executing target/run/test/models/view_model_nested.sql
400 PATCH https://bigquery.googleapis.com/bigquery/v2/projects/dbt-test-env/datasets/test16788790535351041482_test_persist_docs/tables/view_model_nested?prettyPrint=false: Policy tags can only be attached to a leaf field.
Error: og: 11:17:45.579343 [error] [Thread-225]: Unhandled error while executing target/run/test/models/view_model_nested.sql
400 PATCH https://bigquery.googleapis.com/bigquery/v2/projects/dbt-test-env/datasets/test16788790535351041482_test_persist_docs/tables/view_model_nested?prettyPrint=false: Policy tags can only be attached to a leaf field.
[DEBUG] file_log: 11:17:45.582811 [debug] [Thread-225]: Traceback (most recent call last):
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/task/base.py", line 387, in safe_run
    result = self.compile_and_execute(manifest, ctx)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/task/base.py", line 336, in compile_and_execute
    result = self.run(ctx.node, manifest)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/task/base.py", line 435, in run
    return self.execute(compiled_node, manifest)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/task/run.py", line 277, in execute
    result = MacroGenerator(
             ^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/clients/jinja.py", line 330, in __call__
    return self.call_macro(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/clients/jinja.py", line 257, in call_macro
    return macro(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 763, in __call__
    return self._invoke(arguments, autoescape)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 777, in _invoke
    rv = self._func(*arguments)
         ^^^^^^^^^^^^^^^^^^^^^^
  File "<template>", line 39, in macro
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/sandbox.py", line 393, in call
    return __context.call(__obj, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 298, in call
    return __obj(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/clients/jinja.py", line 330, in __call__
    return self.call_macro(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/clients/jinja.py", line 257, in call_macro
    return macro(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 763, in __call__
    return self._invoke(arguments, autoescape)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 777, in _invoke
    rv = self._func(*arguments)
         ^^^^^^^^^^^^^^^^^^^^^^
  File "<template>", line 26, in macro
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/sandbox.py", line 393, in call
    return __context.call(__obj, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 298, in call
    return __obj(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/clients/jinja.py", line 330, in __call__
    return self.call_macro(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/clients/jinja.py", line 257, in call_macro
    return macro(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 763, in __call__
    return self._invoke(arguments, autoescape)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 777, in _invoke
    rv = self._func(*arguments)
         ^^^^^^^^^^^^^^^^^^^^^^
  File "<template>", line 30, in macro
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/sandbox.py", line 393, in call
    return __context.call(__obj, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 298, in call
    return __obj(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/clients/jinja.py", line 330, in __call__
    return self.call_macro(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/clients/jinja.py", line 257, in call_macro
    return macro(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 763, in __call__
    return self._invoke(arguments, autoescape)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 777, in _invoke
    rv = self._func(*arguments)
         ^^^^^^^^^^^^^^^^^^^^^^
  File "<template>", line 22, in macro
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/sandbox.py", line 393, in call
    return __context.call(__obj, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 298, in call
    return __obj(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/clients/jinja.py", line 330, in __call__
    return self.call_macro(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/dbt/clients/jinja.py", line 257, in call_macro
    return macro(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 763, in __call__
    return self._invoke(arguments, autoescape)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 777, in _invoke
    rv = self._func(*arguments)
         ^^^^^^^^^^^^^^^^^^^^^^
  File "<template>", line 20, in macro
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/sandbox.py", line 393, in call
    return __context.call(__obj, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/jinja2/runtime.py", line 298, in call
    return __obj(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/dbt/adapters/bigquery/impl.py", line 676, in update_columns
    conn.handle.update_table(new_table, ["schema"])
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/google/cloud/bigquery/client.py", line 1320, in update_table
    api_response = self._call_api(
                   ^^^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/google/cloud/bigquery/client.py", line 797, in _call_api
    return call()
           ^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/google/api_core/retry.py", line 349, in retry_wrapped_func
    return retry_target(
           ^^^^^^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/google/api_core/retry.py", line 191, in retry_target
    return target()
           ^^^^^^^^
  File "/home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/google/cloud/_http/__init__.py", line 494, in api_request
    raise exceptions.from_http_response(response)
google.api_core.exceptions.BadRequest: 400 PATCH https://bigquery.googleapis.com/bigquery/v2/projects/dbt-test-env/datasets/test16788790535351041482_test_persist_docs/tables/view_model_nested?prettyPrint=false: Policy tags can only be attached to a leaf field.

Error:  stdout_log: 11:17:45  2 of 2 ERROR creating sql view model test16788790535351041482_test_persist_docs.view_model_nested  [ERROR in 1.09s]
Error: og: 11:17:45.583326 [error] [Thread-225]: 2 of 2 ERROR creating sql view model test16788790535351041482_test_persist_docs.view_model_nested  [ERROR in 1.09s]
[DEBUG] file_log: 11:17:45.583685 [debug] [Thread-225]: Finished running node model.test.view_model_nested
[DEBUG] file_log: 11:17:45.588252 [debug] [MainThread]: Connection 'master' was properly closed.
[DEBUG] file_log: 11:17:45.588494 [debug] [MainThread]: Connection 'model.test.view_model_nested' was properly closed.
[INFO] stdout_log: 11:17:45  
[INFO] file_log: 11:17:45.588702 [info ] [MainThread]: 
[INFO] stdout_log: 11:17:45  Finished running 1 table model, 1 view model in 0 hours 0 minutes and 5.12 seconds (5.12s).
[INFO] file_log: 11:17:45.588979 [info ] [MainThread]: Finished running 1 table model, 1 view model in 0 hours 0 minutes and 5.12 seconds (5.12s).
[DEBUG] file_log: 11:17:45.589368 [debug] [MainThread]: Command end result
[INFO] stdout_log: 11:17:45  
[INFO] file_log: 11:17:45.595150 [info ] [MainThread]: 
[INFO] stdout_log: 11:17:45  Completed with 2 errors and 0 warnings:
[INFO] file_log: 11:17:45.595586 [info ] [MainThread]: Completed with 2 errors and 0 warnings:
[INFO] stdout_log: 11:17:45  
[INFO] file_log: 11:17:45.595852 [info ] [MainThread]: 
Error:  stdout_log: 11:17:45  400 PATCH https://bigquery.googleapis.com/bigquery/v2/projects/dbt-test-env/datasets/test16788790535351041482_test_persist_docs/tables/table_model_nested?prettyPrint=false: Policy tags can only be attached to a leaf field.
Error: og: 11:17:45.596105 [error] [MainThread]: 400 PATCH https://bigquery.googleapis.com/bigquery/v2/projects/dbt-test-env/datasets/test16788790535351041482_test_persist_docs/tables/table_model_nested?prettyPrint=false: Policy tags can only be attached to a leaf field.
[INFO] stdout_log: 11:17:45  
[INFO] file_log: 11:17:45.596362 [info ] [MainThread]: 
Error:  stdout_log: 11:17:45  400 PATCH https://bigquery.googleapis.com/bigquery/v2/projects/dbt-test-env/datasets/test16788790535351041482_test_persist_docs/tables/view_model_nested?prettyPrint=false: Policy tags can only be attached to a leaf field.
Error: og: 11:17:45.596598 [error] [MainThread]: 400 PATCH https://bigquery.googleapis.com/bigquery/v2/projects/dbt-test-env/datasets/test16788790535351041482_test_persist_docs/tables/view_model_nested?prettyPrint=false: Policy tags can only be attached to a leaf field.
[INFO] stdout_log: 11:17:45  
[INFO] file_log: 11:17:45.596836 [info ] [MainThread]: 
[INFO] stdout_log: 11:17:45  Done. PASS=0 WARN=0 ERROR=2 SKIP=0 TOTAL=2
[INFO] file_log: 11:17:45.597080 [info ] [MainThread]: Done. PASS=0 WARN=0 ERROR=2 SKIP=0 TOTAL=2
[DEBUG] file_log: 11:17:45.597369 [debug] [MainThread]: Flushing usage events
=============================== warnings summary ===============================
.tox/integration-bigquery/lib/python3.11/site-packages/pkg_resources/__init__.py:2804: 36 warnings
  /home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/pkg_resources/__init__.py:2804: DeprecationWarning: Deprecated call to `pkg_resources.declare_namespace('google')`.
  Implementing implicit namespace packages (as specified in PEP 420) is preferred to `pkg_resources.declare_namespace`. See https://setuptools.pypa.io/en/latest/references/keywords.html#keyword-namespace-packages

.tox/integration-bigquery/lib/python3.11/site-packages/pkg_resources/__init__.py:2804: 16 warnings
  /home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/pkg_resources/__init__.py:2804: DeprecationWarning: Deprecated call to `pkg_resources.declare_namespace('google.cloud')`.
  Implementing implicit namespace packages (as specified in PEP 420) is preferred to `pkg_resources.declare_namespace`. See https://setuptools.pypa.io/en/latest/references/keywords.html#keyword-namespace-packages

.tox/integration-bigquery/lib/python3.11/site-packages/pkg_resources/__init__.py:2309: 16 warnings
  /home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/pkg_resources/__init__.py:2309: DeprecationWarning: Deprecated call to `pkg_resources.declare_namespace('google')`.
  Implementing implicit namespace packages (as specified in PEP 420) is preferred to `pkg_resources.declare_namespace`. See https://setuptools.pypa.io/en/latest/references/keywords.html#keyword-namespace-packages

.tox/integration-bigquery/lib/python3.11/site-packages/pkg_resources/__init__.py:2804
.tox/integration-bigquery/lib/python3.11/site-packages/pkg_resources/__init__.py:2804
.tox/integration-bigquery/lib/python3.11/site-packages/pkg_resources/__init__.py:2804
.tox/integration-bigquery/lib/python3.11/site-packages/pkg_resources/__init__.py:2804
  /home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/pkg_resources/__init__.py:2804: DeprecationWarning: Deprecated call to `pkg_resources.declare_namespace('google.logging')`.
  Implementing implicit namespace packages (as specified in PEP 420) is preferred to `pkg_resources.declare_namespace`. See https://setuptools.pypa.io/en/latest/references/keywords.html#keyword-namespace-packages

.tox/integration-bigquery/lib/python3.11/site-packages/pkg_resources/__init__.py:2804
.tox/integration-bigquery/lib/python3.11/site-packages/pkg_resources/__init__.py:2804
.tox/integration-bigquery/lib/python3.11/site-packages/pkg_resources/__init__.py:2804
.tox/integration-bigquery/lib/python3.11/site-packages/pkg_resources/__init__.py:2804
  /home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/pkg_resources/__init__.py:2804: DeprecationWarning: Deprecated call to `pkg_resources.declare_namespace('google.iam')`.
  Implementing implicit namespace packages (as specified in PEP 420) is preferred to `pkg_resources.declare_namespace`. See https://setuptools.pypa.io/en/latest/references/keywords.html#keyword-namespace-packages

.tox/integration-bigquery/lib/python3.11/site-packages/pkg_resources/__init__.py:2804
.tox/integration-bigquery/lib/python3.11/site-packages/pkg_resources/__init__.py:2804
.tox/integration-bigquery/lib/python3.11/site-packages/pkg_resources/__init__.py:2804
.tox/integration-bigquery/lib/python3.11/site-packages/pkg_resources/__init__.py:2804
  /home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/pkg_resources/__init__.py:2804: DeprecationWarning: Deprecated call to `pkg_resources.declare_namespace('ruamel')`.
  Implementing implicit namespace packages (as specified in PEP 420) is preferred to `pkg_resources.declare_namespace`. See https://setuptools.pypa.io/en/latest/references/keywords.html#keyword-namespace-packages

.tox/integration-bigquery/lib/python3.11/site-packages/google/rpc/__init__.py:20
.tox/integration-bigquery/lib/python3.11/site-packages/google/rpc/__init__.py:20
.tox/integration-bigquery/lib/python3.11/site-packages/google/rpc/__init__.py:20
.tox/integration-bigquery/lib/python3.11/site-packages/google/rpc/__init__.py:20
  /home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/google/rpc/__init__.py:20: DeprecationWarning: Deprecated call to `pkg_resources.declare_namespace('google.rpc')`.
  Implementing implicit namespace packages (as specified in PEP 420) is preferred to `pkg_resources.declare_namespace`. See https://setuptools.pypa.io/en/latest/references/keywords.html#keyword-namespace-packages

.tox/integration-bigquery/lib/python3.11/site-packages/google/cloud/storage/blob.py:21
.tox/integration-bigquery/lib/python3.11/site-packages/google/cloud/storage/blob.py:21
.tox/integration-bigquery/lib/python3.11/site-packages/google/cloud/storage/blob.py:21
.tox/integration-bigquery/lib/python3.11/site-packages/google/cloud/storage/blob.py:21
  /home/runner/work/dbt-bigquery/dbt-bigquery/.tox/integration-bigquery/lib/python3.11/site-packages/google/cloud/storage/blob.py:21: DeprecationWarning: 'cgi' is deprecated and slated for removal in Python 3.13

tests/functional/test_changing_partitions.py: 15 warnings
tests/functional/adapter/simple_bigquery_view/test_simple_bigquery_view.py: 3 warnings
  /home/runner/work/dbt-bigquery/dbt-bigquery/dbt/adapters/bigquery/impl.py:556: PendingDeprecationWarning: This method will be deprecated in future versions. Please use Table.time_partitioning.type_ instead.

-- Docs: https://docs.pytest.org/en/stable/how-to/capture-warnings.html
--------------------- CSV report: integration_results.csv ----------------------
=========================== short test summary info ============================
ERROR tests/functional/adapter/test_persist_docs.py::TestPersistDocsNested::test_persist_docs - AssertionError: dbt exit state did not match expected
====== 140 passed, 3 skipped, 106 warnings, 1 error in 695.69s (0:11:35) =======
integration-bigquery: exit 1 (698.42 seconds) /home/runner/work/dbt-bigquery/dbt-bigquery> .tox/integration-bigquery/bin/python -m pytest -vv tests/functional --profile service_account pid=2066
  integration-bigquery: FAIL code 1 (738.86=setup[40.44]+cmd[698.42] seconds)
  evaluation failed :( (738.91 seconds)
Error: Process completed with exit code 1.

Environment

- OS: all
- Python: all
- dbt-core: 1.5
- dbt-bigquery: 1.5

Additional Context

No response
@mikealfare mikealfare added type:bug Something isn't working triage:product labels Mar 15, 2023
@github-actions github-actions bot changed the title [Bug] Address failing test_persist_docs [ADAP-372] [Bug] Address failing test_persist_docs Mar 15, 2023
@VersusFacit VersusFacit mentioned this issue Mar 15, 2023
Merged
6 tasks
@VersusFacit VersusFacit self-assigned this Mar 15, 2023
@steve-marmalade steve-marmalade mentioned this issue Apr 28, 2023
Closed
2 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@VersusFacit VersusFacit

Labels
type:bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Remove checks on non-leaf-field tags since they no longer can exist. dbt-labs/dbt-bigquery
3 participants
@mikealfare @dbeatty10 @VersusFacit