search

dbt-labs / dbt-core

dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.
https://getdbt.com
Apache License 2.0
9.66k stars 1.6k forks source link

[CT-683] [Bug] 'dbt_utils' is undefined error despite it being in packages.yml + running clean / deps before compile #5294

Closed alexandrafetterman closed 2 years ago

alexandrafetterman commented 2 years ago

Is there an existing issue for this?

Current Behavior

My team is attempting to upgrade to dbt v1.0 and have been following this blog post. I've upgraded to dbt locally and systematically made necessary changes to the codebase (including updating dependency versions in packages.yml.

I've hit a wall in when I run dbt compile, I get the following error:

This happens after successfully running dbt clean and dbt deps.

❯ dbt clean; dbt deps
23:48:33  Running with dbt=1.0.4
23:48:33  Checking target/*
23:48:33  Cleaned target/*
23:48:33  Checking dbt_packages/*
23:48:33  Cleaned dbt_packages/*
23:48:33  Finished cleaning all paths.
23:48:36  Running with dbt=1.0.4
23:48:41  Installing calogica/dbt_expectations
23:48:43    Installed from version 0.5.6
23:48:43    Up to date!
23:48:43  Installing tnightengale/dbt_meta_testing
23:48:44    Installed from version 0.3.5
23:48:44    Up to date!
23:48:44  Installing dbt-labs/codegen
23:48:44    Installed from version 0.6.0
23:48:44    Up to date!
23:48:44  Installing calogica/dbt_date
23:48:44    Installed from version 0.5.7
23:48:44    Up to date!
23:48:44  Installing dbt-labs/dbt_utils
23:48:45    Installed from version 0.8.5
23:48:45    Up to date!
❯ dbt compile
23:49:38  Running with dbt=1.0.4
23:49:38  Partial parse save file not found. Starting full parse.
23:50:04  Encountered an error:
Compilation Error
  'dbt_utils' is undefined. This can happen when calling a macro that does not exist. Check for typos and/or install package dependencies with "dbt deps".

Expected Behavior

I expect to run dbt compile after correctly formatting the packages.yml file and not see a Complilation Error about dbt utils being undefined.

Steps To Reproduce

Use dbt version 1.0.4. packages.yml is formatted as follows:

packages:
  - package: dbt-labs/dbt_utils
    version: 0.8.5

  - package: calogica/dbt_expectations
    version: 0.5.6

  - package: tnightengale/dbt_meta_testing
    version: 0.3.5

  - package: dbt-labs/codegen
    version: 0.6.0

Run dbt clean; dbt deps; dbt compile. In our project, we get the error outlined in the first section. Perhaps it has to do with the partial parse piece?

Relevant log output

============================== 2022-05-24 00:01:54.937565 | 0172c458-0caf-4f86-926c-c83bd7e9e605 ==============================
00:01:54.937565 [info ] [MainThread]: Running with dbt=1.0.4
00:01:54.937946 [debug] [MainThread]: running dbt with arguments Namespace(record_timing_info=None, debug=None, log_format=None, write_json=None, use_colors=None, printer_width=None, warn_error=None, version_check=None, partial_parse=None, single_threaded=False, use_experimental_parser=None, static_parser=None, profiles_dir='/Users/alexandrafetterman/.dbt', send_anonymous_usage_stats=None, fail_fast=None, event_buffer_size=None, project_dir=None, profile=None, target=None, vars='{}', log_cache_events=False, parse_only=False, threads=None, select=None, exclude=None, selector_name=None, state=None, full_refresh=False, defer=None, cls=<class 'dbt.task.compile.CompileTask'>, which='compile', rpc_method='compile')
00:01:54.938113 [debug] [MainThread]: Tracking: tracking
00:01:54.954641 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'start', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x10cca8970>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x10ccc2310>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x10ccc2be0>]}
00:01:55.032942 [info ] [MainThread]: Partial parse save file not found. Starting full parse.
00:01:55.033304 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'partial_parser', 'label': '0172c458-0caf-4f86-926c-c83bd7e9e605', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x10cca1e20>]}

I also get static parser failed on modelX... followed by parser fallback to jinja rendering on modelX... in the logs following, but not clear how that's related to dbt_utils.

When I run dbt --debug --no-partial-parse compile I get the following after a host of static parser failed on modelX and parser fallback to jinja rendering on modelX outputs.

00:43:16.744884 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'end', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x11446ed30>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x115bda640>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x115dafbb0>]}
00:43:16.746092 [debug] [MainThread]: Flushing usage events
00:43:17.267494 [error] [MainThread]: Encountered an error:
Compilation Error
  'dbt_utils' is undefined. This can happen when calling a macro that does not exist. Check for typos and/or install package dependencies with "dbt deps".
00:43:17.271996 [debug] [MainThread]: Traceback (most recent call last):
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/clients/jinja.py", line 516, in catch_jinja
    yield
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/clients/jinja.py", line 548, in render_template
    return template.render(ctx)
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/clients/jinja.py", line 187, in render
    return self.environment.handle_exception()
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/jinja2/environment.py", line 832, in handle_exception
    reraise(*rewrite_traceback_stack(source=source))
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/jinja2/_compat.py", line 28, in reraise
    raise value.with_traceback(tb)
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/clients/jinja.py", line 138, in quoted_native_concat
    head = list(islice(nodes, 2))
  File "<template>", line 1, in top-level template code
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/jinja2/sandbox.py", line 407, in getattr
    value = getattr(obj, attribute)
jinja2.exceptions.UndefinedError: 'dbt_utils' is undefined

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/main.py", line 127, in main
    results, succeeded = handle_and_check(args)
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/main.py", line 192, in handle_and_check
    task, res = run_from_args(parsed)
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/main.py", line 246, in run_from_args
    results = task.run()
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/task/runnable.py", line 454, in run
    self._runtime_initialize()
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/task/runnable.py", line 156, in _runtime_initialize
    super()._runtime_initialize()
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/task/runnable.py", line 94, in _runtime_initialize
    self.load_manifest()
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/task/runnable.py", line 81, in load_manifest
    self.manifest = ManifestLoader.get_full_manifest(self.config)
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/parser/manifest.py", line 200, in get_full_manifest
    manifest = loader.load()
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/parser/manifest.py", line 345, in load
    self.parse_project(
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/parser/manifest.py", line 453, in parse_project
    parser.parse_file(block, dct=dct)
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/parser/schemas.py", line 510, in parse_file
    self.parse_tests(test_block)
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/parser/schemas.py", line 486, in parse_tests
    self.parse_column_tests(block, column)
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/parser/schemas.py", line 210, in parse_column_tests
    self.parse_test(block, test, column)
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/parser/schemas.py", line 482, in parse_test
    self.parse_node(block)
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/parser/schemas.py", line 420, in parse_node
    node = self._parse_generic_test(
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/parser/schemas.py", line 290, in _parse_generic_test
    builder = TestBuilder(
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/parser/generic_test_builders.py", line 245, in __init__
    value = get_rendered(value, render_ctx, native=True)
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/clients/jinja.py", line 597, in get_rendered
    return render_template(template, ctx, node)
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/clients/jinja.py", line 548, in render_template
    return template.render(ctx)
  File "/usr/local/Cellar/python@3.9/3.9.13/Frameworks/Python.framework/Versions/3.9/lib/python3.9/contextlib.py", line 137, in __exit__
    self.gen.throw(typ, value, traceback)
  File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/clients/jinja.py", line 521, in catch_jinja
    raise UndefinedMacroException(str(e), node) from e
dbt.exceptions.UndefinedMacroException: Compilation Error
  'dbt_utils' is undefined. This can happen when calling a macro that does not exist. Check for typos and/or install package dependencies with "dbt deps".

Environment

Your version of dbt is out of date! You can find instructions for upgrading here: https://docs.getdbt.com/docs/installation

Plugins:

What database are you using dbt with?

redshift

Additional Context

No response

jaypeedevlin commented 2 years ago

Slack thread where we're also trying to solve this issue

gshank commented 2 years ago

This is failing when trying to compile a generic test. My guess is that you are using tests from dbt_utils. Would it be possible to create a small test project with just the dbt_utils test that fails? That would make trying to recreate this much easer.

alexandrafetterman commented 2 years ago

@gshank Can you help me see where in the logs you're seeing which test is failing? I'm not seeing it and made sure to remove / replace all not_null_where, unique_where, and relationships_where tests from our schema.yml files before retesting...

alexandrafetterman commented 2 years ago

Update:

We had two custom generic tests, only one of which was being used. I temporarily removed the custom generic tests from the project and the reference to the test in the relevant schema.yml file, committed the changes, and I'm still getting the exact same error about dbt_utils.

Here are the logs from the last dbt clean; dbt deps; dbt compile

============================== 2022-05-24 20:47:43.561171 | 71219303-c0d0-4e05-b88e-f05146e2bb4b ==============================
20:47:43.561171 [info ] [MainThread]: Running with dbt=1.0.4
20:47:43.561564 [debug] [MainThread]: running dbt with arguments Namespace(record_timing_info=None, debug=None, log_format=None, write_json=None, use_colors=None, printer_width=None, warn_error=None, version_check=None, partial_parse=None, single_threaded=False, use_experimental_parser=None, static_parser=None, profiles_dir='/Users/alexandrafetterman/.dbt', send_anonymous_usage_stats=None, fail_fast=None, event_buffer_size=None, project_dir=None, profile=None, target=None, vars='{}', log_cache_events=False, parse_only=False, threads=None, select=None, exclude=None, selector_name=None, state=None, full_refresh=False, defer=None, cls=<class 'dbt.task.compile.CompileTask'>, which='compile', rpc_method='compile')
20:47:43.561751 [debug] [MainThread]: Tracking: tracking
20:47:43.573500 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'start', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x10faad7f0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x10faad640>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x10faad0d0>]}
20:47:43.643507 [info ] [MainThread]: Partial parse save file not found. Starting full parse.
20:47:43.643871 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'partial_parser', 'label': '71219303-c0d0-4e05-b88e-f05146e2bb4b', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x10fb155e0>]}
20:47:47.616779 [debug] [MainThread]: Parsing macros/graph/identify_permissive_schemas.sql
20:47:47.620288 [debug] [MainThread]: Parsing macros/graph/get_schemas_by_model_tag.sql
20:47:47.623331 [debug] [MainThread]: Parsing macros/graph/identify_sensitive_schemas.sql
20:47:47.623880 [debug] [MainThread]: Parsing macros/permissions/grant_select_on_permissive_schemas.sql
20:47:47.625118 [debug] [MainThread]: Parsing macros/permissions/revoke_select_on_sensitive_schemas.sql
20:47:47.626354 [debug] [MainThread]: Parsing macros/surveys/generate_survey_columns.sql
20:47:47.631456 [debug] [MainThread]: Parsing macros/surveys/generate_wide_torch_survey_results.sql
20:47:47.638174 [debug] [MainThread]: Parsing macros/surveys/get_torch_questions.sql
20:47:47.639160 [debug] [MainThread]: Parsing macros/surveys/get_torch_answer_options.sql
20:47:47.640011 [debug] [MainThread]: Parsing macros/surveys/generate_survey_documentation.sql
20:47:47.649281 [debug] [MainThread]: Parsing macros/aws/dbt_aws_billing/dbt_aws_billing_update_tag_mapping.sql
20:47:47.651280 [debug] [MainThread]: Parsing macros/aws/dbt_aws_billing/dbt_aws_billing_consolidate_sources.sql
20:47:47.653274 [debug] [MainThread]: Parsing macros/aws/dbt_aws_billing/dbt_aws_billing_update_cost_category_mapping.sql
20:47:47.655762 [debug] [MainThread]: Parsing macros/catalog.sql
20:47:47.667381 [debug] [MainThread]: Parsing macros/relations.sql
20:47:47.667912 [debug] [MainThread]: Parsing macros/adapters.sql
20:47:47.694821 [debug] [MainThread]: Parsing macros/materializations/snapshot_merge.sql
20:47:47.695660 [debug] [MainThread]: Parsing macros/catalog.sql
20:47:47.697650 [debug] [MainThread]: Parsing macros/relations.sql
20:47:47.698855 [debug] [MainThread]: Parsing macros/adapters.sql
20:47:47.719685 [debug] [MainThread]: Parsing macros/materializations/snapshot_merge.sql
20:47:47.721252 [debug] [MainThread]: Parsing macros/materializations/hooks.sql
20:47:47.724785 [debug] [MainThread]: Parsing macros/materializations/configs.sql
20:47:47.727046 [debug] [MainThread]: Parsing macros/materializations/snapshots/snapshot_merge.sql
20:47:47.728672 [debug] [MainThread]: Parsing macros/materializations/snapshots/strategies.sql
20:47:47.745265 [debug] [MainThread]: Parsing macros/materializations/snapshots/helpers.sql
20:47:47.756281 [debug] [MainThread]: Parsing macros/materializations/snapshots/snapshot.sql
20:47:47.767651 [debug] [MainThread]: Parsing macros/materializations/tests/test.sql
20:47:47.772144 [debug] [MainThread]: Parsing macros/materializations/tests/helpers.sql
20:47:47.773958 [debug] [MainThread]: Parsing macros/materializations/tests/where_subquery.sql
20:47:47.775641 [debug] [MainThread]: Parsing macros/materializations/models/incremental/column_helpers.sql
20:47:47.779941 [debug] [MainThread]: Parsing macros/materializations/models/incremental/merge.sql
20:47:47.791964 [debug] [MainThread]: Parsing macros/materializations/models/incremental/is_incremental.sql
20:47:47.793917 [debug] [MainThread]: Parsing macros/materializations/models/incremental/incremental.sql
20:47:47.805197 [debug] [MainThread]: Parsing macros/materializations/models/incremental/on_schema_change.sql
20:47:47.822513 [debug] [MainThread]: Parsing macros/materializations/models/table/table.sql
20:47:47.830537 [debug] [MainThread]: Parsing macros/materializations/models/table/create_table_as.sql
20:47:47.833701 [debug] [MainThread]: Parsing macros/materializations/models/view/view.sql
20:47:47.841676 [debug] [MainThread]: Parsing macros/materializations/models/view/helpers.sql
20:47:47.843249 [debug] [MainThread]: Parsing macros/materializations/models/view/create_or_replace_view.sql
20:47:47.846035 [debug] [MainThread]: Parsing macros/materializations/models/view/create_view_as.sql
20:47:47.848522 [debug] [MainThread]: Parsing macros/materializations/seeds/seed.sql
20:47:47.855502 [debug] [MainThread]: Parsing macros/materializations/seeds/helpers.sql
20:47:47.873065 [debug] [MainThread]: Parsing macros/get_custom_name/get_custom_alias.sql
20:47:47.874755 [debug] [MainThread]: Parsing macros/get_custom_name/get_custom_schema.sql
20:47:47.877005 [debug] [MainThread]: Parsing macros/get_custom_name/get_custom_database.sql
20:47:47.878431 [debug] [MainThread]: Parsing macros/generic_test_sql/relationships.sql
20:47:47.879239 [debug] [MainThread]: Parsing macros/generic_test_sql/not_null.sql
20:47:47.879764 [debug] [MainThread]: Parsing macros/generic_test_sql/unique.sql
20:47:47.880409 [debug] [MainThread]: Parsing macros/generic_test_sql/accepted_values.sql
20:47:47.881661 [debug] [MainThread]: Parsing macros/etc/statement.sql
20:47:47.885913 [debug] [MainThread]: Parsing macros/etc/datetime.sql
20:47:47.893821 [debug] [MainThread]: Parsing macros/adapters/schema.sql
20:47:47.895821 [debug] [MainThread]: Parsing macros/adapters/indexes.sql
20:47:47.898298 [debug] [MainThread]: Parsing macros/adapters/relation.sql
20:47:47.907330 [debug] [MainThread]: Parsing macros/adapters/freshness.sql
20:47:47.909976 [debug] [MainThread]: Parsing macros/adapters/persist_docs.sql
20:47:47.913979 [debug] [MainThread]: Parsing macros/adapters/metadata.sql
20:47:47.920687 [debug] [MainThread]: Parsing macros/adapters/columns.sql
20:47:47.929517 [debug] [MainThread]: Parsing tests/generic/builtin.sql
20:47:47.932339 [debug] [MainThread]: Parsing macros/cross_db_utils/except.sql
20:47:47.933336 [debug] [MainThread]: Parsing macros/cross_db_utils/replace.sql
20:47:47.934496 [debug] [MainThread]: Parsing macros/cross_db_utils/concat.sql
20:47:47.935547 [debug] [MainThread]: Parsing macros/cross_db_utils/datatypes.sql
20:47:47.941143 [debug] [MainThread]: Parsing macros/cross_db_utils/_is_relation.sql
20:47:47.942190 [debug] [MainThread]: Parsing macros/cross_db_utils/length.sql
20:47:47.943369 [debug] [MainThread]: Parsing macros/cross_db_utils/dateadd.sql
20:47:47.945942 [debug] [MainThread]: Parsing macros/cross_db_utils/intersect.sql
20:47:47.946917 [debug] [MainThread]: Parsing macros/cross_db_utils/escape_single_quotes.sql
20:47:47.948596 [debug] [MainThread]: Parsing macros/cross_db_utils/right.sql
20:47:47.950766 [debug] [MainThread]: Parsing macros/cross_db_utils/listagg.sql
20:47:47.958618 [debug] [MainThread]: Parsing macros/cross_db_utils/datediff.sql
20:47:47.967542 [debug] [MainThread]: Parsing macros/cross_db_utils/safe_cast.sql
20:47:47.969229 [debug] [MainThread]: Parsing macros/cross_db_utils/hash.sql
20:47:47.970523 [debug] [MainThread]: Parsing macros/cross_db_utils/cast_bool_to_text.sql
20:47:47.971831 [debug] [MainThread]: Parsing macros/cross_db_utils/identifier.sql
20:47:47.973334 [debug] [MainThread]: Parsing macros/cross_db_utils/any_value.sql
20:47:47.974507 [debug] [MainThread]: Parsing macros/cross_db_utils/position.sql
20:47:47.975921 [debug] [MainThread]: Parsing macros/cross_db_utils/literal.sql
20:47:47.976905 [debug] [MainThread]: Parsing macros/cross_db_utils/current_timestamp.sql
20:47:47.979993 [debug] [MainThread]: Parsing macros/cross_db_utils/width_bucket.sql
20:47:47.984657 [debug] [MainThread]: Parsing macros/cross_db_utils/bool_or.sql
20:47:47.986087 [debug] [MainThread]: Parsing macros/cross_db_utils/last_day.sql
20:47:47.989378 [debug] [MainThread]: Parsing macros/cross_db_utils/split_part.sql
20:47:47.995059 [debug] [MainThread]: Parsing macros/cross_db_utils/date_trunc.sql
20:47:47.996452 [debug] [MainThread]: Parsing macros/cross_db_utils/_is_ephemeral.sql
20:47:47.998187 [debug] [MainThread]: Parsing macros/materializations/insert_by_period_materialization.sql
20:47:48.019803 [debug] [MainThread]: Parsing macros/web/get_url_host.sql
20:47:48.021494 [debug] [MainThread]: Parsing macros/web/get_url_path.sql
20:47:48.023721 [debug] [MainThread]: Parsing macros/web/get_url_parameter.sql
20:47:48.025087 [debug] [MainThread]: Parsing macros/generic_tests/fewer_rows_than.sql
20:47:48.026535 [debug] [MainThread]: Parsing macros/generic_tests/equal_rowcount.sql
20:47:48.027950 [debug] [MainThread]: Parsing macros/generic_tests/relationships_where.sql
20:47:48.029865 [debug] [MainThread]: Parsing macros/generic_tests/recency.sql
20:47:48.031366 [debug] [MainThread]: Parsing macros/generic_tests/not_constant.sql
20:47:48.032447 [debug] [MainThread]: Parsing macros/generic_tests/accepted_range.sql
20:47:48.034642 [debug] [MainThread]: Parsing macros/generic_tests/not_accepted_values.sql
20:47:48.036461 [debug] [MainThread]: Parsing macros/generic_tests/test_unique_where.sql
20:47:48.037701 [debug] [MainThread]: Parsing macros/generic_tests/at_least_one.sql
20:47:48.038801 [debug] [MainThread]: Parsing macros/generic_tests/unique_combination_of_columns.sql
20:47:48.041232 [debug] [MainThread]: Parsing macros/generic_tests/cardinality_equality.sql
20:47:48.042961 [debug] [MainThread]: Parsing macros/generic_tests/expression_is_true.sql
20:47:48.044522 [debug] [MainThread]: Parsing macros/generic_tests/not_null_proportion.sql
20:47:48.046407 [debug] [MainThread]: Parsing macros/generic_tests/sequential_values.sql
20:47:48.048964 [debug] [MainThread]: Parsing macros/generic_tests/test_not_null_where.sql
20:47:48.050201 [debug] [MainThread]: Parsing macros/generic_tests/equality.sql
20:47:48.053230 [debug] [MainThread]: Parsing macros/generic_tests/mutually_exclusive_ranges.sql
20:47:48.060863 [debug] [MainThread]: Parsing macros/jinja_helpers/pretty_log_format.sql
20:47:48.061848 [debug] [MainThread]: Parsing macros/jinja_helpers/pretty_time.sql
20:47:48.062908 [debug] [MainThread]: Parsing macros/jinja_helpers/log_info.sql
20:47:48.063896 [debug] [MainThread]: Parsing macros/jinja_helpers/slugify.sql
20:47:48.064979 [debug] [MainThread]: Parsing macros/sql/date_spine.sql
20:47:48.068579 [debug] [MainThread]: Parsing macros/sql/nullcheck_table.sql
20:47:48.070279 [debug] [MainThread]: Parsing macros/sql/get_relations_by_pattern.sql
20:47:48.073204 [debug] [MainThread]: Parsing macros/sql/generate_series.sql
20:47:48.076852 [debug] [MainThread]: Parsing macros/sql/get_relations_by_prefix.sql
20:47:48.079775 [debug] [MainThread]: Parsing macros/sql/get_tables_by_prefix_sql.sql
20:47:48.081213 [debug] [MainThread]: Parsing macros/sql/star.sql
20:47:48.084049 [debug] [MainThread]: Parsing macros/sql/unpivot.sql
20:47:48.091067 [debug] [MainThread]: Parsing macros/sql/union.sql
20:47:48.100436 [debug] [MainThread]: Parsing macros/sql/groupby.sql
20:47:48.101614 [debug] [MainThread]: Parsing macros/sql/deduplicate.sql
20:47:48.107610 [debug] [MainThread]: Parsing macros/sql/surrogate_key.sql
20:47:48.110418 [debug] [MainThread]: Parsing macros/sql/safe_add.sql
20:47:48.111800 [debug] [MainThread]: Parsing macros/sql/nullcheck.sql
20:47:48.113161 [debug] [MainThread]: Parsing macros/sql/get_tables_by_pattern_sql.sql
20:47:48.118605 [debug] [MainThread]: Parsing macros/sql/get_column_values.sql
20:47:48.124249 [debug] [MainThread]: Parsing macros/sql/pivot.sql
20:47:48.127634 [debug] [MainThread]: Parsing macros/sql/get_filtered_columns_in_relation.sql
20:47:48.130038 [debug] [MainThread]: Parsing macros/sql/get_query_results_as_dict.sql
20:47:48.132038 [debug] [MainThread]: Parsing macros/sql/get_table_types_sql.sql
20:47:48.133395 [debug] [MainThread]: Parsing macros/sql/haversine_distance.sql
20:47:48.139516 [debug] [MainThread]: Parsing macros/fetch_configured_models.sql
20:47:48.145607 [debug] [MainThread]: Parsing macros/required_tests.sql
20:47:48.149685 [debug] [MainThread]: Parsing macros/required_docs.sql
20:47:48.152864 [debug] [MainThread]: Parsing macros/logger.sql
20:47:48.155675 [debug] [MainThread]: Parsing macros/utils/_get_meta_tests_namespace.sql
20:47:48.156889 [debug] [MainThread]: Parsing macros/utils/required_docs/validate_required_docs.sql
20:47:48.158407 [debug] [MainThread]: Parsing macros/utils/required_docs/evaluate_required_docs.sql
20:47:48.164944 [debug] [MainThread]: Parsing macros/utils/formatters/format_raise_error.sql
20:47:48.166178 [debug] [MainThread]: Parsing macros/utils/formatters/format_error_tests.sql
20:47:48.168008 [debug] [MainThread]: Parsing macros/utils/formatters/format_error_docs.sql
20:47:48.170010 [debug] [MainThread]: Parsing macros/utils/required_tests/evaluate_required_tests.sql
20:47:48.173279 [debug] [MainThread]: Parsing macros/utils/required_tests/validate_required_tests.sql
20:47:48.177540 [debug] [MainThread]: Parsing macros/utils/required_tests/get_regex_match_count.sql
20:47:48.179134 [debug] [MainThread]: Parsing macros/utils/required_tests/tests_per_model.sql
20:47:48.182644 [debug] [MainThread]: Parsing macros/utils/errors/error_required_docs.sql
20:47:48.185404 [debug] [MainThread]: Parsing macros/utils/errors/error_invalid_config_docs.sql
20:47:48.186555 [debug] [MainThread]: Parsing macros/utils/errors/error_required_tests.sql
20:47:48.187713 [debug] [MainThread]: Parsing macros/utils/errors/error_invalid_config_tests.sql
20:47:48.189496 [debug] [MainThread]: Parsing macros/generate_model_yaml.sql
20:47:48.192123 [debug] [MainThread]: Parsing macros/generate_base_model.sql
20:47:48.194505 [debug] [MainThread]: Parsing macros/generate_source.sql
20:47:48.200999 [debug] [MainThread]: Parsing macros/get_date_dimension.sql
20:47:48.223686 [debug] [MainThread]: Parsing macros/get_base_dates.sql
20:47:48.228335 [debug] [MainThread]: Parsing macros/fiscal_date/get_fiscal_year_dates.sql
20:47:48.232279 [debug] [MainThread]: Parsing macros/fiscal_date/get_fiscal_periods.sql
20:47:48.233835 [debug] [MainThread]: Parsing macros/calendar_date/tomorrow.sql
20:47:48.234411 [debug] [MainThread]: Parsing macros/calendar_date/next_week.sql
20:47:48.234920 [debug] [MainThread]: Parsing macros/calendar_date/next_month_name.sql
20:47:48.235561 [debug] [MainThread]: Parsing macros/calendar_date/next_month.sql
20:47:48.236080 [debug] [MainThread]: Parsing macros/calendar_date/day_name.sql
20:47:48.239245 [debug] [MainThread]: Parsing macros/calendar_date/to_unixtimestamp.sql
20:47:48.240757 [debug] [MainThread]: Parsing macros/calendar_date/n_days_away.sql
20:47:48.241531 [debug] [MainThread]: Parsing macros/calendar_date/week_start.sql
20:47:48.243921 [debug] [MainThread]: Parsing macros/calendar_date/iso_week_start.sql
20:47:48.246384 [debug] [MainThread]: Parsing macros/calendar_date/n_days_ago.sql
20:47:48.247328 [debug] [MainThread]: Parsing macros/calendar_date/last_week.sql
20:47:48.247836 [debug] [MainThread]: Parsing macros/calendar_date/now.sql
20:47:48.248377 [debug] [MainThread]: Parsing macros/calendar_date/periods_since.sql
20:47:48.249030 [debug] [MainThread]: Parsing macros/calendar_date/today.sql
20:47:48.249524 [debug] [MainThread]: Parsing macros/calendar_date/last_month.sql
20:47:48.250028 [debug] [MainThread]: Parsing macros/calendar_date/day_of_year.sql
20:47:48.251672 [debug] [MainThread]: Parsing macros/calendar_date/from_unixtimestamp.sql
20:47:48.256794 [debug] [MainThread]: Parsing macros/calendar_date/n_months_ago.sql
20:47:48.257658 [debug] [MainThread]: Parsing macros/calendar_date/date_part.sql
20:47:48.258907 [debug] [MainThread]: Parsing macros/calendar_date/n_weeks_away.sql
20:47:48.259742 [debug] [MainThread]: Parsing macros/calendar_date/day_of_month.sql
20:47:48.260676 [debug] [MainThread]: Parsing macros/calendar_date/yesterday.sql
20:47:48.261254 [debug] [MainThread]: Parsing macros/calendar_date/day_of_week.sql
20:47:48.267825 [debug] [MainThread]: Parsing macros/calendar_date/iso_week_end.sql
20:47:48.269960 [debug] [MainThread]: Parsing macros/calendar_date/n_weeks_ago.sql
20:47:48.271145 [debug] [MainThread]: Parsing macros/calendar_date/month_name.sql
20:47:48.273735 [debug] [MainThread]: Parsing macros/calendar_date/last_month_name.sql
20:47:48.274381 [debug] [MainThread]: Parsing macros/calendar_date/week_of_year.sql
20:47:48.275965 [debug] [MainThread]: Parsing macros/calendar_date/convert_timezone.sql
20:47:48.281030 [debug] [MainThread]: Parsing macros/calendar_date/n_months_away.sql
20:47:48.281852 [debug] [MainThread]: Parsing macros/calendar_date/iso_week_of_year.sql
20:47:48.284193 [debug] [MainThread]: Parsing macros/calendar_date/week_end.sql
20:47:48.286271 [debug] [MainThread]: Parsing macros/calendar_date/next_month_number.sql
20:47:48.287189 [debug] [MainThread]: Parsing macros/calendar_date/last_month_number.sql
20:47:48.287806 [debug] [MainThread]: Parsing macros/utils/datatypes.sql
20:47:48.289963 [debug] [MainThread]: Parsing macros/regex/regexp_instr.sql
20:47:48.292499 [debug] [MainThread]: Parsing macros/math/log_natural.sql
20:47:48.293814 [debug] [MainThread]: Parsing macros/math/rand.sql
20:47:48.295695 [debug] [MainThread]: Parsing macros/math/median.sql
20:47:48.296227 [debug] [MainThread]: Parsing macros/math/percentile_cont.sql
20:47:48.298079 [debug] [MainThread]: Parsing macros/schema_tests/_generalized/expression_between.sql
20:47:48.301425 [debug] [MainThread]: Parsing macros/schema_tests/_generalized/expression_is_true.sql
20:47:48.305129 [debug] [MainThread]: Parsing macros/schema_tests/_generalized/equal_expression.sql
20:47:48.317317 [debug] [MainThread]: Parsing macros/schema_tests/_generalized/_truth_expression.sql
20:47:48.318161 [debug] [MainThread]: Parsing macros/schema_tests/string_matching/expect_column_values_to_match_like_pattern.sql
20:47:48.319293 [debug] [MainThread]: Parsing macros/schema_tests/string_matching/expect_column_values_to_match_like_pattern_list.sql
20:47:48.321201 [debug] [MainThread]: Parsing macros/schema_tests/string_matching/expect_column_values_to_match_regex.sql
20:47:48.322389 [debug] [MainThread]: Parsing macros/schema_tests/string_matching/expect_column_value_lengths_to_equal.sql
20:47:48.323463 [debug] [MainThread]: Parsing macros/schema_tests/string_matching/expect_column_value_lengths_to_be_between.sql
20:47:48.324964 [debug] [MainThread]: Parsing macros/schema_tests/string_matching/expect_column_values_to_not_match_regex.sql
20:47:48.326145 [debug] [MainThread]: Parsing macros/schema_tests/string_matching/expect_column_values_to_not_match_regex_list.sql
20:47:48.328158 [debug] [MainThread]: Parsing macros/schema_tests/string_matching/expect_column_values_to_match_regex_list.sql
20:47:48.330035 [debug] [MainThread]: Parsing macros/schema_tests/string_matching/expect_column_values_to_not_match_like_pattern_list.sql
20:47:48.331949 [debug] [MainThread]: Parsing macros/schema_tests/string_matching/_get_like_pattern_expression.sql
20:47:48.332602 [debug] [MainThread]: Parsing macros/schema_tests/string_matching/expect_column_values_to_not_match_like_pattern.sql
20:47:48.333694 [debug] [MainThread]: Parsing macros/schema_tests/table_shape/expect_row_values_to_have_recent_data.sql
20:47:48.336831 [debug] [MainThread]: Parsing macros/schema_tests/table_shape/expect_table_columns_to_contain_set.sql
20:47:48.339098 [debug] [MainThread]: Parsing macros/schema_tests/table_shape/expect_table_row_count_to_equal_other_table.sql
20:47:48.339993 [debug] [MainThread]: Parsing macros/schema_tests/table_shape/expect_table_columns_to_not_contain_set.sql
20:47:48.342216 [debug] [MainThread]: Parsing macros/schema_tests/table_shape/expect_grouped_row_values_to_have_recent_data.sql
20:47:48.346043 [debug] [MainThread]: Parsing macros/schema_tests/table_shape/expect_column_to_exist.sql
20:47:48.348316 [debug] [MainThread]: Parsing macros/schema_tests/table_shape/expect_table_row_count_to_equal.sql
20:47:48.350546 [debug] [MainThread]: Parsing macros/schema_tests/table_shape/expect_table_row_count_to_be_between.sql
20:47:48.351988 [debug] [MainThread]: Parsing macros/schema_tests/table_shape/expect_table_row_count_to_equal_other_table_times_factor.sql
20:47:48.352757 [debug] [MainThread]: Parsing macros/schema_tests/table_shape/expect_table_columns_to_match_set.sql
20:47:48.355186 [debug] [MainThread]: Parsing macros/schema_tests/table_shape/_get_column_list.sql
20:47:48.356076 [debug] [MainThread]: Parsing macros/schema_tests/table_shape/expect_table_columns_to_match_ordered_list.sql
20:47:48.358741 [debug] [MainThread]: Parsing macros/schema_tests/table_shape/_list_intersect.sql
20:47:48.359684 [debug] [MainThread]: Parsing macros/schema_tests/table_shape/expect_table_column_count_to_equal_other_table.sql
20:47:48.360833 [debug] [MainThread]: Parsing macros/schema_tests/table_shape/expect_table_column_count_to_equal.sql
20:47:48.361695 [debug] [MainThread]: Parsing macros/schema_tests/table_shape/expect_table_column_count_to_be_between.sql
20:47:48.363622 [debug] [MainThread]: Parsing macros/schema_tests/column_values_basic/expect_column_values_to_not_be_in_set.sql
20:47:48.365342 [debug] [MainThread]: Parsing macros/schema_tests/column_values_basic/expect_column_values_to_be_in_set.sql
20:47:48.367101 [debug] [MainThread]: Parsing macros/schema_tests/column_values_basic/expect_column_values_to_be_increasing.sql
20:47:48.369887 [debug] [MainThread]: Parsing macros/schema_tests/column_values_basic/expect_column_values_to_be_null.sql
20:47:48.370861 [debug] [MainThread]: Parsing macros/schema_tests/column_values_basic/expect_column_values_to_be_unique.sql
20:47:48.371516 [debug] [MainThread]: Parsing macros/schema_tests/column_values_basic/expect_column_values_to_be_between.sql
20:47:48.372962 [debug] [MainThread]: Parsing macros/schema_tests/column_values_basic/expect_column_values_to_be_decreasing.sql
20:47:48.375222 [debug] [MainThread]: Parsing macros/schema_tests/column_values_basic/expect_column_values_to_be_in_type_list.sql
20:47:48.377358 [debug] [MainThread]: Parsing macros/schema_tests/column_values_basic/expect_column_values_to_be_of_type.sql
20:47:48.377972 [debug] [MainThread]: Parsing macros/schema_tests/column_values_basic/expect_column_values_to_have_consistent_casing.sql
20:47:48.378868 [debug] [MainThread]: Parsing macros/schema_tests/column_values_basic/expect_column_values_to_not_be_null.sql
20:47:48.379838 [debug] [MainThread]: Parsing macros/schema_tests/aggregate_functions/expect_column_min_to_be_between.sql
20:47:48.381439 [debug] [MainThread]: Parsing macros/schema_tests/aggregate_functions/expect_column_unique_value_count_to_be_between.sql
20:47:48.382954 [debug] [MainThread]: Parsing macros/schema_tests/aggregate_functions/expect_column_quantile_values_to_be_between.sql
20:47:48.384742 [debug] [MainThread]: Parsing macros/schema_tests/aggregate_functions/expect_column_median_to_be_between.sql
20:47:48.386315 [debug] [MainThread]: Parsing macros/schema_tests/aggregate_functions/expect_column_proportion_of_unique_values_to_be_between.sql
20:47:48.387941 [debug] [MainThread]: Parsing macros/schema_tests/aggregate_functions/expect_column_distinct_values_to_equal_set.sql
20:47:48.389676 [debug] [MainThread]: Parsing macros/schema_tests/aggregate_functions/expect_column_most_common_value_to_be_in_set.sql
20:47:48.394075 [debug] [MainThread]: Parsing macros/schema_tests/aggregate_functions/expect_column_distinct_values_to_contain_set.sql
20:47:48.395819 [debug] [MainThread]: Parsing macros/schema_tests/aggregate_functions/expect_column_distinct_count_to_equal.sql
20:47:48.397086 [debug] [MainThread]: Parsing macros/schema_tests/aggregate_functions/expect_column_sum_to_be_between.sql
20:47:48.398589 [debug] [MainThread]: Parsing macros/schema_tests/aggregate_functions/expect_column_stdev_to_be_between.sql
20:47:48.401826 [debug] [MainThread]: Parsing macros/schema_tests/aggregate_functions/expect_column_mean_to_be_between.sql
20:47:48.403333 [debug] [MainThread]: Parsing macros/schema_tests/aggregate_functions/expect_column_max_to_be_between.sql
20:47:48.404822 [debug] [MainThread]: Parsing macros/schema_tests/aggregate_functions/expect_column_distinct_count_to_be_greater_than.sql
20:47:48.406109 [debug] [MainThread]: Parsing macros/schema_tests/aggregate_functions/expect_column_distinct_values_to_be_in_set.sql
20:47:48.407824 [debug] [MainThread]: Parsing macros/schema_tests/aggregate_functions/expect_column_distinct_count_to_equal_other_table.sql
20:47:48.409381 [debug] [MainThread]: Parsing macros/schema_tests/distributional/expect_row_values_to_have_data_for_every_n_datepart.sql
20:47:48.416612 [debug] [MainThread]: Parsing macros/schema_tests/distributional/expect_column_values_to_be_within_n_moving_stdevs.sql
20:47:48.425135 [debug] [MainThread]: Parsing macros/schema_tests/distributional/expect_column_values_to_be_within_n_stdevs.sql
20:47:48.427905 [debug] [MainThread]: Parsing macros/schema_tests/multi-column/expect_select_column_values_to_be_unique_within_record.sql
20:47:48.433499 [debug] [MainThread]: Parsing macros/schema_tests/multi-column/expect_compound_columns_to_be_unique.sql
20:47:48.438507 [debug] [MainThread]: Parsing macros/schema_tests/multi-column/expect_multicolumn_sum_to_equal.sql
20:47:48.440172 [debug] [MainThread]: Parsing macros/schema_tests/multi-column/expect_column_pair_values_to_be_equal.sql
20:47:48.441390 [debug] [MainThread]: Parsing macros/schema_tests/multi-column/expect_column_pair_values_A_to_be_greater_than_B.sql
20:47:48.442778 [debug] [MainThread]: Parsing macros/schema_tests/multi-column/expect_column_pair_values_to_be_in_set.sql
20:47:49.013711 [debug] [MainThread]: 1699: static parser successfully parsed staging/technology/fct_service_metrics.sql
20:47:49.027848 [debug] [MainThread]: 1603: static parser failed on staging/technology/fct_saas_spend.sql
20:47:49.048098 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/technology/fct_saas_spend.sql
20:47:49.049426 [debug] [MainThread]: 1603: static parser failed on staging/technology/fct_support_ticket_statuses.sql
20:47:49.056060 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/technology/fct_support_ticket_statuses.sql
20:47:49.057322 [debug] [MainThread]: 1699: static parser successfully parsed staging/technology/dim_saas_products.sql
20:47:49.060047 [debug] [MainThread]: 1699: static parser successfully parsed staging/technology/fct_jira_releases.sql
20:47:49.062860 [debug] [MainThread]: 1699: static parser successfully parsed staging/technology/dim_support_tickets.sql
20:47:49.065519 [debug] [MainThread]: 1699: static parser successfully parsed staging/sales_and_marketing/dim_opportunity_products.sql
20:47:49.068264 [debug] [MainThread]: 1699: static parser successfully parsed staging/sales_and_marketing/fct_opportunity_clients.sql
20:47:49.070842 [debug] [MainThread]: 1699: static parser successfully parsed staging/sales_and_marketing/dim_accounts.sql
20:47:49.073016 [debug] [MainThread]: 1699: static parser successfully parsed staging/sales_and_marketing/dim_leads.sql
20:47:49.075330 [debug] [MainThread]: 1699: static parser successfully parsed staging/sales_and_marketing/dim_products.sql
20:47:49.077491 [debug] [MainThread]: 1699: static parser successfully parsed staging/sales_and_marketing/dim_opportunities.sql
20:47:49.080119 [debug] [MainThread]: 1699: static parser successfully parsed staging/sales_and_marketing/fct_renewals.sql
20:47:49.082349 [debug] [MainThread]: 1603: static parser failed on staging/product/fct_shelfware_users.sql
20:47:49.088957 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/fct_shelfware_users.sql
20:47:49.089958 [debug] [MainThread]: 1603: static parser failed on staging/product/dim_partnerships.sql
20:47:49.095327 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/dim_partnerships.sql
20:47:49.096384 [debug] [MainThread]: 1603: static parser failed on staging/product/dim_partnership_participants.sql
20:47:49.102715 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/dim_partnership_participants.sql
20:47:49.104278 [debug] [MainThread]: 1699: static parser successfully parsed staging/product/fct_coaches.sql
20:47:49.107229 [debug] [MainThread]: 1603: static parser failed on staging/product/fct_user_signins.sql
20:47:49.112287 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/fct_user_signins.sql
20:47:49.113353 [debug] [MainThread]: 1603: static parser failed on staging/product/fct_user_promoters_and_detractors.sql
20:47:49.122868 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/fct_user_promoters_and_detractors.sql
20:47:49.123920 [debug] [MainThread]: 1603: static parser failed on staging/product/fct_user_activation_events.sql
20:47:49.129013 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/fct_user_activation_events.sql
20:47:49.130000 [debug] [MainThread]: 1603: static parser failed on staging/product/fct_user_comments.sql
20:47:49.134674 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/fct_user_comments.sql
20:47:49.135758 [debug] [MainThread]: 1603: static parser failed on staging/product/fct_active_users.sql
20:47:49.142633 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/fct_active_users.sql
20:47:49.143833 [debug] [MainThread]: 1603: static parser failed on staging/product/fct_churned_users.sql
20:47:49.148937 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/fct_churned_users.sql
20:47:49.150002 [debug] [MainThread]: 1603: static parser failed on staging/product/fct_rematches.sql
20:47:49.156220 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/fct_rematches.sql
20:47:49.157298 [debug] [MainThread]: 1603: static parser failed on staging/product/fct_activations.sql
20:47:49.163765 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/fct_activations.sql
20:47:49.164811 [debug] [MainThread]: 1603: static parser failed on staging/product/fct_user_onboardings.sql
20:47:49.171424 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/fct_user_onboardings.sql
20:47:49.172628 [debug] [MainThread]: 1699: static parser successfully parsed staging/product/fct_user_sessions.sql
20:47:49.174995 [debug] [MainThread]: 1603: static parser failed on staging/product/fct_three_sixty_scores.sql
20:47:49.180121 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/fct_three_sixty_scores.sql
20:47:49.181204 [debug] [MainThread]: 1699: static parser successfully parsed staging/product/customers/dim_customers.sql
20:47:49.183499 [debug] [MainThread]: 1603: static parser failed on staging/product/torch/fct_goals_per_user.sql
20:47:49.188564 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/torch/fct_goals_per_user.sql
20:47:49.189570 [debug] [MainThread]: 1699: static parser successfully parsed staging/product/torch/dim_coach_matches.sql
20:47:49.191748 [debug] [MainThread]: 1699: static parser successfully parsed staging/product/torch/dim_engagements.sql
20:47:49.194141 [debug] [MainThread]: 1603: static parser failed on staging/product/torch/fct_rolling_session_completion.sql
20:47:49.199851 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/torch/fct_rolling_session_completion.sql
20:47:49.201007 [debug] [MainThread]: 1699: static parser successfully parsed staging/product/torch/fct_accepted_coach_recommendations.sql
20:47:49.203367 [debug] [MainThread]: 1699: static parser successfully parsed staging/product/torch/dim_learning_goals.sql
20:47:49.205538 [debug] [MainThread]: 1603: static parser failed on staging/product/torch/fct_coaching_seat_events.sql
20:47:49.212865 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/torch/fct_coaching_seat_events.sql
20:47:49.213872 [debug] [MainThread]: 1699: static parser successfully parsed staging/product/torch/dim_coach_recommendations.sql
20:47:49.216175 [debug] [MainThread]: 1603: static parser failed on staging/product/programs/fct_program_participants.sql
20:47:49.226587 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/programs/fct_program_participants.sql
20:47:49.227641 [debug] [MainThread]: 1603: static parser failed on staging/product/programs/dim_programs.sql
20:47:49.233195 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/programs/dim_programs.sql
20:47:49.234454 [debug] [MainThread]: 1603: static parser failed on staging/product/tasmania/fct_daily_user_program_activity.sql
20:47:49.239858 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/tasmania/fct_daily_user_program_activity.sql
20:47:49.240941 [debug] [MainThread]: 1603: static parser failed on staging/product/tasmania/fct_viewed_resources.sql
20:47:49.247936 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/tasmania/fct_viewed_resources.sql
20:47:49.249201 [debug] [MainThread]: 1603: static parser failed on staging/product/users/dim_users.sql
20:47:49.259045 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/users/dim_users.sql
20:47:49.260155 [debug] [MainThread]: 1603: static parser failed on staging/product/users/dim_users_v2.sql
20:47:49.266430 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/users/dim_users_v2.sql
20:47:49.267557 [debug] [MainThread]: 1699: static parser successfully parsed staging/product/users/dim_user_traits.sql
20:47:49.269806 [debug] [MainThread]: 1603: static parser failed on staging/product/users/intermediate/intm_segment_user_sessions.sql
20:47:49.278741 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/users/intermediate/intm_segment_user_sessions.sql
20:47:49.279743 [debug] [MainThread]: 1603: static parser failed on staging/product/users/intermediate/intm_tasmania_user_ethnicities.sql
20:47:49.284957 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/users/intermediate/intm_tasmania_user_ethnicities.sql
20:47:49.286404 [debug] [MainThread]: 1603: static parser failed on staging/product/users/intermediate/intm_torch_users.sql
20:47:49.294658 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/users/intermediate/intm_torch_users.sql
20:47:49.295904 [debug] [MainThread]: 1603: static parser failed on staging/product/users/intermediate/intm_users.sql
20:47:49.303177 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/users/intermediate/intm_users.sql
20:47:49.304297 [debug] [MainThread]: 1603: static parser failed on staging/product/users/intermediate/intm_tasmania_users.sql
20:47:49.310677 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/users/intermediate/intm_tasmania_users.sql
20:47:49.311720 [debug] [MainThread]: 1603: static parser failed on staging/product/goals_and_compentency/fct_user_goals.sql
20:47:49.319323 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/goals_and_compentency/fct_user_goals.sql
20:47:49.320414 [debug] [MainThread]: 1603: static parser failed on staging/product/goals_and_compentency/fct_user_goal_feedback.sql
20:47:49.330711 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/goals_and_compentency/fct_user_goal_feedback.sql
20:47:49.331703 [debug] [MainThread]: 1603: static parser failed on staging/product/goals_and_compentency/fct_user_goal_action_items.sql
20:47:49.337219 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/goals_and_compentency/fct_user_goal_action_items.sql
20:47:49.338225 [debug] [MainThread]: 1603: static parser failed on staging/product/goals_and_compentency/fct_user_focus_areas.sql
20:47:49.346171 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/goals_and_compentency/fct_user_focus_areas.sql
20:47:49.347465 [debug] [MainThread]: 1603: static parser failed on staging/product/goals_and_compentency/fct_user_skills.sql
20:47:49.354401 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/goals_and_compentency/fct_user_skills.sql
20:47:49.355436 [debug] [MainThread]: 1603: static parser failed on staging/product/surveys/fct_user_satisfaction.sql
20:47:49.364824 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/surveys/fct_user_satisfaction.sql
20:47:49.365827 [debug] [MainThread]: 1603: static parser failed on staging/product/surveys/fct_checkin_survey_results.sql
20:47:49.371016 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/surveys/fct_checkin_survey_results.sql
20:47:49.372006 [debug] [MainThread]: 1603: static parser failed on staging/product/surveys/fct_survey_groups.sql
20:47:49.377008 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/surveys/fct_survey_groups.sql
20:47:49.378067 [debug] [MainThread]: 1603: static parser failed on staging/product/surveys/dim_surveys.sql
20:47:49.382712 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/surveys/dim_surveys.sql
20:47:49.383722 [debug] [MainThread]: 1603: static parser failed on staging/product/surveys/fct_user_surveys.sql
20:47:49.433968 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/surveys/fct_user_surveys.sql
20:47:49.435598 [debug] [MainThread]: 1699: static parser successfully parsed staging/product/surveys/intermediate/intm_torch_satisfaction__filtered.sql
20:47:49.439032 [debug] [MainThread]: 1699: static parser successfully parsed staging/product/surveys/intermediate/intm_torch_promoters_and_detractors__filtered.sql
20:47:49.442102 [debug] [MainThread]: 1699: static parser successfully parsed staging/product/surveys/intermediate/intm_everwise_satisfaction__filtered.sql
20:47:49.445168 [debug] [MainThread]: 1699: static parser successfully parsed staging/product/surveys/intermediate/intm_everwise_promoters_and_detractors__filtered.sql
20:47:49.448465 [debug] [MainThread]: 1603: static parser failed on staging/product/meetings/fct_calendar_profiles.sql
20:47:49.456072 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/meetings/fct_calendar_profiles.sql
20:47:49.457512 [debug] [MainThread]: 1603: static parser failed on staging/product/meetings/fct_meeting_participant_events.sql
20:47:49.466767 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/meetings/fct_meeting_participant_events.sql
20:47:49.468358 [debug] [MainThread]: 1603: static parser failed on staging/product/meetings/fct_user_calendar_availability.sql
20:47:49.477324 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/meetings/fct_user_calendar_availability.sql
20:47:49.478731 [debug] [MainThread]: 1603: static parser failed on staging/product/meetings/dim_meetings.sql
20:47:49.489839 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/meetings/dim_meetings.sql
20:47:49.491275 [debug] [MainThread]: 1603: static parser failed on staging/product/meetings/fct_meeting_scheduling_events.sql
20:47:49.500303 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/meetings/fct_meeting_scheduling_events.sql
20:47:49.501709 [debug] [MainThread]: 1603: static parser failed on staging/product/meetings/fct_meeting_invitees.sql
20:47:49.513117 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/meetings/fct_meeting_invitees.sql
20:47:49.514567 [debug] [MainThread]: 1603: static parser failed on staging/product/meetings/fct_user_cronofy_ids.sql
20:47:49.522667 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/meetings/fct_user_cronofy_ids.sql
20:47:49.524002 [debug] [MainThread]: 1603: static parser failed on staging/product/meetings/fct_calendar_configurations.sql
20:47:49.532352 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/meetings/fct_calendar_configurations.sql
20:47:49.534064 [debug] [MainThread]: 1603: static parser failed on staging/product/meetings/fct_meeting_participants.sql
20:47:49.541803 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/meetings/fct_meeting_participants.sql
20:47:49.543186 [debug] [MainThread]: 1699: static parser successfully parsed staging/product/meetings/fct_meeting_rooms.sql
20:47:49.546108 [debug] [MainThread]: 1603: static parser failed on staging/product/meetings/intermediate/intm_tasmania_meetings_mapped.sql
20:47:49.553593 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/meetings/intermediate/intm_tasmania_meetings_mapped.sql
20:47:49.554981 [debug] [MainThread]: 1699: static parser successfully parsed staging/product/meetings/intermediate/intm_torch_meetings_mapped.sql
20:47:49.557901 [debug] [MainThread]: 1699: static parser successfully parsed staging/product/meetings/intermediate/intm_classified_participants.sql
20:47:49.560578 [debug] [MainThread]: 1603: static parser failed on staging/product/meetings/intermediate/intm_classified_rooms.sql
20:47:49.567464 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/product/meetings/intermediate/intm_classified_rooms.sql
20:47:49.569357 [debug] [MainThread]: 1603: static parser failed on staging/customer_experience/experience_management/fct_coaching_capacity.sql
20:47:49.578693 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/customer_experience/experience_management/fct_coaching_capacity.sql
20:47:49.580233 [debug] [MainThread]: 1603: static parser failed on staging/customer_experience/experience_management/fct_active_engagements.sql
20:47:49.587781 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/customer_experience/experience_management/fct_active_engagements.sql
20:47:49.589357 [debug] [MainThread]: 1603: static parser failed on staging/customer_experience/experience_management/fct_onboarding_queue.sql
20:47:49.596985 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/customer_experience/experience_management/fct_onboarding_queue.sql
20:47:49.598457 [debug] [MainThread]: 1699: static parser successfully parsed staging/customer_experience/experience_management/dim_clients.sql
20:47:49.601425 [debug] [MainThread]: 1699: static parser successfully parsed staging/customer_experience/experience_management/fct_client_stages.sql
20:47:49.604182 [debug] [MainThread]: 1603: static parser failed on staging/customer_experience/experience_management/intermediate/intm_torchapp_userstages__merged.sql
20:47:49.614141 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/customer_experience/experience_management/intermediate/intm_torchapp_userstages__merged.sql
20:47:49.615412 [debug] [MainThread]: 1603: static parser failed on staging/customer_experience/experience_management/intermediate/intm_all_userstages__merged.sql
20:47:49.621925 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/customer_experience/experience_management/intermediate/intm_all_userstages__merged.sql
20:47:49.623202 [debug] [MainThread]: 1603: static parser failed on staging/customer_experience/experience_management/intermediate/intm_torch_salesforce_email__mapped.sql
20:47:49.631453 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/customer_experience/experience_management/intermediate/intm_torch_salesforce_email__mapped.sql
20:47:49.632842 [debug] [MainThread]: 1699: static parser successfully parsed staging/customer_experience/experience_management/intermediate/intm_salesforce_client_stages__compressed.sql
20:47:49.635714 [debug] [MainThread]: 1603: static parser failed on staging/customer_experience/customer_success/fct_user_satisfaction_and_adoption.sql
20:47:49.644551 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/customer_experience/customer_success/fct_user_satisfaction_and_adoption.sql
20:47:49.645998 [debug] [MainThread]: 1603: static parser failed on staging/customer_experience/customer_success/fct_pilot_cohort_groups.sql
20:47:49.653270 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/customer_experience/customer_success/fct_pilot_cohort_groups.sql
20:47:49.654765 [debug] [MainThread]: 1603: static parser failed on staging/customer_experience/customer_success/fct_user_enrollment.sql
20:47:49.661856 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/customer_experience/customer_success/fct_user_enrollment.sql
20:47:49.663048 [debug] [MainThread]: 1603: static parser failed on staging/customer_experience/coaching_operations/fct_coach_tiers.sql
20:47:49.670619 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/customer_experience/coaching_operations/fct_coach_tiers.sql
20:47:49.671945 [debug] [MainThread]: 1603: static parser failed on staging/customer_experience/coaching_operations/fct_active_coaches.sql
20:47:49.679591 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/customer_experience/coaching_operations/fct_active_coaches.sql
20:47:49.680965 [debug] [MainThread]: 1699: static parser successfully parsed staging/customer_experience/coaching_operations/fct_first_engagement_three_sixties.sql
20:47:49.683838 [debug] [MainThread]: 1603: static parser failed on staging/customer_experience/coaching_operations/fct_coach_satisfaction_scores.sql
20:47:49.690233 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/customer_experience/coaching_operations/fct_coach_satisfaction_scores.sql
20:47:49.691561 [debug] [MainThread]: 1699: static parser successfully parsed staging/customer_experience/coaching_operations/fct_coach_net_promoter_scores.sql
20:47:49.694455 [debug] [MainThread]: 1699: static parser successfully parsed staging/customer_experience/coaching_operations/fct_learning_goal_creation.sql
20:47:49.697433 [debug] [MainThread]: 1603: static parser failed on staging/customer_experience/coaching_operations/fct_session_completion_by_coach.sql
20:47:49.704558 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/customer_experience/coaching_operations/fct_session_completion_by_coach.sql
20:47:49.705895 [debug] [MainThread]: 1603: static parser failed on staging/finance/fct_growth_accounting.sql
20:47:49.714301 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/finance/fct_growth_accounting.sql
20:47:49.715858 [debug] [MainThread]: 1699: static parser successfully parsed staging/finance/fct_monthly_customer_acquisitions.sql
20:47:49.718606 [debug] [MainThread]: 1603: static parser failed on staging/finance/fct_average_customer_lifetimes.sql
20:47:49.724088 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/finance/fct_average_customer_lifetimes.sql
20:47:49.725674 [debug] [MainThread]: 1603: static parser failed on staging/finance/fct_monthly_revenues.sql
20:47:49.734303 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/finance/fct_monthly_revenues.sql
20:47:49.735741 [debug] [MainThread]: 1699: static parser successfully parsed staging/finance/fct_customer_lifetime_values.sql
20:47:49.739339 [debug] [MainThread]: 1699: static parser successfully parsed staging/finance/fct_seat_report_invoices.sql
20:47:49.742344 [debug] [MainThread]: 1699: static parser successfully parsed staging/finance/fct_annual_contracts.sql
20:47:49.745120 [debug] [MainThread]: 1699: static parser successfully parsed staging/finance/fct_customer_acquisitions.sql
20:47:49.748699 [debug] [MainThread]: 1699: static parser successfully parsed staging/finance/fct_monthly_customer_lifetime_values.sql
20:47:49.751766 [debug] [MainThread]: 1603: static parser failed on staging/finance/customer_economics/fct_customer_cogs.sql
20:47:49.758811 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/finance/customer_economics/fct_customer_cogs.sql
20:47:49.760585 [debug] [MainThread]: 1603: static parser failed on staging/finance/customer_economics/intermediate/intm_customer_experience_cogs.sql
20:47:49.769744 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/finance/customer_economics/intermediate/intm_customer_experience_cogs.sql
20:47:49.770958 [debug] [MainThread]: 1603: static parser failed on staging/finance/customer_economics/intermediate/intm_coaching_cogs.sql
20:47:49.777162 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/finance/customer_economics/intermediate/intm_coaching_cogs.sql
20:47:49.778671 [debug] [MainThread]: 1699: static parser successfully parsed staging/engineering/jira/fct_triage_requests.sql
20:47:49.781833 [debug] [MainThread]: 1699: static parser successfully parsed staging/engineering/jira/dim_jira_sprints.sql
20:47:49.784773 [debug] [MainThread]: 1699: static parser successfully parsed staging/engineering/jira/dim_jira_issue_sprints.sql
20:47:49.787745 [debug] [MainThread]: 1699: static parser successfully parsed staging/engineering/jira/fct_merged_issues.sql
20:47:49.790455 [debug] [MainThread]: 1699: static parser successfully parsed staging/engineering/jira/fct_started_issues.sql
20:47:49.793168 [debug] [MainThread]: 1603: static parser failed on staging/engineering/jira/dim_jira_issues.sql
20:47:49.799992 [debug] [MainThread]: 1602: parser fallback to jinja rendering on staging/engineering/jira/dim_jira_issues.sql
20:47:49.801286 [debug] [MainThread]: 1699: static parser successfully parsed staging/engineering/github/dim_pull_requests.sql
20:47:49.803724 [debug] [MainThread]: 1699: static parser successfully parsed staging/engineering/aws/fct_aws_cost_and_usage_line_items.sql
20:47:49.806157 [debug] [MainThread]: 1699: static parser successfully parsed sources/da_community_survey/da_community_survey_results.sql
20:47:49.808693 [debug] [MainThread]: 1699: static parser successfully parsed sources/revenue_recognition/revenue_recognition_annual_contracts.sql
20:47:49.811123 [debug] [MainThread]: 1699: static parser successfully parsed sources/finance_dashboard/finance_closed_months.sql
20:47:49.813501 [debug] [MainThread]: 1699: static parser successfully parsed sources/finance_dashboard/finance_dashboard_revenue_details.sql
20:47:49.816051 [debug] [MainThread]: 1699: static parser successfully parsed sources/finance_dashboard/finance_dashboard_summary.sql
20:47:49.818332 [debug] [MainThread]: 1699: static parser successfully parsed sources/finance_dashboard/finance_dashboard_coaching_unit_economics.sql
20:47:49.820893 [debug] [MainThread]: 1603: static parser failed on sources/segment/pages/segment_pages.sql
20:47:49.827288 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/segment/pages/segment_pages.sql
20:47:49.828298 [debug] [MainThread]: 1603: static parser failed on sources/cronofy/cronofy_daily_availability.sql
20:47:49.833201 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/cronofy/cronofy_daily_availability.sql
20:47:49.834226 [debug] [MainThread]: 1603: static parser failed on sources/torch/torch_client_history/torch_client_history.sql
20:47:49.839552 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/torch/torch_client_history/torch_client_history.sql
20:47:49.840621 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_form_responses/torch_form_responses.sql
20:47:49.842659 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_user_third_party_settings/torch_user_third_party_settings.sql
20:47:49.845163 [debug] [MainThread]: 1603: static parser failed on sources/torch/torch_subscriptions/torch_subscriptions.sql
20:47:49.850505 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/torch/torch_subscriptions/torch_subscriptions.sql
20:47:49.851503 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_session_network_quality/torch_session_network_quality.sql
20:47:49.853828 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_questions/torch_answer_options.sql
20:47:49.855891 [debug] [MainThread]: 1603: static parser failed on sources/torch/torch_questions/torch_questions.sql
20:47:49.862052 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/torch/torch_questions/torch_questions.sql
20:47:49.863076 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_success_metrics/torch_success_metrics.sql
20:47:49.866262 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_transactions/torch_transactions.sql
20:47:49.868303 [debug] [MainThread]: 1603: static parser failed on sources/torch/torch_coach_match_history/torch_coach_match_history.sql
20:47:49.873169 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/torch/torch_coach_match_history/torch_coach_match_history.sql
20:47:49.874132 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_coach_sessions/torch_coach_sessions.sql
20:47:49.876149 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_products/torch_products.sql
20:47:49.878275 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_tracks/torch_tracks.sql
20:47:49.880494 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_user_authentications/torch_user_authentications.sql
20:47:49.882513 [debug] [MainThread]: 1603: static parser failed on sources/torch/torch_invitation_history/torch_invitation_history.sql
20:47:49.887292 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/torch/torch_invitation_history/torch_invitation_history.sql
20:47:49.888248 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_domains/torch_domains.sql
20:47:49.890442 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_user_ethnicities/torch_user_ethnicities.sql
20:47:49.892443 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_forms/torch_forms.sql
20:47:49.894513 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_user_roles/torch_user_roles.sql
20:47:49.896773 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_user_history/torch_internal_users.sql
20:47:49.898826 [debug] [MainThread]: 1603: static parser failed on sources/torch/torch_user_history/torch_user_history.sql
20:47:49.903718 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/torch/torch_user_history/torch_user_history.sql
20:47:49.904747 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_goals/torch_goals.sql
20:47:49.906949 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_action_items/torch_action_items.sql
20:47:49.908924 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_organizations/torch_organizations.sql
20:47:49.911217 [debug] [MainThread]: 1603: static parser failed on sources/torch/torch_survey_responses/torch_survey_responses.sql
20:47:49.920031 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/torch/torch_survey_responses/torch_survey_responses.sql
20:47:49.920985 [debug] [MainThread]: 1603: static parser failed on sources/torch/torch_user_attribute_history/torch_user_attribute_history.sql
20:47:49.925492 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/torch/torch_user_attribute_history/torch_user_attribute_history.sql
20:47:49.926410 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_client_relationships/torch_client_relationships.sql
20:47:49.928807 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_feedback_requests/torch_feedback_requests.sql
20:47:49.930992 [debug] [MainThread]: 1603: static parser failed on sources/torch/torch_coach_recommendation_history/torch_coach_recommendation_history.sql
20:47:49.935656 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/torch/torch_coach_recommendation_history/torch_coach_recommendation_history.sql
20:47:49.936794 [debug] [MainThread]: 1603: static parser failed on sources/torch/torch_engagement_history/torch_engagement_stages.sql
20:47:49.941993 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/torch/torch_engagement_history/torch_engagement_stages.sql
20:47:49.942999 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_engagement_history/torch_engagement_history.sql
20:47:49.945437 [debug] [MainThread]: 1603: static parser failed on sources/torch/torch_engagement_history/intermediate/intm_torch_engagement_history__raw.sql
20:47:49.951293 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/torch/torch_engagement_history/intermediate/intm_torch_engagement_history__raw.sql
20:47:49.952221 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_form_response_groups/torch_form_response_groups.sql
20:47:49.954173 [debug] [MainThread]: 1699: static parser successfully parsed sources/torch/torch_seat_report/torch_seat_report.sql
20:47:49.956464 [debug] [MainThread]: 1699: static parser successfully parsed sources/quickbooks/quickbooks_purchase_items.sql
20:47:49.958602 [debug] [MainThread]: 1603: static parser failed on sources/quickbooks/quickbooks_profits_and_losses.sql
20:47:49.963379 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/quickbooks/quickbooks_profits_and_losses.sql
20:47:49.964499 [debug] [MainThread]: 1699: static parser successfully parsed sources/quickbooks/quickbooks_journal_items.sql
20:47:49.966833 [debug] [MainThread]: 1603: static parser failed on sources/quickbooks/quickbooks_transactions.sql
20:47:49.976077 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/quickbooks/quickbooks_transactions.sql
20:47:49.977365 [debug] [MainThread]: 1699: static parser successfully parsed sources/quickbooks/quickbooks_customers.sql
20:47:49.979670 [debug] [MainThread]: 1699: static parser successfully parsed sources/quickbooks/quickbooks_bill_items.sql
20:47:49.981738 [debug] [MainThread]: 1603: static parser failed on sources/common/days.sql
20:47:50.007874 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/common/days.sql
20:47:50.008850 [debug] [MainThread]: 1603: static parser failed on sources/common/days_year_ahead.sql
20:47:50.013141 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/common/days_year_ahead.sql
20:47:50.014497 [debug] [MainThread]: 1699: static parser successfully parsed sources/common/fiscal_quarters.sql
20:47:50.016679 [debug] [MainThread]: 1699: static parser successfully parsed sources/jira/jira_issue_transitions.sql
20:47:50.018914 [debug] [MainThread]: 1699: static parser successfully parsed sources/jira/jira_issue_changes.sql
20:47:50.021221 [debug] [MainThread]: 1699: static parser successfully parsed sources/jira/jira_issue_moves.sql
20:47:50.023572 [debug] [MainThread]: 1603: static parser failed on sources/jira/jira_response_support_cycles.sql
20:47:50.028480 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/jira/jira_response_support_cycles.sql
20:47:50.029510 [debug] [MainThread]: 1699: static parser successfully parsed sources/jira/jira_issues.sql
20:47:50.031881 [debug] [MainThread]: 1603: static parser failed on sources/jira/jira_issue_labels.sql
20:47:50.036299 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/jira/jira_issue_labels.sql
20:47:50.037438 [debug] [MainThread]: 1699: static parser successfully parsed sources/jira/jira_versions.sql
20:47:50.039786 [debug] [MainThread]: 1603: static parser failed on sources/jira/jira_issue_sprints.sql
20:47:50.045569 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/jira/jira_issue_sprints.sql
20:47:50.046602 [debug] [MainThread]: 1603: static parser failed on sources/jira/jira_resolution_support_cycles.sql
20:47:50.051454 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/jira/jira_resolution_support_cycles.sql
20:47:50.052396 [debug] [MainThread]: 1699: static parser successfully parsed sources/github/github_pull_requests.sql
20:47:50.054369 [debug] [MainThread]: 1699: static parser successfully parsed sources/datadog/datadog_data_points/datadog_data_points.sql
20:47:50.056336 [debug] [MainThread]: 1699: static parser successfully parsed sources/datadog/datadog_queries/datadog_queries.sql
20:47:50.058718 [debug] [MainThread]: 1699: static parser successfully parsed sources/salesforce/salesforce_users.sql
20:47:50.060990 [debug] [MainThread]: 1699: static parser successfully parsed sources/salesforce/salesforce_leads.sql
20:47:50.063106 [debug] [MainThread]: 1699: static parser successfully parsed sources/salesforce/salesforce_products.sql
20:47:50.065724 [debug] [MainThread]: 1699: static parser successfully parsed sources/salesforce/salesforce_opportunity_products.sql
20:47:50.068369 [debug] [MainThread]: 1699: static parser successfully parsed sources/salesforce/salesforce_opportunities.sql
20:47:50.070578 [debug] [MainThread]: 1603: static parser failed on sources/salesforce/salesforce_csm_history.sql
20:47:50.075857 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/salesforce/salesforce_csm_history.sql
20:47:50.077035 [debug] [MainThread]: 1699: static parser successfully parsed sources/salesforce/salesforce_accounts.sql
20:47:50.079171 [debug] [MainThread]: 1699: static parser successfully parsed sources/salesforce/salesforce_clients.sql
20:47:50.081612 [debug] [MainThread]: 1699: static parser successfully parsed sources/salesforce/salesforce_deal_groups.sql
20:47:50.084408 [debug] [MainThread]: 1603: static parser failed on sources/salesforce/salesforce_client_history.sql
20:47:50.089788 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/salesforce/salesforce_client_history.sql
20:47:50.091025 [debug] [MainThread]: 1603: static parser failed on sources/salesforce/intermediate/intm_object_id__mapped.sql
20:47:50.096448 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/salesforce/intermediate/intm_object_id__mapped.sql
20:47:50.097739 [debug] [MainThread]: 1603: static parser failed on sources/salesforce/intermediate/intm_salesforce_client_history__inferred.sql
20:47:50.103258 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/salesforce/intermediate/intm_salesforce_client_history__inferred.sql
20:47:50.104417 [debug] [MainThread]: 1603: static parser failed on sources/aws/aws_cost_and_usage/aws_cost_and_usage.sql
20:47:50.114571 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/aws/aws_cost_and_usage/aws_cost_and_usage.sql
20:47:50.115805 [debug] [MainThread]: 1699: static parser successfully parsed sources/sales_targets_and_quotas/sales_pipeline_targets/sales_pipeline_targets.sql
20:47:50.117846 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/everwise_instances.sql
20:47:50.119818 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/everwise_partnerships.sql
20:47:50.122048 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/everwise_user_events.sql
20:47:50.124264 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/everwise_match_proposal_status_changes.sql
20:47:50.126247 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/everwise_teachers.sql
20:47:50.128338 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/everwise_user_fields.sql
20:47:50.131018 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/everwise_students.sql
20:47:50.133227 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/everwise_pages.sql
20:47:50.135209 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/everwise_form_groups.sql
20:47:50.137547 [debug] [MainThread]: 1603: static parser failed on sources/everwise/everwise_user_checkins.sql
20:47:50.145643 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/everwise/everwise_user_checkins.sql
20:47:50.146869 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/everwise_match_proposals.sql
20:47:50.149331 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/everwise_user_activation_events.sql
20:47:50.151314 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/everwise_user_form_groups.sql
20:47:50.153297 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/snippets/everwise_snippets.sql
20:47:50.155799 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/attendees/everwise_attendees.sql
20:47:50.158065 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/user_authentications/everwise_user_authentications.sql
20:47:50.160063 [debug] [MainThread]: 1603: static parser failed on sources/everwise/user_roles/everwise_user_roles.sql
20:47:50.165758 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/everwise/user_roles/everwise_user_roles.sql
20:47:50.166747 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/comments/everwise_comments.sql
20:47:50.168727 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/calendars/everwise_calendars.sql
20:47:50.170704 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/session_events/everwise_session_events.sql
20:47:50.173067 [debug] [MainThread]: 1603: static parser failed on sources/everwise/discussions/everwise_discussion_collaborators.sql
20:47:50.177588 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/everwise/discussions/everwise_discussion_collaborators.sql
20:47:50.178539 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/discussions/everwise_discussions.sql
20:47:50.181309 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/program_templates/everwise_program_templates.sql
20:47:50.183492 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/meeting_templates/everwise_meeting_templates.sql
20:47:50.185445 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/user_skills/everwise_user_skills.sql
20:47:50.187465 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/scheduling_events/everwise_scheduling_events.sql
20:47:50.190342 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/session_allotment_entries/everwise_session_allotments.sql
20:47:50.192291 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/user_goals/everwise_user_goals.sql
20:47:50.194242 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/spaces/everwise_spaces.sql
20:47:50.196791 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/paths/everwise_paths.sql
20:47:50.199758 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/user_group_paths/everwise_user_group_paths.sql
20:47:50.201711 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/line_items/everwise_line_items.sql
20:47:50.203693 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/calendar_profiles/everwise_calendar_profiles.sql
20:47:50.206181 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/tenants/everwise_tenants.sql
20:47:50.208152 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/matching_lists/everwise_matching_lists.sql
20:47:50.210137 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/matching_list_profiles/everwise_matching_list_profiles.sql
20:47:50.212453 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/programs/everwise_programs.sql
20:47:50.214532 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/focus_areas/everwise_focus_areas.sql
20:47:50.216529 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/matching_statuses/everwise_matching_statuses.sql
20:47:50.218514 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/matching_profiles/everwise_matching_profiles.sql
20:47:50.220857 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/user_calendars/everwise_user_calendars.sql
20:47:50.222878 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/user_group_path_sections/everwise_user_group_path_sections.sql
20:47:50.224971 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/users/everwise_users.sql
20:47:50.227174 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/user_traits/everwise_traits.sql
20:47:50.229336 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/user_traits/everwise_user_trait_history.sql
20:47:50.231358 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/program_participants/everwise_program_participants.sql
20:47:50.233361 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/fields/everwise_fields.sql
20:47:50.235533 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/fields/everwise_field_types.sql
20:47:50.237702 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/space_users/everwise_space_users.sql
20:47:50.239707 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/members/everwise_members.sql
20:47:50.241910 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/skills/everwise_skills.sql
20:47:50.243897 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/user_login_history/everwise_user_login_history.sql
20:47:50.246163 [debug] [MainThread]: 1603: static parser failed on sources/everwise/user_login_history/everwise_logins_by_program_type.sql
20:47:50.251832 [debug] [MainThread]: 1602: parser fallback to jinja rendering on sources/everwise/user_login_history/everwise_logins_by_program_type.sql
20:47:50.252838 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/meetings/everwise_meetings.sql
20:47:50.255040 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/program_paths/everwise_program_paths.sql
20:47:50.257221 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/group_paths/everwise_group_paths.sql
20:47:50.259436 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/session_details/everwise_session_details.sql
20:47:50.261571 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/program_cohorts/everwise_program_cohorts.sql
20:47:50.264055 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/checkin_survey_results/everwise_checkin_survey_results.sql
20:47:50.266752 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/user_resources/everwise_user_resources.sql
20:47:50.269156 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/calendar_managers/everwise_calendar_managers.sql
20:47:50.271774 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/user_group_path_resources/everwise_user_group_path_resources.sql
20:47:50.274754 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/user_group_path_resources/everwise_insights_path_level_resource_interactions.sql
20:47:50.277116 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/user_group_path_resources/everwise_meeting_resources.sql
20:47:50.279886 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/manager_employees/everwise_manager_employees.sql
20:47:50.282681 [debug] [MainThread]: 1699: static parser successfully parsed sources/everwise/partnership_checkins/everwise_partnership_checkins.sql
20:47:50.285412 [debug] [MainThread]: 1699: static parser successfully parsed sources/linkedin/linkedin_positions/linkedin_positions.sql
20:47:50.287991 [debug] [MainThread]: 1699: static parser successfully parsed sources/linkedin/linkedin_education/linkedin_education.sql
20:47:50.290327 [debug] [MainThread]: 1699: static parser successfully parsed sources/linkedin/linkedin_profiles/linkedin_profiles.sql
20:47:50.292975 [debug] [MainThread]: 1699: static parser successfully parsed sources/twilio/twilio_participants/twilio_participants.sql
20:47:50.295578 [debug] [MainThread]: 1699: static parser successfully parsed sources/twilio/twilio_rooms/twilio_rooms.sql
20:47:50.297992 [debug] [MainThread]: 1603: static parser failed on analytics/customers/cartus/cartus_customer.sql
20:47:50.309572 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/customers/cartus/cartus_customer.sql
20:47:50.311275 [debug] [MainThread]: 1603: static parser failed on analytics/customers/cartus/cartus_supplier.sql
20:47:50.322467 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/customers/cartus/cartus_supplier.sql
20:47:50.323661 [debug] [MainThread]: 1603: static parser failed on analytics/customers/cartus/intermediate/intm_cartus_user_field_responses.sql
20:47:50.329760 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/customers/cartus/intermediate/intm_cartus_user_field_responses.sql
20:47:50.331037 [debug] [MainThread]: 1603: static parser failed on analytics/behavioral_science/demographics/user_demographics.sql
20:47:50.339607 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/behavioral_science/demographics/user_demographics.sql
20:47:50.340988 [debug] [MainThread]: 1603: static parser failed on analytics/behavioral_science/engagement/coaching_product_engagement.sql
20:47:50.353734 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/behavioral_science/engagement/coaching_product_engagement.sql
20:47:50.354969 [debug] [MainThread]: 1699: static parser successfully parsed analytics/behavioral_science/goals_and_compentency/user_goals.sql
20:47:50.357399 [debug] [MainThread]: 1699: static parser successfully parsed analytics/behavioral_science/goals_and_compentency/user_focus_areas.sql
20:47:50.360154 [debug] [MainThread]: 1699: static parser successfully parsed analytics/behavioral_science/goals_and_compentency/user_skills.sql
20:47:50.362889 [debug] [MainThread]: 1699: static parser successfully parsed analytics/behavioral_science/goals_and_compentency/user_goal_feedback.sql
20:47:50.365436 [debug] [MainThread]: 1699: static parser successfully parsed analytics/behavioral_science/linkedin_profiles/linkedin_position_history.sql
20:47:50.368239 [debug] [MainThread]: 1603: static parser failed on analytics/behavioral_science/linkedin_profiles/intermediate/intm_profile_urls__mapped.sql
20:47:50.376273 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/behavioral_science/linkedin_profiles/intermediate/intm_profile_urls__mapped.sql
20:47:50.377526 [debug] [MainThread]: 1603: static parser failed on analytics/behavioral_science/surveys/coach_experience_results/coach_experience_results.sql
20:47:50.403791 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/behavioral_science/surveys/coach_experience_results/coach_experience_results.sql
20:47:50.404937 [debug] [MainThread]: 1603: static parser failed on analytics/behavioral_science/surveys/coaching_outlook_results/coaching_outlook_results.sql
20:47:50.411623 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/behavioral_science/surveys/coaching_outlook_results/coaching_outlook_results.sql
20:47:50.412820 [debug] [MainThread]: 1603: static parser failed on analytics/behavioral_science/surveys/authentic_leadership_v1_results/authentic_leadership_v1_results.sql
20:47:50.418922 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/behavioral_science/surveys/authentic_leadership_v1_results/authentic_leadership_v1_results.sql
20:47:50.420208 [debug] [MainThread]: 1603: static parser failed on analytics/behavioral_science/surveys/coach_matching_v2_results/coach_matching_v2_results.sql
20:47:50.426370 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/behavioral_science/surveys/coach_matching_v2_results/coach_matching_v2_results.sql
20:47:50.427549 [debug] [MainThread]: 1603: static parser failed on analytics/behavioral_science/surveys/authentic_leadership_v2_results/authentic_leadership_v2_results.sql
20:47:50.433549 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/behavioral_science/surveys/authentic_leadership_v2_results/authentic_leadership_v2_results.sql
20:47:50.435085 [debug] [MainThread]: 1603: static parser failed on analytics/behavioral_science/surveys/personality_results/personality_results.sql
20:47:50.442121 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/behavioral_science/surveys/personality_results/personality_results.sql
20:47:50.443316 [debug] [MainThread]: 1699: static parser successfully parsed analytics/behavioral_science/surveys/assessment_questions/assessment_questions.sql
20:47:50.446019 [debug] [MainThread]: 1603: static parser failed on analytics/behavioral_science/surveys/authentic_leadership_v2_multisurvey_results/authentic_leadership_v2_multisurvey_results.sql
20:47:50.453222 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/behavioral_science/surveys/authentic_leadership_v2_multisurvey_results/authentic_leadership_v2_multisurvey_results.sql
20:47:50.454459 [debug] [MainThread]: 1603: static parser failed on analytics/behavioral_science/surveys/coach_matching_results/coach_matching_results.sql
20:47:50.460226 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/behavioral_science/surveys/coach_matching_results/coach_matching_results.sql
20:47:50.461399 [debug] [MainThread]: 1603: static parser failed on analytics/behavioral_science/surveys/coach_session_follow_up_results/coach_session_follow_up_results.sql
20:47:50.467592 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/behavioral_science/surveys/coach_session_follow_up_results/coach_session_follow_up_results.sql
20:47:50.469076 [debug] [MainThread]: 1699: static parser successfully parsed analytics/sales_operations/historical_pipeline.sql
20:47:50.471886 [debug] [MainThread]: 1603: static parser failed on analytics/sales_operations/weekly_generated_pipeline.sql
20:47:50.480416 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/sales_operations/weekly_generated_pipeline.sql
20:47:50.481685 [debug] [MainThread]: 1699: static parser successfully parsed analytics/sales_operations/salesforce_opportunity_history.sql
20:47:50.485067 [debug] [MainThread]: 1699: static parser successfully parsed analytics/sales_operations/intermediate/intm_generated_pipeline.sql
20:47:50.487699 [debug] [MainThread]: 1699: static parser successfully parsed analytics/core/meetings.sql
20:47:50.490389 [debug] [MainThread]: 1699: static parser successfully parsed analytics/experience_management/clients/clients.sql
20:47:50.493476 [debug] [MainThread]: 1699: static parser successfully parsed analytics/experience_management/client_queue/client_queue.sql
20:47:50.496169 [debug] [MainThread]: 1699: static parser successfully parsed analytics/experience_management/client_queue/prolonged_coach_matching.sql
20:47:50.499377 [debug] [MainThread]: 1699: static parser successfully parsed analytics/experience_management/onboarding_queue/onboarding_queue.sql
20:47:50.502614 [debug] [MainThread]: 1699: static parser successfully parsed analytics/experience_management/coach_calendar_availability/coach_calendar_availability.sql
20:47:50.505637 [debug] [MainThread]: 1699: static parser successfully parsed analytics/experience_management/coaching_capacity/coaching_capacity.sql
20:47:50.508433 [debug] [MainThread]: 1699: static parser successfully parsed analytics/experience_management/support_tickets/support_tickets_cx.sql
20:47:50.511023 [debug] [MainThread]: 1699: static parser successfully parsed analytics/experience_management/torch_user_id_emails/torch_user_id_emails.sql
20:47:50.515196 [debug] [MainThread]: 1699: static parser successfully parsed analytics/experience_management/torch_user_id_emails/intermediate/intm_all_torch_user_id_emails.sql
20:47:50.518685 [debug] [MainThread]: 1699: static parser successfully parsed analytics/product_health/learning/learning_daily_user_program_activity.sql
20:47:50.521636 [debug] [MainThread]: 1699: static parser successfully parsed analytics/product_health/shared/nps.sql
20:47:50.524558 [debug] [MainThread]: 1699: static parser successfully parsed analytics/product_health/shared/user_retention_shelfware.sql
20:47:50.527575 [debug] [MainThread]: 1603: static parser failed on analytics/product_health/shared/meeting_disruptions.sql
20:47:50.534773 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/product_health/shared/meeting_disruptions.sql
20:47:50.536585 [debug] [MainThread]: 1699: static parser successfully parsed analytics/product_health/shared/user_retention_churn.sql
20:47:50.539586 [debug] [MainThread]: 1603: static parser failed on analytics/product_health/shared/participant_meeting_quality.sql
20:47:50.549903 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/product_health/shared/participant_meeting_quality.sql
20:47:50.551277 [debug] [MainThread]: 1603: static parser failed on analytics/product_health/shared/program_participants.sql
20:47:50.559526 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/product_health/shared/program_participants.sql
20:47:50.561084 [debug] [MainThread]: 1603: static parser failed on analytics/product_health/shared/user_growth.sql
20:47:50.568089 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/product_health/shared/user_growth.sql
20:47:50.569456 [debug] [MainThread]: 1699: static parser successfully parsed analytics/product_health/shared/daily_active_users.sql
20:47:50.572070 [debug] [MainThread]: 1699: static parser successfully parsed analytics/product_health/shared/user_sessions.sql
20:47:50.574607 [debug] [MainThread]: 1699: static parser successfully parsed analytics/product_health/shared/program_templates/program_template_usage.sql
20:47:50.577299 [debug] [MainThread]: 1699: static parser successfully parsed analytics/product_health/shared/meetings/meeting_rsvps.sql
20:47:50.579834 [debug] [MainThread]: 1603: static parser failed on analytics/product_health/shared/meetings/calendar_sync_adoption.sql
20:47:50.587238 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/product_health/shared/meetings/calendar_sync_adoption.sql
20:47:50.588741 [debug] [MainThread]: 1699: static parser successfully parsed analytics/product_health/shared/meetings/daily_scheduled_meetings_by_configuration.sql
20:47:50.591605 [debug] [MainThread]: 1699: static parser successfully parsed analytics/product_health/shared/meetings/meeting_scheduling_flows.sql
20:47:50.594144 [debug] [MainThread]: 1603: static parser failed on analytics/product_health/shared/meetings/meeting_adoption.sql
20:47:50.601349 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/product_health/shared/meetings/meeting_adoption.sql
20:47:50.602646 [debug] [MainThread]: 1603: static parser failed on analytics/product_health/shared/meetings/daily_scheduled_meetings.sql
20:47:50.610424 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/product_health/shared/meetings/daily_scheduled_meetings.sql
20:47:50.611840 [debug] [MainThread]: 1603: static parser failed on analytics/product_health/shared/meetings/intermediate/intm_program_meetings__daily.sql
20:47:50.619607 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/product_health/shared/meetings/intermediate/intm_program_meetings__daily.sql
20:47:50.620988 [debug] [MainThread]: 1603: static parser failed on analytics/product_health/shared/meetings/intermediate/intm_program_participants__daily.sql
20:47:50.626805 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/product_health/shared/meetings/intermediate/intm_program_participants__daily.sql
20:47:50.627969 [debug] [MainThread]: 1699: static parser successfully parsed analytics/product_health/coaching/onboarding_funnel.sql
20:47:50.630379 [debug] [MainThread]: 1699: static parser successfully parsed analytics/product_health/coaching/three_sixty_scores.sql
20:47:50.633132 [debug] [MainThread]: 1603: static parser failed on analytics/product_health/coaching/daily_user_assessments.sql
20:47:50.639651 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/product_health/coaching/daily_user_assessments.sql
20:47:50.640843 [debug] [MainThread]: 1603: static parser failed on analytics/product_health/coaching/coaching_daily_sessions_per_seat.sql
20:47:50.647766 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/product_health/coaching/coaching_daily_sessions_per_seat.sql
20:47:50.649002 [debug] [MainThread]: 1699: static parser successfully parsed analytics/product_health/coaching/coach_recommendations.sql
20:47:50.651372 [debug] [MainThread]: 1699: static parser successfully parsed analytics/product_health/coaching/accepted_coach_recommendations.sql
20:47:50.705569 [debug] [MainThread]: 1699: static parser successfully parsed analytics/product_health/coaching/coaching_learning_goals.sql
20:47:50.708985 [debug] [MainThread]: 1699: static parser successfully parsed analytics/product_health/coaching/coaching_learning_goals_per_user.sql
20:47:50.712601 [debug] [MainThread]: 1699: static parser successfully parsed analytics/product_health/mentoring/mentoring_daily_user_program_activity.sql
20:47:50.715857 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/technology/service_metrics.sql
20:47:50.719241 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/technology/releases.sql
20:47:50.722414 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/technology/support_ticket_statuses.sql
20:47:50.725784 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/technology/aws_costs.sql
20:47:50.729034 [debug] [MainThread]: 1603: static parser failed on analytics/kpis/technology/support_tickets.sql
20:47:50.739172 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/kpis/technology/support_tickets.sql
20:47:50.740707 [debug] [MainThread]: 1603: static parser failed on analytics/kpis/technology/monthly_employee_count.sql
20:47:50.747384 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/kpis/technology/monthly_employee_count.sql
20:47:50.748856 [debug] [MainThread]: 1603: static parser failed on analytics/kpis/technology/monthly_saas_spend.sql
20:47:50.755953 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/kpis/technology/monthly_saas_spend.sql
20:47:50.757526 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/marketing/mql_contributions_to_revenue.sql
20:47:50.760515 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/marketing/mql_to_customer_conversions.sql
20:47:50.763554 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/marketing/raw_lead_to_mql_conversions.sql
20:47:50.766373 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/marketing/mql_contributions_to_pipeline.sql
20:47:50.770087 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/marketing/customer_acquisition_cost.sql
20:47:50.774350 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/marketing/mql_to_sal_conversions.sql
20:47:50.777257 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/finance/customer_acquisitions.sql
20:47:50.779918 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/finance/monthly_customer_lifetime_values.sql
20:47:50.782596 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/finance/monthly_customer_acquisitions.sql
20:47:50.786162 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/finance/revenue_details.sql
20:47:50.789264 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/finance/summary.sql
20:47:50.792212 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/finance/coaching_unit_economics.sql
20:47:50.795146 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/finance/customer_lifetime_values.sql
20:47:50.797769 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/finance/annual_contracts.sql
20:47:50.801003 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/finance/cohort_retention.sql
20:47:50.804200 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/finance/growth_accounting.sql
20:47:50.806966 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/finance/monthly_revenues.sql
20:47:50.810032 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/customer_success/net_seats.sql
20:47:50.812686 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/customer_success/session_completion.sql
20:47:50.815550 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/customer_success/net_promoter_scores.sql
20:47:50.818675 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/customer_success/satisfaction.sql
20:47:50.821362 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/customer_success/activations.sql
20:47:50.824528 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/customer_success/rematches.sql
20:47:50.827238 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/customer_success/renewals.sql
20:47:50.829881 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/customer_success/net_revenue.sql
20:47:50.833165 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/engineering/pull_requests.sql
20:47:50.836091 [debug] [MainThread]: 1699: static parser successfully parsed analytics/kpis/engineering/completed_issues.sql
20:47:50.838918 [debug] [MainThread]: 1699: static parser successfully parsed analytics/finance/seat_report_invoices.sql
20:47:50.841827 [debug] [MainThread]: 1699: static parser successfully parsed analytics/finance/customer_cost.sql
20:47:50.844561 [debug] [MainThread]: 1603: static parser failed on analytics/customer_success/cohort_match_progress.sql
20:47:50.850839 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/customer_success/cohort_match_progress.sql
20:47:50.852172 [debug] [MainThread]: 1603: static parser failed on analytics/customer_success/pilot_cohort_enrollment.sql
20:47:50.860013 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/customer_success/pilot_cohort_enrollment.sql
20:47:50.861437 [debug] [MainThread]: 1699: static parser successfully parsed analytics/customer_success/pilot_qualitative_feedback.sql
20:47:50.864005 [debug] [MainThread]: 1603: static parser failed on analytics/customer_success/pilot_user_satisfaction_and_adoption.sql
20:47:50.871638 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/customer_success/pilot_user_satisfaction_and_adoption.sql
20:47:50.873253 [debug] [MainThread]: 1699: static parser successfully parsed analytics/revenue/contracts/contract_opportunity_products.sql
20:47:50.876114 [debug] [MainThread]: 1603: static parser failed on analytics/revenue/monthly_customer_total_booking_value/monthly_customer_total_booking_value.sql
20:47:50.883252 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/revenue/monthly_customer_total_booking_value/monthly_customer_total_booking_value.sql
20:47:50.884522 [debug] [MainThread]: 1699: static parser successfully parsed analytics/coaching_operations/session_completion_by_coach.sql
20:47:50.887038 [debug] [MainThread]: 1699: static parser successfully parsed analytics/coaching_operations/coach_tiers.sql
20:47:50.889926 [debug] [MainThread]: 1603: static parser failed on analytics/coaching_operations/coach_economics.sql
20:47:50.897301 [debug] [MainThread]: 1602: parser fallback to jinja rendering on analytics/coaching_operations/coach_economics.sql
20:47:50.898893 [debug] [MainThread]: 1699: static parser successfully parsed analytics/coaching_operations/learning_goal_creation.sql
20:47:50.901541 [debug] [MainThread]: 1699: static parser successfully parsed analytics/coaching_operations/coach_satisfaction.sql
20:47:50.904315 [debug] [MainThread]: 1699: static parser successfully parsed analytics/coaching_operations/active_coaches.sql
20:47:50.907299 [debug] [MainThread]: 1699: static parser successfully parsed analytics/coaching_operations/first_engagement_three_sixties.sql
20:47:50.909824 [debug] [MainThread]: 1699: static parser successfully parsed analytics/coaching_operations/active_engagements.sql
20:47:50.912483 [debug] [MainThread]: 1699: static parser successfully parsed analytics/coaching_operations/coach_net_promoter_scores.sql
20:48:10.317997 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'end', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x11099fc40>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x1121efc10>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x1121ca610>]}
gshank commented 2 years ago

A traceback entry in the earlier log: File "/usr/local/Cellar/dbt-redshift@1.0.0/1.0.0_2/libexec/lib/python3.9/site-packages/dbt/parser/generic_test_builders.py", line 245, in init value = get_rendered(value, render_ctx, native=True)

The subsequent calls were things that executed when trying to render the generic test.

I don't see an error in the log in the last update. Was there an error that didn't get into the logs?

nicholasyager commented 2 years ago

As a late follow-up to this, I've confirmed that this is caused by an UndefinedMacroException raised during Jinja rendering of a test argument. This can be replicated by adding a bogus macro call to a test config. For example:

models:
  - name: example
    columns:
      - name: id
        tests:
        - not_null:
            where: {{ bogus_package.macro() }}

This will result in the following error message:

Compilation Error
  'bogus_package' is undefined. This can happen when calling a macro that does not exist. Check for typos and/or install package dependencies with "dbt deps".

I'm not sure as to why @alexandrafetterman was experiencing this specific issue, but this is a good opportunity to improve the compiler error message raised during these situations. I'll put together a light PR that adds context to the error message to indicate that the macro is being referenced by a test and which test is affected.

nicholasyager commented 2 years ago

I'm not sure as to why [reporter] was experiencing this specific issue [...]

I've been able to find some other issues raised in the last year (#3580, #5259, #4103). This functional regression occurred in dbt-core 0.20.1 as detailed in a comment here.

In any case, @alexandrafetterman the recommendation proposed here of creating a generic test that accepts a custom where argument should allow you to replicate the behavior of the conditional tests in 1.x.

For example:

not_null_where_macro.sql


{% test not_null_where_macro(model, column_name, macro_where) %}

    select {{ column_name }}
    from {{model}}
    where
        {{column_name}} is not null
        and {{ macro_where }}

{% endtest %}

_schema.yml

  - name: example_model
    columns:
      - name: value
        tests:
          - not_null_where_macro:
              macro_where: id > {{ example_macro_name() }}
ralphrendon-pepperstone commented 1 year ago

I also encounter this error message despite having configure my packages.yml with the same level of dbt_project.yml

This is the content of my packges.yml

packages:

packages:

Steps to recreate: dbt clean; dbt deps; dbt test

image

image

image

jaypeedevlin commented 1 year ago

@rap082993 your issue here is that you have packages: twice and that the default behaviour for many YAML parsers is to ignore the first block. You can verify this from your output of dbt deps as you can see dbt_utils is not being installed.

If you change to:

packages:
  - package: dbt_utils
    version: 1.0.0
  - package: dbt_utils
    version: [">=0.8.0", "<0.9.0"]

...you'll find it works