cls[0m19:12:52.802074 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'start', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024C33AAEC00>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024C343F0A10>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024C31399F40>]}


============================== 19:12:52.806383 | c107f8ca-0bf0-420d-a1ac-6e51b0ebb204 ==============================
[0m19:12:52.806383 [info ] [MainThread]: Running with dbt=1.10.16
[0m19:12:52.808407 [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', 'profiles_dir': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\chinook', 'send_anonymous_usage_stats': 'True', 'quiet': 'False', 'warn_error': 'None', 'partial_parse': 'True', 'invocation_command': 'dbt seed --select Customer', 'use_colors': 'True', 'indirect_selection': 'eager', 'use_experimental_parser': 'False', 'log_path': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\chinook\\logs'}
[0m19:12:53.278735 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'project_id', 'label': 'c107f8ca-0bf0-420d-a1ac-6e51b0ebb204', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024C35D6DC10>]}
[0m19:12:53.331081 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'adapter_info', 'label': 'c107f8ca-0bf0-420d-a1ac-6e51b0ebb204', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024C35F7E6C0>]}
[0m19:12:53.332074 [info ] [MainThread]: Registered adapter: fabric=1.9.8
[0m19:12:53.516695 [debug] [MainThread]: checksum: c4b99e2e3bb042c661c8397fd92290cd0d52b31ce393ad721fa0bb3c9591dd0f, vars: {}, profile: , target: , version: 1.10.16
[0m19:12:53.698744 [debug] [MainThread]: Partial parsing enabled: 0 files deleted, 0 files added, 0 files changed.
[0m19:12:53.698744 [debug] [MainThread]: Partial parsing enabled, no changes found, skipping parsing
[0m19:12:53.738529 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'load_project', 'label': 'c107f8ca-0bf0-420d-a1ac-6e51b0ebb204', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024C36335730>]}
[0m19:12:53.793885 [debug] [MainThread]: Wrote artifact WritableManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\chinook\target\manifest.json
[0m19:12:53.793885 [debug] [MainThread]: Wrote artifact SemanticManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\chinook\target\semantic_manifest.json
[0m19:12:53.819774 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'resource_counts', 'label': 'c107f8ca-0bf0-420d-a1ac-6e51b0ebb204', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024C36393950>]}
[0m19:12:53.819774 [info ] [MainThread]: Found 2 models, 11 seeds, 4 data tests, 500 macros
[0m19:12:53.819774 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'runnable_timing', 'label': 'c107f8ca-0bf0-420d-a1ac-6e51b0ebb204', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024C36084860>]}
[0m19:12:53.819774 [info ] [MainThread]: 
[0m19:12:53.819774 [info ] [MainThread]: Concurrency: 4 threads (target='fabric-dev')
[0m19:12:53.819774 [info ] [MainThread]: 
[0m19:12:53.819774 [debug] [MainThread]: Acquiring new fabric connection 'master'
[0m19:12:53.819774 [debug] [ThreadPool]: Acquiring new fabric connection 'list_ws_ssc_articles'
[0m19:12:53.841957 [debug] [ThreadPool]: dbt-fabric
[0m19:12:53.841957 [debug] [ThreadPool]: Using fabric connection "list_ws_ssc_articles"
[0m19:12:53.841957 [debug] [ThreadPool]: On list_ws_ssc_articles: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "chinook", "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:12:53.841957 [debug] [ThreadPool]: Opening a new connection, currently in state init
[0m19:12:53.841957 [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=ActiveDirectoryServicePrincipal;UID={236fff28-f19b-47b8-8aca-31183d8eeb8c};PWD=***;encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m19:12:55.028567 [debug] [ThreadPool]: fabric adapter: Connected to db: ws_ssc_articles
[0m19:12:55.053839 [debug] [ThreadPool]: SQL status: OK in 1.000 seconds
[0m19:12:55.069683 [debug] [ThreadPool]: On list_ws_ssc_articles: Close
[0m19:12:55.069683 [debug] [ThreadPool]: Acquiring new fabric connection 'list_ws_ssc_articles_data'
[0m19:12:55.069683 [debug] [ThreadPool]: dbt-fabric
[0m19:12:55.069683 [debug] [ThreadPool]: Using fabric connection "list_ws_ssc_articles_data"
[0m19:12:55.069683 [debug] [ThreadPool]: On list_ws_ssc_articles_data: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "chinook", "target_name": "fabric-dev", "connection_name": "list_ws_ssc_articles_data"} */
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 'data'
    
    OPTION (LABEL = 'dbt-fabric-dw');

  
[0m19:12:55.069683 [debug] [ThreadPool]: Opening a new connection, currently in state init
[0m19:12:55.069683 [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=ActiveDirectoryServicePrincipal;UID={236fff28-f19b-47b8-8aca-31183d8eeb8c};PWD=***;encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m19:12:55.085765 [debug] [ThreadPool]: Acquiring new fabric connection 'list_ws_ssc_articles_data_raw'
[0m19:12:55.087782 [debug] [ThreadPool]: fabric adapter: Connected to db: ws_ssc_articles
[0m19:12:55.087782 [debug] [ThreadPool]: dbt-fabric
[0m19:12:55.089797 [debug] [ThreadPool]: Using fabric connection "list_ws_ssc_articles_data_raw"
[0m19:12:55.089797 [debug] [ThreadPool]: On list_ws_ssc_articles_data_raw: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "chinook", "target_name": "fabric-dev", "connection_name": "list_ws_ssc_articles_data_raw"} */
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 'data_raw'
    
    OPTION (LABEL = 'dbt-fabric-dw');

  
[0m19:12:55.089797 [debug] [ThreadPool]: Opening a new connection, currently in state init
[0m19:12:55.089797 [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=ActiveDirectoryServicePrincipal;UID={236fff28-f19b-47b8-8aca-31183d8eeb8c};PWD=***;encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m19:12:55.133469 [debug] [ThreadPool]: SQL status: OK in 0.000 seconds
[0m19:12:55.133469 [debug] [ThreadPool]: On list_ws_ssc_articles_data: ROLLBACK
[0m19:12:55.133469 [debug] [ThreadPool]: On list_ws_ssc_articles_data: Close
[0m19:12:55.910680 [debug] [ThreadPool]: fabric adapter: Connected to db: ws_ssc_articles
[0m19:12:55.958446 [debug] [ThreadPool]: SQL status: OK in 1.000 seconds
[0m19:12:55.958446 [debug] [ThreadPool]: On list_ws_ssc_articles_data_raw: ROLLBACK
[0m19:12:55.958446 [debug] [ThreadPool]: On list_ws_ssc_articles_data_raw: Close
[0m19:12:55.958446 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'runnable_timing', 'label': 'c107f8ca-0bf0-420d-a1ac-6e51b0ebb204', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024C35FCD280>]}
[0m19:12:55.958446 [debug] [MainThread]: On master: COMMIT
[0m19:12:55.974235 [debug] [Thread-1 (]: Began running node seed.chinook.Customer
[0m19:12:55.974235 [info ] [Thread-1 (]: 1 of 1 START seed file data_raw.Customer ....................................... [RUN]
[0m19:12:55.974235 [debug] [Thread-1 (]: Acquiring new fabric connection 'seed.chinook.Customer'
[0m19:12:55.974235 [debug] [Thread-1 (]: Began compiling node seed.chinook.Customer
[0m19:12:55.974235 [debug] [Thread-1 (]: Began executing node seed.chinook.Customer
[0m19:12:56.003217 [debug] [Thread-1 (]: Compilation Error in seed Customer (seeds\Customer.csv)
  Row 0 has 14 values, but Table only has 13 columns.
  
  > in macro materialization_seed_default (macros\materializations\seeds\seed.sql)
  > called by seed Customer (seeds\Customer.csv)
[0m19:12:56.003217 [debug] [Thread-1 (]: Sending event: {'category': 'dbt', 'action': 'run_model', 'label': 'c107f8ca-0bf0-420d-a1ac-6e51b0ebb204', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024C36392C30>]}
[0m19:12:56.003217 [error] [Thread-1 (]: 1 of 1 ERROR loading seed file data_raw.Customer ............................... [[31mERROR[0m in 0.03s]
[0m19:12:56.003217 [debug] [Thread-1 (]: Finished running node seed.chinook.Customer
[0m19:12:56.003217 [debug] [Thread-7 (]: Marking all children of 'seed.chinook.Customer' to be skipped because of status 'error'.  Reason: Compilation Error in seed Customer (seeds\Customer.csv)
  Row 0 has 14 values, but Table only has 13 columns.
  
  > in macro materialization_seed_default (macros\materializations\seeds\seed.sql)
  > called by seed Customer (seeds\Customer.csv).
[0m19:12:56.010874 [debug] [MainThread]: On master: COMMIT
[0m19:12:56.010874 [debug] [MainThread]: Connection 'master' was properly closed.
[0m19:12:56.010874 [debug] [MainThread]: Connection 'list_ws_ssc_articles' was properly closed.
[0m19:12:56.010874 [debug] [MainThread]: Connection 'list_ws_ssc_articles_data' was properly closed.
[0m19:12:56.010874 [debug] [MainThread]: Connection 'list_ws_ssc_articles_data_raw' was properly closed.
[0m19:12:56.010874 [debug] [MainThread]: Connection 'seed.chinook.Customer' was properly closed.
[0m19:12:56.010874 [info ] [MainThread]: 
[0m19:12:56.010874 [info ] [MainThread]: Finished running 1 seed in 0 hours 0 minutes and 2.19 seconds (2.19s).
[0m19:12:56.010874 [debug] [MainThread]: Command end result
[0m19:12:56.070315 [debug] [MainThread]: Wrote artifact WritableManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\chinook\target\manifest.json
[0m19:12:56.087327 [debug] [MainThread]: Wrote artifact SemanticManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\chinook\target\semantic_manifest.json
[0m19:12:56.092411 [debug] [MainThread]: Wrote artifact RunExecutionResult to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\chinook\target\run_results.json
[0m19:12:56.092411 [info ] [MainThread]: 
[0m19:12:56.093348 [info ] [MainThread]: [31mCompleted with 1 error, 0 partial successes, and 0 warnings:[0m
[0m19:12:56.094345 [info ] [MainThread]: 
[0m19:12:56.094345 [error] [MainThread]: [31mFailure in seed Customer (seeds\Customer.csv)[0m
[0m19:12:56.095340 [error] [MainThread]:   Compilation Error in seed Customer (seeds\Customer.csv)
  Row 0 has 14 values, but Table only has 13 columns.
  
  > in macro materialization_seed_default (macros\materializations\seeds\seed.sql)
  > called by seed Customer (seeds\Customer.csv)
[0m19:12:56.096392 [info ] [MainThread]: 
[0m19:12:56.096392 [info ] [MainThread]: Done. PASS=0 WARN=0 ERROR=1 SKIP=0 NO-OP=0 TOTAL=1
[0m19:12:56.097407 [debug] [MainThread]: Command `dbt seed` failed at 19:12:56.097407 after 3.45 seconds
[0m19:12:56.098418 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'end', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024C33ACC7A0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024C361EFD10>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000024C361EE8D0>]}
[0m19:12:56.098418 [debug] [MainThread]: Flushing usage events
[0m19:12:56.306315 [debug] [MainThread]: An error was encountered while trying to flush usage events
[0m19:16:22.555329 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'start', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000017D3B92D4F0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000017D3C1AF110>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000017D3B9BC740>]}


============================== 19:16:22.555329 | 26c2828f-18be-478f-80d5-fd8f7a79a81a ==============================
[0m19:16:22.555329 [info ] [MainThread]: Running with dbt=1.10.16
[0m19:16:22.555329 [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', 'log_format': 'default', 'debug': 'False', 'fail_fast': 'False', 'profiles_dir': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\chinook', 'send_anonymous_usage_stats': 'True', 'quiet': 'False', 'warn_error': 'None', 'partial_parse': 'True', 'indirect_selection': 'eager', 'invocation_command': 'dbt seed --select Customer', 'use_colors': 'True', 'use_experimental_parser': 'False', 'log_path': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\chinook\\logs'}
[0m19:16:23.005653 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'project_id', 'label': '26c2828f-18be-478f-80d5-fd8f7a79a81a', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000017D39758CB0>]}
[0m19:16:23.055775 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'adapter_info', 'label': '26c2828f-18be-478f-80d5-fd8f7a79a81a', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000017D3DC15FD0>]}
[0m19:16:23.055775 [info ] [MainThread]: Registered adapter: fabric=1.9.8
[0m19:16:23.248070 [debug] [MainThread]: checksum: c4b99e2e3bb042c661c8397fd92290cd0d52b31ce393ad721fa0bb3c9591dd0f, vars: {}, profile: , target: , version: 1.10.16
[0m19:16:23.462301 [debug] [MainThread]: Partial parsing enabled: 0 files deleted, 0 files added, 1 files changed.
[0m19:16:23.462301 [debug] [MainThread]: Partial parsing: updated file: chinook://seeds\Customer.csv
[0m19:16:23.637638 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'load_project', 'label': '26c2828f-18be-478f-80d5-fd8f7a79a81a', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000017D3E31B9E0>]}
[0m19:16:23.721445 [debug] [MainThread]: Wrote artifact WritableManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\chinook\target\manifest.json
[0m19:16:23.736311 [debug] [MainThread]: Wrote artifact SemanticManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\chinook\target\semantic_manifest.json
[0m19:16:23.757500 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'resource_counts', 'label': '26c2828f-18be-478f-80d5-fd8f7a79a81a', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000017D3E1CCA10>]}
[0m19:16:23.757500 [info ] [MainThread]: Found 2 models, 11 seeds, 4 data tests, 500 macros
[0m19:16:23.757500 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'runnable_timing', 'label': '26c2828f-18be-478f-80d5-fd8f7a79a81a', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000017D3AD059D0>]}
[0m19:16:23.757500 [info ] [MainThread]: 
[0m19:16:23.757500 [info ] [MainThread]: Concurrency: 4 threads (target='fabric-dev')
[0m19:16:23.757500 [info ] [MainThread]: 
[0m19:16:23.757500 [debug] [MainThread]: Acquiring new fabric connection 'master'
[0m19:16:23.767221 [debug] [ThreadPool]: Acquiring new fabric connection 'list_ws_ssc_articles'
[0m19:16:23.779489 [debug] [ThreadPool]: dbt-fabric
[0m19:16:23.779489 [debug] [ThreadPool]: Using fabric connection "list_ws_ssc_articles"
[0m19:16:23.779489 [debug] [ThreadPool]: On list_ws_ssc_articles: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "chinook", "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:16:23.779489 [debug] [ThreadPool]: Opening a new connection, currently in state init
[0m19:16:23.779489 [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=ActiveDirectoryServicePrincipal;UID={236fff28-f19b-47b8-8aca-31183d8eeb8c};PWD=***;encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m19:16:25.304788 [debug] [ThreadPool]: fabric adapter: Connected to db: ws_ssc_articles
[0m19:16:25.336895 [debug] [ThreadPool]: SQL status: OK in 2.000 seconds
[0m19:16:25.336895 [debug] [ThreadPool]: On list_ws_ssc_articles: Close
[0m19:16:25.353109 [debug] [ThreadPool]: Acquiring new fabric connection 'list_ws_ssc_articles_data'
[0m19:16:25.363203 [debug] [ThreadPool]: dbt-fabric
[0m19:16:25.363203 [debug] [ThreadPool]: Using fabric connection "list_ws_ssc_articles_data"
[0m19:16:25.363203 [debug] [ThreadPool]: On list_ws_ssc_articles_data: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "chinook", "target_name": "fabric-dev", "connection_name": "list_ws_ssc_articles_data"} */
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 'data'
    
    OPTION (LABEL = 'dbt-fabric-dw');

  
[0m19:16:25.363203 [debug] [ThreadPool]: Opening a new connection, currently in state init
[0m19:16:25.363203 [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=ActiveDirectoryServicePrincipal;UID={236fff28-f19b-47b8-8aca-31183d8eeb8c};PWD=***;encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m19:16:25.363203 [debug] [ThreadPool]: Acquiring new fabric connection 'list_ws_ssc_articles_data_raw'
[0m19:16:25.363203 [debug] [ThreadPool]: dbt-fabric
[0m19:16:25.366856 [debug] [ThreadPool]: Using fabric connection "list_ws_ssc_articles_data_raw"
[0m19:16:25.366856 [debug] [ThreadPool]: On list_ws_ssc_articles_data_raw: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "chinook", "target_name": "fabric-dev", "connection_name": "list_ws_ssc_articles_data_raw"} */
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 'data_raw'
    
    OPTION (LABEL = 'dbt-fabric-dw');

  
[0m19:16:25.366856 [debug] [ThreadPool]: Opening a new connection, currently in state init
[0m19:16:25.366856 [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=ActiveDirectoryServicePrincipal;UID={236fff28-f19b-47b8-8aca-31183d8eeb8c};PWD=***;encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m19:16:26.152557 [debug] [ThreadPool]: fabric adapter: Connected to db: ws_ssc_articles
[0m19:16:26.184652 [debug] [ThreadPool]: fabric adapter: Connected to db: ws_ssc_articles
[0m19:16:26.200431 [debug] [ThreadPool]: SQL status: OK in 1.000 seconds
[0m19:16:26.213065 [debug] [ThreadPool]: On list_ws_ssc_articles_data: ROLLBACK
[0m19:16:26.213065 [debug] [ThreadPool]: On list_ws_ssc_articles_data: Close
[0m19:16:26.241701 [debug] [ThreadPool]: SQL status: OK in 1.000 seconds
[0m19:16:26.248312 [debug] [ThreadPool]: On list_ws_ssc_articles_data_raw: ROLLBACK
[0m19:16:26.248312 [debug] [ThreadPool]: On list_ws_ssc_articles_data_raw: Close
[0m19:16:26.248312 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'runnable_timing', 'label': '26c2828f-18be-478f-80d5-fd8f7a79a81a', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000017D3D1FF6E0>]}
[0m19:16:26.248312 [debug] [MainThread]: On master: COMMIT
[0m19:16:26.248312 [debug] [Thread-1 (]: Began running node seed.chinook.Customer
[0m19:16:26.248312 [info ] [Thread-1 (]: 1 of 1 START seed file data_raw.Customer ....................................... [RUN]
[0m19:16:26.248312 [debug] [Thread-1 (]: Acquiring new fabric connection 'seed.chinook.Customer'
[0m19:16:26.248312 [debug] [Thread-1 (]: Began compiling node seed.chinook.Customer
[0m19:16:26.248312 [debug] [Thread-1 (]: Began executing node seed.chinook.Customer
[0m19:16:26.274209 [debug] [Thread-1 (]: Compilation Error in seed Customer (seeds\Customer.csv)
  Row 0 has 462 values, but Table only has 13 columns.
  
  > in macro materialization_seed_default (macros\materializations\seeds\seed.sql)
  > called by seed Customer (seeds\Customer.csv)
[0m19:16:26.274209 [debug] [Thread-1 (]: Sending event: {'category': 'dbt', 'action': 'run_model', 'label': '26c2828f-18be-478f-80d5-fd8f7a79a81a', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000017D3DE22F30>]}
[0m19:16:26.274209 [error] [Thread-1 (]: 1 of 1 ERROR loading seed file data_raw.Customer ............................... [[31mERROR[0m in 0.03s]
[0m19:16:26.274209 [debug] [Thread-1 (]: Finished running node seed.chinook.Customer
[0m19:16:26.274209 [debug] [Thread-7 (]: Marking all children of 'seed.chinook.Customer' to be skipped because of status 'error'.  Reason: Compilation Error in seed Customer (seeds\Customer.csv)
  Row 0 has 462 values, but Table only has 13 columns.
  
  > in macro materialization_seed_default (macros\materializations\seeds\seed.sql)
  > called by seed Customer (seeds\Customer.csv).
[0m19:16:26.274209 [debug] [MainThread]: On master: COMMIT
[0m19:16:26.274209 [debug] [MainThread]: Connection 'master' was properly closed.
[0m19:16:26.274209 [debug] [MainThread]: Connection 'list_ws_ssc_articles' was properly closed.
[0m19:16:26.289892 [debug] [MainThread]: Connection 'list_ws_ssc_articles_data' was properly closed.
[0m19:16:26.289892 [debug] [MainThread]: Connection 'list_ws_ssc_articles_data_raw' was properly closed.
[0m19:16:26.289892 [debug] [MainThread]: Connection 'seed.chinook.Customer' was properly closed.
[0m19:16:26.289892 [info ] [MainThread]: 
[0m19:16:26.291125 [info ] [MainThread]: Finished running 1 seed in 0 hours 0 minutes and 2.53 seconds (2.53s).
[0m19:16:26.292122 [debug] [MainThread]: Command end result
[0m19:16:26.313374 [debug] [MainThread]: Wrote artifact WritableManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\chinook\target\manifest.json
[0m19:16:26.313374 [debug] [MainThread]: Wrote artifact SemanticManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\chinook\target\semantic_manifest.json
[0m19:16:26.313374 [debug] [MainThread]: Wrote artifact RunExecutionResult to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\chinook\target\run_results.json
[0m19:16:26.313374 [info ] [MainThread]: 
[0m19:16:26.313374 [info ] [MainThread]: [31mCompleted with 1 error, 0 partial successes, and 0 warnings:[0m
[0m19:16:26.313374 [info ] [MainThread]: 
[0m19:16:26.323185 [error] [MainThread]: [31mFailure in seed Customer (seeds\Customer.csv)[0m
[0m19:16:26.323185 [error] [MainThread]:   Compilation Error in seed Customer (seeds\Customer.csv)
  Row 0 has 462 values, but Table only has 13 columns.
  
  > in macro materialization_seed_default (macros\materializations\seeds\seed.sql)
  > called by seed Customer (seeds\Customer.csv)
[0m19:16:26.324194 [info ] [MainThread]: 
[0m19:16:26.324194 [info ] [MainThread]: Done. PASS=0 WARN=0 ERROR=1 SKIP=0 NO-OP=0 TOTAL=1
[0m19:16:26.326137 [debug] [MainThread]: Command `dbt seed` failed at 19:16:26.326137 after 4.00 seconds
[0m19:16:26.326137 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'end', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000017D37722510>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000017D3D9BC2C0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000017D3B52A780>]}
[0m19:16:26.327200 [debug] [MainThread]: Flushing usage events
[0m19:16:26.583579 [debug] [MainThread]: An error was encountered while trying to flush usage events
[0m20:01:02.456105 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'start', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000027D1B6CC380>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000027D19E26270>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000027D19976360>]}


============================== 20:01:02.458595 | 77abb159-713f-46cb-80de-15210ffe2bc9 ==============================
[0m20:01:02.458595 [info ] [MainThread]: Running with dbt=1.10.16
[0m20:01:02.458595 [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', 'profiles_dir': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\chinook', 'send_anonymous_usage_stats': 'True', 'quiet': 'False', 'warn_error': 'None', 'partial_parse': 'True', '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\\chinook\\logs'}
[0m20:01:02.479815 [info ] [MainThread]: dbt version: 1.10.16
[0m20:01:02.479815 [info ] [MainThread]: python version: 3.12.7
[0m20:01:02.479815 [info ] [MainThread]: python path: C:\ProgramData\anaconda3\python.exe
[0m20:01:02.479815 [info ] [MainThread]: os info: Windows-11-10.0.26100-SP0
[0m20:01:02.829905 [info ] [MainThread]: Using profiles dir at C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\chinook
[0m20:01:02.829905 [info ] [MainThread]: Using profiles.yml file at C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\chinook\profiles.yml
[0m20:01:02.829905 [info ] [MainThread]: Using dbt_project.yml file at C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\chinook\dbt_project.yml
[0m20:01:02.829905 [info ] [MainThread]: adapter type: fabric
[0m20:01:02.829905 [info ] [MainThread]: adapter version: 1.9.8
[0m20:01:02.909357 [info ] [MainThread]: Configuration:
[0m20:01:02.909357 [info ] [MainThread]:   profiles.yml file [[32mOK found and valid[0m]
[0m20:01:02.909357 [info ] [MainThread]:   dbt_project.yml file [[32mOK found and valid[0m]
[0m20:01:02.909357 [info ] [MainThread]: Required dependencies:
[0m20:01:02.909357 [debug] [MainThread]: Executing "git --help"
[0m20:01:02.991952 [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:01:02.992684 [debug] [MainThread]: STDERR: "b''"
[0m20:01:02.992684 [info ] [MainThread]:  - git [[32mOK found[0m]

[0m20:01:02.993805 [info ] [MainThread]: Connection:
[0m20:01:02.993805 [info ] [MainThread]:   server: abgrhetr4hsurajv2abiablt4q-s2kupy7y6b7utpgtkqubc35a5i.datawarehouse.fabric.microsoft.com
[0m20:01:02.994795 [info ] [MainThread]:   database: ws_ssc_articles
[0m20:01:02.994795 [info ] [MainThread]:   schema: data
[0m20:01:02.995805 [info ] [MainThread]:   warehouse_snapshot_name: None
[0m20:01:02.995805 [info ] [MainThread]:   snapshot_timestamp: None
[0m20:01:02.996790 [info ] [MainThread]:   UID: None
[0m20:01:02.996790 [info ] [MainThread]:   workspace_id: None
[0m20:01:02.996790 [info ] [MainThread]:   authentication: ActiveDirectoryServicePrincipal
[0m20:01:02.997791 [info ] [MainThread]:   retries: 3
[0m20:01:02.997791 [info ] [MainThread]:   login_timeout: 0
[0m20:01:02.997791 [info ] [MainThread]:   query_timeout: 0
[0m20:01:02.998766 [info ] [MainThread]:   trace_flag: False
[0m20:01:02.998766 [info ] [MainThread]:   encrypt: True
[0m20:01:02.999761 [info ] [MainThread]:   trust_cert: False
[0m20:01:02.999761 [info ] [MainThread]:   api_url: https://api.fabric.microsoft.com/v1
[0m20:01:03.000787 [info ] [MainThread]: Registered adapter: fabric=1.9.8
[0m20:01:03.188666 [debug] [MainThread]: Acquiring new fabric connection 'debug'
[0m20:01:03.188666 [debug] [MainThread]: Using fabric connection "debug"
[0m20:01:03.188666 [debug] [MainThread]: On debug: select 1 as id
[0m20:01:03.188666 [debug] [MainThread]: Opening a new connection, currently in state init
[0m20:01:03.188666 [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=ActiveDirectoryServicePrincipal;UID={236fff28-f19b-47b8-8aca-31183d8eeb8c};PWD=***;encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:01:07.740823 [debug] [MainThread]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:01:07.791686 [debug] [MainThread]: SQL status: OK in 5.000 seconds
[0m20:01:07.793218 [debug] [MainThread]: On debug: Close
[0m20:01:07.793218 [info ] [MainThread]:   Connection test: [[32mOK connection ok[0m]

[0m20:01:07.793218 [info ] [MainThread]: [32mAll checks passed![0m
[0m20:01:07.793218 [debug] [MainThread]: Command `dbt debug` succeeded at 20:01:07.793218 after 5.60 seconds
[0m20:01:07.793218 [debug] [MainThread]: Connection 'debug' was properly closed.
[0m20:01:07.793218 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'end', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000027D1C2F72F0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000027D1BF07020>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000027D19E8E720>]}
[0m20:01:07.793218 [debug] [MainThread]: Flushing usage events
[0m20:01:08.069886 [debug] [MainThread]: An error was encountered while trying to flush usage events
[0m20:01:20.447319 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'start', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002775D0F40E0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002775F73E3C0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002775D56F7A0>]}


============================== 20:01:20.454082 | 71331081-bee8-468f-a00d-1ad14c688296 ==============================
[0m20:01:20.454082 [info ] [MainThread]: Running with dbt=1.10.16
[0m20:01:20.454082 [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', '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\\chinook', 'invocation_command': 'dbt seed --select Customer', 'use_colors': 'True', 'indirect_selection': 'eager', 'use_experimental_parser': 'False', 'log_path': 'C:\\Users\\jminer\\OneDrive - Insight\\Desktop\\Bin\\SSC\\SSC - Article 32\\chinook\\logs'}
[0m20:01:20.907814 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'project_id', 'label': '71331081-bee8-468f-a00d-1ad14c688296', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000027761AFC500>]}
[0m20:01:20.956018 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'adapter_info', 'label': '71331081-bee8-468f-a00d-1ad14c688296', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000027761829BB0>]}
[0m20:01:20.956018 [info ] [MainThread]: Registered adapter: fabric=1.9.8
[0m20:01:21.149191 [debug] [MainThread]: checksum: c4b99e2e3bb042c661c8397fd92290cd0d52b31ce393ad721fa0bb3c9591dd0f, vars: {}, profile: , target: , version: 1.10.16
[0m20:01:21.742622 [debug] [MainThread]: Partial parsing enabled: 0 files deleted, 0 files added, 1 files changed.
[0m20:01:21.750631 [debug] [MainThread]: Partial parsing: updated file: chinook://seeds\Customer.csv
[0m20:01:21.926652 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'load_project', 'label': '71331081-bee8-468f-a00d-1ad14c688296', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000277623FFB00>]}
[0m20:01:22.026120 [debug] [MainThread]: Wrote artifact WritableManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\chinook\target\manifest.json
[0m20:01:22.026120 [debug] [MainThread]: Wrote artifact SemanticManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\chinook\target\semantic_manifest.json
[0m20:01:22.059170 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'resource_counts', 'label': '71331081-bee8-468f-a00d-1ad14c688296', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000277622AFE60>]}
[0m20:01:22.059170 [info ] [MainThread]: Found 2 models, 11 seeds, 4 data tests, 500 macros
[0m20:01:22.059170 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'runnable_timing', 'label': '71331081-bee8-468f-a00d-1ad14c688296', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000277622B82C0>]}
[0m20:01:22.059170 [info ] [MainThread]: 
[0m20:01:22.059170 [info ] [MainThread]: Concurrency: 4 threads (target='fabric-dev')
[0m20:01:22.059170 [info ] [MainThread]: 
[0m20:01:22.059170 [debug] [MainThread]: Acquiring new fabric connection 'master'
[0m20:01:22.059170 [debug] [ThreadPool]: Acquiring new fabric connection 'list_ws_ssc_articles'
[0m20:01:22.081263 [debug] [ThreadPool]: dbt-fabric
[0m20:01:22.081263 [debug] [ThreadPool]: Using fabric connection "list_ws_ssc_articles"
[0m20:01:22.081263 [debug] [ThreadPool]: On list_ws_ssc_articles: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "chinook", "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:01:22.081263 [debug] [ThreadPool]: Opening a new connection, currently in state init
[0m20:01:22.081263 [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=ActiveDirectoryServicePrincipal;UID={236fff28-f19b-47b8-8aca-31183d8eeb8c};PWD=***;encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:01:23.381455 [debug] [ThreadPool]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:01:23.425873 [debug] [ThreadPool]: SQL status: OK in 1.000 seconds
[0m20:01:23.428572 [debug] [ThreadPool]: On list_ws_ssc_articles: Close
[0m20:01:23.430584 [debug] [ThreadPool]: Acquiring new fabric connection 'list_ws_ssc_articles_data'
[0m20:01:23.441893 [debug] [ThreadPool]: dbt-fabric
[0m20:01:23.441893 [debug] [ThreadPool]: Using fabric connection "list_ws_ssc_articles_data"
[0m20:01:23.441893 [debug] [ThreadPool]: On list_ws_ssc_articles_data: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "chinook", "target_name": "fabric-dev", "connection_name": "list_ws_ssc_articles_data"} */
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 'data'
    
    OPTION (LABEL = 'dbt-fabric-dw');

  
[0m20:01:23.441893 [debug] [ThreadPool]: Opening a new connection, currently in state init
[0m20:01:23.443900 [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=ActiveDirectoryServicePrincipal;UID={236fff28-f19b-47b8-8aca-31183d8eeb8c};PWD=***;encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:01:23.443900 [debug] [ThreadPool]: Acquiring new fabric connection 'list_ws_ssc_articles_data_raw'
[0m20:01:23.443900 [debug] [ThreadPool]: dbt-fabric
[0m20:01:23.443900 [debug] [ThreadPool]: Using fabric connection "list_ws_ssc_articles_data_raw"
[0m20:01:23.443900 [debug] [ThreadPool]: On list_ws_ssc_articles_data_raw: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "chinook", "target_name": "fabric-dev", "connection_name": "list_ws_ssc_articles_data_raw"} */
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 'data_raw'
    
    OPTION (LABEL = 'dbt-fabric-dw');

  
[0m20:01:23.443900 [debug] [ThreadPool]: Opening a new connection, currently in state init
[0m20:01:23.443900 [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=ActiveDirectoryServicePrincipal;UID={236fff28-f19b-47b8-8aca-31183d8eeb8c};PWD=***;encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:01:23.958433 [debug] [ThreadPool]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:01:24.052072 [debug] [ThreadPool]: SQL status: OK in 1.000 seconds
[0m20:01:24.054095 [debug] [ThreadPool]: On list_ws_ssc_articles_data: ROLLBACK
[0m20:01:24.055610 [debug] [ThreadPool]: On list_ws_ssc_articles_data: Close
[0m20:01:24.315055 [debug] [ThreadPool]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:01:24.426678 [debug] [ThreadPool]: SQL status: OK in 1.000 seconds
[0m20:01:24.426678 [debug] [ThreadPool]: On list_ws_ssc_articles_data_raw: ROLLBACK
[0m20:01:24.426678 [debug] [ThreadPool]: On list_ws_ssc_articles_data_raw: Close
[0m20:01:24.440432 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'runnable_timing', 'label': '71331081-bee8-468f-a00d-1ad14c688296', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002776237AFF0>]}
[0m20:01:24.442543 [debug] [MainThread]: On master: COMMIT
[0m20:01:24.442543 [debug] [Thread-1 (]: Began running node seed.chinook.Customer
[0m20:01:24.442543 [info ] [Thread-1 (]: 1 of 1 START seed file data_raw.Customer ....................................... [RUN]
[0m20:01:24.442543 [debug] [Thread-1 (]: Acquiring new fabric connection 'seed.chinook.Customer'
[0m20:01:24.442543 [debug] [Thread-1 (]: Began compiling node seed.chinook.Customer
[0m20:01:24.442543 [debug] [Thread-1 (]: Began executing node seed.chinook.Customer
[0m20:01:24.475711 [debug] [Thread-1 (]: Using fabric connection "seed.chinook.Customer"
[0m20:01:24.475711 [debug] [Thread-1 (]: On seed.chinook.Customer: /* {"app": "dbt", "dbt_version": "1.10.16", "profile_name": "chinook", "target_name": "fabric-dev", "node_id": "seed.chinook.Customer"} */

    create table "ws_ssc_articles"."data_raw"."Customer" ("CustomerId" int,"FirstName" varchar(16),"LastName" varchar(16),"Company" varchar(49),"Address" varchar(41),"City" varchar(21),"State" varchar(16),"Country" varchar(16),"PostalCode" varchar(16),"Phone" varchar(19),"Fax" varchar(18),"Email" varchar(29),"SupportRepId" int)
  
[0m20:01:24.476724 [debug] [Thread-1 (]: Opening a new connection, currently in state init
[0m20:01:24.476724 [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=ActiveDirectoryServicePrincipal;UID={236fff28-f19b-47b8-8aca-31183d8eeb8c};PWD=***;encrypt=Yes;TrustServerCertificate=No;APP=dbt-fabric/1.9.8;ConnectRetryCount=3;ConnectRetryInterval=10
[0m20:01:24.476724 [debug] [Thread-1 (]: fabric adapter: Connected to db: ws_ssc_articles
[0m20:01:26.853180 [debug] [Thread-1 (]: SQL status: OK in 2.000 seconds
[0m20:01:26.869283 [debug] [Thread-1 (]: Inserting batches of 160 records
[0m20:01:26.932889 [debug] [Thread-1 (]: dbt-fabric
[0m20:01:26.932889 [debug] [Thread-1 (]: Using fabric connection "seed.chinook.Customer"
[0m20:01:26.932889 [debug] [Thread-1 (]: On seed.chinook.Customer: 
            insert into "ws_ssc_articles"."data_raw"."Customer" ("CustomerId", "FirstName", "LastName", "Company", "Address", "City", "State", "Country", "PostalCode", "Phone", "Fax", "Email", "SupportRepId") values
            (?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?),(?,?,?,?,?,?,?,?,?,?,?,?,?),(?,...
[0m20:01:30.634214 [debug] [Thread-1 (]: SQL status: OK in 4.000 seconds
[0m20:01:30.682080 [debug] [Thread-1 (]: Writing runtime SQL for node "seed.chinook.Customer"
[0m20:01:30.698060 [debug] [Thread-1 (]: On seed.chinook.Customer: COMMIT
[0m20:01:30.698060 [debug] [Thread-1 (]: On seed.chinook.Customer: Close
[0m20:01:30.698060 [debug] [Thread-1 (]: Sending event: {'category': 'dbt', 'action': 'run_model', 'label': '71331081-bee8-468f-a00d-1ad14c688296', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000277622A7A40>]}
[0m20:01:30.698060 [info ] [Thread-1 (]: 1 of 1 OK loaded seed file data_raw.Customer ................................... [[32mINSERT 59[0m in 6.26s]
[0m20:01:30.698060 [debug] [Thread-1 (]: Finished running node seed.chinook.Customer
[0m20:01:30.698060 [debug] [MainThread]: On master: COMMIT
[0m20:01:30.698060 [debug] [MainThread]: Connection 'master' was properly closed.
[0m20:01:30.698060 [debug] [MainThread]: Connection 'list_ws_ssc_articles' was properly closed.
[0m20:01:30.698060 [debug] [MainThread]: Connection 'list_ws_ssc_articles_data' was properly closed.
[0m20:01:30.698060 [debug] [MainThread]: Connection 'list_ws_ssc_articles_data_raw' was properly closed.
[0m20:01:30.698060 [debug] [MainThread]: Connection 'seed.chinook.Customer' was properly closed.
[0m20:01:30.698060 [info ] [MainThread]: 
[0m20:01:30.698060 [info ] [MainThread]: Finished running 1 seed in 0 hours 0 minutes and 8.64 seconds (8.64s).
[0m20:01:30.698060 [debug] [MainThread]: Command end result
[0m20:01:30.730881 [debug] [MainThread]: Wrote artifact WritableManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\chinook\target\manifest.json
[0m20:01:30.734358 [debug] [MainThread]: Wrote artifact SemanticManifest to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\chinook\target\semantic_manifest.json
[0m20:01:30.736403 [debug] [MainThread]: Wrote artifact RunExecutionResult to C:\Users\jminer\OneDrive - Insight\Desktop\Bin\SSC\SSC - Article 32\chinook\target\run_results.json
[0m20:01:30.736403 [info ] [MainThread]: 
[0m20:01:30.736403 [info ] [MainThread]: [32mCompleted successfully[0m
[0m20:01:30.736403 [info ] [MainThread]: 
[0m20:01:30.736403 [info ] [MainThread]: Done. PASS=1 WARN=0 ERROR=0 SKIP=0 NO-OP=0 TOTAL=1
[0m20:01:30.742403 [debug] [MainThread]: Command `dbt seed` succeeded at 20:01:30.742403 after 10.45 seconds
[0m20:01:30.743411 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'end', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002775D051B50>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002775FCCD1C0>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002775ECAAEA0>]}
[0m20:01:30.743411 [debug] [MainThread]: Flushing usage events
[0m20:01:30.851077 [debug] [MainThread]: An error was encountered while trying to flush usage events
