[0m19:49:07.997056 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'start', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000026819EDF200>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000026819C16ED0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002681A23A870>]}


============================== 19:49:08.006434 | b406548c-8dfa-457d-8d71-3e5fc63db874 ==============================
[0m19:49:08.006434 [info ] [MainThread]: Running with dbt=1.10.16
[0m19:49:08.006434 [debug] [MainThread]: running dbt with arguments {'version_check': 'True', 'no_print': 'None', 'static_parser': 'True', 'target_path': 'None', 'warn_error_options': 'WarnErrorOptionsV2(error=[], warn=[], silence=[])', 'printer_width': '80', 'write_json': 'True', 'introspect': 'True', 'log_cache_events': 'False', 'empty': 'None', 'cache_selected_only': 'False', 'log_format': 'default', 'debug': 'False', 'fail_fast': 'False', 'partial_parse': 'True', 'send_anonymous_usage_stats': 'True', 'quiet': 'False', 'warn_error': 'None', 'profiles_dir': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\jaffle-shop-classic', 'invocation_command': 'dbt debug', 'indirect_selection': 'eager', 'use_colors': 'True', 'use_experimental_parser': 'False', 'log_path': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\jaffle-shop-classic\\logs'}
[0m19:49:08.006434 [warn ] [MainThread]: [[33mWARNING[0m]: Deprecated functionality

User config should be moved from the 'config' key in profiles.yml to the 'flags' key in dbt_project.yml.
[0m19:49:08.006434 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'deprecation', 'label': 'b406548c-8dfa-457d-8d71-3e5fc63db874', 'property_': 'warn', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002681A1F8A40>]}
[0m19:49:08.039582 [info ] [MainThread]: dbt version: 1.10.16
[0m19:49:08.039582 [info ] [MainThread]: python version: 3.12.7
[0m19:49:08.039582 [info ] [MainThread]: python path: C:\ProgramData\anaconda3\python.exe
[0m19:49:08.050553 [info ] [MainThread]: os info: Windows-11-10.0.26100-SP0
[0m19:49:08.701069 [info ] [MainThread]: Using profiles dir at C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic
[0m19:49:08.701069 [info ] [MainThread]: Using profiles.yml file at C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\profiles.yml
[0m19:49:08.702126 [info ] [MainThread]: Using dbt_project.yml file at C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\dbt_project.yml
[0m19:49:08.702126 [info ] [MainThread]: adapter type: fabric
[0m19:49:08.703112 [info ] [MainThread]: adapter version: 1.9.8
[0m19:49:08.796575 [info ] [MainThread]: Configuration:
[0m19:49:08.797574 [info ] [MainThread]:   profiles.yml file [[32mOK found and valid[0m]
[0m19:49:08.798515 [info ] [MainThread]:   dbt_project.yml file [[32mOK found and valid[0m]
[0m19:49:08.798515 [info ] [MainThread]: Required dependencies:
[0m19:49:08.799515 [debug] [MainThread]: Executing "git --help"
[0m19:49:08.903742 [debug] [MainThread]: STDOUT: "b"usage: git [-v | --version] [-h | --help] [-C <path>] [-c <name>=<value>]\n           [--exec-path[=<path>]] [--html-path] [--man-path] [--info-path]\n           [-p | --paginate | -P | --no-pager] [--no-replace-objects] [--no-lazy-fetch]\n           [--no-optional-locks] [--no-advice] [--bare] [--git-dir=<path>]\n           [--work-tree=<path>] [--namespace=<name>] [--config-env=<name>=<envvar>]\n           <command> [<args>]\n\nThese are common Git commands used in various situations:\n\nstart a working area (see also: git help tutorial)\n   clone      Clone a repository into a new directory\n   init       Create an empty Git repository or reinitialize an existing one\n\nwork on the current change (see also: git help everyday)\n   add        Add file contents to the index\n   mv         Move or rename a file, a directory, or a symlink\n   restore    Restore working tree files\n   rm         Remove files from the working tree and from the index\n\nexamine the history and state (see also: git help revisions)\n   bisect     Use binary search to find the commit that introduced a bug\n   diff       Show changes between commits, commit and working tree, etc\n   grep       Print lines matching a pattern\n   log        Show commit logs\n   show       Show various types of objects\n   status     Show the working tree status\n\ngrow, mark and tweak your common history\n   backfill   Download missing objects in a partial clone\n   branch     List, create, or delete branches\n   commit     Record changes to the repository\n   merge      Join two or more development histories together\n   rebase     Reapply commits on top of another base tip\n   reset      Reset current HEAD to the specified state\n   switch     Switch branches\n   tag        Create, list, delete or verify a tag object signed with GPG\n\ncollaborate (see also: git help workflows)\n   fetch      Download objects and refs from another repository\n   pull       Fetch from and integrate with another repository or a local branch\n   push       Update remote refs along with associated objects\n\n'git help -a' and 'git help -g' list available subcommands and some\nconcept guides. See 'git help <command>' or 'git help <concept>'\nto read about a specific subcommand or concept.\nSee 'git help git' for an overview of the system.\n""
[0m19:49:08.905965 [debug] [MainThread]: STDERR: "b''"
[0m19:49:08.905965 [info ] [MainThread]:  - git [[32mOK found[0m]

[0m19:49:08.907511 [info ] [MainThread]: Connection:
[0m19:49:08.907511 [info ] [MainThread]:   server: abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com
[0m19:49:08.907511 [info ] [MainThread]:   database: ws_ssc_articles
[0m19:49:08.907511 [info ] [MainThread]:   schema: dbo
[0m19:49:08.907511 [info ] [MainThread]:   warehouse_snapshot_name: None
[0m19:49:08.907511 [info ] [MainThread]:   snapshot_timestamp: None
[0m19:49:08.907511 [info ] [MainThread]:   UID: None
[0m19:49:08.912485 [info ] [MainThread]:   workspace_id: None
[0m19:49:08.912485 [info ] [MainThread]:   authentication: CLI
[0m19:49:08.912485 [info ] [MainThread]:   retries: 3
[0m19:49:08.912485 [info ] [MainThread]:   login_timeout: 0
[0m19:49:08.915394 [info ] [MainThread]:   query_timeout: 0
[0m19:49:08.915394 [info ] [MainThread]:   trace_flag: False
[0m19:49:08.916407 [info ] [MainThread]:   encrypt: True
[0m19:49:08.917402 [info ] [MainThread]:   trust_cert: False
[0m19:49:08.917402 [info ] [MainThread]:   api_url: https://api.fabric.microsoft.com/v1
[0m19:49:08.918403 [info ] [MainThread]: Registered adapter: fabric=1.9.8
[0m19:49:09.214319 [debug] [MainThread]: Acquiring new fabric connection 'debug'
[0m19:49:09.215299 [debug] [MainThread]: Using fabric connection "debug"
[0m19:49:09.215299 [debug] [MainThread]: On debug: select 1 as id
[0m19:49:09.215299 [debug] [MainThread]: Opening a new connection, currently in state init
[0m19:49:09.216300 [debug] [MainThread]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m19:49:09.218712 [debug] [MainThread]: fabric adapter: Error running SQL: select 1 as id
[0m19:49:09.218712 [debug] [MainThread]: fabric adapter: Rolling back transaction.
[0m19:49:09.218712 [debug] [MainThread]: On debug: No close available on handle
[0m19:49:09.218712 [info ] [MainThread]:   Connection test: [[31mERROR[0m]

[0m19:49:09.218712 [info ] [MainThread]: [31m1 check failed:[0m
[0m19:49:09.218712 [info ] [MainThread]: dbt was unable to connect to the specified database.
The database returned the following error:

  >Database Error
  Azure CLI not found on path

Check your database credentials and try again. For more information, visit:
https://docs.getdbt.com/docs/configure-your-profile


[0m19:49:09.227292 [warn ] [MainThread]: [[33mWARNING[0m][DeprecationsSummary]: Deprecated functionality
Summary of encountered deprecations:
- ProjectFlagsMovedDeprecation: 1 occurrence
To see all deprecation instances instead of just the first occurrence of each,
run command again with the `--show-all-deprecations` flag. You may also need to
run with `--no-partial-parse` as some deprecations are only encountered during
parsing.
[0m19:49:09.227292 [debug] [MainThread]: Command `dbt debug` failed at 19:49:09.227292 after 1.55 seconds
[0m19:49:09.229227 [debug] [MainThread]: Connection 'debug' was properly closed.
[0m19:49:09.230236 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'end', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002681BE290D0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000026819A57C20>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002681A23A870>]}
[0m19:49:09.230236 [debug] [MainThread]: Flushing usage events
[0m19:49:09.414048 [debug] [MainThread]: An error was encountered while trying to flush usage events
[0m19:52:09.961527 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'start', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000233BA66E210>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000233B73C3590>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000233B91D57C0>]}


============================== 19:52:09.961527 | 83e0aef5-aa95-4234-b58c-1797ffb92745 ==============================
[0m19:52:09.961527 [info ] [MainThread]: Running with dbt=1.10.16
[0m19:52:09.961527 [debug] [MainThread]: running dbt with arguments {'version_check': 'True', 'no_print': 'None', 'static_parser': 'True', 'warn_error_options': 'WarnErrorOptionsV2(error=[], warn=[], silence=[])', 'target_path': 'None', 'printer_width': '80', 'write_json': 'True', 'introspect': 'True', 'log_cache_events': 'False', 'empty': 'None', 'cache_selected_only': 'False', 'fail_fast': 'False', 'debug': 'False', 'log_format': 'default', 'partial_parse': 'True', 'send_anonymous_usage_stats': 'True', 'quiet': 'False', 'warn_error': 'None', 'profiles_dir': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\jaffle-shop-classic', 'use_colors': 'True', 'indirect_selection': 'eager', 'invocation_command': 'dbt debug', 'use_experimental_parser': 'False', 'log_path': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\jaffle-shop-classic\\logs'}
[0m19:52:09.977275 [warn ] [MainThread]: [[33mWARNING[0m]: Deprecated functionality

User config should be moved from the 'config' key in profiles.yml to the 'flags' key in dbt_project.yml.
[0m19:52:09.977275 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'deprecation', 'label': '83e0aef5-aa95-4234-b58c-1797ffb92745', 'property_': 'warn', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000233B9B80F20>]}
[0m19:52:10.000087 [info ] [MainThread]: dbt version: 1.10.16
[0m19:52:10.001373 [info ] [MainThread]: python version: 3.12.7
[0m19:52:10.001373 [info ] [MainThread]: python path: C:\ProgramData\anaconda3\python.exe
[0m19:52:10.002376 [info ] [MainThread]: os info: Windows-11-10.0.26100-SP0
[0m19:52:10.406089 [info ] [MainThread]: Using profiles dir at C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic
[0m19:52:10.407481 [info ] [MainThread]: Using profiles.yml file at C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\profiles.yml
[0m19:52:10.407481 [info ] [MainThread]: Using dbt_project.yml file at C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\dbt_project.yml
[0m19:52:10.408657 [info ] [MainThread]: adapter type: fabric
[0m19:52:10.409152 [info ] [MainThread]: adapter version: 1.9.8
[0m19:52:10.496195 [info ] [MainThread]: Configuration:
[0m19:52:10.497128 [info ] [MainThread]:   profiles.yml file [[32mOK found and valid[0m]
[0m19:52:10.497128 [info ] [MainThread]:   dbt_project.yml file [[32mOK found and valid[0m]
[0m19:52:10.498127 [info ] [MainThread]: Required dependencies:
[0m19:52:10.499137 [debug] [MainThread]: Executing "git --help"
[0m19:52:10.592038 [debug] [MainThread]: STDOUT: "b"usage: git [-v | --version] [-h | --help] [-C <path>] [-c <name>=<value>]\n           [--exec-path[=<path>]] [--html-path] [--man-path] [--info-path]\n           [-p | --paginate | -P | --no-pager] [--no-replace-objects] [--no-lazy-fetch]\n           [--no-optional-locks] [--no-advice] [--bare] [--git-dir=<path>]\n           [--work-tree=<path>] [--namespace=<name>] [--config-env=<name>=<envvar>]\n           <command> [<args>]\n\nThese are common Git commands used in various situations:\n\nstart a working area (see also: git help tutorial)\n   clone      Clone a repository into a new directory\n   init       Create an empty Git repository or reinitialize an existing one\n\nwork on the current change (see also: git help everyday)\n   add        Add file contents to the index\n   mv         Move or rename a file, a directory, or a symlink\n   restore    Restore working tree files\n   rm         Remove files from the working tree and from the index\n\nexamine the history and state (see also: git help revisions)\n   bisect     Use binary search to find the commit that introduced a bug\n   diff       Show changes between commits, commit and working tree, etc\n   grep       Print lines matching a pattern\n   log        Show commit logs\n   show       Show various types of objects\n   status     Show the working tree status\n\ngrow, mark and tweak your common history\n   backfill   Download missing objects in a partial clone\n   branch     List, create, or delete branches\n   commit     Record changes to the repository\n   merge      Join two or more development histories together\n   rebase     Reapply commits on top of another base tip\n   reset      Reset current HEAD to the specified state\n   switch     Switch branches\n   tag        Create, list, delete or verify a tag object signed with GPG\n\ncollaborate (see also: git help workflows)\n   fetch      Download objects and refs from another repository\n   pull       Fetch from and integrate with another repository or a local branch\n   push       Update remote refs along with associated objects\n\n'git help -a' and 'git help -g' list available subcommands and some\nconcept guides. See 'git help <command>' or 'git help <concept>'\nto read about a specific subcommand or concept.\nSee 'git help git' for an overview of the system.\n""
[0m19:52:10.592038 [debug] [MainThread]: STDERR: "b''"
[0m19:52:10.592038 [info ] [MainThread]:  - git [[32mOK found[0m]

[0m19:52:10.593797 [info ] [MainThread]: Connection:
[0m19:52:10.594318 [info ] [MainThread]:   server: abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com
[0m19:52:10.594318 [info ] [MainThread]:   database: ws_ssc_articles
[0m19:52:10.595888 [info ] [MainThread]:   schema: dbo
[0m19:52:10.595888 [info ] [MainThread]:   warehouse_snapshot_name: None
[0m19:52:10.595888 [info ] [MainThread]:   snapshot_timestamp: None
[0m19:52:10.595888 [info ] [MainThread]:   UID: john@craftydba.com
[0m19:52:10.595888 [info ] [MainThread]:   workspace_id: None
[0m19:52:10.599433 [info ] [MainThread]:   authentication: ActiveDirectoryInteractive
[0m19:52:10.599433 [info ] [MainThread]:   retries: 3
[0m19:52:10.600440 [info ] [MainThread]:   login_timeout: 0
[0m19:52:10.600440 [info ] [MainThread]:   query_timeout: 0
[0m19:52:10.601444 [info ] [MainThread]:   trace_flag: False
[0m19:52:10.601444 [info ] [MainThread]:   encrypt: True
[0m19:52:10.602440 [info ] [MainThread]:   trust_cert: False
[0m19:52:10.602440 [info ] [MainThread]:   api_url: https://api.fabric.microsoft.com/v1
[0m19:52:10.603933 [info ] [MainThread]: Registered adapter: fabric=1.9.8
[0m19:52:10.790516 [debug] [MainThread]: Acquiring new fabric connection 'debug'
[0m19:52:10.790516 [debug] [MainThread]: Using fabric connection "debug"
[0m19:52:10.792523 [debug] [MainThread]: On debug: select 1 as id
[0m19:52:10.792523 [debug] [MainThread]: Opening a new connection, currently in state init
[0m19:52:10.792523 [debug] [MainThread]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={john@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m19:53:48.290224 [debug] [MainThread]: fabric adapter: Connected to db: ws_ssc_articles
[0m19:53:48.338753 [debug] [MainThread]: SQL status: OK in 98.000 seconds
[0m19:53:48.342769 [debug] [MainThread]: On debug: Close
[0m19:53:48.342769 [info ] [MainThread]:   Connection test: [[32mOK connection ok[0m]

[0m19:53:48.344775 [info ] [MainThread]: [32mAll checks passed![0m
[0m19:53:48.344775 [warn ] [MainThread]: [[33mWARNING[0m][DeprecationsSummary]: Deprecated functionality
Summary of encountered deprecations:
- ProjectFlagsMovedDeprecation: 1 occurrence
To see all deprecation instances instead of just the first occurrence of each,
run command again with the `--show-all-deprecations` flag. You may also need to
run with `--no-partial-parse` as some deprecations are only encountered during
parsing.
[0m19:53:48.346778 [debug] [MainThread]: Command `dbt debug` succeeded at 19:53:48.346778 after 98.66 seconds
[0m19:53:48.346778 [debug] [MainThread]: Connection 'debug' was properly closed.
[0m19:53:48.348782 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'end', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000233B7B3E030>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000233BBDE6E10>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000233B9DDE240>]}
[0m19:53:48.348782 [debug] [MainThread]: Flushing usage events
[0m19:53:48.533438 [debug] [MainThread]: An error was encountered while trying to flush usage events
[0m19:55:10.636382 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'start', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000271676D9D90>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000271690DBAA0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000027169BC77D0>]}


============================== 19:55:10.636382 | 03c4af2d-1e49-4602-b486-ad33102bd3e2 ==============================
[0m19:55:10.636382 [info ] [MainThread]: Running with dbt=1.10.16
[0m19:55:10.636382 [debug] [MainThread]: running dbt with arguments {'static_parser': 'True', 'no_print': 'None', 'version_check': 'True', 'warn_error_options': 'WarnErrorOptionsV2(error=[], warn=[], silence=[])', 'target_path': 'None', 'printer_width': '80', 'write_json': 'True', 'empty': 'None', 'log_cache_events': 'False', 'introspect': 'True', 'cache_selected_only': 'False', 'fail_fast': 'False', 'debug': 'False', 'log_format': 'default', 'profiles_dir': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\jaffle-shop-classic', 'send_anonymous_usage_stats': 'True', 'quiet': 'False', 'warn_error': 'None', 'partial_parse': 'True', 'use_colors': 'True', 'indirect_selection': 'eager', 'invocation_command': 'dbt seed', 'use_experimental_parser': 'False', 'log_path': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\jaffle-shop-classic\\logs'}
[0m19:55:10.636382 [warn ] [MainThread]: [[33mWARNING[0m]: Deprecated functionality

User config should be moved from the 'config' key in profiles.yml to the 'flags' key in dbt_project.yml.
[0m19:55:10.636382 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'deprecation', 'label': '03c4af2d-1e49-4602-b486-ad33102bd3e2', 'property_': 'warn', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000027169BC77D0>]}
[0m19:55:11.137799 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'project_id', 'label': '03c4af2d-1e49-4602-b486-ad33102bd3e2', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002716C3022A0>]}
[0m19:55:11.185695 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'adapter_info', 'label': '03c4af2d-1e49-4602-b486-ad33102bd3e2', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002716C3126F0>]}
[0m19:55:11.188130 [info ] [MainThread]: Registered adapter: fabric=1.9.8
[0m19:55:11.367972 [debug] [MainThread]: checksum: c4b99e2e3bb042c661c8397fd92290cd0d52b31ce393ad721fa0bb3c9591dd0f, vars: {}, profile: , target: , version: 1.10.16
[0m19:55:11.367972 [info ] [MainThread]: Unable to do partial parsing because saved manifest not found. Starting full parse.
[0m19:55:11.367972 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'partial_parser', 'label': '03c4af2d-1e49-4602-b486-ad33102bd3e2', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002716C4D6360>]}
[0m19:55:12.888840 [warn ] [MainThread]: [[33mWARNING[0m][MissingArgumentsPropertyInGenericTestDeprecation]: Deprecated
functionality
Found top-level arguments to test `relationships`. Arguments to generic tests
should be nested under the `arguments` property.`
[0m19:55:12.888840 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'deprecation', 'label': '03c4af2d-1e49-4602-b486-ad33102bd3e2', 'property_': 'warn', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002716C8FB380>]}
[0m19:55:13.016694 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'load_project', 'label': '03c4af2d-1e49-4602-b486-ad33102bd3e2', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002716C435670>]}
[0m19:55:13.083965 [debug] [MainThread]: Wrote artifact WritableManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\target\manifest.json
[0m19:55:13.085969 [debug] [MainThread]: Wrote artifact SemanticManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\target\semantic_manifest.json
[0m19:55:13.113550 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'resource_counts', 'label': '03c4af2d-1e49-4602-b486-ad33102bd3e2', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002716CC7A630>]}
[0m19:55:13.113550 [info ] [MainThread]: Found 5 models, 3 seeds, 20 data tests, 500 macros
[0m19:55:13.113550 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'runnable_timing', 'label': '03c4af2d-1e49-4602-b486-ad33102bd3e2', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002716CC129F0>]}
[0m19:55:13.121418 [info ] [MainThread]: 
[0m19:55:13.121418 [info ] [MainThread]: Concurrency: 4 threads (target='fabric-dev')
[0m19:55:13.121418 [info ] [MainThread]: 
[0m19:55:13.121418 [debug] [MainThread]: Acquiring new fabric connection 'master'
[0m19:55:13.126678 [debug] [ThreadPool]: Acquiring new fabric connection 'list_ws_ssc_articles'
[0m19:55:13.142307 [debug] [ThreadPool]: dbt-fabric
[0m19:55:13.142307 [debug] [ThreadPool]: Using fabric connection "list_ws_ssc_articles"
[0m19:55:13.142307 [debug] [ThreadPool]: On list_ws_ssc_articles: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "connection_name": "list_ws_ssc_articles"} */
USE [ws_ssc_articles];
    select  name as [schema]
    from sys.schemas  
    OPTION (LABEL = 'dbt-fabric-dw');

  
[0m19:55:13.143305 [debug] [ThreadPool]: Opening a new connection, currently in state init
[0m19:55:13.143305 [debug] [ThreadPool]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={john@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m19:56:04.995294 [debug] [ThreadPool]: fabric adapter: Error running SQL: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "connection_name": "list_ws_ssc_articles"} */
USE [ws_ssc_articles];
    select  name as [schema]
    from sys.schemas  
    OPTION (LABEL = 'dbt-fabric-dw');

  
[0m19:56:04.995294 [debug] [ThreadPool]: fabric adapter: Rolling back transaction.
[0m19:56:04.995294 [debug] [ThreadPool]: On list_ws_ssc_articles: No close available on handle
[0m19:56:04.995294 [debug] [ThreadPool]: fabric adapter: Error running SQL: macro list_schemas
[0m19:56:04.995294 [debug] [ThreadPool]: fabric adapter: Rolling back transaction.
[0m19:56:04.995294 [debug] [MainThread]: Connection 'master' was properly closed.
[0m19:56:04.995294 [debug] [MainThread]: Connection 'list_ws_ssc_articles' was properly closed.
[0m19:56:04.995294 [info ] [MainThread]: 
[0m19:56:04.995294 [info ] [MainThread]: Finished running  in 0 hours 0 minutes and 51.87 seconds (51.87s).
[0m19:56:04.995294 [error] [MainThread]: Encountered an error:
Database Error
  ('42000', "[42000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Login failed for user '<token-identified principal>' due to no proper resource access. Only backend connections are allowed. (19732) (SQLDriverConnect); [42000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Login failed for user '<token-identified principal>' due to no proper resource access. Only backend connections are allowed. (19732)")
[0m19:56:04.995294 [warn ] [MainThread]: [[33mWARNING[0m][DeprecationsSummary]: Deprecated functionality
Summary of encountered deprecations:
- ProjectFlagsMovedDeprecation: 1 occurrence
- MissingArgumentsPropertyInGenericTestDeprecation: 4 occurrences
To see all deprecation instances instead of just the first occurrence of each,
run command again with the `--show-all-deprecations` flag. You may also need to
run with `--no-partial-parse` as some deprecations are only encountered during
parsing.
[0m19:56:04.995294 [debug] [MainThread]: Command `dbt seed` failed at 19:56:04.995294 after 54.60 seconds
[0m19:56:04.995294 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'end', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002716BB37080>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002716C7E8AA0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002716C86E420>]}
[0m19:56:04.995294 [debug] [MainThread]: Flushing usage events
[0m19:56:05.205904 [debug] [MainThread]: An error was encountered while trying to flush usage events
[0m20:43:12.412000 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'start', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000226C4D29E20>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000226C789D3A0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000226C789D370>]}


============================== 20:43:12.418169 | debcebfd-7815-403c-984f-499a8a7186e8 ==============================
[0m20:43:12.418169 [info ] [MainThread]: Running with dbt=1.10.16
[0m20:43:12.418169 [debug] [MainThread]: running dbt with arguments {'static_parser': 'True', 'no_print': 'None', 'version_check': 'True', 'target_path': 'None', 'warn_error_options': 'WarnErrorOptionsV2(error=[], warn=[], silence=[])', 'printer_width': '80', 'write_json': 'True', 'empty': 'None', 'log_cache_events': 'False', 'introspect': 'True', 'cache_selected_only': 'False', 'log_format': 'default', 'debug': 'False', 'fail_fast': 'False', 'profiles_dir': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\jaffle-shop-classic', 'send_anonymous_usage_stats': 'True', 'quiet': 'False', 'warn_error': 'None', 'partial_parse': 'True', 'use_colors': 'True', 'invocation_command': 'dbt debug', 'indirect_selection': 'eager', 'use_experimental_parser': 'False', 'log_path': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\jaffle-shop-classic\\logs'}
[0m20:43:12.418169 [warn ] [MainThread]: [[33mWARNING[0m]: Deprecated functionality

User config should be moved from the 'config' key in profiles.yml to the 'flags' key in dbt_project.yml.
[0m20:43:12.418169 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'deprecation', 'label': 'debcebfd-7815-403c-984f-499a8a7186e8', 'property_': 'warn', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000226C7A10B30>]}
[0m20:43:12.440177 [info ] [MainThread]: dbt version: 1.10.16
[0m20:43:12.440177 [info ] [MainThread]: python version: 3.12.7
[0m20:43:12.440177 [info ] [MainThread]: python path: C:\ProgramData\anaconda3\python.exe
[0m20:43:12.455301 [info ] [MainThread]: os info: Windows-11-10.0.26100-SP0
[0m20:43:12.800395 [info ] [MainThread]: Using profiles dir at C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic
[0m20:43:12.808782 [info ] [MainThread]: Using profiles.yml file at C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\profiles.yml
[0m20:43:12.808782 [info ] [MainThread]: Using dbt_project.yml file at C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\dbt_project.yml
[0m20:43:12.808782 [info ] [MainThread]: adapter type: fabric
[0m20:43:12.808782 [info ] [MainThread]: adapter version: 1.9.8
[0m20:43:12.898817 [info ] [MainThread]: Configuration:
[0m20:43:12.899472 [info ] [MainThread]:   profiles.yml file [[32mOK found and valid[0m]
[0m20:43:12.899472 [info ] [MainThread]:   dbt_project.yml file [[32mOK found and valid[0m]
[0m20:43:12.900509 [info ] [MainThread]: Required dependencies:
[0m20:43:12.900886 [debug] [MainThread]: Executing "git --help"
[0m20:43:12.988690 [debug] [MainThread]: STDOUT: "b"usage: git [-v | --version] [-h | --help] [-C <path>] [-c <name>=<value>]\n           [--exec-path[=<path>]] [--html-path] [--man-path] [--info-path]\n           [-p | --paginate | -P | --no-pager] [--no-replace-objects] [--no-lazy-fetch]\n           [--no-optional-locks] [--no-advice] [--bare] [--git-dir=<path>]\n           [--work-tree=<path>] [--namespace=<name>] [--config-env=<name>=<envvar>]\n           <command> [<args>]\n\nThese are common Git commands used in various situations:\n\nstart a working area (see also: git help tutorial)\n   clone      Clone a repository into a new directory\n   init       Create an empty Git repository or reinitialize an existing one\n\nwork on the current change (see also: git help everyday)\n   add        Add file contents to the index\n   mv         Move or rename a file, a directory, or a symlink\n   restore    Restore working tree files\n   rm         Remove files from the working tree and from the index\n\nexamine the history and state (see also: git help revisions)\n   bisect     Use binary search to find the commit that introduced a bug\n   diff       Show changes between commits, commit and working tree, etc\n   grep       Print lines matching a pattern\n   log        Show commit logs\n   show       Show various types of objects\n   status     Show the working tree status\n\ngrow, mark and tweak your common history\n   backfill   Download missing objects in a partial clone\n   branch     List, create, or delete branches\n   commit     Record changes to the repository\n   merge      Join two or more development histories together\n   rebase     Reapply commits on top of another base tip\n   reset      Reset current HEAD to the specified state\n   switch     Switch branches\n   tag        Create, list, delete or verify a tag object signed with GPG\n\ncollaborate (see also: git help workflows)\n   fetch      Download objects and refs from another repository\n   pull       Fetch from and integrate with another repository or a local branch\n   push       Update remote refs along with associated objects\n\n'git help -a' and 'git help -g' list available subcommands and some\nconcept guides. See 'git help <command>' or 'git help <concept>'\nto read about a specific subcommand or concept.\nSee 'git help git' for an overview of the system.\n""
[0m20:43:12.988690 [debug] [MainThread]: STDERR: "b''"
[0m20:43:12.988690 [info ] [MainThread]:  - git [[32mOK found[0m]

[0m20:43:12.989862 [info ] [MainThread]: Connection:
[0m20:43:12.990840 [info ] [MainThread]:   server: abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com
[0m20:43:12.990840 [info ] [MainThread]:   database: ws_ssc_articles
[0m20:43:12.991837 [info ] [MainThread]:   schema: dbo
[0m20:43:12.991837 [info ] [MainThread]:   warehouse_snapshot_name: None
[0m20:43:12.991837 [info ] [MainThread]:   snapshot_timestamp: None
[0m20:43:12.992839 [info ] [MainThread]:   UID: robin@craftydba.com
[0m20:43:12.992839 [info ] [MainThread]:   workspace_id: None
[0m20:43:12.993836 [info ] [MainThread]:   authentication: ActiveDirectoryInteractive
[0m20:43:12.993836 [info ] [MainThread]:   retries: 3
[0m20:43:12.993836 [info ] [MainThread]:   login_timeout: 0
[0m20:43:12.994839 [info ] [MainThread]:   query_timeout: 0
[0m20:43:12.994839 [info ] [MainThread]:   trace_flag: False
[0m20:43:12.995840 [info ] [MainThread]:   encrypt: True
[0m20:43:12.995840 [info ] [MainThread]:   trust_cert: False
[0m20:43:12.996837 [info ] [MainThread]:   api_url: https://api.fabric.microsoft.com/v1
[0m20:43:12.997840 [info ] [MainThread]: Registered adapter: fabric=1.9.8
[0m20:43:13.185537 [debug] [MainThread]: Acquiring new fabric connection 'debug'
[0m20:43:13.186538 [debug] [MainThread]: Using fabric connection "debug"
[0m20:43:13.186538 [debug] [MainThread]: On debug: select 1 as id
[0m20:43:13.186538 [debug] [MainThread]: Opening a new connection, currently in state init
[0m20:43:13.187539 [debug] [MainThread]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:44:45.569811 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'start', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000291BB971940>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000291B9C11FA0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000291BC113950>]}


============================== 20:44:45.569811 | 3213c03c-efb3-4038-9c31-72718f21bd1f ==============================
[0m20:44:45.569811 [info ] [MainThread]: Running with dbt=1.10.16
[0m20:44:45.569811 [debug] [MainThread]: running dbt with arguments {'static_parser': 'True', 'no_print': 'None', 'version_check': 'True', 'warn_error_options': 'WarnErrorOptionsV2(error=[], warn=[], silence=[])', 'target_path': 'None', 'printer_width': '80', 'write_json': 'True', 'empty': 'None', 'log_cache_events': 'False', 'introspect': 'True', 'cache_selected_only': 'False', 'fail_fast': 'False', 'debug': 'False', 'log_format': 'default', 'partial_parse': 'True', 'send_anonymous_usage_stats': 'True', 'quiet': 'False', 'warn_error': 'None', 'profiles_dir': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\jaffle-shop-classic', 'invocation_command': 'dbt debug', 'indirect_selection': 'eager', 'use_colors': 'True', 'use_experimental_parser': 'False', 'log_path': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\jaffle-shop-classic\\logs'}
[0m20:44:45.569811 [warn ] [MainThread]: [[33mWARNING[0m]: Deprecated functionality

User config should be moved from the 'config' key in profiles.yml to the 'flags' key in dbt_project.yml.
[0m20:44:45.569811 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'deprecation', 'label': '3213c03c-efb3-4038-9c31-72718f21bd1f', 'property_': 'warn', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000291BCDB8560>]}
[0m20:44:45.584106 [info ] [MainThread]: dbt version: 1.10.16
[0m20:44:45.584106 [info ] [MainThread]: python version: 3.12.7
[0m20:44:45.599869 [info ] [MainThread]: python path: C:\ProgramData\anaconda3\python.exe
[0m20:44:45.599869 [info ] [MainThread]: os info: Windows-11-10.0.26100-SP0
[0m20:44:45.924022 [info ] [MainThread]: Using profiles dir at C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic
[0m20:44:45.924022 [info ] [MainThread]: Using profiles.yml file at C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\profiles.yml
[0m20:44:45.924022 [info ] [MainThread]: Using dbt_project.yml file at C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\dbt_project.yml
[0m20:44:45.924022 [info ] [MainThread]: adapter type: fabric
[0m20:44:45.924022 [info ] [MainThread]: adapter version: 1.9.8
[0m20:44:46.009800 [info ] [MainThread]: Configuration:
[0m20:44:46.010692 [info ] [MainThread]:   profiles.yml file [[32mOK found and valid[0m]
[0m20:44:46.010692 [info ] [MainThread]:   dbt_project.yml file [[32mOK found and valid[0m]
[0m20:44:46.010692 [info ] [MainThread]: Required dependencies:
[0m20:44:46.011731 [debug] [MainThread]: Executing "git --help"
[0m20:44:46.098619 [debug] [MainThread]: STDOUT: "b"usage: git [-v | --version] [-h | --help] [-C <path>] [-c <name>=<value>]\n           [--exec-path[=<path>]] [--html-path] [--man-path] [--info-path]\n           [-p | --paginate | -P | --no-pager] [--no-replace-objects] [--no-lazy-fetch]\n           [--no-optional-locks] [--no-advice] [--bare] [--git-dir=<path>]\n           [--work-tree=<path>] [--namespace=<name>] [--config-env=<name>=<envvar>]\n           <command> [<args>]\n\nThese are common Git commands used in various situations:\n\nstart a working area (see also: git help tutorial)\n   clone      Clone a repository into a new directory\n   init       Create an empty Git repository or reinitialize an existing one\n\nwork on the current change (see also: git help everyday)\n   add        Add file contents to the index\n   mv         Move or rename a file, a directory, or a symlink\n   restore    Restore working tree files\n   rm         Remove files from the working tree and from the index\n\nexamine the history and state (see also: git help revisions)\n   bisect     Use binary search to find the commit that introduced a bug\n   diff       Show changes between commits, commit and working tree, etc\n   grep       Print lines matching a pattern\n   log        Show commit logs\n   show       Show various types of objects\n   status     Show the working tree status\n\ngrow, mark and tweak your common history\n   backfill   Download missing objects in a partial clone\n   branch     List, create, or delete branches\n   commit     Record changes to the repository\n   merge      Join two or more development histories together\n   rebase     Reapply commits on top of another base tip\n   reset      Reset current HEAD to the specified state\n   switch     Switch branches\n   tag        Create, list, delete or verify a tag object signed with GPG\n\ncollaborate (see also: git help workflows)\n   fetch      Download objects and refs from another repository\n   pull       Fetch from and integrate with another repository or a local branch\n   push       Update remote refs along with associated objects\n\n'git help -a' and 'git help -g' list available subcommands and some\nconcept guides. See 'git help <command>' or 'git help <concept>'\nto read about a specific subcommand or concept.\nSee 'git help git' for an overview of the system.\n""
[0m20:44:46.099662 [debug] [MainThread]: STDERR: "b''"
[0m20:44:46.099662 [info ] [MainThread]:  - git [[32mOK found[0m]

[0m20:44:46.100635 [info ] [MainThread]: Connection:
[0m20:44:46.101620 [info ] [MainThread]:   server: abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com
[0m20:44:46.101620 [info ] [MainThread]:   database: ws_ssc_articles
[0m20:44:46.102618 [info ] [MainThread]:   schema: dbo
[0m20:44:46.103620 [info ] [MainThread]:   warehouse_snapshot_name: None
[0m20:44:46.103620 [info ] [MainThread]:   snapshot_timestamp: None
[0m20:44:46.103620 [info ] [MainThread]:   UID: robin@craftydba.com
[0m20:44:46.105126 [info ] [MainThread]:   workspace_id: None
[0m20:44:46.105126 [info ] [MainThread]:   authentication: ActiveDirectoryInteractive
[0m20:44:46.105126 [info ] [MainThread]:   retries: 3
[0m20:44:46.106133 [info ] [MainThread]:   login_timeout: 0
[0m20:44:46.106133 [info ] [MainThread]:   query_timeout: 0
[0m20:44:46.107134 [info ] [MainThread]:   trace_flag: False
[0m20:44:46.107134 [info ] [MainThread]:   encrypt: True
[0m20:44:46.108134 [info ] [MainThread]:   trust_cert: False
[0m20:44:46.108134 [info ] [MainThread]:   api_url: https://api.fabric.microsoft.com/v1
[0m20:44:46.109133 [info ] [MainThread]: Registered adapter: fabric=1.9.8
[0m20:44:46.314347 [debug] [MainThread]: Acquiring new fabric connection 'debug'
[0m20:44:46.314347 [debug] [MainThread]: Using fabric connection "debug"
[0m20:44:46.314347 [debug] [MainThread]: On debug: select 1 as id
[0m20:44:46.314347 [debug] [MainThread]: Opening a new connection, currently in state init
[0m20:44:46.314347 [debug] [MainThread]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:45:21.309698 [debug] [MainThread]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:45:21.349006 [debug] [MainThread]: SQL status: OK in 35.000 seconds
[0m20:45:21.349006 [debug] [MainThread]: On debug: Close
[0m20:45:21.349006 [info ] [MainThread]:   Connection test: [[32mOK connection ok[0m]

[0m20:45:21.349006 [info ] [MainThread]: [32mAll checks passed![0m
[0m20:45:21.349006 [warn ] [MainThread]: [[33mWARNING[0m][DeprecationsSummary]: Deprecated functionality
Summary of encountered deprecations:
- ProjectFlagsMovedDeprecation: 1 occurrence
To see all deprecation instances instead of just the first occurrence of each,
run command again with the `--show-all-deprecations` flag. You may also need to
run with `--no-partial-parse` as some deprecations are only encountered during
parsing.
[0m20:45:21.349006 [debug] [MainThread]: Command `dbt debug` succeeded at 20:45:21.349006 after 36.01 seconds
[0m20:45:21.349006 [debug] [MainThread]: Connection 'debug' was properly closed.
[0m20:45:21.349006 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'end', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000291BC51C740>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000291B9B11C70>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000291BE3F74A0>]}
[0m20:45:21.349006 [debug] [MainThread]: Flushing usage events
[0m20:45:21.594712 [debug] [MainThread]: An error was encountered while trying to flush usage events
[0m20:45:45.678960 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'start', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000231702BB860>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002316F245CD0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002316D2C20C0>]}


============================== 20:45:45.678960 | 125b91fd-5fa8-423b-93d9-6a10231a6007 ==============================
[0m20:45:45.678960 [info ] [MainThread]: Running with dbt=1.10.16
[0m20:45:45.678960 [debug] [MainThread]: running dbt with arguments {'static_parser': 'True', 'no_print': 'None', 'version_check': 'True', 'warn_error_options': 'WarnErrorOptionsV2(error=[], warn=[], silence=[])', 'target_path': 'None', 'printer_width': '80', 'write_json': 'True', 'introspect': 'True', 'log_cache_events': 'False', 'empty': 'None', 'cache_selected_only': 'False', 'log_format': 'default', 'debug': 'False', 'fail_fast': 'False', 'partial_parse': 'True', 'send_anonymous_usage_stats': 'True', 'quiet': 'False', 'warn_error': 'None', 'profiles_dir': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\jaffle-shop-classic', 'invocation_command': 'dbt debug', 'indirect_selection': 'eager', 'use_colors': 'True', 'use_experimental_parser': 'False', 'log_path': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\jaffle-shop-classic\\logs'}
[0m20:45:45.678960 [warn ] [MainThread]: [[33mWARNING[0m]: Deprecated functionality

User config should be moved from the 'config' key in profiles.yml to the 'flags' key in dbt_project.yml.
[0m20:45:45.678960 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'deprecation', 'label': '125b91fd-5fa8-423b-93d9-6a10231a6007', 'property_': 'warn', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000023170415190>]}
[0m20:45:45.710330 [info ] [MainThread]: dbt version: 1.10.16
[0m20:45:45.710330 [info ] [MainThread]: python version: 3.12.7
[0m20:45:45.710330 [info ] [MainThread]: python path: C:\ProgramData\anaconda3\python.exe
[0m20:45:45.710330 [info ] [MainThread]: os info: Windows-11-10.0.26100-SP0
[0m20:45:46.041127 [info ] [MainThread]: Using profiles dir at C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic
[0m20:45:46.042127 [info ] [MainThread]: Using profiles.yml file at C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\profiles.yml
[0m20:45:46.042127 [info ] [MainThread]: Using dbt_project.yml file at C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\dbt_project.yml
[0m20:45:46.043234 [info ] [MainThread]: adapter type: fabric
[0m20:45:46.043234 [info ] [MainThread]: adapter version: 1.9.8
[0m20:45:46.127419 [info ] [MainThread]: Configuration:
[0m20:45:46.128419 [info ] [MainThread]:   profiles.yml file [[32mOK found and valid[0m]
[0m20:45:46.129419 [info ] [MainThread]:   dbt_project.yml file [[32mOK found and valid[0m]
[0m20:45:46.130420 [info ] [MainThread]: Required dependencies:
[0m20:45:46.130420 [debug] [MainThread]: Executing "git --help"
[0m20:45:46.202692 [debug] [MainThread]: STDOUT: "b"usage: git [-v | --version] [-h | --help] [-C <path>] [-c <name>=<value>]\n           [--exec-path[=<path>]] [--html-path] [--man-path] [--info-path]\n           [-p | --paginate | -P | --no-pager] [--no-replace-objects] [--no-lazy-fetch]\n           [--no-optional-locks] [--no-advice] [--bare] [--git-dir=<path>]\n           [--work-tree=<path>] [--namespace=<name>] [--config-env=<name>=<envvar>]\n           <command> [<args>]\n\nThese are common Git commands used in various situations:\n\nstart a working area (see also: git help tutorial)\n   clone      Clone a repository into a new directory\n   init       Create an empty Git repository or reinitialize an existing one\n\nwork on the current change (see also: git help everyday)\n   add        Add file contents to the index\n   mv         Move or rename a file, a directory, or a symlink\n   restore    Restore working tree files\n   rm         Remove files from the working tree and from the index\n\nexamine the history and state (see also: git help revisions)\n   bisect     Use binary search to find the commit that introduced a bug\n   diff       Show changes between commits, commit and working tree, etc\n   grep       Print lines matching a pattern\n   log        Show commit logs\n   show       Show various types of objects\n   status     Show the working tree status\n\ngrow, mark and tweak your common history\n   backfill   Download missing objects in a partial clone\n   branch     List, create, or delete branches\n   commit     Record changes to the repository\n   merge      Join two or more development histories together\n   rebase     Reapply commits on top of another base tip\n   reset      Reset current HEAD to the specified state\n   switch     Switch branches\n   tag        Create, list, delete or verify a tag object signed with GPG\n\ncollaborate (see also: git help workflows)\n   fetch      Download objects and refs from another repository\n   pull       Fetch from and integrate with another repository or a local branch\n   push       Update remote refs along with associated objects\n\n'git help -a' and 'git help -g' list available subcommands and some\nconcept guides. See 'git help <command>' or 'git help <concept>'\nto read about a specific subcommand or concept.\nSee 'git help git' for an overview of the system.\n""
[0m20:45:46.202692 [debug] [MainThread]: STDERR: "b''"
[0m20:45:46.202692 [info ] [MainThread]:  - git [[32mOK found[0m]

[0m20:45:46.202692 [info ] [MainThread]: Connection:
[0m20:45:46.202692 [info ] [MainThread]:   server: abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com
[0m20:45:46.202692 [info ] [MainThread]:   database: ws_ssc_articles
[0m20:45:46.202692 [info ] [MainThread]:   schema: dbo
[0m20:45:46.202692 [info ] [MainThread]:   warehouse_snapshot_name: None
[0m20:45:46.202692 [info ] [MainThread]:   snapshot_timestamp: None
[0m20:45:46.202692 [info ] [MainThread]:   UID: robin@craftydba.com
[0m20:45:46.202692 [info ] [MainThread]:   workspace_id: None
[0m20:45:46.202692 [info ] [MainThread]:   authentication: ActiveDirectoryInteractive
[0m20:45:46.202692 [info ] [MainThread]:   retries: 3
[0m20:45:46.202692 [info ] [MainThread]:   login_timeout: 0
[0m20:45:46.202692 [info ] [MainThread]:   query_timeout: 0
[0m20:45:46.218220 [info ] [MainThread]:   trace_flag: False
[0m20:45:46.218220 [info ] [MainThread]:   encrypt: True
[0m20:45:46.219395 [info ] [MainThread]:   trust_cert: False
[0m20:45:46.219395 [info ] [MainThread]:   api_url: https://api.fabric.microsoft.com/v1
[0m20:45:46.220428 [info ] [MainThread]: Registered adapter: fabric=1.9.8
[0m20:45:46.393123 [debug] [MainThread]: Acquiring new fabric connection 'debug'
[0m20:45:46.394124 [debug] [MainThread]: Using fabric connection "debug"
[0m20:45:46.394124 [debug] [MainThread]: On debug: select 1 as id
[0m20:45:46.394124 [debug] [MainThread]: Opening a new connection, currently in state init
[0m20:45:46.394124 [debug] [MainThread]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:46:24.222523 [debug] [MainThread]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:46:24.259847 [debug] [MainThread]: SQL status: OK in 38.000 seconds
[0m20:46:24.262484 [debug] [MainThread]: On debug: Close
[0m20:46:24.263486 [info ] [MainThread]:   Connection test: [[32mOK connection ok[0m]

[0m20:46:24.264337 [info ] [MainThread]: [32mAll checks passed![0m
[0m20:46:24.267387 [warn ] [MainThread]: [[33mWARNING[0m][DeprecationsSummary]: Deprecated functionality
Summary of encountered deprecations:
- ProjectFlagsMovedDeprecation: 1 occurrence
To see all deprecation instances instead of just the first occurrence of each,
run command again with the `--show-all-deprecations` flag. You may also need to
run with `--no-partial-parse` as some deprecations are only encountered during
parsing.
[0m20:46:24.270555 [debug] [MainThread]: Command `dbt debug` succeeded at 20:46:24.269506 after 38.82 seconds
[0m20:46:24.270555 [debug] [MainThread]: Connection 'debug' was properly closed.
[0m20:46:24.271515 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'end', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002317031F140>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000231704B8B60>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000023170415190>]}
[0m20:46:24.272754 [debug] [MainThread]: Flushing usage events
[0m20:46:24.500648 [debug] [MainThread]: An error was encountered while trying to flush usage events
[0m20:46:34.849013 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'start', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000021D5F7C3590>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000021D6240FEF0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000021D6240EE10>]}


============================== 20:46:34.849013 | 9ac48c94-6fc2-4083-bc2f-4841b101fa0b ==============================
[0m20:46:34.849013 [info ] [MainThread]: Running with dbt=1.10.16
[0m20:46:34.849013 [debug] [MainThread]: running dbt with arguments {'static_parser': 'True', 'no_print': 'None', 'version_check': 'True', 'target_path': 'None', 'warn_error_options': 'WarnErrorOptionsV2(error=[], warn=[], silence=[])', 'printer_width': '80', 'write_json': 'True', 'empty': 'None', 'log_cache_events': 'False', 'introspect': 'True', 'cache_selected_only': 'False', 'fail_fast': 'False', 'debug': 'False', 'log_format': 'default', 'partial_parse': 'True', 'send_anonymous_usage_stats': 'True', 'quiet': 'False', 'warn_error': 'None', 'profiles_dir': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\jaffle-shop-classic', 'use_colors': 'True', 'invocation_command': 'dbt seed', 'indirect_selection': 'eager', 'use_experimental_parser': 'False', 'log_path': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\jaffle-shop-classic\\logs'}
[0m20:46:34.849013 [warn ] [MainThread]: [[33mWARNING[0m]: Deprecated functionality

User config should be moved from the 'config' key in profiles.yml to the 'flags' key in dbt_project.yml.
[0m20:46:34.849013 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'deprecation', 'label': '9ac48c94-6fc2-4083-bc2f-4841b101fa0b', 'property_': 'warn', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000021D61DFF7A0>]}
[0m20:46:35.318824 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'project_id', 'label': '9ac48c94-6fc2-4083-bc2f-4841b101fa0b', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000021D64228B00>]}
[0m20:46:35.366948 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'adapter_info', 'label': '9ac48c94-6fc2-4083-bc2f-4841b101fa0b', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000021D640BF470>]}
[0m20:46:35.366948 [info ] [MainThread]: Registered adapter: fabric=1.9.8
[0m20:46:35.536638 [debug] [MainThread]: checksum: c4b99e2e3bb042c661c8397fd92290cd0d52b31ce393ad721fa0bb3c9591dd0f, vars: {}, profile: , target: , version: 1.10.16
[0m20:46:35.680211 [info ] [MainThread]: Unable to do partial parsing because profile has changed
[0m20:46:35.680211 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'partial_parser', 'label': '9ac48c94-6fc2-4083-bc2f-4841b101fa0b', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000021D646B2120>]}
[0m20:46:37.062215 [warn ] [MainThread]: [[33mWARNING[0m][MissingArgumentsPropertyInGenericTestDeprecation]: Deprecated
functionality
Found top-level arguments to test `relationships`. Arguments to generic tests
should be nested under the `arguments` property.`
[0m20:46:37.062215 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'deprecation', 'label': '9ac48c94-6fc2-4083-bc2f-4841b101fa0b', 'property_': 'warn', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000021D64C1FEF0>]}
[0m20:46:37.187532 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'load_project', 'label': '9ac48c94-6fc2-4083-bc2f-4841b101fa0b', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000021D64BE0650>]}
[0m20:46:37.251369 [debug] [MainThread]: Wrote artifact WritableManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\target\manifest.json
[0m20:46:37.251369 [debug] [MainThread]: Wrote artifact SemanticManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\target\semantic_manifest.json
[0m20:46:37.267095 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'resource_counts', 'label': '9ac48c94-6fc2-4083-bc2f-4841b101fa0b', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000021D64E16840>]}
[0m20:46:37.267095 [info ] [MainThread]: Found 5 models, 3 seeds, 20 data tests, 500 macros
[0m20:46:37.267095 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'runnable_timing', 'label': '9ac48c94-6fc2-4083-bc2f-4841b101fa0b', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000021D64DBA420>]}
[0m20:46:37.267095 [info ] [MainThread]: 
[0m20:46:37.283011 [info ] [MainThread]: Concurrency: 4 threads (target='fabric-dev')
[0m20:46:37.283011 [info ] [MainThread]: 
[0m20:46:37.283011 [debug] [MainThread]: Acquiring new fabric connection 'master'
[0m20:46:37.283011 [debug] [ThreadPool]: Acquiring new fabric connection 'list_ws_ssc_articles'
[0m20:46:37.300742 [debug] [ThreadPool]: dbt-fabric
[0m20:46:37.301171 [debug] [ThreadPool]: Using fabric connection "list_ws_ssc_articles"
[0m20:46:37.301171 [debug] [ThreadPool]: On list_ws_ssc_articles: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "connection_name": "list_ws_ssc_articles"} */
USE [ws_ssc_articles];
    select  name as [schema]
    from sys.schemas  
    OPTION (LABEL = 'dbt-fabric-dw');

  
[0m20:46:37.301171 [debug] [ThreadPool]: Opening a new connection, currently in state init
[0m20:46:37.301171 [debug] [ThreadPool]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:46:57.134956 [debug] [ThreadPool]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:46:57.167099 [debug] [ThreadPool]: SQL status: OK in 20.000 seconds
[0m20:46:57.182575 [debug] [ThreadPool]: On list_ws_ssc_articles: Close
[0m20:46:57.182575 [debug] [ThreadPool]: Acquiring new fabric connection 'list_ws_ssc_articles_dbo'
[0m20:46:57.182575 [debug] [ThreadPool]: dbt-fabric
[0m20:46:57.182575 [debug] [ThreadPool]: Using fabric connection "list_ws_ssc_articles_dbo"
[0m20:46:57.182575 [debug] [ThreadPool]: On list_ws_ssc_articles_dbo: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "connection_name": "list_ws_ssc_articles_dbo"} */
USE [ws_ssc_articles];
    with base as (
      select
        DB_NAME() as [database],
        t.name as [name],
        SCHEMA_NAME(t.schema_id) as [schema],
        'table' as table_type
      from sys.tables as t 
      union all
      select
        DB_NAME() as [database],
        v.name as [name],
        SCHEMA_NAME(v.schema_id) as [schema],
        'view' as table_type
      from sys.views as v 
    )
    select * from base
    where [schema] like 'dbo'
    
    OPTION (LABEL = 'dbt-fabric-dw');

  
[0m20:46:57.182575 [debug] [ThreadPool]: Opening a new connection, currently in state init
[0m20:46:57.182575 [debug] [ThreadPool]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:46:57.198366 [debug] [ThreadPool]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:46:57.263053 [debug] [ThreadPool]: SQL status: OK in 0.000 seconds
[0m20:46:57.263053 [debug] [ThreadPool]: On list_ws_ssc_articles_dbo: ROLLBACK
[0m20:46:57.263053 [debug] [ThreadPool]: On list_ws_ssc_articles_dbo: Close
[0m20:46:57.263053 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'runnable_timing', 'label': '9ac48c94-6fc2-4083-bc2f-4841b101fa0b', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000021D64E2B6B0>]}
[0m20:46:57.263053 [debug] [MainThread]: On master: COMMIT
[0m20:46:57.358652 [debug] [Thread-1 (]: Began running node seed.jaffle_shop.raw_customers
[0m20:46:57.358652 [debug] [Thread-2 (]: Began running node seed.jaffle_shop.raw_orders
[0m20:46:57.358652 [debug] [Thread-3 (]: Began running node seed.jaffle_shop.raw_payments
[0m20:46:57.358652 [info ] [Thread-1 (]: 1 of 3 START seed file dbo.raw_customers ....................................... [RUN]
[0m20:46:57.358652 [info ] [Thread-2 (]: 2 of 3 START seed file dbo.raw_orders .......................................... [RUN]
[0m20:46:57.358652 [debug] [Thread-1 (]: Acquiring new fabric connection 'seed.jaffle_shop.raw_customers'
[0m20:46:57.358652 [debug] [Thread-2 (]: Acquiring new fabric connection 'seed.jaffle_shop.raw_orders'
[0m20:46:57.358652 [info ] [Thread-3 (]: 3 of 3 START seed file dbo.raw_payments ........................................ [RUN]
[0m20:46:57.358652 [debug] [Thread-1 (]: Began compiling node seed.jaffle_shop.raw_customers
[0m20:46:57.358652 [debug] [Thread-2 (]: Began compiling node seed.jaffle_shop.raw_orders
[0m20:46:57.358652 [debug] [Thread-3 (]: Acquiring new fabric connection 'seed.jaffle_shop.raw_payments'
[0m20:46:57.358652 [debug] [Thread-1 (]: Began executing node seed.jaffle_shop.raw_customers
[0m20:46:57.358652 [debug] [Thread-2 (]: Began executing node seed.jaffle_shop.raw_orders
[0m20:46:57.358652 [debug] [Thread-3 (]: Began compiling node seed.jaffle_shop.raw_payments
[0m20:46:57.394842 [debug] [Thread-3 (]: Began executing node seed.jaffle_shop.raw_payments
[0m20:46:57.412581 [debug] [Thread-1 (]: Using fabric connection "seed.jaffle_shop.raw_customers"
[0m20:46:57.412581 [debug] [Thread-1 (]: On seed.jaffle_shop.raw_customers: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "seed.jaffle_shop.raw_customers"} */

    create table "ws_ssc_articles"."dbo"."raw_customers" ("id" int,"first_name" varchar(16),"last_name" varchar(16))
  
[0m20:46:57.412581 [debug] [Thread-2 (]: Using fabric connection "seed.jaffle_shop.raw_orders"
[0m20:46:57.424497 [debug] [Thread-1 (]: Opening a new connection, currently in state init
[0m20:46:57.424497 [debug] [Thread-2 (]: On seed.jaffle_shop.raw_orders: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "seed.jaffle_shop.raw_orders"} */

    create table "ws_ssc_articles"."dbo"."raw_orders" ("id" int,"user_id" int,"order_date" date,"status" varchar(16))
  
[0m20:46:57.425926 [debug] [Thread-3 (]: Using fabric connection "seed.jaffle_shop.raw_payments"
[0m20:46:57.425926 [debug] [Thread-1 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:46:57.425926 [debug] [Thread-2 (]: Opening a new connection, currently in state init
[0m20:46:57.425926 [debug] [Thread-3 (]: On seed.jaffle_shop.raw_payments: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "seed.jaffle_shop.raw_payments"} */

    create table "ws_ssc_articles"."dbo"."raw_payments" ("id" int,"order_id" int,"payment_method" varchar(16),"amount" int)
  
[0m20:46:57.425926 [debug] [Thread-2 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:46:57.425926 [debug] [Thread-3 (]: Opening a new connection, currently in state init
[0m20:46:57.425926 [debug] [Thread-2 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:46:57.425926 [debug] [Thread-3 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:46:57.764660 [debug] [Thread-2 (]: SQL status: OK in 0.000 seconds
[0m20:46:57.785088 [debug] [Thread-2 (]: Inserting batches of 400 records
[0m20:46:57.867829 [debug] [Thread-2 (]: dbt-fabric
[0m20:46:57.867829 [debug] [Thread-2 (]: Using fabric connection "seed.jaffle_shop.raw_orders"
[0m20:46:57.867829 [debug] [Thread-2 (]: On seed.jaffle_shop.raw_orders: 
            insert into "ws_ssc_articles"."dbo"."raw_orders" ("id", "user_id", "order_date", "status") values
            (?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?)...
[0m20:46:58.021146 [debug] [Thread-1 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:46:58.165405 [debug] [Thread-3 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:46:58.229925 [debug] [Thread-1 (]: SQL status: OK in 1.000 seconds
[0m20:46:58.245916 [debug] [Thread-1 (]: Inserting batches of 400 records
[0m20:46:58.293820 [debug] [Thread-1 (]: dbt-fabric
[0m20:46:58.293820 [debug] [Thread-1 (]: Using fabric connection "seed.jaffle_shop.raw_customers"
[0m20:46:58.293820 [debug] [Thread-1 (]: On seed.jaffle_shop.raw_customers: 
            insert into "ws_ssc_articles"."dbo"."raw_customers" ("id", "first_name", "last_name") values
            (?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?...
[0m20:46:58.373924 [debug] [Thread-3 (]: SQL status: OK in 1.000 seconds
[0m20:46:58.373924 [debug] [Thread-3 (]: Inserting batches of 400 records
[0m20:46:58.454181 [debug] [Thread-3 (]: dbt-fabric
[0m20:46:58.454181 [debug] [Thread-3 (]: Using fabric connection "seed.jaffle_shop.raw_payments"
[0m20:46:58.454181 [debug] [Thread-3 (]: On seed.jaffle_shop.raw_payments: 
            insert into "ws_ssc_articles"."dbo"."raw_payments" ("id", "order_id", "payment_method", "amount") values
            (?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?...
[0m20:46:58.603061 [debug] [Thread-2 (]: SQL status: OK in 1.000 seconds
[0m20:46:58.641629 [debug] [Thread-2 (]: Writing runtime SQL for node "seed.jaffle_shop.raw_orders"
[0m20:46:58.674940 [debug] [Thread-2 (]: On seed.jaffle_shop.raw_orders: COMMIT
[0m20:46:58.674940 [debug] [Thread-2 (]: On seed.jaffle_shop.raw_orders: Close
[0m20:46:58.680806 [debug] [Thread-2 (]: Sending event: {'category': 'dbt', 'action': 'run_model', 'label': '9ac48c94-6fc2-4083-bc2f-4841b101fa0b', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000021D61D5C5C0>]}
[0m20:46:58.680806 [info ] [Thread-2 (]: 2 of 3 OK loaded seed file dbo.raw_orders ...................................... [[32mINSERT 99[0m in 1.32s]
[0m20:46:58.680806 [debug] [Thread-2 (]: Finished running node seed.jaffle_shop.raw_orders
[0m20:46:58.806339 [debug] [Thread-1 (]: SQL status: OK in 1.000 seconds
[0m20:46:58.849643 [debug] [Thread-1 (]: Writing runtime SQL for node "seed.jaffle_shop.raw_customers"
[0m20:46:58.860375 [debug] [Thread-1 (]: On seed.jaffle_shop.raw_customers: COMMIT
[0m20:46:58.860375 [debug] [Thread-1 (]: On seed.jaffle_shop.raw_customers: Close
[0m20:46:58.860375 [debug] [Thread-1 (]: Sending event: {'category': 'dbt', 'action': 'run_model', 'label': '9ac48c94-6fc2-4083-bc2f-4841b101fa0b', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000021D64BEBB00>]}
[0m20:46:58.860375 [info ] [Thread-1 (]: 1 of 3 OK loaded seed file dbo.raw_customers ................................... [[32mINSERT 100[0m in 1.50s]
[0m20:46:58.865834 [debug] [Thread-1 (]: Finished running node seed.jaffle_shop.raw_customers
[0m20:46:59.137510 [debug] [Thread-3 (]: SQL status: OK in 1.000 seconds
[0m20:46:59.167715 [debug] [Thread-3 (]: Writing runtime SQL for node "seed.jaffle_shop.raw_payments"
[0m20:46:59.190757 [debug] [Thread-3 (]: On seed.jaffle_shop.raw_payments: COMMIT
[0m20:46:59.200404 [debug] [Thread-3 (]: On seed.jaffle_shop.raw_payments: Close
[0m20:46:59.200404 [debug] [Thread-3 (]: Sending event: {'category': 'dbt', 'action': 'run_model', 'label': '9ac48c94-6fc2-4083-bc2f-4841b101fa0b', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000021D64E65100>]}
[0m20:46:59.200404 [info ] [Thread-3 (]: 3 of 3 OK loaded seed file dbo.raw_payments .................................... [[32mINSERT 113[0m in 1.84s]
[0m20:46:59.200404 [debug] [Thread-3 (]: Finished running node seed.jaffle_shop.raw_payments
[0m20:46:59.200404 [debug] [MainThread]: On master: COMMIT
[0m20:46:59.200404 [debug] [MainThread]: Connection 'master' was properly closed.
[0m20:46:59.200404 [debug] [MainThread]: Connection 'list_ws_ssc_articles' was properly closed.
[0m20:46:59.200404 [debug] [MainThread]: Connection 'list_ws_ssc_articles_dbo' was properly closed.
[0m20:46:59.200404 [debug] [MainThread]: Connection 'seed.jaffle_shop.raw_customers' was properly closed.
[0m20:46:59.200404 [debug] [MainThread]: Connection 'seed.jaffle_shop.raw_orders' was properly closed.
[0m20:46:59.200404 [debug] [MainThread]: Connection 'seed.jaffle_shop.raw_payments' was properly closed.
[0m20:46:59.200404 [info ] [MainThread]: 
[0m20:46:59.200404 [info ] [MainThread]: Finished running 3 seeds in 0 hours 0 minutes and 21.92 seconds (21.92s).
[0m20:46:59.211068 [debug] [MainThread]: Command end result
[0m20:46:59.242755 [debug] [MainThread]: Wrote artifact WritableManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\target\manifest.json
[0m20:46:59.242755 [debug] [MainThread]: Wrote artifact SemanticManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\target\semantic_manifest.json
[0m20:46:59.257948 [debug] [MainThread]: Wrote artifact RunExecutionResult to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\target\run_results.json
[0m20:46:59.259071 [info ] [MainThread]: 
[0m20:46:59.259071 [info ] [MainThread]: [32mCompleted successfully[0m
[0m20:46:59.260062 [info ] [MainThread]: 
[0m20:46:59.261066 [info ] [MainThread]: Done. PASS=3 WARN=0 ERROR=0 SKIP=0 NO-OP=0 TOTAL=3
[0m20:46:59.262063 [warn ] [MainThread]: [[33mWARNING[0m][DeprecationsSummary]: Deprecated functionality
Summary of encountered deprecations:
- ProjectFlagsMovedDeprecation: 1 occurrence
- MissingArgumentsPropertyInGenericTestDeprecation: 4 occurrences
To see all deprecation instances instead of just the first occurrence of each,
run command again with the `--show-all-deprecations` flag. You may also need to
run with `--no-partial-parse` as some deprecations are only encountered during
parsing.
[0m20:46:59.264077 [debug] [MainThread]: Command `dbt seed` succeeded at 20:46:59.262956 after 24.68 seconds
[0m20:46:59.264077 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'end', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000021D64DEB860>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000021D625E0EC0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000021D64AB8E00>]}
[0m20:46:59.265060 [debug] [MainThread]: Flushing usage events
[0m20:46:59.381344 [debug] [MainThread]: An error was encountered while trying to flush usage events
[0m20:47:48.593879 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'start', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024CEE2C8F50>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024CEEF476B0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024CEEE1A870>]}


============================== 20:47:48.609932 | 62df7efe-209e-4a03-8416-b5bfc6443faf ==============================
[0m20:47:48.609932 [info ] [MainThread]: Running with dbt=1.10.16
[0m20:47:48.609932 [debug] [MainThread]: running dbt with arguments {'version_check': 'True', 'no_print': 'None', 'static_parser': 'True', 'target_path': 'None', 'warn_error_options': 'WarnErrorOptionsV2(error=[], warn=[], silence=[])', 'printer_width': '80', 'write_json': 'True', 'introspect': 'True', 'log_cache_events': 'False', 'empty': 'False', 'cache_selected_only': 'False', 'fail_fast': 'False', 'debug': 'False', 'log_format': 'default', 'partial_parse': 'True', 'send_anonymous_usage_stats': 'True', 'quiet': 'False', 'warn_error': 'None', 'profiles_dir': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\jaffle-shop-classic', 'invocation_command': 'dbt run', 'indirect_selection': 'eager', 'use_colors': 'True', 'use_experimental_parser': 'False', 'log_path': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\jaffle-shop-classic\\logs'}
[0m20:47:48.609932 [warn ] [MainThread]: [[33mWARNING[0m]: Deprecated functionality

User config should be moved from the 'config' key in profiles.yml to the 'flags' key in dbt_project.yml.
[0m20:47:48.609932 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'deprecation', 'label': '62df7efe-209e-4a03-8416-b5bfc6443faf', 'property_': 'warn', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024CEEB10B30>]}
[0m20:47:49.122736 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'project_id', 'label': '62df7efe-209e-4a03-8416-b5bfc6443faf', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024CEE2F04A0>]}
[0m20:47:49.183760 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'adapter_info', 'label': '62df7efe-209e-4a03-8416-b5bfc6443faf', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024CF0A04D70>]}
[0m20:47:49.185766 [info ] [MainThread]: Registered adapter: fabric=1.9.8
[0m20:47:49.375415 [debug] [MainThread]: checksum: c4b99e2e3bb042c661c8397fd92290cd0d52b31ce393ad721fa0bb3c9591dd0f, vars: {}, profile: , target: , version: 1.10.16
[0m20:47:49.572627 [debug] [MainThread]: Partial parsing enabled: 0 files deleted, 0 files added, 0 files changed.
[0m20:47:49.572627 [debug] [MainThread]: Partial parsing enabled, no changes found, skipping parsing
[0m20:47:49.608844 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'load_project', 'label': '62df7efe-209e-4a03-8416-b5bfc6443faf', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024CF0DB4DA0>]}
[0m20:47:49.656834 [debug] [MainThread]: Wrote artifact WritableManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\target\manifest.json
[0m20:47:49.656834 [debug] [MainThread]: Wrote artifact SemanticManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\target\semantic_manifest.json
[0m20:47:49.693727 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'resource_counts', 'label': '62df7efe-209e-4a03-8416-b5bfc6443faf', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024CF1015F40>]}
[0m20:47:49.693727 [info ] [MainThread]: Found 5 models, 3 seeds, 20 data tests, 500 macros
[0m20:47:49.693727 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'runnable_timing', 'label': '62df7efe-209e-4a03-8416-b5bfc6443faf', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024CF0A50380>]}
[0m20:47:49.693727 [info ] [MainThread]: 
[0m20:47:49.693727 [info ] [MainThread]: Concurrency: 4 threads (target='fabric-dev')
[0m20:47:49.693727 [info ] [MainThread]: 
[0m20:47:49.693727 [debug] [MainThread]: Acquiring new fabric connection 'master'
[0m20:47:49.704247 [debug] [ThreadPool]: Acquiring new fabric connection 'list_ws_ssc_articles'
[0m20:47:49.719185 [debug] [ThreadPool]: dbt-fabric
[0m20:47:49.719185 [debug] [ThreadPool]: Using fabric connection "list_ws_ssc_articles"
[0m20:47:49.719185 [debug] [ThreadPool]: On list_ws_ssc_articles: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "connection_name": "list_ws_ssc_articles"} */
USE [ws_ssc_articles];
    select  name as [schema]
    from sys.schemas  
    OPTION (LABEL = 'dbt-fabric-dw');

  
[0m20:47:49.719185 [debug] [ThreadPool]: Opening a new connection, currently in state init
[0m20:47:49.719185 [debug] [ThreadPool]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:48:08.810727 [debug] [ThreadPool]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:48:08.810727 [warn ] [ThreadPool]: fabric adapter: No workspace_id provided; skipping snapshot management.
[0m20:48:08.848458 [debug] [ThreadPool]: SQL status: OK in 19.000 seconds
[0m20:48:08.848458 [debug] [ThreadPool]: On list_ws_ssc_articles: Close
[0m20:48:08.864900 [debug] [ThreadPool]: Acquiring new fabric connection 'list_ws_ssc_articles_dbo'
[0m20:48:08.873952 [debug] [ThreadPool]: dbt-fabric
[0m20:48:08.874958 [debug] [ThreadPool]: Using fabric connection "list_ws_ssc_articles_dbo"
[0m20:48:08.874958 [debug] [ThreadPool]: On list_ws_ssc_articles_dbo: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "connection_name": "list_ws_ssc_articles_dbo"} */
USE [ws_ssc_articles];
    with base as (
      select
        DB_NAME() as [database],
        t.name as [name],
        SCHEMA_NAME(t.schema_id) as [schema],
        'table' as table_type
      from sys.tables as t 
      union all
      select
        DB_NAME() as [database],
        v.name as [name],
        SCHEMA_NAME(v.schema_id) as [schema],
        'view' as table_type
      from sys.views as v 
    )
    select * from base
    where [schema] like 'dbo'
    
    OPTION (LABEL = 'dbt-fabric-dw');

  
[0m20:48:08.875958 [debug] [ThreadPool]: Opening a new connection, currently in state init
[0m20:48:08.876578 [debug] [ThreadPool]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:48:08.876578 [debug] [ThreadPool]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:48:08.913971 [debug] [ThreadPool]: SQL status: OK in 0.000 seconds
[0m20:48:08.913971 [debug] [ThreadPool]: On list_ws_ssc_articles_dbo: ROLLBACK
[0m20:48:08.913971 [debug] [ThreadPool]: On list_ws_ssc_articles_dbo: Close
[0m20:48:08.913971 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'runnable_timing', 'label': '62df7efe-209e-4a03-8416-b5bfc6443faf', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024CEBFEE0F0>]}
[0m20:48:08.929885 [debug] [MainThread]: On master: COMMIT
[0m20:48:08.932007 [debug] [Thread-1 (]: Began running node model.jaffle_shop.stg_customers
[0m20:48:08.932007 [debug] [Thread-2 (]: Began running node model.jaffle_shop.stg_orders
[0m20:48:08.932007 [debug] [Thread-3 (]: Began running node model.jaffle_shop.stg_payments
[0m20:48:08.932007 [info ] [Thread-1 (]: 1 of 5 START sql view model dbo.stg_customers .................................. [RUN]
[0m20:48:08.932007 [info ] [Thread-2 (]: 2 of 5 START sql view model dbo.stg_orders ..................................... [RUN]
[0m20:48:08.932007 [debug] [Thread-1 (]: Acquiring new fabric connection 'model.jaffle_shop.stg_customers'
[0m20:48:08.932007 [debug] [Thread-2 (]: Acquiring new fabric connection 'model.jaffle_shop.stg_orders'
[0m20:48:08.932007 [info ] [Thread-3 (]: 3 of 5 START sql view model dbo.stg_payments ................................... [RUN]
[0m20:48:08.932007 [debug] [Thread-1 (]: Began compiling node model.jaffle_shop.stg_customers
[0m20:48:08.932007 [debug] [Thread-2 (]: Began compiling node model.jaffle_shop.stg_orders
[0m20:48:08.932007 [debug] [Thread-3 (]: Acquiring new fabric connection 'model.jaffle_shop.stg_payments'
[0m20:48:08.952247 [debug] [Thread-2 (]: Writing injected SQL for node "model.jaffle_shop.stg_orders"
[0m20:48:08.998077 [debug] [Thread-3 (]: Began compiling node model.jaffle_shop.stg_payments
[0m20:48:08.998077 [debug] [Thread-1 (]: Writing injected SQL for node "model.jaffle_shop.stg_customers"
[0m20:48:08.998077 [debug] [Thread-3 (]: Writing injected SQL for node "model.jaffle_shop.stg_payments"
[0m20:48:09.019883 [debug] [Thread-1 (]: Began executing node model.jaffle_shop.stg_customers
[0m20:48:09.039180 [debug] [Thread-1 (]: Writing runtime sql for node "model.jaffle_shop.stg_customers"
[0m20:48:09.040176 [debug] [Thread-3 (]: Began executing node model.jaffle_shop.stg_payments
[0m20:48:09.044178 [debug] [Thread-3 (]: Writing runtime sql for node "model.jaffle_shop.stg_payments"
[0m20:48:09.044178 [debug] [Thread-2 (]: Began executing node model.jaffle_shop.stg_orders
[0m20:48:09.047177 [debug] [Thread-2 (]: Writing runtime sql for node "model.jaffle_shop.stg_orders"
[0m20:48:09.048176 [debug] [Thread-1 (]: Using fabric connection "model.jaffle_shop.stg_customers"
[0m20:48:09.048176 [debug] [Thread-1 (]: On model.jaffle_shop.stg_customers: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "model.jaffle_shop.stg_customers"} */
USE [ws_ssc_articles];
    
    

    EXEC('create view "dbo"."stg_customers" as with source as (
    select * from "ws_ssc_articles"."dbo"."raw_customers"

),

renamed as (

    select
        id as customer_id,
        first_name,
        last_name

    from source

)

select * from renamed;');



[0m20:48:09.048176 [debug] [Thread-1 (]: Opening a new connection, currently in state init
[0m20:48:09.048176 [debug] [Thread-1 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:48:09.048176 [debug] [Thread-1 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:48:09.048176 [debug] [Thread-3 (]: Using fabric connection "model.jaffle_shop.stg_payments"
[0m20:48:09.048176 [debug] [Thread-3 (]: On model.jaffle_shop.stg_payments: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "model.jaffle_shop.stg_payments"} */
USE [ws_ssc_articles];
    
    

    EXEC('create view "dbo"."stg_payments" as with source as (
    select * from "ws_ssc_articles"."dbo"."raw_payments"

),

renamed as (

    select
        id as payment_id,
        order_id,
        payment_method,

        -- `amount` is currently stored in cents, so we convert it to dollars
        amount / 100 as amount

    from source

)

select * from renamed;');



[0m20:48:09.048176 [debug] [Thread-2 (]: Using fabric connection "model.jaffle_shop.stg_orders"
[0m20:48:09.048176 [debug] [Thread-3 (]: Opening a new connection, currently in state init
[0m20:48:09.048176 [debug] [Thread-2 (]: On model.jaffle_shop.stg_orders: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "model.jaffle_shop.stg_orders"} */
USE [ws_ssc_articles];
    
    

    EXEC('create view "dbo"."stg_orders" as with source as (
    select * from "ws_ssc_articles"."dbo"."raw_orders"

),

renamed as (

    select
        id as order_id,
        user_id as customer_id,
        order_date,
        status

    from source

)

select * from renamed;');



[0m20:48:09.048176 [debug] [Thread-3 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:48:09.048176 [debug] [Thread-2 (]: Opening a new connection, currently in state init
[0m20:48:09.048176 [debug] [Thread-2 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:48:09.112281 [debug] [Thread-1 (]: SQL status: OK in 0.000 seconds
[0m20:48:09.132257 [debug] [Thread-1 (]: On model.jaffle_shop.stg_customers: COMMIT
[0m20:48:09.132257 [debug] [Thread-1 (]: On model.jaffle_shop.stg_customers: Close
[0m20:48:09.132257 [debug] [Thread-1 (]: Sending event: {'category': 'dbt', 'action': 'run_model', 'label': '62df7efe-209e-4a03-8416-b5bfc6443faf', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024CF02D6DB0>]}
[0m20:48:09.132257 [info ] [Thread-1 (]: 1 of 5 OK created sql view model dbo.stg_customers ............................. [[32mOK[0m in 0.20s]
[0m20:48:09.132257 [debug] [Thread-1 (]: Finished running node model.jaffle_shop.stg_customers
[0m20:48:09.664053 [debug] [Thread-2 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:48:09.664053 [debug] [Thread-3 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:48:09.711925 [debug] [Thread-3 (]: SQL status: OK in 1.000 seconds
[0m20:48:09.711925 [debug] [Thread-2 (]: SQL status: OK in 1.000 seconds
[0m20:48:09.711925 [debug] [Thread-3 (]: On model.jaffle_shop.stg_payments: COMMIT
[0m20:48:09.711925 [debug] [Thread-2 (]: On model.jaffle_shop.stg_orders: COMMIT
[0m20:48:09.728002 [debug] [Thread-3 (]: On model.jaffle_shop.stg_payments: Close
[0m20:48:09.738008 [debug] [Thread-2 (]: On model.jaffle_shop.stg_orders: Close
[0m20:48:09.738008 [debug] [Thread-3 (]: Sending event: {'category': 'dbt', 'action': 'run_model', 'label': '62df7efe-209e-4a03-8416-b5bfc6443faf', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024CF102E7B0>]}
[0m20:48:09.738008 [debug] [Thread-2 (]: Sending event: {'category': 'dbt', 'action': 'run_model', 'label': '62df7efe-209e-4a03-8416-b5bfc6443faf', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024CF02D6DB0>]}
[0m20:48:09.738008 [info ] [Thread-3 (]: 3 of 5 OK created sql view model dbo.stg_payments .............................. [[32mOK[0m in 0.81s]
[0m20:48:09.738008 [debug] [Thread-3 (]: Finished running node model.jaffle_shop.stg_payments
[0m20:48:09.738008 [info ] [Thread-2 (]: 2 of 5 OK created sql view model dbo.stg_orders ................................ [[32mOK[0m in 0.81s]
[0m20:48:09.743885 [debug] [Thread-2 (]: Finished running node model.jaffle_shop.stg_orders
[0m20:48:09.743885 [debug] [Thread-4 (]: Began running node model.jaffle_shop.customers
[0m20:48:09.743885 [debug] [Thread-1 (]: Began running node model.jaffle_shop.orders
[0m20:48:09.743885 [info ] [Thread-4 (]: 4 of 5 START sql table model dbo.customers ..................................... [RUN]
[0m20:48:09.743885 [debug] [Thread-4 (]: Acquiring new fabric connection 'model.jaffle_shop.customers'
[0m20:48:09.743885 [info ] [Thread-1 (]: 5 of 5 START sql table model dbo.orders ........................................ [RUN]
[0m20:48:09.748001 [debug] [Thread-4 (]: Began compiling node model.jaffle_shop.customers
[0m20:48:09.748001 [debug] [Thread-1 (]: Re-using an available connection from the pool (formerly model.jaffle_shop.stg_customers, now model.jaffle_shop.orders)
[0m20:48:09.751622 [debug] [Thread-4 (]: Writing injected SQL for node "model.jaffle_shop.customers"
[0m20:48:09.752641 [debug] [Thread-1 (]: Began compiling node model.jaffle_shop.orders
[0m20:48:09.756956 [debug] [Thread-1 (]: Writing injected SQL for node "model.jaffle_shop.orders"
[0m20:48:09.759167 [debug] [Thread-4 (]: Began executing node model.jaffle_shop.customers
[0m20:48:09.768820 [debug] [Thread-1 (]: Began executing node model.jaffle_shop.orders
[0m20:48:09.782073 [debug] [Thread-1 (]: Applying DROP to: "ws_ssc_articles"."dbo"."orders__dbt_temp"
[0m20:48:09.782073 [debug] [Thread-4 (]: Applying DROP to: "ws_ssc_articles"."dbo"."customers__dbt_temp"
[0m20:48:09.782073 [debug] [Thread-1 (]: Using fabric connection "model.jaffle_shop.orders"
[0m20:48:09.782073 [debug] [Thread-4 (]: Using fabric connection "model.jaffle_shop.customers"
[0m20:48:09.782073 [debug] [Thread-1 (]: On model.jaffle_shop.orders: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "model.jaffle_shop.orders"} */

      
    USE [ws_ssc_articles];
    EXEC('DROP table IF EXISTS "dbo"."orders__dbt_temp";');

[0m20:48:09.782073 [debug] [Thread-4 (]: On model.jaffle_shop.customers: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "model.jaffle_shop.customers"} */

      
    USE [ws_ssc_articles];
    EXEC('DROP table IF EXISTS "dbo"."customers__dbt_temp";');

[0m20:48:09.782073 [debug] [Thread-1 (]: Opening a new connection, currently in state closed
[0m20:48:09.782073 [debug] [Thread-4 (]: Opening a new connection, currently in state init
[0m20:48:09.797102 [debug] [Thread-1 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:48:09.797102 [debug] [Thread-4 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:48:09.798146 [debug] [Thread-1 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:48:09.834252 [debug] [Thread-1 (]: SQL status: OK in 0.000 seconds
[0m20:48:09.834252 [debug] [Thread-1 (]: Applying DROP to: "ws_ssc_articles"."dbo"."orders__dbt_temp__dbt_tmp_vw"
[0m20:48:09.834252 [debug] [Thread-1 (]: dbt-fabric
[0m20:48:09.834252 [debug] [Thread-1 (]: Using fabric connection "model.jaffle_shop.orders"
[0m20:48:09.834252 [debug] [Thread-1 (]: On model.jaffle_shop.orders: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "model.jaffle_shop.orders"} */

        USE [ws_ssc_articles];
        select
            sch.name as schema_name,
            obj.name as view_name
        from sys.sql_expression_dependencies refs
        inner join sys.objects obj
        on refs.referencing_id = obj.object_id
        inner join sys.schemas sch
        on obj.schema_id = sch.schema_id
        where refs.referenced_database_name = 'ws_ssc_articles'
        and refs.referenced_schema_name = 'dbo'
        and refs.referenced_entity_name = 'orders__dbt_temp__dbt_tmp_vw'
        and refs.referencing_class = 1
        and obj.type = 'V'
        
    OPTION (LABEL = 'dbt-fabric-dw');

      
[0m20:48:09.974271 [debug] [Thread-1 (]: SQL status: OK in 0.000 seconds
[0m20:48:09.974271 [debug] [Thread-1 (]: Using fabric connection "model.jaffle_shop.orders"
[0m20:48:09.990269 [debug] [Thread-1 (]: On model.jaffle_shop.orders: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "model.jaffle_shop.orders"} */

      
      
    
    USE [ws_ssc_articles];
    EXEC('DROP view IF EXISTS "dbo"."orders__dbt_temp__dbt_tmp_vw";');

[0m20:48:10.022411 [debug] [Thread-1 (]: SQL status: OK in 0.000 seconds
[0m20:48:10.038240 [debug] [Thread-1 (]: dbt-fabric
[0m20:48:10.038240 [debug] [Thread-1 (]: Applying DROP to: "ws_ssc_articles"."dbo"."orders__dbt_temp__dbt_tmp_vw"
[0m20:48:10.038240 [debug] [Thread-1 (]: dbt-fabric
[0m20:48:10.038240 [debug] [Thread-1 (]: Using fabric connection "model.jaffle_shop.orders"
[0m20:48:10.038240 [debug] [Thread-1 (]: On model.jaffle_shop.orders: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "model.jaffle_shop.orders"} */

        USE [ws_ssc_articles];
        select
            sch.name as schema_name,
            obj.name as view_name
        from sys.sql_expression_dependencies refs
        inner join sys.objects obj
        on refs.referencing_id = obj.object_id
        inner join sys.schemas sch
        on obj.schema_id = sch.schema_id
        where refs.referenced_database_name = 'ws_ssc_articles'
        and refs.referenced_schema_name = 'dbo'
        and refs.referenced_entity_name = 'orders__dbt_temp__dbt_tmp_vw'
        and refs.referencing_class = 1
        and obj.type = 'V'
        
    OPTION (LABEL = 'dbt-fabric-dw');

      
[0m20:48:10.086251 [debug] [Thread-1 (]: SQL status: OK in 0.000 seconds
[0m20:48:10.086251 [debug] [Thread-1 (]: Using fabric connection "model.jaffle_shop.orders"
[0m20:48:10.086251 [debug] [Thread-1 (]: On model.jaffle_shop.orders: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "model.jaffle_shop.orders"} */

      
      
    
    USE [ws_ssc_articles];
    EXEC('DROP view IF EXISTS "dbo"."orders__dbt_temp__dbt_tmp_vw";');

[0m20:48:10.134536 [debug] [Thread-1 (]: SQL status: OK in 0.000 seconds
[0m20:48:10.134536 [debug] [Thread-1 (]: Writing runtime sql for node "model.jaffle_shop.orders"
[0m20:48:10.134536 [debug] [Thread-1 (]: Using fabric connection "model.jaffle_shop.orders"
[0m20:48:10.134536 [debug] [Thread-1 (]: On model.jaffle_shop.orders: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "model.jaffle_shop.orders"} */

  
    
    
    USE [ws_ssc_articles];
    
    

    EXEC('create view "dbo"."orders__dbt_temp__dbt_tmp_vw" as 

with orders as (

    select * from "ws_ssc_articles"."dbo"."stg_orders"

),

payments as (

    select * from "ws_ssc_articles"."dbo"."stg_payments"

),

order_payments as (

    select
        order_id,

        sum(case when payment_method = ''credit_card'' then amount else 0 end) as credit_card_amount,
        sum(case when payment_method = ''coupon'' then amount else 0 end) as coupon_amount,
        sum(case when payment_method = ''bank_transfer'' then amount else 0 end) as bank_transfer_amount,
        sum(case when payment_method = ''gift_card'' then amount else 0 end) as gift_card_amount,
        sum(amount) as total_amount

    from payments

    group by order_id

),

final as (

    select
        orders.order_id,
        orders.customer_id,
        orders.order_date,
        orders.status,

        order_payments.credit_card_amount,

        order_payments.coupon_amount,

        order_payments.bank_transfer_amount,

        order_payments.gift_card_amount,

        order_payments.total_amount as amount

    from orders


    left join order_payments
        on orders.order_id = order_payments.order_id

)

select * from final;');




    
    
            EXEC('CREATE TABLE "ws_ssc_articles"."dbo"."orders__dbt_temp" AS SELECT * FROM "ws_ssc_articles"."dbo"."orders__dbt_temp__dbt_tmp_vw" 
    OPTION (LABEL = ''dbt-fabric-dw'');
');
        

    

  
  
[0m20:48:10.353939 [debug] [Thread-4 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:48:10.398645 [debug] [Thread-4 (]: SQL status: OK in 1.000 seconds
[0m20:48:10.398645 [debug] [Thread-4 (]: Applying DROP to: "ws_ssc_articles"."dbo"."customers__dbt_temp__dbt_tmp_vw"
[0m20:48:10.398645 [debug] [Thread-4 (]: dbt-fabric
[0m20:48:10.414482 [debug] [Thread-4 (]: Using fabric connection "model.jaffle_shop.customers"
[0m20:48:10.414482 [debug] [Thread-4 (]: On model.jaffle_shop.customers: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "model.jaffle_shop.customers"} */

        USE [ws_ssc_articles];
        select
            sch.name as schema_name,
            obj.name as view_name
        from sys.sql_expression_dependencies refs
        inner join sys.objects obj
        on refs.referencing_id = obj.object_id
        inner join sys.schemas sch
        on obj.schema_id = sch.schema_id
        where refs.referenced_database_name = 'ws_ssc_articles'
        and refs.referenced_schema_name = 'dbo'
        and refs.referenced_entity_name = 'customers__dbt_temp__dbt_tmp_vw'
        and refs.referencing_class = 1
        and obj.type = 'V'
        
    OPTION (LABEL = 'dbt-fabric-dw');

      
[0m20:48:10.464828 [debug] [Thread-4 (]: SQL status: OK in 0.000 seconds
[0m20:48:10.464828 [debug] [Thread-4 (]: Using fabric connection "model.jaffle_shop.customers"
[0m20:48:10.464828 [debug] [Thread-4 (]: On model.jaffle_shop.customers: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "model.jaffle_shop.customers"} */

      
      
    
    USE [ws_ssc_articles];
    EXEC('DROP view IF EXISTS "dbo"."customers__dbt_temp__dbt_tmp_vw";');

[0m20:48:10.499686 [debug] [Thread-4 (]: SQL status: OK in 0.000 seconds
[0m20:48:10.515297 [debug] [Thread-4 (]: dbt-fabric
[0m20:48:10.515297 [debug] [Thread-4 (]: Applying DROP to: "ws_ssc_articles"."dbo"."customers__dbt_temp__dbt_tmp_vw"
[0m20:48:10.515297 [debug] [Thread-4 (]: dbt-fabric
[0m20:48:10.515297 [debug] [Thread-4 (]: Using fabric connection "model.jaffle_shop.customers"
[0m20:48:10.515297 [debug] [Thread-4 (]: On model.jaffle_shop.customers: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "model.jaffle_shop.customers"} */

        USE [ws_ssc_articles];
        select
            sch.name as schema_name,
            obj.name as view_name
        from sys.sql_expression_dependencies refs
        inner join sys.objects obj
        on refs.referencing_id = obj.object_id
        inner join sys.schemas sch
        on obj.schema_id = sch.schema_id
        where refs.referenced_database_name = 'ws_ssc_articles'
        and refs.referenced_schema_name = 'dbo'
        and refs.referenced_entity_name = 'customers__dbt_temp__dbt_tmp_vw'
        and refs.referencing_class = 1
        and obj.type = 'V'
        
    OPTION (LABEL = 'dbt-fabric-dw');

      
[0m20:48:10.548134 [debug] [Thread-4 (]: SQL status: OK in 0.000 seconds
[0m20:48:10.565051 [debug] [Thread-4 (]: Using fabric connection "model.jaffle_shop.customers"
[0m20:48:10.565051 [debug] [Thread-4 (]: On model.jaffle_shop.customers: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "model.jaffle_shop.customers"} */

      
      
    
    USE [ws_ssc_articles];
    EXEC('DROP view IF EXISTS "dbo"."customers__dbt_temp__dbt_tmp_vw";');

[0m20:48:10.598160 [debug] [Thread-4 (]: SQL status: OK in 0.000 seconds
[0m20:48:10.598160 [debug] [Thread-4 (]: Writing runtime sql for node "model.jaffle_shop.customers"
[0m20:48:10.613046 [debug] [Thread-4 (]: Using fabric connection "model.jaffle_shop.customers"
[0m20:48:10.613940 [debug] [Thread-4 (]: On model.jaffle_shop.customers: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "model.jaffle_shop.customers"} */

  
    
    
    USE [ws_ssc_articles];
    
    

    EXEC('create view "dbo"."customers__dbt_temp__dbt_tmp_vw" as with customers as (

    select * from "ws_ssc_articles"."dbo"."stg_customers"

),

orders as (

    select * from "ws_ssc_articles"."dbo"."stg_orders"

),

payments as (

    select * from "ws_ssc_articles"."dbo"."stg_payments"

),

customer_orders as (

        select
        customer_id,

        min(order_date) as first_order,
        max(order_date) as most_recent_order,
        count(order_id) as number_of_orders
    from orders

    group by customer_id

),

customer_payments as (

    select
        orders.customer_id,
        sum(amount) as total_amount

    from payments

    left join orders on
         payments.order_id = orders.order_id

    group by orders.customer_id

),

final as (

    select
        customers.customer_id,
        customers.first_name,
        customers.last_name,
        customer_orders.first_order,
        customer_orders.most_recent_order,
        customer_orders.number_of_orders,
        customer_payments.total_amount as customer_lifetime_value

    from customers

    left join customer_orders
        on customers.customer_id = customer_orders.customer_id

    left join customer_payments
        on  customers.customer_id = customer_payments.customer_id

)

select * from final;');




    
    
            EXEC('CREATE TABLE "ws_ssc_articles"."dbo"."customers__dbt_temp" AS SELECT * FROM "ws_ssc_articles"."dbo"."customers__dbt_temp__dbt_tmp_vw" 
    OPTION (LABEL = ''dbt-fabric-dw'');
');
        

    

  
  
[0m20:48:11.486672 [debug] [Thread-1 (]: SQL status: OK in 1.000 seconds
[0m20:48:11.505775 [debug] [Thread-1 (]: Using fabric connection "model.jaffle_shop.orders"
[0m20:48:11.505775 [debug] [Thread-1 (]: On model.jaffle_shop.orders: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "model.jaffle_shop.orders"} */
USE [ws_ssc_articles];
      EXEC sp_rename 'dbo.orders__dbt_temp', 'orders'
[0m20:48:11.614871 [debug] [Thread-4 (]: SQL status: OK in 1.000 seconds
[0m20:48:11.631767 [debug] [Thread-4 (]: Using fabric connection "model.jaffle_shop.customers"
[0m20:48:11.631767 [debug] [Thread-4 (]: On model.jaffle_shop.customers: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "model.jaffle_shop.customers"} */
USE [ws_ssc_articles];
      EXEC sp_rename 'dbo.customers__dbt_temp', 'customers'
[0m20:48:12.179886 [debug] [Thread-1 (]: SQL status: OK in 1.000 seconds
[0m20:48:12.182892 [debug] [Thread-1 (]: Applying DROP to: "ws_ssc_articles"."dbo"."orders__dbt_temp__dbt_tmp_vw"
[0m20:48:12.183883 [debug] [Thread-1 (]: dbt-fabric
[0m20:48:12.183883 [debug] [Thread-1 (]: Using fabric connection "model.jaffle_shop.orders"
[0m20:48:12.185394 [debug] [Thread-1 (]: On model.jaffle_shop.orders: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "model.jaffle_shop.orders"} */

        USE [ws_ssc_articles];
        select
            sch.name as schema_name,
            obj.name as view_name
        from sys.sql_expression_dependencies refs
        inner join sys.objects obj
        on refs.referencing_id = obj.object_id
        inner join sys.schemas sch
        on obj.schema_id = sch.schema_id
        where refs.referenced_database_name = 'ws_ssc_articles'
        and refs.referenced_schema_name = 'dbo'
        and refs.referenced_entity_name = 'orders__dbt_temp__dbt_tmp_vw'
        and refs.referencing_class = 1
        and obj.type = 'V'
        
    OPTION (LABEL = 'dbt-fabric-dw');

      
[0m20:48:12.187418 [debug] [Thread-4 (]: SQL status: OK in 1.000 seconds
[0m20:48:12.190415 [debug] [Thread-4 (]: Applying DROP to: "ws_ssc_articles"."dbo"."customers__dbt_temp__dbt_tmp_vw"
[0m20:48:12.191414 [debug] [Thread-4 (]: dbt-fabric
[0m20:48:12.192412 [debug] [Thread-4 (]: Using fabric connection "model.jaffle_shop.customers"
[0m20:48:12.192412 [debug] [Thread-4 (]: On model.jaffle_shop.customers: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "model.jaffle_shop.customers"} */

        USE [ws_ssc_articles];
        select
            sch.name as schema_name,
            obj.name as view_name
        from sys.sql_expression_dependencies refs
        inner join sys.objects obj
        on refs.referencing_id = obj.object_id
        inner join sys.schemas sch
        on obj.schema_id = sch.schema_id
        where refs.referenced_database_name = 'ws_ssc_articles'
        and refs.referenced_schema_name = 'dbo'
        and refs.referenced_entity_name = 'customers__dbt_temp__dbt_tmp_vw'
        and refs.referencing_class = 1
        and obj.type = 'V'
        
    OPTION (LABEL = 'dbt-fabric-dw');

      
[0m20:48:12.223197 [debug] [Thread-1 (]: SQL status: OK in 0.000 seconds
[0m20:48:12.225133 [debug] [Thread-1 (]: Using fabric connection "model.jaffle_shop.orders"
[0m20:48:12.225133 [debug] [Thread-1 (]: On model.jaffle_shop.orders: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "model.jaffle_shop.orders"} */

      
      
    
    USE [ws_ssc_articles];
    EXEC('DROP view IF EXISTS "dbo"."orders__dbt_temp__dbt_tmp_vw";');

[0m20:48:12.229590 [debug] [Thread-4 (]: SQL status: OK in 0.000 seconds
[0m20:48:12.230591 [debug] [Thread-4 (]: Using fabric connection "model.jaffle_shop.customers"
[0m20:48:12.230591 [debug] [Thread-4 (]: On model.jaffle_shop.customers: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "model.jaffle_shop.customers"} */

      
      
    
    USE [ws_ssc_articles];
    EXEC('DROP view IF EXISTS "dbo"."customers__dbt_temp__dbt_tmp_vw";');

[0m20:48:12.269032 [debug] [Thread-1 (]: SQL status: OK in 0.000 seconds
[0m20:48:12.271028 [debug] [Thread-1 (]: On model.jaffle_shop.orders: COMMIT
[0m20:48:12.275083 [debug] [Thread-1 (]: On model.jaffle_shop.orders: Close
[0m20:48:12.276081 [debug] [Thread-1 (]: Sending event: {'category': 'dbt', 'action': 'run_model', 'label': '62df7efe-209e-4a03-8416-b5bfc6443faf', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024CF0B56CC0>]}
[0m20:48:12.276081 [info ] [Thread-1 (]: 5 of 5 OK created sql table model dbo.orders ................................... [[32mOK[0m in 2.53s]
[0m20:48:12.277083 [debug] [Thread-1 (]: Finished running node model.jaffle_shop.orders
[0m20:48:12.314915 [debug] [Thread-4 (]: SQL status: OK in 0.000 seconds
[0m20:48:12.314915 [debug] [Thread-4 (]: On model.jaffle_shop.customers: COMMIT
[0m20:48:12.314915 [debug] [Thread-4 (]: On model.jaffle_shop.customers: Close
[0m20:48:12.314915 [debug] [Thread-4 (]: Sending event: {'category': 'dbt', 'action': 'run_model', 'label': '62df7efe-209e-4a03-8416-b5bfc6443faf', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024CF10D25A0>]}
[0m20:48:12.314915 [info ] [Thread-4 (]: 4 of 5 OK created sql table model dbo.customers ................................ [[32mOK[0m in 2.57s]
[0m20:48:12.314915 [debug] [Thread-4 (]: Finished running node model.jaffle_shop.customers
[0m20:48:12.329749 [debug] [MainThread]: On master: COMMIT
[0m20:48:12.330658 [debug] [MainThread]: Connection 'master' was properly closed.
[0m20:48:12.330658 [debug] [MainThread]: Connection 'list_ws_ssc_articles' was properly closed.
[0m20:48:12.330658 [debug] [MainThread]: Connection 'list_ws_ssc_articles_dbo' was properly closed.
[0m20:48:12.331787 [debug] [MainThread]: Connection 'model.jaffle_shop.orders' was properly closed.
[0m20:48:12.331787 [debug] [MainThread]: Connection 'model.jaffle_shop.stg_orders' was properly closed.
[0m20:48:12.331787 [debug] [MainThread]: Connection 'model.jaffle_shop.stg_payments' was properly closed.
[0m20:48:12.331787 [debug] [MainThread]: Connection 'model.jaffle_shop.customers' was properly closed.
[0m20:48:12.331787 [info ] [MainThread]: 
[0m20:48:12.332760 [info ] [MainThread]: Finished running 2 table models, 3 view models in 0 hours 0 minutes and 22.64 seconds (22.64s).
[0m20:48:12.334701 [debug] [MainThread]: Command end result
[0m20:48:12.355530 [debug] [MainThread]: Wrote artifact WritableManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\target\manifest.json
[0m20:48:12.355530 [debug] [MainThread]: Wrote artifact SemanticManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\target\semantic_manifest.json
[0m20:48:12.367141 [debug] [MainThread]: Wrote artifact RunExecutionResult to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\target\run_results.json
[0m20:48:12.367845 [info ] [MainThread]: 
[0m20:48:12.367845 [info ] [MainThread]: [32mCompleted successfully[0m
[0m20:48:12.367845 [info ] [MainThread]: 
[0m20:48:12.367845 [info ] [MainThread]: Done. PASS=5 WARN=0 ERROR=0 SKIP=0 NO-OP=0 TOTAL=5
[0m20:48:12.367845 [warn ] [MainThread]: [[33mWARNING[0m][DeprecationsSummary]: Deprecated functionality
Summary of encountered deprecations:
- ProjectFlagsMovedDeprecation: 1 occurrence
To see all deprecation instances instead of just the first occurrence of each,
run command again with the `--show-all-deprecations` flag. You may also need to
run with `--no-partial-parse` as some deprecations are only encountered during
parsing.
[0m20:48:12.367845 [debug] [MainThread]: Command `dbt run` succeeded at 20:48:12.367845 after 24.00 seconds
[0m20:48:12.367845 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'end', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024CF0711130>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024CEEF476B0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024CF05CCAA0>]}
[0m20:48:12.367845 [debug] [MainThread]: Flushing usage events
[0m20:48:12.591195 [debug] [MainThread]: An error was encountered while trying to flush usage events
[0m20:48:42.760818 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'start', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000016F0B52FE30>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000016F088B9CD0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000016F0B633EC0>]}


============================== 20:48:42.760818 | 1279772e-56ec-41bc-b416-48f6ad47072c ==============================
[0m20:48:42.760818 [info ] [MainThread]: Running with dbt=1.10.16
[0m20:48:42.760818 [debug] [MainThread]: running dbt with arguments {'static_parser': 'True', 'no_print': 'None', 'version_check': 'True', 'warn_error_options': 'WarnErrorOptionsV2(error=[], warn=[], silence=[])', 'target_path': 'None', 'printer_width': '80', 'write_json': 'True', 'empty': 'None', 'log_cache_events': 'False', 'introspect': 'True', 'cache_selected_only': 'False', 'fail_fast': 'False', 'debug': 'False', 'log_format': 'default', 'profiles_dir': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\jaffle-shop-classic', 'send_anonymous_usage_stats': 'True', 'quiet': 'False', 'warn_error': 'None', 'partial_parse': 'True', 'indirect_selection': 'eager', 'invocation_command': 'dbt test', 'use_colors': 'True', 'use_experimental_parser': 'False', 'log_path': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\jaffle-shop-classic\\logs'}
[0m20:48:42.760818 [warn ] [MainThread]: [[33mWARNING[0m]: Deprecated functionality

User config should be moved from the 'config' key in profiles.yml to the 'flags' key in dbt_project.yml.
[0m20:48:42.760818 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'deprecation', 'label': '1279772e-56ec-41bc-b416-48f6ad47072c', 'property_': 'warn', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000016F0B633EC0>]}
[0m20:48:43.228806 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'project_id', 'label': '1279772e-56ec-41bc-b416-48f6ad47072c', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000016F0E040B00>]}
[0m20:48:43.277057 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'adapter_info', 'label': '1279772e-56ec-41bc-b416-48f6ad47072c', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000016F0BF7BAD0>]}
[0m20:48:43.277057 [info ] [MainThread]: Registered adapter: fabric=1.9.8
[0m20:48:43.462857 [debug] [MainThread]: checksum: c4b99e2e3bb042c661c8397fd92290cd0d52b31ce393ad721fa0bb3c9591dd0f, vars: {}, profile: , target: , version: 1.10.16
[0m20:48:43.623687 [debug] [MainThread]: Partial parsing enabled: 0 files deleted, 0 files added, 0 files changed.
[0m20:48:43.633478 [debug] [MainThread]: Partial parsing enabled, no changes found, skipping parsing
[0m20:48:43.665393 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'load_project', 'label': '1279772e-56ec-41bc-b416-48f6ad47072c', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000016F0E3A4D40>]}
[0m20:48:43.713244 [debug] [MainThread]: Wrote artifact WritableManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\target\manifest.json
[0m20:48:43.729337 [debug] [MainThread]: Wrote artifact SemanticManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\target\semantic_manifest.json
[0m20:48:43.760798 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'resource_counts', 'label': '1279772e-56ec-41bc-b416-48f6ad47072c', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000016F0E6D3F20>]}
[0m20:48:43.760798 [info ] [MainThread]: Found 5 models, 3 seeds, 20 data tests, 500 macros
[0m20:48:43.760798 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'runnable_timing', 'label': '1279772e-56ec-41bc-b416-48f6ad47072c', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000016F0E6B7740>]}
[0m20:48:43.760798 [info ] [MainThread]: 
[0m20:48:43.760798 [info ] [MainThread]: Concurrency: 4 threads (target='fabric-dev')
[0m20:48:43.760798 [info ] [MainThread]: 
[0m20:48:43.760798 [debug] [MainThread]: Acquiring new fabric connection 'master'
[0m20:48:43.819990 [debug] [ThreadPool]: Acquiring new fabric connection 'list_ws_ssc_articles_dbo'
[0m20:48:43.837725 [debug] [ThreadPool]: dbt-fabric
[0m20:48:43.837725 [debug] [ThreadPool]: Using fabric connection "list_ws_ssc_articles_dbo"
[0m20:48:43.837725 [debug] [ThreadPool]: On list_ws_ssc_articles_dbo: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "connection_name": "list_ws_ssc_articles_dbo"} */
USE [ws_ssc_articles];
    with base as (
      select
        DB_NAME() as [database],
        t.name as [name],
        SCHEMA_NAME(t.schema_id) as [schema],
        'table' as table_type
      from sys.tables as t 
      union all
      select
        DB_NAME() as [database],
        v.name as [name],
        SCHEMA_NAME(v.schema_id) as [schema],
        'view' as table_type
      from sys.views as v 
    )
    select * from base
    where [schema] like 'dbo'
    
    OPTION (LABEL = 'dbt-fabric-dw');

  
[0m20:48:43.837725 [debug] [ThreadPool]: Opening a new connection, currently in state init
[0m20:48:43.837725 [debug] [ThreadPool]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:48:59.735689 [debug] [ThreadPool]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:48:59.792374 [debug] [ThreadPool]: SQL status: OK in 16.000 seconds
[0m20:48:59.792374 [debug] [ThreadPool]: On list_ws_ssc_articles_dbo: ROLLBACK
[0m20:48:59.792374 [debug] [ThreadPool]: On list_ws_ssc_articles_dbo: Close
[0m20:48:59.808798 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'runnable_timing', 'label': '1279772e-56ec-41bc-b416-48f6ad47072c', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000016F0E6D3BC0>]}
[0m20:48:59.808798 [debug] [MainThread]: On master: COMMIT
[0m20:48:59.817400 [debug] [Thread-1 (]: Began running node test.jaffle_shop.accepted_values_orders_status__placed__shipped__completed__return_pending__returned.be6b5b5ec3
[0m20:48:59.824625 [debug] [Thread-2 (]: Began running node test.jaffle_shop.accepted_values_stg_orders_status__placed__shipped__completed__return_pending__returned.080fb20aad
[0m20:48:59.817400 [info ] [Thread-1 (]: 1 of 20 START test accepted_values_orders_status__placed__shipped__completed__return_pending__returned  [RUN]
[0m20:48:59.824625 [debug] [Thread-3 (]: Began running node test.jaffle_shop.accepted_values_stg_payments_payment_method__credit_card__coupon__bank_transfer__gift_card.3c3820f278
[0m20:48:59.824625 [debug] [Thread-4 (]: Began running node test.jaffle_shop.not_null_customers_customer_id.5c9bf9911d
[0m20:48:59.824625 [info ] [Thread-2 (]: 2 of 20 START test accepted_values_stg_orders_status__placed__shipped__completed__return_pending__returned  [RUN]
[0m20:48:59.824625 [debug] [Thread-1 (]: Acquiring new fabric connection 'test.jaffle_shop.accepted_values_orders_status__placed__shipped__completed__return_pending__returned.be6b5b5ec3'
[0m20:48:59.824625 [info ] [Thread-3 (]: 3 of 20 START test accepted_values_stg_payments_payment_method__credit_card__coupon__bank_transfer__gift_card  [RUN]
[0m20:48:59.824625 [debug] [Thread-2 (]: Acquiring new fabric connection 'test.jaffle_shop.accepted_values_stg_orders_status__placed__shipped__completed__return_pending__returned.080fb20aad'
[0m20:48:59.824625 [info ] [Thread-4 (]: 4 of 20 START test not_null_customers_customer_id .............................. [RUN]
[0m20:48:59.824625 [debug] [Thread-1 (]: Began compiling node test.jaffle_shop.accepted_values_orders_status__placed__shipped__completed__return_pending__returned.be6b5b5ec3
[0m20:48:59.824625 [debug] [Thread-3 (]: Acquiring new fabric connection 'test.jaffle_shop.accepted_values_stg_payments_payment_method__credit_card__coupon__bank_transfer__gift_card.3c3820f278'
[0m20:48:59.824625 [debug] [Thread-2 (]: Began compiling node test.jaffle_shop.accepted_values_stg_orders_status__placed__shipped__completed__return_pending__returned.080fb20aad
[0m20:48:59.824625 [debug] [Thread-4 (]: Acquiring new fabric connection 'test.jaffle_shop.not_null_customers_customer_id.5c9bf9911d'
[0m20:48:59.840408 [debug] [Thread-3 (]: Began compiling node test.jaffle_shop.accepted_values_stg_payments_payment_method__credit_card__coupon__bank_transfer__gift_card.3c3820f278
[0m20:48:59.855667 [debug] [Thread-1 (]: Writing injected SQL for node "test.jaffle_shop.accepted_values_orders_status__placed__shipped__completed__return_pending__returned.be6b5b5ec3"
[0m20:48:59.855667 [debug] [Thread-2 (]: Writing injected SQL for node "test.jaffle_shop.accepted_values_stg_orders_status__placed__shipped__completed__return_pending__returned.080fb20aad"
[0m20:48:59.868154 [debug] [Thread-4 (]: Began compiling node test.jaffle_shop.not_null_customers_customer_id.5c9bf9911d
[0m20:48:59.876408 [debug] [Thread-3 (]: Writing injected SQL for node "test.jaffle_shop.accepted_values_stg_payments_payment_method__credit_card__coupon__bank_transfer__gift_card.3c3820f278"
[0m20:48:59.889569 [debug] [Thread-4 (]: Writing injected SQL for node "test.jaffle_shop.not_null_customers_customer_id.5c9bf9911d"
[0m20:48:59.891578 [debug] [Thread-1 (]: Began executing node test.jaffle_shop.accepted_values_orders_status__placed__shipped__completed__return_pending__returned.be6b5b5ec3
[0m20:48:59.901547 [debug] [Thread-2 (]: Began executing node test.jaffle_shop.accepted_values_stg_orders_status__placed__shipped__completed__return_pending__returned.080fb20aad
[0m20:48:59.912694 [debug] [Thread-1 (]: Writing runtime sql for node "test.jaffle_shop.accepted_values_orders_status__placed__shipped__completed__return_pending__returned.be6b5b5ec3"
[0m20:48:59.917588 [debug] [Thread-2 (]: Writing runtime sql for node "test.jaffle_shop.accepted_values_stg_orders_status__placed__shipped__completed__return_pending__returned.080fb20aad"
[0m20:48:59.918588 [debug] [Thread-4 (]: Began executing node test.jaffle_shop.not_null_customers_customer_id.5c9bf9911d
[0m20:48:59.918588 [debug] [Thread-3 (]: Began executing node test.jaffle_shop.accepted_values_stg_payments_payment_method__credit_card__coupon__bank_transfer__gift_card.3c3820f278
[0m20:48:59.918588 [debug] [Thread-4 (]: Writing runtime sql for node "test.jaffle_shop.not_null_customers_customer_id.5c9bf9911d"
[0m20:48:59.918588 [debug] [Thread-3 (]: Writing runtime sql for node "test.jaffle_shop.accepted_values_stg_payments_payment_method__credit_card__coupon__bank_transfer__gift_card.3c3820f278"
[0m20:48:59.924680 [debug] [Thread-1 (]: Using fabric connection "test.jaffle_shop.accepted_values_orders_status__placed__shipped__completed__return_pending__returned.be6b5b5ec3"
[0m20:48:59.924680 [debug] [Thread-1 (]: On test.jaffle_shop.accepted_values_orders_status__placed__shipped__completed__return_pending__returned.be6b5b5ec3: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "test.jaffle_shop.accepted_values_orders_status__placed__shipped__completed__return_pending__returned.be6b5b5ec3"} */

    with test_main_sql as (
  
    
    
    

with all_values as (

    select
        status as value_field,
        count(*) as n_records

    from "ws_ssc_articles"."dbo"."orders"
    group by status

)

select *
from all_values
where value_field not in (
    'placed','shipped','completed','return_pending','returned'
)



  
  ),
  dbt_internal_test as (
    select  * from test_main_sql
  )
  select
    count(*) as failures,
    case when count(*) != 0
      then 'true' else 'false' end as should_warn,
    case when count(*) != 0
      then 'true' else 'false' end as should_error
  from dbt_internal_test
[0m20:48:59.924680 [debug] [Thread-1 (]: Opening a new connection, currently in state init
[0m20:48:59.924680 [debug] [Thread-1 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:48:59.924680 [debug] [Thread-2 (]: Using fabric connection "test.jaffle_shop.accepted_values_stg_orders_status__placed__shipped__completed__return_pending__returned.080fb20aad"
[0m20:48:59.924680 [debug] [Thread-2 (]: On test.jaffle_shop.accepted_values_stg_orders_status__placed__shipped__completed__return_pending__returned.080fb20aad: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "test.jaffle_shop.accepted_values_stg_orders_status__placed__shipped__completed__return_pending__returned.080fb20aad"} */

    with test_main_sql as (
  
    
    
    

with all_values as (

    select
        status as value_field,
        count(*) as n_records

    from "ws_ssc_articles"."dbo"."stg_orders"
    group by status

)

select *
from all_values
where value_field not in (
    'placed','shipped','completed','return_pending','returned'
)



  
  ),
  dbt_internal_test as (
    select  * from test_main_sql
  )
  select
    count(*) as failures,
    case when count(*) != 0
      then 'true' else 'false' end as should_warn,
    case when count(*) != 0
      then 'true' else 'false' end as should_error
  from dbt_internal_test
[0m20:48:59.924680 [debug] [Thread-1 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:48:59.924680 [debug] [Thread-2 (]: Opening a new connection, currently in state init
[0m20:48:59.924680 [debug] [Thread-3 (]: Using fabric connection "test.jaffle_shop.accepted_values_stg_payments_payment_method__credit_card__coupon__bank_transfer__gift_card.3c3820f278"
[0m20:48:59.924680 [debug] [Thread-2 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:48:59.924680 [debug] [Thread-4 (]: Using fabric connection "test.jaffle_shop.not_null_customers_customer_id.5c9bf9911d"
[0m20:48:59.924680 [debug] [Thread-3 (]: On test.jaffle_shop.accepted_values_stg_payments_payment_method__credit_card__coupon__bank_transfer__gift_card.3c3820f278: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "test.jaffle_shop.accepted_values_stg_payments_payment_method__credit_card__coupon__bank_transfer__gift_card.3c3820f278"} */

    with test_main_sql as (
  
    
    
    

with all_values as (

    select
        payment_method as value_field,
        count(*) as n_records

    from "ws_ssc_articles"."dbo"."stg_payments"
    group by payment_method

)

select *
from all_values
where value_field not in (
    'credit_card','coupon','bank_transfer','gift_card'
)



  
  ),
  dbt_internal_test as (
    select  * from test_main_sql
  )
  select
    count(*) as failures,
    case when count(*) != 0
      then 'true' else 'false' end as should_warn,
    case when count(*) != 0
      then 'true' else 'false' end as should_error
  from dbt_internal_test
[0m20:48:59.924680 [debug] [Thread-4 (]: On test.jaffle_shop.not_null_customers_customer_id.5c9bf9911d: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "test.jaffle_shop.not_null_customers_customer_id.5c9bf9911d"} */

    with test_main_sql as (
  
    
    
    



select customer_id
from "ws_ssc_articles"."dbo"."customers"
where customer_id is null



  
  ),
  dbt_internal_test as (
    select  * from test_main_sql
  )
  select
    count(*) as failures,
    case when count(*) != 0
      then 'true' else 'false' end as should_warn,
    case when count(*) != 0
      then 'true' else 'false' end as should_error
  from dbt_internal_test
[0m20:48:59.924680 [debug] [Thread-3 (]: Opening a new connection, currently in state init
[0m20:48:59.924680 [debug] [Thread-4 (]: Opening a new connection, currently in state init
[0m20:48:59.924680 [debug] [Thread-3 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:48:59.924680 [debug] [Thread-4 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:49:00.516988 [debug] [Thread-1 (]: SQL status: OK in 1.000 seconds
[0m20:49:00.516988 [debug] [Thread-1 (]: On test.jaffle_shop.accepted_values_orders_status__placed__shipped__completed__return_pending__returned.be6b5b5ec3: ROLLBACK
[0m20:49:00.532770 [debug] [Thread-2 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:49:00.532770 [debug] [Thread-1 (]: On test.jaffle_shop.accepted_values_orders_status__placed__shipped__completed__return_pending__returned.be6b5b5ec3: Close
[0m20:49:00.532770 [info ] [Thread-1 (]: 1 of 20 PASS accepted_values_orders_status__placed__shipped__completed__return_pending__returned  [[32mPASS[0m in 0.71s]
[0m20:49:00.532770 [debug] [Thread-1 (]: Finished running node test.jaffle_shop.accepted_values_orders_status__placed__shipped__completed__return_pending__returned.be6b5b5ec3
[0m20:49:00.532770 [debug] [Thread-1 (]: Began running node test.jaffle_shop.not_null_orders_amount.106140f9fd
[0m20:49:00.532770 [info ] [Thread-1 (]: 5 of 20 START test not_null_orders_amount ...................................... [RUN]
[0m20:49:00.532770 [debug] [Thread-1 (]: Re-using an available connection from the pool (formerly test.jaffle_shop.accepted_values_orders_status__placed__shipped__completed__return_pending__returned.be6b5b5ec3, now test.jaffle_shop.not_null_orders_amount.106140f9fd)
[0m20:49:00.532770 [debug] [Thread-1 (]: Began compiling node test.jaffle_shop.not_null_orders_amount.106140f9fd
[0m20:49:00.532770 [debug] [Thread-1 (]: Writing injected SQL for node "test.jaffle_shop.not_null_orders_amount.106140f9fd"
[0m20:49:00.554495 [debug] [Thread-1 (]: Began executing node test.jaffle_shop.not_null_orders_amount.106140f9fd
[0m20:49:00.555497 [debug] [Thread-1 (]: Writing runtime sql for node "test.jaffle_shop.not_null_orders_amount.106140f9fd"
[0m20:49:00.555497 [debug] [Thread-1 (]: Using fabric connection "test.jaffle_shop.not_null_orders_amount.106140f9fd"
[0m20:49:00.555497 [debug] [Thread-1 (]: On test.jaffle_shop.not_null_orders_amount.106140f9fd: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "test.jaffle_shop.not_null_orders_amount.106140f9fd"} */

    with test_main_sql as (
  
    
    
    



select amount
from "ws_ssc_articles"."dbo"."orders"
where amount is null



  
  ),
  dbt_internal_test as (
    select  * from test_main_sql
  )
  select
    count(*) as failures,
    case when count(*) != 0
      then 'true' else 'false' end as should_warn,
    case when count(*) != 0
      then 'true' else 'false' end as should_error
  from dbt_internal_test
[0m20:49:00.555497 [debug] [Thread-1 (]: Opening a new connection, currently in state closed
[0m20:49:00.555497 [debug] [Thread-1 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:49:00.555497 [debug] [Thread-1 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:49:00.574451 [debug] [Thread-4 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:49:00.622749 [debug] [Thread-3 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:49:00.700977 [debug] [Thread-2 (]: SQL status: OK in 1.000 seconds
[0m20:49:00.716786 [debug] [Thread-2 (]: On test.jaffle_shop.accepted_values_stg_orders_status__placed__shipped__completed__return_pending__returned.080fb20aad: ROLLBACK
[0m20:49:00.716786 [debug] [Thread-2 (]: On test.jaffle_shop.accepted_values_stg_orders_status__placed__shipped__completed__return_pending__returned.080fb20aad: Close
[0m20:49:00.716786 [info ] [Thread-2 (]: 2 of 20 PASS accepted_values_stg_orders_status__placed__shipped__completed__return_pending__returned  [[32mPASS[0m in 0.89s]
[0m20:49:00.716786 [debug] [Thread-2 (]: Finished running node test.jaffle_shop.accepted_values_stg_orders_status__placed__shipped__completed__return_pending__returned.080fb20aad
[0m20:49:00.716786 [debug] [Thread-2 (]: Began running node test.jaffle_shop.not_null_orders_bank_transfer_amount.7743500c49
[0m20:49:00.716786 [info ] [Thread-2 (]: 6 of 20 START test not_null_orders_bank_transfer_amount ........................ [RUN]
[0m20:49:00.716786 [debug] [Thread-2 (]: Re-using an available connection from the pool (formerly test.jaffle_shop.accepted_values_stg_orders_status__placed__shipped__completed__return_pending__returned.080fb20aad, now test.jaffle_shop.not_null_orders_bank_transfer_amount.7743500c49)
[0m20:49:00.716786 [debug] [Thread-2 (]: Began compiling node test.jaffle_shop.not_null_orders_bank_transfer_amount.7743500c49
[0m20:49:00.728498 [debug] [Thread-2 (]: Writing injected SQL for node "test.jaffle_shop.not_null_orders_bank_transfer_amount.7743500c49"
[0m20:49:00.730521 [debug] [Thread-2 (]: Began executing node test.jaffle_shop.not_null_orders_bank_transfer_amount.7743500c49
[0m20:49:00.734396 [debug] [Thread-2 (]: Writing runtime sql for node "test.jaffle_shop.not_null_orders_bank_transfer_amount.7743500c49"
[0m20:49:00.737932 [debug] [Thread-2 (]: Using fabric connection "test.jaffle_shop.not_null_orders_bank_transfer_amount.7743500c49"
[0m20:49:00.738953 [debug] [Thread-2 (]: On test.jaffle_shop.not_null_orders_bank_transfer_amount.7743500c49: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "test.jaffle_shop.not_null_orders_bank_transfer_amount.7743500c49"} */

    with test_main_sql as (
  
    
    
    



select bank_transfer_amount
from "ws_ssc_articles"."dbo"."orders"
where bank_transfer_amount is null



  
  ),
  dbt_internal_test as (
    select  * from test_main_sql
  )
  select
    count(*) as failures,
    case when count(*) != 0
      then 'true' else 'false' end as should_warn,
    case when count(*) != 0
      then 'true' else 'false' end as should_error
  from dbt_internal_test
[0m20:49:00.740957 [debug] [Thread-2 (]: Opening a new connection, currently in state closed
[0m20:49:00.743315 [debug] [Thread-2 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:49:00.745366 [debug] [Thread-2 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:49:00.752998 [debug] [Thread-1 (]: SQL status: OK in 0.000 seconds
[0m20:49:00.752998 [debug] [Thread-1 (]: On test.jaffle_shop.not_null_orders_amount.106140f9fd: ROLLBACK
[0m20:49:00.752998 [debug] [Thread-1 (]: On test.jaffle_shop.not_null_orders_amount.106140f9fd: Close
[0m20:49:00.752998 [info ] [Thread-1 (]: 5 of 20 PASS not_null_orders_amount ............................................ [[32mPASS[0m in 0.22s]
[0m20:49:00.752998 [debug] [Thread-1 (]: Finished running node test.jaffle_shop.not_null_orders_amount.106140f9fd
[0m20:49:00.752998 [debug] [Thread-1 (]: Began running node test.jaffle_shop.not_null_orders_coupon_amount.ab90c90625
[0m20:49:00.752998 [info ] [Thread-1 (]: 7 of 20 START test not_null_orders_coupon_amount ............................... [RUN]
[0m20:49:00.752998 [debug] [Thread-1 (]: Re-using an available connection from the pool (formerly test.jaffle_shop.not_null_orders_amount.106140f9fd, now test.jaffle_shop.not_null_orders_coupon_amount.ab90c90625)
[0m20:49:00.752998 [debug] [Thread-1 (]: Began compiling node test.jaffle_shop.not_null_orders_coupon_amount.ab90c90625
[0m20:49:00.770686 [debug] [Thread-1 (]: Writing injected SQL for node "test.jaffle_shop.not_null_orders_coupon_amount.ab90c90625"
[0m20:49:00.772625 [debug] [Thread-1 (]: Began executing node test.jaffle_shop.not_null_orders_coupon_amount.ab90c90625
[0m20:49:00.776464 [debug] [Thread-1 (]: Writing runtime sql for node "test.jaffle_shop.not_null_orders_coupon_amount.ab90c90625"
[0m20:49:00.776464 [debug] [Thread-1 (]: Using fabric connection "test.jaffle_shop.not_null_orders_coupon_amount.ab90c90625"
[0m20:49:00.776464 [debug] [Thread-1 (]: On test.jaffle_shop.not_null_orders_coupon_amount.ab90c90625: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "test.jaffle_shop.not_null_orders_coupon_amount.ab90c90625"} */

    with test_main_sql as (
  
    
    
    



select coupon_amount
from "ws_ssc_articles"."dbo"."orders"
where coupon_amount is null



  
  ),
  dbt_internal_test as (
    select  * from test_main_sql
  )
  select
    count(*) as failures,
    case when count(*) != 0
      then 'true' else 'false' end as should_warn,
    case when count(*) != 0
      then 'true' else 'false' end as should_error
  from dbt_internal_test
[0m20:49:00.776464 [debug] [Thread-1 (]: Opening a new connection, currently in state closed
[0m20:49:00.776464 [debug] [Thread-1 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:49:00.776464 [debug] [Thread-1 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:49:00.855387 [debug] [Thread-1 (]: SQL status: OK in 0.000 seconds
[0m20:49:00.857394 [debug] [Thread-1 (]: On test.jaffle_shop.not_null_orders_coupon_amount.ab90c90625: ROLLBACK
[0m20:49:00.858390 [debug] [Thread-1 (]: On test.jaffle_shop.not_null_orders_coupon_amount.ab90c90625: Close
[0m20:49:00.858390 [info ] [Thread-1 (]: 7 of 20 PASS not_null_orders_coupon_amount ..................................... [[32mPASS[0m in 0.11s]
[0m20:49:00.859394 [debug] [Thread-1 (]: Finished running node test.jaffle_shop.not_null_orders_coupon_amount.ab90c90625
[0m20:49:00.860392 [debug] [Thread-1 (]: Began running node test.jaffle_shop.not_null_orders_credit_card_amount.d3ca593b59
[0m20:49:00.860392 [info ] [Thread-1 (]: 8 of 20 START test not_null_orders_credit_card_amount .......................... [RUN]
[0m20:49:00.861397 [debug] [Thread-1 (]: Re-using an available connection from the pool (formerly test.jaffle_shop.not_null_orders_coupon_amount.ab90c90625, now test.jaffle_shop.not_null_orders_credit_card_amount.d3ca593b59)
[0m20:49:00.861397 [debug] [Thread-1 (]: Began compiling node test.jaffle_shop.not_null_orders_credit_card_amount.d3ca593b59
[0m20:49:00.866387 [debug] [Thread-1 (]: Writing injected SQL for node "test.jaffle_shop.not_null_orders_credit_card_amount.d3ca593b59"
[0m20:49:00.868429 [debug] [Thread-1 (]: Began executing node test.jaffle_shop.not_null_orders_credit_card_amount.d3ca593b59
[0m20:49:00.872023 [debug] [Thread-1 (]: Writing runtime sql for node "test.jaffle_shop.not_null_orders_credit_card_amount.d3ca593b59"
[0m20:49:00.872023 [debug] [Thread-1 (]: Using fabric connection "test.jaffle_shop.not_null_orders_credit_card_amount.d3ca593b59"
[0m20:49:00.872023 [debug] [Thread-1 (]: On test.jaffle_shop.not_null_orders_credit_card_amount.d3ca593b59: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "test.jaffle_shop.not_null_orders_credit_card_amount.d3ca593b59"} */

    with test_main_sql as (
  
    
    
    



select credit_card_amount
from "ws_ssc_articles"."dbo"."orders"
where credit_card_amount is null



  
  ),
  dbt_internal_test as (
    select  * from test_main_sql
  )
  select
    count(*) as failures,
    case when count(*) != 0
      then 'true' else 'false' end as should_warn,
    case when count(*) != 0
      then 'true' else 'false' end as should_error
  from dbt_internal_test
[0m20:49:00.872023 [debug] [Thread-1 (]: Opening a new connection, currently in state closed
[0m20:49:00.872023 [debug] [Thread-1 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:49:00.872023 [debug] [Thread-1 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:49:00.882146 [debug] [Thread-4 (]: SQL status: OK in 1.000 seconds
[0m20:49:00.885837 [debug] [Thread-4 (]: On test.jaffle_shop.not_null_customers_customer_id.5c9bf9911d: ROLLBACK
[0m20:49:00.886918 [debug] [Thread-4 (]: On test.jaffle_shop.not_null_customers_customer_id.5c9bf9911d: Close
[0m20:49:00.887907 [info ] [Thread-4 (]: 4 of 20 PASS not_null_customers_customer_id .................................... [[32mPASS[0m in 1.06s]
[0m20:49:00.888904 [debug] [Thread-4 (]: Finished running node test.jaffle_shop.not_null_customers_customer_id.5c9bf9911d
[0m20:49:00.889851 [debug] [Thread-4 (]: Began running node test.jaffle_shop.not_null_orders_customer_id.c5f02694af
[0m20:49:00.889851 [info ] [Thread-4 (]: 9 of 20 START test not_null_orders_customer_id ................................. [RUN]
[0m20:49:00.890925 [debug] [Thread-4 (]: Re-using an available connection from the pool (formerly test.jaffle_shop.not_null_customers_customer_id.5c9bf9911d, now test.jaffle_shop.not_null_orders_customer_id.c5f02694af)
[0m20:49:00.890925 [debug] [Thread-4 (]: Began compiling node test.jaffle_shop.not_null_orders_customer_id.c5f02694af
[0m20:49:00.890925 [debug] [Thread-4 (]: Writing injected SQL for node "test.jaffle_shop.not_null_orders_customer_id.c5f02694af"
[0m20:49:00.890925 [debug] [Thread-4 (]: Began executing node test.jaffle_shop.not_null_orders_customer_id.c5f02694af
[0m20:49:00.890925 [debug] [Thread-4 (]: Writing runtime sql for node "test.jaffle_shop.not_null_orders_customer_id.c5f02694af"
[0m20:49:00.901563 [debug] [Thread-4 (]: Using fabric connection "test.jaffle_shop.not_null_orders_customer_id.c5f02694af"
[0m20:49:00.902617 [debug] [Thread-4 (]: On test.jaffle_shop.not_null_orders_customer_id.c5f02694af: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "test.jaffle_shop.not_null_orders_customer_id.c5f02694af"} */

    with test_main_sql as (
  
    
    
    



select customer_id
from "ws_ssc_articles"."dbo"."orders"
where customer_id is null



  
  ),
  dbt_internal_test as (
    select  * from test_main_sql
  )
  select
    count(*) as failures,
    case when count(*) != 0
      then 'true' else 'false' end as should_warn,
    case when count(*) != 0
      then 'true' else 'false' end as should_error
  from dbt_internal_test
[0m20:49:00.902617 [debug] [Thread-4 (]: Opening a new connection, currently in state closed
[0m20:49:00.903711 [debug] [Thread-4 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:49:00.929982 [debug] [Thread-2 (]: SQL status: OK in 0.000 seconds
[0m20:49:00.929982 [debug] [Thread-2 (]: On test.jaffle_shop.not_null_orders_bank_transfer_amount.7743500c49: ROLLBACK
[0m20:49:00.929982 [debug] [Thread-2 (]: On test.jaffle_shop.not_null_orders_bank_transfer_amount.7743500c49: Close
[0m20:49:00.934999 [info ] [Thread-2 (]: 6 of 20 PASS not_null_orders_bank_transfer_amount .............................. [[32mPASS[0m in 0.22s]
[0m20:49:00.936027 [debug] [Thread-2 (]: Finished running node test.jaffle_shop.not_null_orders_bank_transfer_amount.7743500c49
[0m20:49:00.937011 [debug] [Thread-2 (]: Began running node test.jaffle_shop.not_null_orders_gift_card_amount.413a0d2d7a
[0m20:49:00.937830 [info ] [Thread-2 (]: 10 of 20 START test not_null_orders_gift_card_amount ........................... [RUN]
[0m20:49:00.937830 [debug] [Thread-2 (]: Re-using an available connection from the pool (formerly test.jaffle_shop.not_null_orders_bank_transfer_amount.7743500c49, now test.jaffle_shop.not_null_orders_gift_card_amount.413a0d2d7a)
[0m20:49:00.937830 [debug] [Thread-2 (]: Began compiling node test.jaffle_shop.not_null_orders_gift_card_amount.413a0d2d7a
[0m20:49:00.937830 [debug] [Thread-2 (]: Writing injected SQL for node "test.jaffle_shop.not_null_orders_gift_card_amount.413a0d2d7a"
[0m20:49:00.937830 [debug] [Thread-2 (]: Began executing node test.jaffle_shop.not_null_orders_gift_card_amount.413a0d2d7a
[0m20:49:00.937830 [debug] [Thread-2 (]: Writing runtime sql for node "test.jaffle_shop.not_null_orders_gift_card_amount.413a0d2d7a"
[0m20:49:00.937830 [debug] [Thread-2 (]: Using fabric connection "test.jaffle_shop.not_null_orders_gift_card_amount.413a0d2d7a"
[0m20:49:00.937830 [debug] [Thread-2 (]: On test.jaffle_shop.not_null_orders_gift_card_amount.413a0d2d7a: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "test.jaffle_shop.not_null_orders_gift_card_amount.413a0d2d7a"} */

    with test_main_sql as (
  
    
    
    



select gift_card_amount
from "ws_ssc_articles"."dbo"."orders"
where gift_card_amount is null



  
  ),
  dbt_internal_test as (
    select  * from test_main_sql
  )
  select
    count(*) as failures,
    case when count(*) != 0
      then 'true' else 'false' end as should_warn,
    case when count(*) != 0
      then 'true' else 'false' end as should_error
  from dbt_internal_test
[0m20:49:00.937830 [debug] [Thread-2 (]: Opening a new connection, currently in state closed
[0m20:49:00.937830 [debug] [Thread-2 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:49:01.052965 [debug] [Thread-1 (]: SQL status: OK in 0.000 seconds
[0m20:49:01.052965 [debug] [Thread-1 (]: On test.jaffle_shop.not_null_orders_credit_card_amount.d3ca593b59: ROLLBACK
[0m20:49:01.052965 [debug] [Thread-1 (]: On test.jaffle_shop.not_null_orders_credit_card_amount.d3ca593b59: Close
[0m20:49:01.052965 [info ] [Thread-1 (]: 8 of 20 PASS not_null_orders_credit_card_amount ................................ [[32mPASS[0m in 0.19s]
[0m20:49:01.052965 [debug] [Thread-1 (]: Finished running node test.jaffle_shop.not_null_orders_credit_card_amount.d3ca593b59
[0m20:49:01.052965 [debug] [Thread-1 (]: Began running node test.jaffle_shop.not_null_orders_order_id.cf6c17daed
[0m20:49:01.052965 [info ] [Thread-1 (]: 11 of 20 START test not_null_orders_order_id ................................... [RUN]
[0m20:49:01.052965 [debug] [Thread-1 (]: Re-using an available connection from the pool (formerly test.jaffle_shop.not_null_orders_credit_card_amount.d3ca593b59, now test.jaffle_shop.not_null_orders_order_id.cf6c17daed)
[0m20:49:01.052965 [debug] [Thread-1 (]: Began compiling node test.jaffle_shop.not_null_orders_order_id.cf6c17daed
[0m20:49:01.052965 [debug] [Thread-1 (]: Writing injected SQL for node "test.jaffle_shop.not_null_orders_order_id.cf6c17daed"
[0m20:49:01.070078 [debug] [Thread-1 (]: Began executing node test.jaffle_shop.not_null_orders_order_id.cf6c17daed
[0m20:49:01.074335 [debug] [Thread-1 (]: Writing runtime sql for node "test.jaffle_shop.not_null_orders_order_id.cf6c17daed"
[0m20:49:01.075957 [debug] [Thread-1 (]: Using fabric connection "test.jaffle_shop.not_null_orders_order_id.cf6c17daed"
[0m20:49:01.075957 [debug] [Thread-1 (]: On test.jaffle_shop.not_null_orders_order_id.cf6c17daed: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "test.jaffle_shop.not_null_orders_order_id.cf6c17daed"} */

    with test_main_sql as (
  
    
    
    



select order_id
from "ws_ssc_articles"."dbo"."orders"
where order_id is null



  
  ),
  dbt_internal_test as (
    select  * from test_main_sql
  )
  select
    count(*) as failures,
    case when count(*) != 0
      then 'true' else 'false' end as should_warn,
    case when count(*) != 0
      then 'true' else 'false' end as should_error
  from dbt_internal_test
[0m20:49:01.075957 [debug] [Thread-1 (]: Opening a new connection, currently in state closed
[0m20:49:01.079230 [debug] [Thread-1 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:49:01.250140 [debug] [Thread-3 (]: SQL status: OK in 1.000 seconds
[0m20:49:01.250140 [debug] [Thread-3 (]: On test.jaffle_shop.accepted_values_stg_payments_payment_method__credit_card__coupon__bank_transfer__gift_card.3c3820f278: ROLLBACK
[0m20:49:01.250140 [debug] [Thread-3 (]: On test.jaffle_shop.accepted_values_stg_payments_payment_method__credit_card__coupon__bank_transfer__gift_card.3c3820f278: Close
[0m20:49:01.250140 [info ] [Thread-3 (]: 3 of 20 PASS accepted_values_stg_payments_payment_method__credit_card__coupon__bank_transfer__gift_card  [[32mPASS[0m in 1.43s]
[0m20:49:01.250140 [debug] [Thread-3 (]: Finished running node test.jaffle_shop.accepted_values_stg_payments_payment_method__credit_card__coupon__bank_transfer__gift_card.3c3820f278
[0m20:49:01.250140 [debug] [Thread-3 (]: Began running node test.jaffle_shop.not_null_stg_customers_customer_id.e2cfb1f9aa
[0m20:49:01.250140 [info ] [Thread-3 (]: 12 of 20 START test not_null_stg_customers_customer_id ......................... [RUN]
[0m20:49:01.250140 [debug] [Thread-3 (]: Re-using an available connection from the pool (formerly test.jaffle_shop.accepted_values_stg_payments_payment_method__credit_card__coupon__bank_transfer__gift_card.3c3820f278, now test.jaffle_shop.not_null_stg_customers_customer_id.e2cfb1f9aa)
[0m20:49:01.250140 [debug] [Thread-3 (]: Began compiling node test.jaffle_shop.not_null_stg_customers_customer_id.e2cfb1f9aa
[0m20:49:01.250140 [debug] [Thread-3 (]: Writing injected SQL for node "test.jaffle_shop.not_null_stg_customers_customer_id.e2cfb1f9aa"
[0m20:49:01.275219 [debug] [Thread-3 (]: Began executing node test.jaffle_shop.not_null_stg_customers_customer_id.e2cfb1f9aa
[0m20:49:01.278489 [debug] [Thread-3 (]: Writing runtime sql for node "test.jaffle_shop.not_null_stg_customers_customer_id.e2cfb1f9aa"
[0m20:49:01.279465 [debug] [Thread-3 (]: Using fabric connection "test.jaffle_shop.not_null_stg_customers_customer_id.e2cfb1f9aa"
[0m20:49:01.280466 [debug] [Thread-3 (]: On test.jaffle_shop.not_null_stg_customers_customer_id.e2cfb1f9aa: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "test.jaffle_shop.not_null_stg_customers_customer_id.e2cfb1f9aa"} */

    with test_main_sql as (
  
    
    
    



select customer_id
from "ws_ssc_articles"."dbo"."stg_customers"
where customer_id is null



  
  ),
  dbt_internal_test as (
    select  * from test_main_sql
  )
  select
    count(*) as failures,
    case when count(*) != 0
      then 'true' else 'false' end as should_warn,
    case when count(*) != 0
      then 'true' else 'false' end as should_error
  from dbt_internal_test
[0m20:49:01.280466 [debug] [Thread-3 (]: Opening a new connection, currently in state closed
[0m20:49:01.280466 [debug] [Thread-3 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:49:01.281465 [debug] [Thread-3 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:49:01.402587 [debug] [Thread-3 (]: SQL status: OK in 0.000 seconds
[0m20:49:01.402587 [debug] [Thread-3 (]: On test.jaffle_shop.not_null_stg_customers_customer_id.e2cfb1f9aa: ROLLBACK
[0m20:49:01.402587 [debug] [Thread-3 (]: On test.jaffle_shop.not_null_stg_customers_customer_id.e2cfb1f9aa: Close
[0m20:49:01.402587 [info ] [Thread-3 (]: 12 of 20 PASS not_null_stg_customers_customer_id ............................... [[32mPASS[0m in 0.15s]
[0m20:49:01.402587 [debug] [Thread-3 (]: Finished running node test.jaffle_shop.not_null_stg_customers_customer_id.e2cfb1f9aa
[0m20:49:01.402587 [debug] [Thread-3 (]: Began running node test.jaffle_shop.not_null_stg_orders_order_id.81cfe2fe64
[0m20:49:01.402587 [debug] [Thread-4 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:49:01.402587 [info ] [Thread-3 (]: 13 of 20 START test not_null_stg_orders_order_id ............................... [RUN]
[0m20:49:01.402587 [debug] [Thread-3 (]: Re-using an available connection from the pool (formerly test.jaffle_shop.not_null_stg_customers_customer_id.e2cfb1f9aa, now test.jaffle_shop.not_null_stg_orders_order_id.81cfe2fe64)
[0m20:49:01.402587 [debug] [Thread-3 (]: Began compiling node test.jaffle_shop.not_null_stg_orders_order_id.81cfe2fe64
[0m20:49:01.412027 [debug] [Thread-3 (]: Writing injected SQL for node "test.jaffle_shop.not_null_stg_orders_order_id.81cfe2fe64"
[0m20:49:01.417436 [debug] [Thread-3 (]: Began executing node test.jaffle_shop.not_null_stg_orders_order_id.81cfe2fe64
[0m20:49:01.420031 [debug] [Thread-3 (]: Writing runtime sql for node "test.jaffle_shop.not_null_stg_orders_order_id.81cfe2fe64"
[0m20:49:01.422103 [debug] [Thread-3 (]: Using fabric connection "test.jaffle_shop.not_null_stg_orders_order_id.81cfe2fe64"
[0m20:49:01.423384 [debug] [Thread-3 (]: On test.jaffle_shop.not_null_stg_orders_order_id.81cfe2fe64: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "test.jaffle_shop.not_null_stg_orders_order_id.81cfe2fe64"} */

    with test_main_sql as (
  
    
    
    



select order_id
from "ws_ssc_articles"."dbo"."stg_orders"
where order_id is null



  
  ),
  dbt_internal_test as (
    select  * from test_main_sql
  )
  select
    count(*) as failures,
    case when count(*) != 0
      then 'true' else 'false' end as should_warn,
    case when count(*) != 0
      then 'true' else 'false' end as should_error
  from dbt_internal_test
[0m20:49:01.424066 [debug] [Thread-3 (]: Opening a new connection, currently in state closed
[0m20:49:01.424066 [debug] [Thread-3 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:49:01.425077 [debug] [Thread-3 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:49:01.427125 [debug] [Thread-2 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:49:01.509876 [debug] [Thread-3 (]: SQL status: OK in 0.000 seconds
[0m20:49:01.511874 [debug] [Thread-3 (]: On test.jaffle_shop.not_null_stg_orders_order_id.81cfe2fe64: ROLLBACK
[0m20:49:01.512875 [debug] [Thread-3 (]: On test.jaffle_shop.not_null_stg_orders_order_id.81cfe2fe64: Close
[0m20:49:01.512875 [debug] [Thread-2 (]: SQL status: OK in 1.000 seconds
[0m20:49:01.512875 [info ] [Thread-3 (]: 13 of 20 PASS not_null_stg_orders_order_id ..................................... [[32mPASS[0m in 0.11s]
[0m20:49:01.514323 [debug] [Thread-3 (]: Finished running node test.jaffle_shop.not_null_stg_orders_order_id.81cfe2fe64
[0m20:49:01.515354 [debug] [Thread-3 (]: Began running node test.jaffle_shop.not_null_stg_payments_payment_id.c19cc50075
[0m20:49:01.516339 [debug] [Thread-2 (]: On test.jaffle_shop.not_null_orders_gift_card_amount.413a0d2d7a: ROLLBACK
[0m20:49:01.515354 [info ] [Thread-3 (]: 14 of 20 START test not_null_stg_payments_payment_id ........................... [RUN]
[0m20:49:01.517347 [debug] [Thread-2 (]: On test.jaffle_shop.not_null_orders_gift_card_amount.413a0d2d7a: Close
[0m20:49:01.517347 [debug] [Thread-3 (]: Re-using an available connection from the pool (formerly test.jaffle_shop.not_null_stg_orders_order_id.81cfe2fe64, now test.jaffle_shop.not_null_stg_payments_payment_id.c19cc50075)
[0m20:49:01.519333 [debug] [Thread-3 (]: Began compiling node test.jaffle_shop.not_null_stg_payments_payment_id.c19cc50075
[0m20:49:01.518342 [info ] [Thread-2 (]: 10 of 20 PASS not_null_orders_gift_card_amount ................................. [[32mPASS[0m in 0.58s]
[0m20:49:01.523932 [debug] [Thread-3 (]: Writing injected SQL for node "test.jaffle_shop.not_null_stg_payments_payment_id.c19cc50075"
[0m20:49:01.525594 [debug] [Thread-2 (]: Finished running node test.jaffle_shop.not_null_orders_gift_card_amount.413a0d2d7a
[0m20:49:01.526601 [debug] [Thread-2 (]: Began running node test.jaffle_shop.relationships_orders_customer_id__customer_id__ref_customers_.c6ec7f58f2
[0m20:49:01.526601 [info ] [Thread-2 (]: 15 of 20 START test relationships_orders_customer_id__customer_id__ref_customers_  [RUN]
[0m20:49:01.527901 [debug] [Thread-2 (]: Re-using an available connection from the pool (formerly test.jaffle_shop.not_null_orders_gift_card_amount.413a0d2d7a, now test.jaffle_shop.relationships_orders_customer_id__customer_id__ref_customers_.c6ec7f58f2)
[0m20:49:01.528910 [debug] [Thread-2 (]: Began compiling node test.jaffle_shop.relationships_orders_customer_id__customer_id__ref_customers_.c6ec7f58f2
[0m20:49:01.536792 [debug] [Thread-2 (]: Writing injected SQL for node "test.jaffle_shop.relationships_orders_customer_id__customer_id__ref_customers_.c6ec7f58f2"
[0m20:49:01.538080 [debug] [Thread-3 (]: Began executing node test.jaffle_shop.not_null_stg_payments_payment_id.c19cc50075
[0m20:49:01.541145 [debug] [Thread-3 (]: Writing runtime sql for node "test.jaffle_shop.not_null_stg_payments_payment_id.c19cc50075"
[0m20:49:01.541470 [debug] [Thread-2 (]: Began executing node test.jaffle_shop.relationships_orders_customer_id__customer_id__ref_customers_.c6ec7f58f2
[0m20:49:01.544807 [debug] [Thread-2 (]: Writing runtime sql for node "test.jaffle_shop.relationships_orders_customer_id__customer_id__ref_customers_.c6ec7f58f2"
[0m20:49:01.545808 [debug] [Thread-3 (]: Using fabric connection "test.jaffle_shop.not_null_stg_payments_payment_id.c19cc50075"
[0m20:49:01.546998 [debug] [Thread-3 (]: On test.jaffle_shop.not_null_stg_payments_payment_id.c19cc50075: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "test.jaffle_shop.not_null_stg_payments_payment_id.c19cc50075"} */

    with test_main_sql as (
  
    
    
    



select payment_id
from "ws_ssc_articles"."dbo"."stg_payments"
where payment_id is null



  
  ),
  dbt_internal_test as (
    select  * from test_main_sql
  )
  select
    count(*) as failures,
    case when count(*) != 0
      then 'true' else 'false' end as should_warn,
    case when count(*) != 0
      then 'true' else 'false' end as should_error
  from dbt_internal_test
[0m20:49:01.546998 [debug] [Thread-3 (]: Opening a new connection, currently in state closed
[0m20:49:01.548026 [debug] [Thread-3 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:49:01.548026 [debug] [Thread-2 (]: Using fabric connection "test.jaffle_shop.relationships_orders_customer_id__customer_id__ref_customers_.c6ec7f58f2"
[0m20:49:01.548026 [debug] [Thread-3 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:49:01.548026 [debug] [Thread-2 (]: On test.jaffle_shop.relationships_orders_customer_id__customer_id__ref_customers_.c6ec7f58f2: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "test.jaffle_shop.relationships_orders_customer_id__customer_id__ref_customers_.c6ec7f58f2"} */

    with test_main_sql as (
  
    
    
    

with child as (
    select customer_id as from_field
    from "ws_ssc_articles"."dbo"."orders"
    where customer_id is not null
),

parent as (
    select customer_id as to_field
    from "ws_ssc_articles"."dbo"."customers"
)

select
    from_field

from child
left join parent
    on child.from_field = parent.to_field

where parent.to_field is null



  
  ),
  dbt_internal_test as (
    select  * from test_main_sql
  )
  select
    count(*) as failures,
    case when count(*) != 0
      then 'true' else 'false' end as should_warn,
    case when count(*) != 0
      then 'true' else 'false' end as should_error
  from dbt_internal_test
[0m20:49:01.548026 [debug] [Thread-2 (]: Opening a new connection, currently in state closed
[0m20:49:01.548026 [debug] [Thread-2 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:49:01.551538 [debug] [Thread-2 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:49:01.603470 [debug] [Thread-1 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:49:01.650138 [debug] [Thread-2 (]: SQL status: OK in 0.000 seconds
[0m20:49:01.651658 [debug] [Thread-4 (]: SQL status: OK in 1.000 seconds
[0m20:49:01.654607 [debug] [Thread-4 (]: On test.jaffle_shop.not_null_orders_customer_id.c5f02694af: ROLLBACK
[0m20:49:01.654607 [debug] [Thread-2 (]: On test.jaffle_shop.relationships_orders_customer_id__customer_id__ref_customers_.c6ec7f58f2: ROLLBACK
[0m20:49:01.654607 [debug] [Thread-4 (]: On test.jaffle_shop.not_null_orders_customer_id.c5f02694af: Close
[0m20:49:01.654607 [debug] [Thread-2 (]: On test.jaffle_shop.relationships_orders_customer_id__customer_id__ref_customers_.c6ec7f58f2: Close
[0m20:49:01.654607 [info ] [Thread-4 (]: 9 of 20 PASS not_null_orders_customer_id ....................................... [[32mPASS[0m in 0.76s]
[0m20:49:01.654607 [debug] [Thread-4 (]: Finished running node test.jaffle_shop.not_null_orders_customer_id.c5f02694af
[0m20:49:01.654607 [info ] [Thread-2 (]: 15 of 20 PASS relationships_orders_customer_id__customer_id__ref_customers_ .... [[32mPASS[0m in 0.13s]
[0m20:49:01.654607 [debug] [Thread-4 (]: Began running node test.jaffle_shop.unique_customers_customer_id.c5af1ff4b1
[0m20:49:01.654607 [debug] [Thread-2 (]: Finished running node test.jaffle_shop.relationships_orders_customer_id__customer_id__ref_customers_.c6ec7f58f2
[0m20:49:01.654607 [debug] [Thread-2 (]: Began running node test.jaffle_shop.unique_orders_order_id.fed79b3a6e
[0m20:49:01.654607 [info ] [Thread-4 (]: 16 of 20 START test unique_customers_customer_id ............................... [RUN]
[0m20:49:01.654607 [info ] [Thread-2 (]: 17 of 20 START test unique_orders_order_id ..................................... [RUN]
[0m20:49:01.654607 [debug] [Thread-4 (]: Re-using an available connection from the pool (formerly test.jaffle_shop.not_null_orders_customer_id.c5f02694af, now test.jaffle_shop.unique_customers_customer_id.c5af1ff4b1)
[0m20:49:01.666194 [debug] [Thread-2 (]: Re-using an available connection from the pool (formerly test.jaffle_shop.relationships_orders_customer_id__customer_id__ref_customers_.c6ec7f58f2, now test.jaffle_shop.unique_orders_order_id.fed79b3a6e)
[0m20:49:01.666194 [debug] [Thread-4 (]: Began compiling node test.jaffle_shop.unique_customers_customer_id.c5af1ff4b1
[0m20:49:01.667399 [debug] [Thread-2 (]: Began compiling node test.jaffle_shop.unique_orders_order_id.fed79b3a6e
[0m20:49:01.673242 [debug] [Thread-4 (]: Writing injected SQL for node "test.jaffle_shop.unique_customers_customer_id.c5af1ff4b1"
[0m20:49:01.673242 [debug] [Thread-2 (]: Writing injected SQL for node "test.jaffle_shop.unique_orders_order_id.fed79b3a6e"
[0m20:49:01.673242 [debug] [Thread-2 (]: Began executing node test.jaffle_shop.unique_orders_order_id.fed79b3a6e
[0m20:49:01.673242 [debug] [Thread-4 (]: Began executing node test.jaffle_shop.unique_customers_customer_id.c5af1ff4b1
[0m20:49:01.684768 [debug] [Thread-2 (]: Writing runtime sql for node "test.jaffle_shop.unique_orders_order_id.fed79b3a6e"
[0m20:49:01.689281 [debug] [Thread-4 (]: Writing runtime sql for node "test.jaffle_shop.unique_customers_customer_id.c5af1ff4b1"
[0m20:49:01.689956 [debug] [Thread-2 (]: Using fabric connection "test.jaffle_shop.unique_orders_order_id.fed79b3a6e"
[0m20:49:01.691415 [debug] [Thread-2 (]: On test.jaffle_shop.unique_orders_order_id.fed79b3a6e: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "test.jaffle_shop.unique_orders_order_id.fed79b3a6e"} */

    with test_main_sql as (
  
    
    
    

select
    order_id as unique_field,
    count(*) as n_records

from "ws_ssc_articles"."dbo"."orders"
where order_id is not null
group by order_id
having count(*) > 1



  
  ),
  dbt_internal_test as (
    select  * from test_main_sql
  )
  select
    count(*) as failures,
    case when count(*) != 0
      then 'true' else 'false' end as should_warn,
    case when count(*) != 0
      then 'true' else 'false' end as should_error
  from dbt_internal_test
[0m20:49:01.692425 [debug] [Thread-2 (]: Opening a new connection, currently in state closed
[0m20:49:01.692425 [debug] [Thread-2 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:49:01.692425 [debug] [Thread-2 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:49:01.693424 [debug] [Thread-4 (]: Using fabric connection "test.jaffle_shop.unique_customers_customer_id.c5af1ff4b1"
[0m20:49:01.693424 [debug] [Thread-4 (]: On test.jaffle_shop.unique_customers_customer_id.c5af1ff4b1: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "test.jaffle_shop.unique_customers_customer_id.c5af1ff4b1"} */

    with test_main_sql as (
  
    
    
    

select
    customer_id as unique_field,
    count(*) as n_records

from "ws_ssc_articles"."dbo"."customers"
where customer_id is not null
group by customer_id
having count(*) > 1



  
  ),
  dbt_internal_test as (
    select  * from test_main_sql
  )
  select
    count(*) as failures,
    case when count(*) != 0
      then 'true' else 'false' end as should_warn,
    case when count(*) != 0
      then 'true' else 'false' end as should_error
  from dbt_internal_test
[0m20:49:01.693424 [debug] [Thread-4 (]: Opening a new connection, currently in state closed
[0m20:49:01.693424 [debug] [Thread-4 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:49:01.693424 [debug] [Thread-4 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:49:01.756043 [debug] [Thread-3 (]: SQL status: OK in 0.000 seconds
[0m20:49:01.759085 [debug] [Thread-3 (]: On test.jaffle_shop.not_null_stg_payments_payment_id.c19cc50075: ROLLBACK
[0m20:49:01.759085 [debug] [Thread-3 (]: On test.jaffle_shop.not_null_stg_payments_payment_id.c19cc50075: Close
[0m20:49:01.760098 [info ] [Thread-3 (]: 14 of 20 PASS not_null_stg_payments_payment_id ................................. [[32mPASS[0m in 0.24s]
[0m20:49:01.761089 [debug] [Thread-3 (]: Finished running node test.jaffle_shop.not_null_stg_payments_payment_id.c19cc50075
[0m20:49:01.762092 [debug] [Thread-3 (]: Began running node test.jaffle_shop.unique_stg_customers_customer_id.c7614daada
[0m20:49:01.763072 [info ] [Thread-3 (]: 18 of 20 START test unique_stg_customers_customer_id ........................... [RUN]
[0m20:49:01.764043 [debug] [Thread-3 (]: Re-using an available connection from the pool (formerly test.jaffle_shop.not_null_stg_payments_payment_id.c19cc50075, now test.jaffle_shop.unique_stg_customers_customer_id.c7614daada)
[0m20:49:01.764043 [debug] [Thread-3 (]: Began compiling node test.jaffle_shop.unique_stg_customers_customer_id.c7614daada
[0m20:49:01.769175 [debug] [Thread-3 (]: Writing injected SQL for node "test.jaffle_shop.unique_stg_customers_customer_id.c7614daada"
[0m20:49:01.769175 [debug] [Thread-3 (]: Began executing node test.jaffle_shop.unique_stg_customers_customer_id.c7614daada
[0m20:49:01.775357 [debug] [Thread-3 (]: Writing runtime sql for node "test.jaffle_shop.unique_stg_customers_customer_id.c7614daada"
[0m20:49:01.775357 [debug] [Thread-2 (]: SQL status: OK in 0.000 seconds
[0m20:49:01.777370 [debug] [Thread-2 (]: On test.jaffle_shop.unique_orders_order_id.fed79b3a6e: ROLLBACK
[0m20:49:01.779386 [debug] [Thread-2 (]: On test.jaffle_shop.unique_orders_order_id.fed79b3a6e: Close
[0m20:49:01.779386 [debug] [Thread-3 (]: Using fabric connection "test.jaffle_shop.unique_stg_customers_customer_id.c7614daada"
[0m20:49:01.781399 [debug] [Thread-1 (]: SQL status: OK in 1.000 seconds
[0m20:49:01.782291 [debug] [Thread-3 (]: On test.jaffle_shop.unique_stg_customers_customer_id.c7614daada: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "test.jaffle_shop.unique_stg_customers_customer_id.c7614daada"} */

    with test_main_sql as (
  
    
    
    

select
    customer_id as unique_field,
    count(*) as n_records

from "ws_ssc_articles"."dbo"."stg_customers"
where customer_id is not null
group by customer_id
having count(*) > 1



  
  ),
  dbt_internal_test as (
    select  * from test_main_sql
  )
  select
    count(*) as failures,
    case when count(*) != 0
      then 'true' else 'false' end as should_warn,
    case when count(*) != 0
      then 'true' else 'false' end as should_error
  from dbt_internal_test
[0m20:49:01.782291 [info ] [Thread-2 (]: 17 of 20 PASS unique_orders_order_id ........................................... [[32mPASS[0m in 0.12s]
[0m20:49:01.784802 [debug] [Thread-1 (]: On test.jaffle_shop.not_null_orders_order_id.cf6c17daed: ROLLBACK
[0m20:49:01.785690 [debug] [Thread-3 (]: Opening a new connection, currently in state closed
[0m20:49:01.785690 [debug] [Thread-2 (]: Finished running node test.jaffle_shop.unique_orders_order_id.fed79b3a6e
[0m20:49:01.786828 [debug] [Thread-1 (]: On test.jaffle_shop.not_null_orders_order_id.cf6c17daed: Close
[0m20:49:01.787690 [debug] [Thread-3 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:49:01.787690 [debug] [Thread-2 (]: Began running node test.jaffle_shop.unique_stg_orders_order_id.e3b841c71a
[0m20:49:01.787690 [info ] [Thread-1 (]: 11 of 20 PASS not_null_orders_order_id ......................................... [[32mPASS[0m in 0.73s]
[0m20:49:01.787690 [debug] [Thread-3 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:49:01.787690 [info ] [Thread-2 (]: 19 of 20 START test unique_stg_orders_order_id ................................. [RUN]
[0m20:49:01.787690 [debug] [Thread-1 (]: Finished running node test.jaffle_shop.not_null_orders_order_id.cf6c17daed
[0m20:49:01.787690 [debug] [Thread-2 (]: Re-using an available connection from the pool (formerly test.jaffle_shop.unique_orders_order_id.fed79b3a6e, now test.jaffle_shop.unique_stg_orders_order_id.e3b841c71a)
[0m20:49:01.787690 [debug] [Thread-1 (]: Began running node test.jaffle_shop.unique_stg_payments_payment_id.3744510712
[0m20:49:01.787690 [debug] [Thread-2 (]: Began compiling node test.jaffle_shop.unique_stg_orders_order_id.e3b841c71a
[0m20:49:01.787690 [debug] [Thread-2 (]: Writing injected SQL for node "test.jaffle_shop.unique_stg_orders_order_id.e3b841c71a"
[0m20:49:01.787690 [info ] [Thread-1 (]: 20 of 20 START test unique_stg_payments_payment_id ............................. [RUN]
[0m20:49:01.787690 [debug] [Thread-1 (]: Re-using an available connection from the pool (formerly test.jaffle_shop.not_null_orders_order_id.cf6c17daed, now test.jaffle_shop.unique_stg_payments_payment_id.3744510712)
[0m20:49:01.787690 [debug] [Thread-1 (]: Began compiling node test.jaffle_shop.unique_stg_payments_payment_id.3744510712
[0m20:49:01.801813 [debug] [Thread-1 (]: Writing injected SQL for node "test.jaffle_shop.unique_stg_payments_payment_id.3744510712"
[0m20:49:01.801813 [debug] [Thread-2 (]: Began executing node test.jaffle_shop.unique_stg_orders_order_id.e3b841c71a
[0m20:49:01.801813 [debug] [Thread-2 (]: Writing runtime sql for node "test.jaffle_shop.unique_stg_orders_order_id.e3b841c71a"
[0m20:49:01.809710 [debug] [Thread-1 (]: Began executing node test.jaffle_shop.unique_stg_payments_payment_id.3744510712
[0m20:49:01.812045 [debug] [Thread-1 (]: Writing runtime sql for node "test.jaffle_shop.unique_stg_payments_payment_id.3744510712"
[0m20:49:01.813035 [debug] [Thread-2 (]: Using fabric connection "test.jaffle_shop.unique_stg_orders_order_id.e3b841c71a"
[0m20:49:01.813035 [debug] [Thread-2 (]: On test.jaffle_shop.unique_stg_orders_order_id.e3b841c71a: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "test.jaffle_shop.unique_stg_orders_order_id.e3b841c71a"} */

    with test_main_sql as (
  
    
    
    

select
    order_id as unique_field,
    count(*) as n_records

from "ws_ssc_articles"."dbo"."stg_orders"
where order_id is not null
group by order_id
having count(*) > 1



  
  ),
  dbt_internal_test as (
    select  * from test_main_sql
  )
  select
    count(*) as failures,
    case when count(*) != 0
      then 'true' else 'false' end as should_warn,
    case when count(*) != 0
      then 'true' else 'false' end as should_error
  from dbt_internal_test
[0m20:49:01.813035 [debug] [Thread-2 (]: Opening a new connection, currently in state closed
[0m20:49:01.813035 [debug] [Thread-2 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:49:01.813035 [debug] [Thread-2 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:49:01.813035 [debug] [Thread-1 (]: Using fabric connection "test.jaffle_shop.unique_stg_payments_payment_id.3744510712"
[0m20:49:01.813035 [debug] [Thread-1 (]: On test.jaffle_shop.unique_stg_payments_payment_id.3744510712: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "jaffle_shop", "target_name": "fabric-dev", "node_id": "test.jaffle_shop.unique_stg_payments_payment_id.3744510712"} */

    with test_main_sql as (
  
    
    
    

select
    payment_id as unique_field,
    count(*) as n_records

from "ws_ssc_articles"."dbo"."stg_payments"
where payment_id is not null
group by payment_id
having count(*) > 1



  
  ),
  dbt_internal_test as (
    select  * from test_main_sql
  )
  select
    count(*) as failures,
    case when count(*) != 0
      then 'true' else 'false' end as should_warn,
    case when count(*) != 0
      then 'true' else 'false' end as should_error
  from dbt_internal_test
[0m20:49:01.813035 [debug] [Thread-1 (]: Opening a new connection, currently in state closed
[0m20:49:01.813035 [debug] [Thread-1 (]: fabric adapter: Using connection string: DRIVER={ODBC Driver 18 for SQL Server};SERVER=abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com;Database=ws_ssc_articles;Pooling=true;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF;Authentication=ActiveDirectoryInteractive;UID={robin@craftydba.com};encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:49:01.813035 [debug] [Thread-1 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:49:01.838163 [debug] [Thread-4 (]: SQL status: OK in 0.000 seconds
[0m20:49:01.838163 [debug] [Thread-4 (]: On test.jaffle_shop.unique_customers_customer_id.c5af1ff4b1: ROLLBACK
[0m20:49:01.838163 [debug] [Thread-4 (]: On test.jaffle_shop.unique_customers_customer_id.c5af1ff4b1: Close
[0m20:49:01.838163 [info ] [Thread-4 (]: 16 of 20 PASS unique_customers_customer_id ..................................... [[32mPASS[0m in 0.18s]
[0m20:49:01.838163 [debug] [Thread-4 (]: Finished running node test.jaffle_shop.unique_customers_customer_id.c5af1ff4b1
[0m20:49:01.868956 [debug] [Thread-3 (]: SQL status: OK in 0.000 seconds
[0m20:49:01.868956 [debug] [Thread-3 (]: On test.jaffle_shop.unique_stg_customers_customer_id.c7614daada: ROLLBACK
[0m20:49:01.882584 [debug] [Thread-3 (]: On test.jaffle_shop.unique_stg_customers_customer_id.c7614daada: Close
[0m20:49:01.882584 [info ] [Thread-3 (]: 18 of 20 PASS unique_stg_customers_customer_id ................................. [[32mPASS[0m in 0.12s]
[0m20:49:01.883632 [debug] [Thread-3 (]: Finished running node test.jaffle_shop.unique_stg_customers_customer_id.c7614daada
[0m20:49:01.908455 [debug] [Thread-1 (]: SQL status: OK in 0.000 seconds
[0m20:49:01.908455 [debug] [Thread-1 (]: On test.jaffle_shop.unique_stg_payments_payment_id.3744510712: ROLLBACK
[0m20:49:01.908455 [debug] [Thread-1 (]: On test.jaffle_shop.unique_stg_payments_payment_id.3744510712: Close
[0m20:49:01.908455 [info ] [Thread-1 (]: 20 of 20 PASS unique_stg_payments_payment_id ................................... [[32mPASS[0m in 0.12s]
[0m20:49:01.908455 [debug] [Thread-1 (]: Finished running node test.jaffle_shop.unique_stg_payments_payment_id.3744510712
[0m20:49:01.943785 [debug] [Thread-2 (]: SQL status: OK in 0.000 seconds
[0m20:49:01.943785 [debug] [Thread-2 (]: On test.jaffle_shop.unique_stg_orders_order_id.e3b841c71a: ROLLBACK
[0m20:49:01.943785 [debug] [Thread-2 (]: On test.jaffle_shop.unique_stg_orders_order_id.e3b841c71a: Close
[0m20:49:01.943785 [info ] [Thread-2 (]: 19 of 20 PASS unique_stg_orders_order_id ....................................... [[32mPASS[0m in 0.16s]
[0m20:49:01.943785 [debug] [Thread-2 (]: Finished running node test.jaffle_shop.unique_stg_orders_order_id.e3b841c71a
[0m20:49:01.943785 [debug] [MainThread]: On master: COMMIT
[0m20:49:01.943785 [debug] [MainThread]: Connection 'master' was properly closed.
[0m20:49:01.951579 [debug] [MainThread]: Connection 'list_ws_ssc_articles_dbo' was properly closed.
[0m20:49:01.951579 [debug] [MainThread]: Connection 'test.jaffle_shop.unique_stg_payments_payment_id.3744510712' was properly closed.
[0m20:49:01.952702 [debug] [MainThread]: Connection 'test.jaffle_shop.unique_stg_orders_order_id.e3b841c71a' was properly closed.
[0m20:49:01.953695 [debug] [MainThread]: Connection 'test.jaffle_shop.unique_stg_customers_customer_id.c7614daada' was properly closed.
[0m20:49:01.953695 [debug] [MainThread]: Connection 'test.jaffle_shop.unique_customers_customer_id.c5af1ff4b1' was properly closed.
[0m20:49:01.953695 [info ] [MainThread]: 
[0m20:49:01.953695 [info ] [MainThread]: Finished running 20 data tests in 0 hours 0 minutes and 18.19 seconds (18.19s).
[0m20:49:01.959617 [debug] [MainThread]: Command end result
[0m20:49:01.978841 [debug] [MainThread]: Wrote artifact WritableManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\target\manifest.json
[0m20:49:01.983683 [debug] [MainThread]: Wrote artifact SemanticManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\target\semantic_manifest.json
[0m20:49:01.989504 [debug] [MainThread]: Wrote artifact RunExecutionResult to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\jaffle-shop-classic\target\run_results.json
[0m20:49:01.989504 [info ] [MainThread]: 
[0m20:49:01.989504 [info ] [MainThread]: [32mCompleted successfully[0m
[0m20:49:01.989504 [info ] [MainThread]: 
[0m20:49:01.989504 [info ] [MainThread]: Done. PASS=20 WARN=0 ERROR=0 SKIP=0 NO-OP=0 TOTAL=20
[0m20:49:01.989504 [warn ] [MainThread]: [[33mWARNING[0m][DeprecationsSummary]: Deprecated functionality
Summary of encountered deprecations:
- ProjectFlagsMovedDeprecation: 1 occurrence
To see all deprecation instances instead of just the first occurrence of each,
run command again with the `--show-all-deprecations` flag. You may also need to
run with `--no-partial-parse` as some deprecations are only encountered during
parsing.
[0m20:49:01.989504 [debug] [MainThread]: Command `dbt test` succeeded at 20:49:01.989504 after 19.44 seconds
[0m20:49:01.989504 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'end', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000016F0C04EA20>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000016F0B96F740>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000016F0B96F770>]}
[0m20:49:01.989504 [debug] [MainThread]: Flushing usage events
[0m20:49:02.104513 [debug] [MainThread]: An error was encountered while trying to flush usage events
