search

opensource-observer / oso

Measuring the impact of open source software
https://opensource.observer
Apache License 2.0
73 stars 16 forks source link

add: github repo `dependencies` dlt asset #2397

Closed Jabolol closed 4 weeks ago

Jabolol commented 4 weeks ago

This PR closes #2363 by adding two new Dagster assets: ossd/sbom and ossd/missing_sbom. Both are dependencies of ossd/repositories, with missing_sbom also introducing a new staging model, stg_ossd__missing_sbom. This model is a view that pulls the latest repositories without an SBOM, so we can notify maintainers to submit one. They can follow GitHub's guide to do that.

It also includes some cleanup in the github_repos dlt source to make things more reusable and reduce duplicate logic.

vercel[bot] commented 4 weeks ago

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name Status Preview Comments Updated (UTC)
kariba-network ✅ Ready (Inspect) Visit Preview 💬 Add feedback Oct 24, 2024 7:01pm
oso-www ✅ Ready (Inspect) Visit Preview 💬 Add feedback Oct 24, 2024 7:01pm
oso-prs[bot] commented 4 weeks ago

Test deployment for PR #2397 failed on commit 2e3061e2c766f4b1d41ae3041a02cb7fdd91adb3. With error:

Error stack:

Error: Command failed: /home/runner/work/oso/oso/ops/external-prs/pr-clone/.venv/bin/dbt run --no-use-colors

    at genericNodeError (node:internal/errors:984:15)
    at wrappedFn (node:internal/errors:538:14)
    at ChildProcess.exithandler (node:child_process:422:12)
    at ChildProcess.emit (node:events:519:28)
    at ChildProcess.emit (node:domain:488:12)
    at maybeClose (node:internal/child_process:1105:16)
    at Socket.<anonymous> (node:internal/child_process:457:11)
    at Socket.emit (node:events:519:28)
    at Socket.emit (node:domain:488:12)
    at Pipe.<anonymous> (node:net:339:12)

DBT stdout:

19:00:24  Running with dbt=1.8.6
19:00:28  Registered adapter: bigquery=1.8.2
19:00:28  Unable to do partial parsing because saved manifest not found. Starting full parse.
19:00:31  Found 237 models, 128 sources, 503 macros
19:00:31  
19:00:32  Concurrency: 32 threads (target='playground')
19:00:32  
19:00:32  1 of 235 START sql view model pr_2397.int_time_intervals ....................... [RUN]
19:00:32  2 of 235 START sql table model pr_2397.rf4_repos_by_app ........................ [RUN]
19:00:32  3 of 235 START sql incremental model pr_2397.rf4_transactions_window ........... [RUN]
19:00:32  4 of 235 START sql incremental model pr_2397.stg_arbitrum_one__deployers ....... [RUN]
19:00:32  5 of 235 START sql incremental model pr_2397.stg_arbitrum_one__factories ....... [RUN]
19:00:32  6 of 235 START sql incremental model pr_2397.stg_arbitrum_one__proxies ......... [RUN]
19:00:32  7 of 235 START sql incremental model pr_2397.stg_base__deployers ............... [RUN]
19:00:32  8 of 235 START sql incremental model pr_2397.stg_base__factories ............... [RUN]
19:00:32  9 of 235 START sql incremental model pr_2397.stg_base__first_time_addresses .... [RUN]
19:00:32  10 of 235 START sql table model pr_2397.stg_base__potential_bots ............... [RUN]
19:00:32  11 of 235 START sql incremental model pr_2397.stg_base__proxies ................ [RUN]
19:00:32  12 of 235 START sql incremental model pr_2397.stg_deps_dev__dependencies ....... [RUN]
19:00:32  13 of 235 START sql incremental model pr_2397.stg_ethereum__deployers .......... [RUN]
19:00:32  14 of 235 START sql view model pr_2397.stg_ethereum_attestation_service__optimism  [RUN]
19:00:32  15 of 235 START sql view model pr_2397.stg_farcaster__addresses ................ [RUN]
19:00:32  16 of 235 START sql view model pr_2397.stg_farcaster__profiles ................. [RUN]
19:00:32  17 of 235 START sql incremental model pr_2397.stg_frax__deployers .............. [RUN]
19:00:32  18 of 235 START sql incremental model pr_2397.stg_frax__factories .............. [RUN]
19:00:32  19 of 235 START sql incremental model pr_2397.stg_frax__first_time_addresses ... [RUN]
19:00:32  20 of 235 START sql table model pr_2397.stg_frax__potential_bots ............... [RUN]
19:00:32  21 of 235 START sql incremental model pr_2397.stg_frax__proxies ................ [RUN]
19:00:32  22 of 235 START sql view model pr_2397.stg_gitcoin__donations .................. [RUN]
19:00:32  23 of 235 START sql view model pr_2397.stg_gitcoin__matching ................... [RUN]
19:00:32  24 of 235 START sql view model pr_2397.stg_gitcoin__project_groups ............. [RUN]
19:00:32  25 of 235 START sql view model pr_2397.stg_gitcoin__project_lookup ............. [RUN]
19:00:32  26 of 235 START sql table model pr_2397.stg_karma3__globaltrust ................ [RUN]
19:00:32  27 of 235 START sql table model pr_2397.stg_karma3__localtrust ................. [RUN]
19:00:32  28 of 235 START sql view model pr_2397.stg_lens__owners ........................ [RUN]
19:00:32  29 of 235 START sql view model pr_2397.stg_lens__profiles ...................... [RUN]
19:00:32  30 of 235 START sql incremental model pr_2397.stg_metal__deployers ............. [RUN]
19:00:32  31 of 235 START sql incremental model pr_2397.stg_metal__factories ............. [RUN]
19:00:32  32 of 235 START sql incremental model pr_2397.stg_metal__first_time_addresses .. [RUN]
19:00:34  16 of 235 OK created sql view model pr_2397.stg_farcaster__profiles ............ [CREATE VIEW (0 processed) in 2.52s]
19:00:34  33 of 235 START sql table model pr_2397.stg_metal__potential_bots .............. [RUN]
19:00:34  29 of 235 OK created sql view model pr_2397.stg_lens__profiles ................. [CREATE VIEW (0 processed) in 2.56s]
19:00:34  34 of 235 START sql incremental model pr_2397.stg_metal__proxies ............... [RUN]
19:00:34  25 of 235 OK created sql view model pr_2397.stg_gitcoin__project_lookup ........ [CREATE VIEW (0 processed) in 2.58s]
19:00:34  35 of 235 START sql incremental model pr_2397.stg_mode__deployers .............. [RUN]
19:00:34  22 of 235 OK created sql view model pr_2397.stg_gitcoin__donations ............. [CREATE VIEW (0 processed) in 2.65s]
19:00:35  14 of 235 OK created sql view model pr_2397.stg_ethereum_attestation_service__optimism  [CREATE VIEW (0 processed) in 2.66s]
19:00:35  23 of 235 OK created sql view model pr_2397.stg_gitcoin__matching .............. [CREATE VIEW (0 processed) in 2.65s]
19:00:35  28 of 235 OK created sql view model pr_2397.stg_lens__owners ................... [CREATE VIEW (0 processed) in 2.69s]
19:00:35  24 of 235 OK created sql view model pr_2397.stg_gitcoin__project_groups ........ [CREATE VIEW (0 processed) in 2.69s]
19:00:35  36 of 235 START sql incremental model pr_2397.stg_mode__factories .............. [RUN]
19:00:35  37 of 235 START sql incremental model pr_2397.stg_mode__first_time_addresses ... [RUN]
19:00:35  38 of 235 START sql table model pr_2397.stg_mode__potential_bots ............... [RUN]
19:00:35  39 of 235 START sql incremental model pr_2397.stg_mode__proxies ................ [RUN]
19:00:35  40 of 235 START sql view model pr_2397.stg_open_collective__deposits ........... [RUN]
19:00:35  15 of 235 OK created sql view model pr_2397.stg_farcaster__addresses ........... [CREATE VIEW (0 processed) in 2.76s]
19:00:35  41 of 235 START sql view model pr_2397.stg_open_collective__expenses ........... [RUN]
19:00:35  1 of 235 OK created sql view model pr_2397.int_time_intervals .................. [CREATE VIEW (0 processed) in 3.51s]
19:00:35  42 of 235 START sql table model pr_2397.stg_optimism__airdrop_addresses ........ [RUN]
19:00:36  40 of 235 OK created sql view model pr_2397.stg_open_collective__deposits ...... [CREATE VIEW (0 processed) in 1.09s]
19:00:36  43 of 235 START sql incremental model pr_2397.stg_optimism__deployers .......... [RUN]
19:00:36  4 of 235 OK created sql incremental model pr_2397.stg_arbitrum_one__deployers .. [CREATE TABLE (0.0 rows, 0 processed) in 4.01s]
19:00:36  44 of 235 START sql incremental model pr_2397.stg_optimism__factories .......... [RUN]
19:00:36  41 of 235 OK created sql view model pr_2397.stg_open_collective__expenses ...... [CREATE VIEW (0 processed) in 1.12s]
19:00:36  45 of 235 START sql incremental model pr_2397.stg_optimism__first_time_addresses  [RUN]
19:00:36  2 of 235 OK created sql table model pr_2397.rf4_repos_by_app ................... [CREATE TABLE (821.0 rows, 705.0 KiB processed) in 4.25s]
19:00:36  46 of 235 START sql table model pr_2397.stg_optimism__potential_bots ........... [RUN]
19:00:37  7 of 235 OK created sql incremental model pr_2397.stg_base__deployers .......... [CREATE TABLE (0.0 rows, 0 processed) in 4.76s]
19:00:37  47 of 235 START sql incremental model pr_2397.stg_optimism__proxies ............ [RUN]
19:00:37  12 of 235 OK created sql incremental model pr_2397.stg_deps_dev__dependencies .. [CREATE TABLE (1.0 rows, 0 processed) in 4.93s]
19:00:37  48 of 235 START sql view model pr_2397.stg_ossd__current_collections ........... [RUN]
19:00:37  20 of 235 OK created sql table model pr_2397.stg_frax__potential_bots .......... [CREATE TABLE (0.0 rows, 0 processed) in 4.98s]
19:00:37  49 of 235 START sql view model pr_2397.stg_ossd__current_projects .............. [RUN]
19:00:37  30 of 235 OK created sql incremental model pr_2397.stg_metal__deployers ........ [CREATE TABLE (0.0 rows, 0 processed) in 5.02s]
19:00:37  31 of 235 OK created sql incremental model pr_2397.stg_metal__factories ........ [CREATE TABLE (0.0 rows, 0 processed) in 5.02s]
19:00:37  50 of 235 START sql view model pr_2397.stg_ossd__current_repositories .......... [RUN]
19:00:37  51 of 235 START sql view model pr_2397.stg_ossd__missing_sbom .................. [RUN]
19:00:37  19 of 235 OK created sql incremental model pr_2397.stg_frax__first_time_addresses  [CREATE TABLE (0.0 rows, 0 processed) in 5.15s]
19:00:37  5 of 235 OK created sql incremental model pr_2397.stg_arbitrum_one__factories .. [CREATE TABLE (0.0 rows, 0 processed) in 5.19s]
19:00:37  52 of 235 START sql view model pr_2397.stg_passport__scores .................... [RUN]
19:00:37  53 of 235 START sql incremental model pr_2397.stg_pgn__deployers ............... [RUN]
19:00:39  32 of 235 OK created sql incremental model pr_2397.stg_metal__first_time_addresses  [CREATE TABLE (0.0 rows, 0 processed) in 5.14s]
19:00:39  18 of 235 OK created sql incremental model pr_2397.stg_frax__factories ......... [CREATE TABLE (0.0 rows, 0 processed) in 5.28s]
19:00:39  9 of 235 OK created sql incremental model pr_2397.stg_base__first_time_addresses  [CREATE TABLE (0.0 rows, 0 processed) in 5.35s]
19:00:39  6 of 235 OK created sql incremental model pr_2397.stg_arbitrum_one__proxies .... [CREATE TABLE (0.0 rows, 0 processed) in 5.38s]
19:00:39  21 of 235 OK created sql incremental model pr_2397.stg_frax__proxies ........... [CREATE TABLE (0.0 rows, 0 processed) in 5.51s]
19:00:39  8 of 235 OK created sql incremental model pr_2397.stg_base__factories .......... [CREATE TABLE (0.0 rows, 0 processed) in 5.57s]
19:00:39  51 of 235 ERROR creating sql view model pr_2397.stg_ossd__missing_sbom ......... [ERROR in 0.53s]
19:00:39  33 of 235 OK created sql table model pr_2397.stg_metal__potential_bots ......... [CREATE TABLE (0.0 rows, 0 processed) in 3.31s]
19:00:39  48 of 235 OK created sql view model pr_2397.stg_ossd__current_collections ...... [CREATE VIEW (0 processed) in 1.12s]
19:00:39  11 of 235 OK created sql incremental model pr_2397.stg_base__proxies ........... [CREATE TABLE (0.0 rows, 0 processed) in 6.12s]
19:00:39  17 of 235 OK created sql incremental model pr_2397.stg_frax__deployers ......... [CREATE TABLE (0.0 rows, 0 processed) in 6.15s]
19:00:39  52 of 235 OK created sql view model pr_2397.stg_passport__scores ............... [CREATE VIEW (0 processed) in 0.99s]
19:00:39  50 of 235 OK created sql view model pr_2397.stg_ossd__current_repositories ..... [CREATE VIEW (0 processed) in 1.11s]
19:00:39  35 of 235 OK created sql incremental model pr_2397.stg_mode__deployers ......... [CREATE TABLE (0.0 rows, 0 processed) in 3.92s]
19:00:39  43 of 235 OK created sql incremental model pr_2397.stg_optimism__deployers ..... [CREATE TABLE (0.0 rows, 0 processed) in 2.95s]
19:00:39  34 of 235 OK created sql incremental model pr_2397.stg_metal__proxies .......... [CREATE TABLE (0.0 rows, 0 processed) in 4.30s]
19:00:39  38 of 235 OK created sql table model pr_2397.stg_mode__potential_bots .......... [CREATE TABLE (14.0 rows, 4.9 MiB processed) in 4.37s]
19:00:39  54 of 235 START sql incremental model pr_2397.stg_pgn__factories ............... [RUN]
19:00:39  49 of 235 OK created sql view model pr_2397.stg_ossd__current_projects ......... [CREATE VIEW (0 processed) in 2.16s]
19:00:39  37 of 235 OK created sql incremental model pr_2397.stg_mode__first_time_addresses  [CREATE TABLE (0.0 rows, 0 processed) in 4.69s]
19:00:39  36 of 235 OK created sql incremental model pr_2397.stg_mode__factories ......... [CREATE TABLE (0.0 rows, 0 processed) in 4.76s]
19:00:39  55 of 235 START sql incremental model pr_2397.stg_pgn__first_time_addresses .... [RUN]
19:00:39  56 of 235 START sql table model pr_2397.stg_pgn__potential_bots ................ [RUN]
19:00:39  57 of 235 START sql incremental model pr_2397.stg_pgn__proxies ................. [RUN]
19:00:39  58 of 235 START sql table model pr_2397.stg_utility__calendar .................. [RUN]
19:00:39  59 of 235 START sql incremental model pr_2397.stg_zora__deployers .............. [RUN]
19:00:39  60 of 235 START sql incremental model pr_2397.stg_zora__factories .............. [RUN]
19:00:39  61 of 235 START sql incremental model pr_2397.stg_zora__first_time_addresses ... [RUN]
19:00:39  62 of 235 START sql table model pr_2397.stg_zora__potential_bots ............... [RUN]
19:00:39  63 of 235 START sql incremental model pr_2397.stg_zora__proxies ................ [RUN]
19:00:39  64 of 235 START sql view model pr_2397.int_users ............................... [RUN]
19:00:39  65 of 235 START sql view model pr_2397.int_gitcoin_funding_events .............. [RUN]
19:00:39  66 of 235 START sql view model pr_2397.stg_open_collective__events ............. [RUN]
19:00:39  67 of 235 START sql view model pr_2397.int_events_dependencies ................. [RUN]
19:00:39  68 of 235 START sql view model pr_2397.int_collections ......................... [RUN]
19:00:39  69 of 235 START sql incremental model pr_2397.stg_github__events ............... [RUN]
19:00:39  71 of 235 START sql view model pr_2397.int_projects ............................ [RUN]
19:00:39  70 of 235 START sql view model pr_2397.int_artifacts_in_ossd_by_project ........ [RUN]
19:00:40  72 of 235 START sql view model pr_2397.int_projects_by_collection .............. [RUN]
19:00:40  45 of 235 OK created sql incremental model pr_2397.stg_optimism__first_time_addresses  [CREATE TABLE (0.0 rows, 0 processed) in 3.57s]
19:00:40  44 of 235 OK created sql incremental model pr_2397.stg_optimism__factories ..... [CREATE TABLE (0.0 rows, 0 processed) in 4.09s]
19:00:40  53 of 235 OK created sql incremental model pr_2397.stg_pgn__deployers .......... [CREATE TABLE (0.0 rows, 0 processed) in 2.94s]
19:00:40  39 of 235 OK created sql incremental model pr_2397.stg_mode__proxies ........... [CREATE TABLE (0.0 rows, 0 processed) in 5.44s]
19:00:40  47 of 235 OK created sql incremental model pr_2397.stg_optimism__proxies ....... [CREATE TABLE (0.0 rows, 0 processed) in 3.42s]
19:00:41  42 of 235 OK created sql table model pr_2397.stg_optimism__airdrop_addresses ... [CREATE TABLE (611.5k rows, 38.6 MiB processed) in 5.45s]
19:00:41  67 of 235 OK created sql view model pr_2397.int_events_dependencies ............ [CREATE VIEW (0 processed) in 1.85s]
19:00:41  71 of 235 OK created sql view model pr_2397.int_projects ....................... [CREATE VIEW (0 processed) in 1.91s]
19:00:41  73 of 235 START sql table model pr_2397.projects_v1 ............................ [RUN]
19:00:41  70 of 235 OK created sql view model pr_2397.int_artifacts_in_ossd_by_project ... [CREATE VIEW (0 processed) in 1.84s]
19:00:41  74 of 235 START sql view model pr_2397.int_gitcoin_project_directory ........... [RUN]
19:00:42  65 of 235 OK created sql view model pr_2397.int_gitcoin_funding_events ......... [CREATE VIEW (0 processed) in 2.14s]
19:00:45  66 of 235 OK created sql view model pr_2397.stg_open_collective__events ........ [CREATE VIEW (0 processed) in 2.09s]
19:00:45  64 of 235 OK created sql view model pr_2397.int_users .......................... [CREATE VIEW (0 processed) in 2.20s]
19:00:45  72 of 235 OK created sql view model pr_2397.int_projects_by_collection ......... [CREATE VIEW (0 processed) in 2.39s]
19:00:45  68 of 235 OK created sql view model pr_2397.int_collections .................... [CREATE VIEW (0 processed) in 2.92s]
19:00:45  74 of 235 OK created sql view model pr_2397.int_gitcoin_project_directory ...... [CREATE VIEW (0 processed) in 1.56s]
19:00:45  60 of 235 OK created sql incremental model pr_2397.stg_zora__factories ......... [CREATE TABLE (0.0 rows, 0 processed) in 4.16s]
19:00:45  54 of 235 OK created sql incremental model pr_2397.stg_pgn__factories .......... [CREATE TABLE (0.0 rows, 0 processed) in 4.34s]
19:00:45  59 of 235 OK created sql incremental model pr_2397.stg_zora__deployers ......... [CREATE TABLE (0.0 rows, 0 processed) in 4.40s]
19:00:45  56 of 235 OK created sql table model pr_2397.stg_pgn__potential_bots ........... [CREATE TABLE (0.0 rows, 11.8 KiB processed) in 4.54s]
19:00:45  57 of 235 OK created sql incremental model pr_2397.stg_pgn__proxies ............ [CREATE TABLE (0.0 rows, 0 processed) in 4.57s]
19:00:45  55 of 235 OK created sql incremental model pr_2397.stg_pgn__first_time_addresses  [CREATE TABLE (0.0 rows, 0 processed) in 4.68s]
19:00:45  61 of 235 OK created sql incremental model pr_2397.stg_zora__first_time_addresses  [CREATE TABLE (0.0 rows, 0 processed) in 4.71s]
19:00:45  63 of 235 OK created sql incremental model pr_2397.stg_zora__proxies ........... [CREATE TABLE (0.0 rows, 0 processed) in 4.76s]
19:00:45  26 of 235 OK created sql table model pr_2397.stg_karma3__globaltrust ........... [CREATE TABLE (24.0m rows, 733.7 MiB processed) in 13.12s]
19:00:45  73 of 235 OK created sql table model pr_2397.projects_v1 ....................... [CREATE TABLE (9.0 rows, 762.0 Bytes processed) in 3.65s]
19:00:45  69 of 235 OK created sql incremental model pr_2397.stg_github__events .......... [CREATE TABLE (0.0 rows, 25.9 KiB processed) in 5.62s]
19:00:45  75 of 235 START sql table model pr_2397.users_v1 ............................... [RUN]
19:00:45  76 of 235 START sql table model pr_2397.collections_v1 ......................... [RUN]
19:00:45  77 of 235 START sql table model pr_2397.projects_by_collection_v1 .............. [RUN]
19:00:45  78 of 235 START sql table model pr_2397.int_factories .......................... [RUN]
19:00:45  79 of 235 START sql table model pr_2397.int_deployers .......................... [RUN]
19:00:45  80 of 235 START sql view model pr_2397.int_deployers_by_project ................ [RUN]
19:00:45  81 of 235 START sql view model pr_2397.int_first_time_addresses ................ [RUN]
19:00:45  82 of 235 START sql view model pr_2397.int_proxies ............................. [RUN]
19:00:45  83 of 235 START sql table model pr_2397.int_safes .............................. [RUN]
19:00:45  84 of 235 START sql table model pr_2397.rf4_trusted_users ...................... [RUN]
19:00:45  85 of 235 START sql view model pr_2397.int_oss_funding_grants_to_project ....... [RUN]
19:00:45  86 of 235 START sql view model pr_2397.stg_github__comments .................... [RUN]
19:00:45  87 of 235 START sql view model pr_2397.stg_github__issues ...................... [RUN]
19:00:45  88 of 235 START sql view model pr_2397.stg_github__pull_request_merge_events ... [RUN]
19:00:45  89 of 235 START sql view model pr_2397.stg_github__pull_requests ............... [RUN]
19:00:45  90 of 235 START sql view model pr_2397.stg_github__push_events ................. [RUN]
19:00:45  91 of 235 START sql view model pr_2397.stg_github__releases .................... [RUN]
19:00:45  92 of 235 START sql view model pr_2397.stg_github__stars_and_forks ............. [RUN]
19:00:47  3 of 235 OK created sql incremental model pr_2397.rf4_transactions_window ...... [CREATE TABLE (11.5m rows, 2.6 GiB processed) in 14.85s]
19:00:47  89 of 235 OK created sql view model pr_2397.stg_github__pull_requests .......... [CREATE VIEW (0 processed) in 1.57s]
19:00:47  87 of 235 OK created sql view model pr_2397.stg_github__issues ................. [CREATE VIEW (0 processed) in 1.60s]
19:00:47  92 of 235 OK created sql view model pr_2397.stg_github__stars_and_forks ........ [CREATE VIEW (0 processed) in 1.61s]
19:00:47  88 of 235 OK created sql view model pr_2397.stg_github__pull_request_merge_events  [CREATE VIEW (0 processed) in 1.63s]
19:00:47  91 of 235 OK created sql view model pr_2397.stg_github__releases ............... [CREATE VIEW (0 processed) in 1.68s]
19:00:47  85 of 235 OK created sql view model pr_2397.int_oss_funding_grants_to_project .. [CREATE VIEW (0 processed) in 1.83s]
19:00:47  86 of 235 OK created sql view model pr_2397.stg_github__comments ............... [CREATE VIEW (0 processed) in 1.90s]
19:00:47  90 of 235 OK created sql view model pr_2397.stg_github__push_events ............ [CREATE VIEW (0 processed) in 1.90s]
19:00:47  93 of 235 START sql view model pr_2397.stg_github__commits ..................... [RUN]
19:00:48  82 of 235 OK created sql view model pr_2397.int_proxies ........................ [CREATE VIEW (0 processed) in 2.55s]
19:00:48  81 of 235 OK created sql view model pr_2397.int_first_time_addresses ........... [CREATE VIEW (0 processed) in 2.92s]
19:00:48  94 of 235 START sql view model pr_2397.int_artifacts_by_address ................ [RUN]
19:00:48  93 of 235 OK created sql view model pr_2397.stg_github__commits ................ [CREATE VIEW (0 processed) in 1.22s]
19:00:48  95 of 235 START sql view model pr_2397.stg_github__distinct_main_commits ....... [RUN]
19:00:49  79 of 235 OK created sql table model pr_2397.int_deployers ..................... [CREATE TABLE (0.0 rows, 0 processed) in 3.52s]
19:00:49  78 of 235 OK created sql table model pr_2397.int_factories ..................... [CREATE TABLE (0.0 rows, 0 processed) in 3.83s]
19:00:49  96 of 235 START sql view model pr_2397.int_derived_contracts ................... [RUN]
19:00:54  94 of 235 OK created sql view model pr_2397.int_artifacts_by_address ........... [CREATE VIEW (0 processed) in 0.97s]
19:00:54  62 of 235 OK created sql table model pr_2397.stg_zora__potential_bots .......... [CREATE TABLE (1.4k rows, 852.9 MiB processed) in 9.76s]
19:00:54  76 of 235 OK created sql table model pr_2397.collections_v1 .................... [CREATE TABLE (21.0 rows, 893.0 Bytes processed) in 3.94s]
19:00:54  80 of 235 OK created sql view model pr_2397.int_deployers_by_project ........... [CREATE VIEW (0 processed) in 4.00s]
19:00:54  95 of 235 OK created sql view model pr_2397.stg_github__distinct_main_commits .. [CREATE VIEW (0 processed) in 1.11s]
19:00:54  83 of 235 OK created sql table model pr_2397.int_safes ......................... [CREATE TABLE (0.0 rows, 0 processed) in 4.32s]
19:00:54  77 of 235 OK created sql table model pr_2397.projects_by_collection_v1 ......... [CREATE TABLE (66.0 rows, 40.5 KiB processed) in 4.50s]
19:00:54  96 of 235 OK created sql view model pr_2397.int_derived_contracts .............. [CREATE VIEW (0 processed) in 0.90s]
19:00:54  10 of 235 OK created sql table model pr_2397.stg_base__potential_bots .......... [CREATE TABLE (9.3k rows, 3.7 GiB processed) in 18.73s]
19:00:54  46 of 235 OK created sql table model pr_2397.stg_optimism__potential_bots ...... [CREATE TABLE (1.2k rows, 1.9 GiB processed) in 15.41s]
19:00:54  75 of 235 OK created sql table model pr_2397.users_v1 .......................... [CREATE TABLE (1.2m rows, 86.3 MiB processed) in 7.43s]
19:00:54  58 of 235 OK created sql table model pr_2397.stg_utility__calendar ............. [CREATE TABLE (31.8k rows, 0 processed) in 14.62s]
19:00:54  97 of 235 START sql view model pr_2397.stg_github__distinct_commits_resolved_mergebot  [RUN]
19:00:54  98 of 235 START sql table model pr_2397.contracts_v0 ........................... [RUN]
19:00:54  99 of 235 START sql table model pr_2397.int_contracts_by_project ............... [RUN]
19:00:54  100 of 235 START sql table model pr_2397.rf4_agora_contract_discovery .......... [RUN]
19:00:54  101 of 235 START sql table model pr_2397.rf4_oso_contract_discovery ............ [RUN]
19:00:54  102 of 235 START sql view model pr_2397.int_potential_bots ..................... [RUN]
19:00:54  103 of 235 START sql incremental model pr_2397.stg_base__addresses_gas_and_usage  [RUN]
19:00:54  104 of 235 START sql incremental model pr_2397.stg_frax__addresses_gas_and_usage  [RUN]
19:00:54  105 of 235 START sql incremental model pr_2397.stg_metal__addresses_gas_and_usage  [RUN]
19:00:54  106 of 235 START sql incremental model pr_2397.stg_mode__addresses_gas_and_usage  [RUN]
19:00:54  107 of 235 START sql incremental model pr_2397.stg_optimism__addresses_gas_and_usage  [RUN]
19:00:54  108 of 235 START sql incremental model pr_2397.stg_pgn__addresses_gas_and_usage  [RUN]
19:00:54  109 of 235 START sql incremental model pr_2397.stg_zora__addresses_gas_and_usage  [RUN]
19:00:56  97 of 235 OK created sql view model pr_2397.stg_github__distinct_commits_resolved_mergebot  [CREATE VIEW (0 processed) in 1.75s]
19:00:56  102 of 235 OK created sql view model pr_2397.int_potential_bots ................ [CREATE VIEW (0 processed) in 1.81s]
19:00:56  110 of 235 START sql view model pr_2397.int_addresses_by_user .................. [RUN]
19:00:57  110 of 235 OK created sql view model pr_2397.int_addresses_by_user ............. [CREATE VIEW (0 processed) in 1.08s]
19:00:57  111 of 235 START sql view model pr_2397.int_superchain_trusted_users ........... [RUN]
19:00:58  103 of 235 OK created sql incremental model pr_2397.stg_base__addresses_gas_and_usage  [CREATE TABLE (0.0 rows, 248.0 Bytes processed) in 4.16s]
19:00:59  109 of 235 OK created sql incremental model pr_2397.stg_zora__addresses_gas_and_usage  [CREATE TABLE (0.0 rows, 248.0 Bytes processed) in 4.25s]
19:00:59  107 of 235 OK created sql incremental model pr_2397.stg_optimism__addresses_gas_and_usage  [CREATE TABLE (0.0 rows, 248.0 Bytes processed) in 4.27s]
19:00:59  104 of 235 OK created sql incremental model pr_2397.stg_frax__addresses_gas_and_usage  [CREATE TABLE (0.0 rows, 248.0 Bytes processed) in 4.45s]
19:00:59  105 of 235 OK created sql incremental model pr_2397.stg_metal__addresses_gas_and_usage  [CREATE TABLE (0.0 rows, 248.0 Bytes processed) in 4.46s]
19:00:59  108 of 235 OK created sql incremental model pr_2397.stg_pgn__addresses_gas_and_usage  [CREATE TABLE (0.0 rows, 248.0 Bytes processed) in 4.51s]
19:00:59  111 of 235 OK created sql view model pr_2397.int_superchain_trusted_users ...... [CREATE VIEW (0 processed) in 1.67s]
19:00:59  100 of 235 OK created sql table model pr_2397.rf4_agora_contract_discovery ..... [CREATE TABLE (3.9k rows, 693.7 KiB processed) in 4.65s]
19:00:59  98 of 235 OK created sql table model pr_2397.contracts_v0 ...................... [CREATE TABLE (0.0 rows, 0 processed) in 5.13s]
19:01:00  106 of 235 OK created sql incremental model pr_2397.stg_mode__addresses_gas_and_usage  [CREATE TABLE (0.0 rows, 248.0 Bytes processed) in 5.44s]
19:01:00  112 of 235 START sql view model pr_2397.int_addresses_usage .................... [RUN]
19:01:00  84 of 235 OK created sql table model pr_2397.rf4_trusted_users ................. [CREATE TABLE (3.0m rows, 213.9 MiB processed) in 14.84s]
19:01:01  112 of 235 OK created sql view model pr_2397.int_addresses_usage ............... [CREATE VIEW (0 processed) in 1.05s]
19:01:01  99 of 235 OK created sql table model pr_2397.int_contracts_by_project .......... [CREATE TABLE (366.0 rows, 21.6 KiB processed) in 6.52s]
19:01:01  113 of 235 START sql view model pr_2397.int_all_artifacts ...................... [RUN]
19:01:01  114 of 235 START sql table model pr_2397.rf4_network_share ..................... [RUN]
19:01:01  101 of 235 OK created sql table model pr_2397.rf4_oso_contract_discovery ....... [CREATE TABLE (327.0 rows, 427.2 KiB processed) in 6.74s]
19:01:01  115 of 235 START sql table model pr_2397.rf4_contracts_by_app .................. [RUN]
19:01:02  113 of 235 OK created sql view model pr_2397.int_all_artifacts ................. [CREATE VIEW (0 processed) in 0.92s]
19:01:02  116 of 235 START sql incremental model pr_2397.int_arbitrum_one_traces ......... [RUN]
19:01:02  117 of 235 START sql incremental model pr_2397.int_arbitrum_one_transactions ... [RUN]
19:01:02  118 of 235 START sql view model pr_2397.int_artifact_types ..................... [RUN]
19:01:02  119 of 235 START sql view model pr_2397.int_artifacts_by_collection ............ [RUN]
19:01:02  120 of 235 START sql view model pr_2397.int_artifacts_by_project ............... [RUN]
19:01:02  121 of 235 START sql incremental model pr_2397.int_base_traces ................. [RUN]
19:01:02  122 of 235 START sql incremental model pr_2397.int_base_transactions ........... [RUN]
19:01:02  123 of 235 START sql incremental model pr_2397.int_frax_traces ................. [RUN]
19:01:02  124 of 235 START sql incremental model pr_2397.int_frax_transactions ........... [RUN]
19:01:02  125 of 235 START sql incremental model pr_2397.int_metal_traces ................ [RUN]
19:01:02  126 of 235 START sql incremental model pr_2397.int_metal_transactions .......... [RUN]
19:01:02  127 of 235 START sql incremental model pr_2397.int_mode_traces ................. [RUN]
19:01:02  128 of 235 START sql incremental model pr_2397.int_mode_transactions ........... [RUN]
19:01:02  129 of 235 START sql incremental model pr_2397.int_optimism_traces ............. [RUN]
19:01:02  130 of 235 START sql incremental model pr_2397.int_optimism_transactions ....... [RUN]
19:01:02  131 of 235 START sql incremental model pr_2397.int_pgn_traces .................. [RUN]
19:01:02  132 of 235 START sql incremental model pr_2397.int_pgn_transactions ............ [RUN]
19:01:02  133 of 235 START sql incremental model pr_2397.int_zora_traces ................. [RUN]
19:01:02  134 of 235 START sql incremental model pr_2397.int_zora_transactions ........... [RUN]
19:01:04  119 of 235 OK created sql view model pr_2397.int_artifacts_by_collection ....... [CREATE VIEW (0 processed) in 2.04s]
19:01:04  135 of 235 START sql table model pr_2397.artifacts_by_collection_v1 ............ [RUN]
19:01:04  118 of 235 OK created sql view model pr_2397.int_artifact_types ................ [CREATE VIEW (0 processed) in 2.10s]
19:01:04  120 of 235 OK created sql view model pr_2397.int_artifacts_by_project .......... [CREATE VIEW (0 processed) in 2.11s]
19:01:04  136 of 235 START sql table model pr_2397.artifacts_by_project_v1 ............... [RUN]
19:01:04  115 of 235 OK created sql table model pr_2397.rf4_contracts_by_app ............. [CREATE TABLE (3.1k rows, 617.6 KiB processed) in 3.19s]
19:01:04  137 of 235 START sql table model pr_2397.rf4_transactions_by_app ............... [RUN]
19:01:05  27 of 235 OK created sql table model pr_2397.stg_karma3__localtrust ............ [CREATE TABLE (237.0m rows, 8.8 GiB processed) in 32.92s]
19:01:09  131 of 235 OK created sql incremental model pr_2397.int_pgn_traces ............. [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 7.47s]
19:01:10  114 of 235 OK created sql table model pr_2397.rf4_network_share ................ [CREATE TABLE (412.1k rows, 2.3 GiB processed) in 8.88s]
19:01:10  117 of 235 OK created sql incremental model pr_2397.int_arbitrum_one_transactions  [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 8.00s]
19:01:10  138 of 235 START sql incremental model pr_2397.int_arbitrum_one_contract_invocation_events  [RUN]
19:01:10  116 of 235 OK created sql incremental model pr_2397.int_arbitrum_one_traces .... [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 8.07s]
19:01:10  123 of 235 OK created sql incremental model pr_2397.int_frax_traces ............ [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 8.13s]
19:01:10  124 of 235 OK created sql incremental model pr_2397.int_frax_transactions ...... [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 8.15s]
19:01:10  139 of 235 START sql incremental model pr_2397.int_frax_contract_invocation_events  [RUN]
19:01:10  136 of 235 OK created sql table model pr_2397.artifacts_by_project_v1 .......... [CREATE TABLE (1.4k rows, 194.1 KiB processed) in 6.06s]
19:01:10  140 of 235 START sql table model pr_2397.rf4_4337_events ....................... [RUN]
19:01:10  128 of 235 OK created sql incremental model pr_2397.int_mode_transactions ...... [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 8.22s]
19:01:10  141 of 235 START sql incremental model pr_2397.int_mode_contract_invocation_events  [RUN]
19:01:10  122 of 235 OK created sql incremental model pr_2397.int_base_transactions ...... [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 8.44s]
19:01:10  142 of 235 START sql incremental model pr_2397.int_base_contract_invocation_events  [RUN]
19:01:10  126 of 235 OK created sql incremental model pr_2397.int_metal_transactions ..... [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 8.43s]
19:01:10  143 of 235 START sql incremental model pr_2397.int_metal_contract_invocation_events  [RUN]
19:01:10  135 of 235 OK created sql table model pr_2397.artifacts_by_collection_v1 ....... [CREATE TABLE (9.0k rows, 234.5 KiB processed) in 6.47s]
19:01:10  121 of 235 OK created sql incremental model pr_2397.int_base_traces ............ [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 8.52s]
19:01:10  132 of 235 OK created sql incremental model pr_2397.int_pgn_transactions ....... [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 8.54s]
19:01:10  144 of 235 START sql incremental model pr_2397.int_pgn_contract_invocation_events  [RUN]
19:01:11  129 of 235 OK created sql incremental model pr_2397.int_optimism_traces ........ [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 8.78s]
19:01:11  134 of 235 OK created sql incremental model pr_2397.int_zora_transactions ...... [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 8.82s]
19:01:11  145 of 235 START sql incremental model pr_2397.int_zora_contract_invocation_events  [RUN]
19:01:11  133 of 235 OK created sql incremental model pr_2397.int_zora_traces ............ [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 8.88s]
19:01:11  125 of 235 OK created sql incremental model pr_2397.int_metal_traces ........... [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 8.89s]
19:01:11  130 of 235 OK created sql incremental model pr_2397.int_optimism_transactions .. [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 9.14s]
19:01:11  146 of 235 START sql incremental model pr_2397.int_optimism_contract_invocation_events  [RUN]
19:01:11  127 of 235 OK created sql incremental model pr_2397.int_mode_traces ............ [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 9.28s]
19:01:12  137 of 235 OK created sql table model pr_2397.rf4_transactions_by_app .......... [CREATE TABLE (1.7m rows, 1.1 GiB processed) in 8.12s]
19:01:12  147 of 235 START sql table model pr_2397.rf4_onchain_eligibility_checks ........ [RUN]
19:01:14  141 of 235 OK created sql incremental model pr_2397.int_mode_contract_invocation_events  [CREATE TABLE (0.0 rows, 21.5 KiB processed) in 3.84s]
19:01:14  140 of 235 OK created sql table model pr_2397.rf4_4337_events .................. [CREATE TABLE (0.0 rows, 122.0 KiB processed) in 4.08s]
19:01:14  139 of 235 OK created sql incremental model pr_2397.int_frax_contract_invocation_events  [CREATE TABLE (0.0 rows, 21.5 KiB processed) in 4.35s]
19:01:14  138 of 235 OK created sql incremental model pr_2397.int_arbitrum_one_contract_invocation_events  [CREATE TABLE (0.0 rows, 21.5 KiB processed) in 4.60s]
19:01:14  13 of 235 OK created sql incremental model pr_2397.stg_ethereum__deployers ..... [CREATE TABLE (4.7m rows, 727.7 MiB processed) in 42.64s]
19:01:16  142 of 235 OK created sql incremental model pr_2397.int_base_contract_invocation_events  [CREATE TABLE (0.0 rows, 21.5 KiB processed) in 5.35s]
19:01:16  144 of 235 OK created sql incremental model pr_2397.int_pgn_contract_invocation_events  [CREATE TABLE (0.0 rows, 21.5 KiB processed) in 5.40s]
19:01:16  143 of 235 OK created sql incremental model pr_2397.int_metal_contract_invocation_events  [CREATE TABLE (0.0 rows, 21.5 KiB processed) in 5.55s]
19:01:16  146 of 235 OK created sql incremental model pr_2397.int_optimism_contract_invocation_events  [CREATE TABLE (0.0 rows, 21.5 KiB processed) in 4.90s]
19:01:16  145 of 235 OK created sql incremental model pr_2397.int_zora_contract_invocation_events  [CREATE TABLE (0.0 rows, 21.5 KiB processed) in 5.23s]
19:01:16  148 of 235 START sql table model pr_2397.int_events ............................ [RUN]
19:01:20  147 of 235 OK created sql table model pr_2397.rf4_onchain_eligibility_checks ... [CREATE TABLE (462.0 rows, 198.2 MiB processed) in 7.40s]
19:01:54  148 of 235 OK created sql table model pr_2397.int_events ....................... [CREATE TABLE (6.1m rows, 1.6 GiB processed) in 38.35s]
19:01:54  149 of 235 START sql table model pr_2397.event_types_v1 ........................ [RUN]
19:01:54  150 of 235 START sql view model pr_2397.int_artifacts_by_user .................. [RUN]
19:01:54  151 of 235 START sql view model pr_2397.int_artifacts_history .................. [RUN]
19:01:54  152 of 235 START sql table model pr_2397.int_events_daily_to_artifact .......... [RUN]
19:01:54  153 of 235 START sql view model pr_2397.int_events_to_project .................. [RUN]
19:01:54  154 of 235 START sql table model pr_2397.int_funding_metrics_by_project ........ [RUN]
19:01:54  155 of 235 START sql table model pr_2397.oso_events_v0 ......................... [RUN]
19:01:54  156 of 235 START sql view model pr_2397.superchain_metric__daily_active_addresses_avg_6_months  [RUN]
19:01:54  157 of 235 START sql view model pr_2397.superchain_metric__gas_fees_sum_6_months  [RUN]
19:01:54  158 of 235 START sql view model pr_2397.superchain_metric__monthly_active_addresses_avg_6_months  [RUN]
19:01:54  159 of 235 START sql view model pr_2397.superchain_metric__transactions_sum_6_months  [RUN]
19:01:54  160 of 235 START sql view model pr_2397.superchain_metric__trusted_daily_active_users_avg_6_months  [RUN]
19:01:54  161 of 235 START sql view model pr_2397.superchain_metric__trusted_monthly_active_users_avg_6_months  [RUN]
19:01:54  162 of 235 START sql view model pr_2397.superchain_metric__trusted_transactions_sum_6_months  [RUN]
19:01:54  163 of 235 START sql view model pr_2397.superchain_metric__trusted_users_onboarded_sum_6_months  [RUN]
19:01:54  164 of 235 START sql table model pr_2397.timeseries_events_by_artifact_v0 ...... [RUN]
19:01:56  151 of 235 OK created sql view model pr_2397.int_artifacts_history ............. [CREATE VIEW (0 processed) in 1.37s]
19:01:56  165 of 235 START sql view model pr_2397.int_artifacts .......................... [RUN]
19:01:56  159 of 235 OK created sql view model pr_2397.superchain_metric__transactions_sum_6_months  [CREATE VIEW (0 processed) in 1.41s]
19:01:56  157 of 235 OK created sql view model pr_2397.superchain_metric__gas_fees_sum_6_months  [CREATE VIEW (0 processed) in 1.49s]
19:01:56  158 of 235 OK created sql view model pr_2397.superchain_metric__monthly_active_addresses_avg_6_months  [CREATE VIEW (0 processed) in 1.54s]
19:01:56  156 of 235 OK created sql view model pr_2397.superchain_metric__daily_active_addresses_avg_6_months  [CREATE VIEW (0 processed) in 1.58s]
19:01:56  153 of 235 OK created sql view model pr_2397.int_events_to_project ............. [CREATE VIEW (0 processed) in 1.70s]
19:01:56  166 of 235 START sql table model pr_2397.events_daily_to_artifact .............. [RUN]
19:01:56  167 of 235 START sql table model pr_2397.events_daily_to_project ............... [RUN]
19:01:56  168 of 235 START sql table model pr_2397.events_daily_to_project_by_source ..... [RUN]
19:01:56  169 of 235 START sql view model pr_2397.int_addresses_to_project ............... [RUN]
19:01:56  170 of 235 START sql view model pr_2397.int_contributors_to_project ............ [RUN]
19:01:56  171 of 235 START sql view model pr_2397.int_events_daily_to_project ............ [RUN]
19:01:56  172 of 235 START sql view model pr_2397.int_events_to_collection ............... [RUN]
19:01:56  173 of 235 START sql table model pr_2397.int_repo_metrics_by_project ........... [RUN]
19:01:56  160 of 235 OK created sql view model pr_2397.superchain_metric__trusted_daily_active_users_avg_6_months  [CREATE VIEW (0 processed) in 1.77s]
19:01:56  150 of 235 OK created sql view model pr_2397.int_artifacts_by_user ............. [CREATE VIEW (0 processed) in 1.92s]
19:01:56  163 of 235 OK created sql view model pr_2397.superchain_metric__trusted_users_onboarded_sum_6_months  [CREATE VIEW (0 processed) in 2.12s]
19:01:56  161 of 235 OK created sql view model pr_2397.superchain_metric__trusted_monthly_active_users_avg_6_months  [CREATE VIEW (0 processed) in 2.12s]
19:01:56  174 of 235 START sql table model pr_2397.artifacts_by_user_v1 .................. [RUN]
19:01:56  162 of 235 OK created sql view model pr_2397.superchain_metric__trusted_transactions_sum_6_months  [CREATE VIEW (0 processed) in 2.19s]
19:01:56  175 of 235 START sql view model pr_2397.int_timeseries_superchain_metrics__all . [RUN]
19:01:57  165 of 235 OK created sql view model pr_2397.int_artifacts ..................... [CREATE VIEW (0 processed) in 0.97s]
19:01:57  176 of 235 START sql table model pr_2397.artifacts_v1 .......................... [RUN]
19:01:57  171 of 235 OK created sql view model pr_2397.int_events_daily_to_project ....... [CREATE VIEW (0 processed) in 1.24s]
19:01:57  177 of 235 START sql view model pr_2397.int_code_metric__active_developers ..... [RUN]
19:01:57  178 of 235 START sql view model pr_2397.int_code_metric__commits_prs_issues .... [RUN]
19:01:57  179 of 235 START sql view model pr_2397.int_code_metric__contributors .......... [RUN]
19:01:57  180 of 235 START sql view model pr_2397.int_code_metric__new_contributors ...... [RUN]
19:01:57  181 of 235 START sql view model pr_2397.int_developer_status_monthly_by_project  [RUN]
19:01:57  182 of 235 START sql view model pr_2397.int_events_alltime_to_project .......... [RUN]
19:01:57  183 of 235 START sql view model pr_2397.int_events_monthly_to_project .......... [RUN]
19:01:57  184 of 235 START sql view model pr_2397.int_first_last_event_by_artifact ....... [RUN]
19:01:57  185 of 235 START sql table model pr_2397.int_onchain_metric__active_addresses .. [RUN]
19:01:57  186 of 235 START sql table model pr_2397.int_onchain_metric__active_contracts .. [RUN]
19:01:57  187 of 235 START sql table model pr_2397.int_onchain_metric__days_since_first_transaction  [RUN]
19:01:57  188 of 235 START sql table model pr_2397.int_onchain_metric__gas_fees .......... [RUN]
19:01:57  189 of 235 START sql table model pr_2397.int_onchain_metric__high_low_activity_addresses  [RUN]
19:01:57  190 of 235 START sql table model pr_2397.int_onchain_metric__multi_project_addresses  [RUN]
19:01:57  191 of 235 START sql table model pr_2397.int_onchain_metric__new_addresses ..... [RUN]
19:01:57  192 of 235 START sql table model pr_2397.int_onchain_metric__returning_addresses  [RUN]
19:01:57  193 of 235 START sql table model pr_2397.int_onchain_metric__transactions ...... [RUN]
19:01:57  172 of 235 OK created sql view model pr_2397.int_events_to_collection .......... [CREATE VIEW (0 processed) in 1.39s]
19:01:58  175 of 235 OK created sql view model pr_2397.int_timeseries_superchain_metrics__all  [CREATE VIEW (0 processed) in 1.41s]
19:01:58  194 of 235 START sql table model pr_2397.int_timeseries_code_metrics__developers  [RUN]
19:01:58  195 of 235 START sql table model pr_2397.events_daily_to_collection ............ [RUN]
19:01:58  170 of 235 OK created sql view model pr_2397.int_contributors_to_project ....... [CREATE VIEW (0 processed) in 2.41s]
19:01:58  196 of 235 START sql table model pr_2397.events_daily_to_collection_by_source .. [RUN]
19:01:59  169 of 235 OK created sql view model pr_2397.int_addresses_to_project .......... [CREATE VIEW (0 processed) in 2.80s]
19:01:59  197 of 235 START sql view model pr_2397.int_address_rfm_segments_by_project .... [RUN]
19:01:59  181 of 235 OK created sql view model pr_2397.int_developer_status_monthly_by_project  [CREATE VIEW (0 processed) in 1.68s]
19:01:59  198 of 235 START sql view model pr_2397.int_addresses_daily_activity ........... [RUN]
19:01:59  178 of 235 OK created sql view model pr_2397.int_code_metric__commits_prs_issues  [CREATE VIEW (0 processed) in 1.78s]
19:01:59  184 of 235 OK created sql view model pr_2397.int_first_last_event_by_artifact .. [CREATE VIEW (0 processed) in 1.77s]
19:01:59  177 of 235 OK created sql view model pr_2397.int_code_metric__active_developers  [CREATE VIEW (0 processed) in 1.85s]
19:01:59  182 of 235 OK created sql view model pr_2397.int_events_alltime_to_project ..... [CREATE VIEW (0 processed) in 1.87s]
19:01:59  179 of 235 OK created sql view model pr_2397.int_code_metric__contributors ..... [CREATE VIEW (0 processed) in 2.08s]
19:02:00  197 of 235 OK created sql view model pr_2397.int_address_rfm_segments_by_project  [CREATE VIEW (0 processed) in 0.83s]
19:02:00  180 of 235 OK created sql view model pr_2397.int_code_metric__new_contributors . [CREATE VIEW (0 processed) in 2.47s]
19:02:00  183 of 235 OK created sql view model pr_2397.int_events_monthly_to_project ..... [CREATE VIEW (0 processed) in 2.62s]
19:02:00  199 of 235 START sql view model pr_2397.int_code_metric__bus_factor ............ [RUN]
19:02:00  198 of 235 OK created sql view model pr_2397.int_addresses_daily_activity ...... [CREATE VIEW (0 processed) in 1.15s]
19:02:00  200 of 235 START sql view model pr_2397.int_active_addresses_daily_to_project .. [RUN]
19:02:00  201 of 235 START sql view model pr_2397.int_active_addresses_monthly_to_project  [RUN]
19:02:00  202 of 235 START sql view model pr_2397.int_address_totals_by_project .......... [RUN]
19:02:01  199 of 235 OK created sql view model pr_2397.int_code_metric__bus_factor ....... [CREATE VIEW (0 processed) in 0.96s]
19:02:01  202 of 235 OK created sql view model pr_2397.int_address_totals_by_project ..... [CREATE VIEW (0 processed) in 0.94s]
19:02:01  200 of 235 OK created sql view model pr_2397.int_active_addresses_daily_to_project  [CREATE VIEW (0 processed) in 0.98s]
19:02:01  201 of 235 OK created sql view model pr_2397.int_active_addresses_monthly_to_project  [CREATE VIEW (0 processed) in 1.20s]
19:02:02  149 of 235 OK created sql table model pr_2397.event_types_v1 ................... [CREATE TABLE (3.0 rows, 43.4 MiB processed) in 7.52s]
19:02:03  164 of 235 OK created sql table model pr_2397.timeseries_events_by_artifact_v0 . [CREATE TABLE (6.1m rows, 986.9 MiB processed) in 9.28s]
19:02:04  155 of 235 OK created sql table model pr_2397.oso_events_v0 .................... [CREATE TABLE (0.0 rows, 1.9 GiB processed) in 10.20s]
19:02:05  166 of 235 OK created sql table model pr_2397.events_daily_to_artifact ......... [CREATE TABLE (0.0 rows, 402.5 MiB processed) in 8.82s]
19:02:05  203 of 235 START sql table model pr_2397.events_monthly_to_artifact ............ [RUN]
19:02:05  204 of 235 START sql table model pr_2397.events_weekly_to_artifact ............. [RUN]
19:02:05  168 of 235 OK created sql table model pr_2397.events_daily_to_project_by_source  [CREATE TABLE (0.0 rows, 500.9 MiB processed) in 9.28s]
19:02:05  205 of 235 START sql table model pr_2397.event_indexing_status_by_project_v1 ... [RUN]
19:02:05  206 of 235 START sql table model pr_2397.events_monthly_to_project_by_source ... [RUN]
19:02:05  207 of 235 START sql table model pr_2397.events_weekly_to_project_by_source .... [RUN]
19:02:05  174 of 235 OK created sql table model pr_2397.artifacts_by_user_v1 ............. [CREATE TABLE (179.3k rows, 693.9 MiB processed) in 8.92s]
19:02:07  167 of 235 OK created sql table model pr_2397.events_daily_to_project .......... [CREATE TABLE (0.0 rows, 402.5 MiB processed) in 10.96s]
19:02:07  208 of 235 START sql table model pr_2397.events_monthly_to_project ............. [RUN]
19:02:07  209 of 235 START sql table model pr_2397.events_weekly_to_project .............. [RUN]
19:02:07  154 of 235 OK created sql table model pr_2397.int_funding_metrics_by_project ... [CREATE TABLE (29.3k rows, 1.9 GiB processed) in 12.97s]
19:02:07  210 of 235 START sql table model pr_2397.funding_metrics_by_project_v1 ......... [RUN]
19:02:07  204 of 235 OK created sql table model pr_2397.events_weekly_to_artifact ........ [CREATE TABLE (0.0 rows, 0 processed) in 2.52s]
19:02:08  176 of 235 OK created sql table model pr_2397.artifacts_v1 ..................... [CREATE TABLE (180.7k rows, 861.0 MiB processed) in 11.00s]
19:02:08  211 of 235 START sql table model pr_2397.rf4_events_daily_to_project ........... [RUN]
19:02:08  173 of 235 OK created sql table model pr_2397.int_repo_metrics_by_project ...... [CREATE TABLE (883.0 rows, 668.8 MiB processed) in 11.92s]
19:02:08  212 of 235 START sql table model pr_2397.rf4_repo_stats_by_project ............. [RUN]
19:02:08  206 of 235 OK created sql table model pr_2397.events_monthly_to_project_by_source  [CREATE TABLE (0.0 rows, 0 processed) in 2.70s]
19:02:08  207 of 235 OK created sql table model pr_2397.events_weekly_to_project_by_source  [CREATE TABLE (0.0 rows, 0 processed) in 2.70s]
19:02:08  193 of 235 OK created sql table model pr_2397.int_onchain_metric__transactions . [CREATE TABLE (0.0 rows, 767.1 MiB processed) in 10.85s]
19:02:08  188 of 235 OK created sql table model pr_2397.int_onchain_metric__gas_fees ..... [CREATE TABLE (0.0 rows, 767.1 MiB processed) in 10.89s]
19:02:08  185 of 235 OK created sql table model pr_2397.int_onchain_metric__active_addresses  [CREATE TABLE (0.0 rows, 720.8 MiB processed) in 10.92s]
19:02:08  187 of 235 OK created sql table model pr_2397.int_onchain_metric__days_since_first_transaction  [CREATE TABLE (0.0 rows, 720.8 MiB processed) in 11.01s]
19:02:08  205 of 235 OK created sql table model pr_2397.event_indexing_status_by_project_v1  [CREATE TABLE (0.0 rows, 707.0 Bytes processed) in 3.16s]
19:02:09  203 of 235 OK created sql table model pr_2397.events_monthly_to_artifact ....... [CREATE TABLE (0.0 rows, 0 processed) in 3.88s]
19:02:09  196 of 235 OK created sql table model pr_2397.events_daily_to_collection_by_source  [CREATE TABLE (0.0 rows, 500.9 MiB processed) in 10.54s]
19:02:09  213 of 235 START sql table model pr_2397.events_monthly_to_collection_by_source  [RUN]
19:02:09  214 of 235 START sql table model pr_2397.events_weekly_to_collection_by_source . [RUN]
19:02:09  191 of 235 OK created sql table model pr_2397.int_onchain_metric__new_addresses  [CREATE TABLE (0.0 rows, 720.8 MiB processed) in 11.85s]
19:02:09  195 of 235 OK created sql table model pr_2397.events_daily_to_collection ....... [CREATE TABLE (0.0 rows, 402.5 MiB processed) in 11.06s]
19:02:09  215 of 235 START sql table model pr_2397.events_monthly_to_collection .......... [RUN]
19:02:09  216 of 235 START sql table model pr_2397.events_weekly_to_collection ........... [RUN]
19:02:09  208 of 235 OK created sql table model pr_2397.events_monthly_to_project ........ [CREATE TABLE (0.0 rows, 0 processed) in 2.37s]
19:02:10  190 of 235 OK created sql table model pr_2397.int_onchain_metric__multi_project_addresses  [CREATE TABLE (0.0 rows, 720.8 MiB processed) in 12.37s]
19:02:10  186 of 235 OK created sql table model pr_2397.int_onchain_metric__active_contracts  [CREATE TABLE (0.0 rows, 720.8 MiB processed) in 12.57s]
19:02:10  189 of 235 OK created sql table model pr_2397.int_onchain_metric__high_low_activity_addresses  [CREATE TABLE (0.0 rows, 767.1 MiB processed) in 12.71s]
19:02:10  210 of 235 OK created sql table model pr_2397.funding_metrics_by_project_v1 .... [CREATE TABLE (29.3k rows, 4.3 MiB processed) in 2.98s]
19:02:11  212 of 235 OK created sql table model pr_2397.rf4_repo_stats_by_project ........ [CREATE TABLE (635.0 rows, 216.7 KiB processed) in 2.79s]
19:02:11  213 of 235 OK created sql table model pr_2397.events_monthly_to_collection_by_source  [CREATE TABLE (0.0 rows, 0 processed) in 2.30s]
19:02:11  214 of 235 OK created sql table model pr_2397.events_weekly_to_collection_by_source  [CREATE TABLE (0.0 rows, 0 processed) in 2.50s]
19:02:12  216 of 235 OK created sql table model pr_2397.events_weekly_to_collection ...... [CREATE TABLE (0.0 rows, 0 processed) in 2.45s]
19:02:12  215 of 235 OK created sql table model pr_2397.events_monthly_to_collection ..... [CREATE TABLE (0.0 rows, 0 processed) in 2.61s]
19:02:12  209 of 235 OK created sql table model pr_2397.events_weekly_to_project ......... [CREATE TABLE (0.0 rows, 0 processed) in 5.03s]
19:02:13  192 of 235 OK created sql table model pr_2397.int_onchain_metric__returning_addresses  [CREATE TABLE (0.0 rows, 720.8 MiB processed) in 15.45s]
19:02:13  217 of 235 START sql table model pr_2397.int_onchain_metrics_by_project ........ [RUN]
19:02:16  217 of 235 OK created sql table model pr_2397.int_onchain_metrics_by_project ... [CREATE TABLE (0.0 rows, 220.0 Bytes processed) in 3.46s]
19:02:16  218 of 235 START sql table model pr_2397.onchain_metrics_by_project_v1 ......... [RUN]
19:02:17  211 of 235 OK created sql table model pr_2397.rf4_events_daily_to_project ...... [CREATE TABLE (0.0 rows, 700.5 MiB processed) in 9.56s]
19:02:17  219 of 235 START sql table model pr_2397.rf4_daily_active_addresses ............ [RUN]
19:02:17  220 of 235 START sql table model pr_2397.rf4_gas_fees .......................... [RUN]
19:02:17  221 of 235 START sql table model pr_2397.rf4_monthly_active_addresses .......... [RUN]
19:02:17  222 of 235 START sql table model pr_2397.rf4_openrank_trusted_users_count ...... [RUN]
19:02:17  223 of 235 START sql table model pr_2397.rf4_power_user_addresses .............. [RUN]
19:02:17  224 of 235 START sql table model pr_2397.rf4_recurring_addresses ............... [RUN]
19:02:17  225 of 235 START sql table model pr_2397.rf4_transactions ...................... [RUN]
19:02:17  226 of 235 START sql table model pr_2397.rf4_trusted_daily_active_users ........ [RUN]
19:02:17  227 of 235 START sql table model pr_2397.rf4_trusted_monthly_active_users ...... [RUN]
19:02:17  228 of 235 START sql table model pr_2397.rf4_trusted_recurring_users ........... [RUN]
19:02:17  229 of 235 START sql table model pr_2397.rf4_trusted_transaction_count ......... [RUN]
19:02:17  230 of 235 START sql table model pr_2397.rf4_trusted_users_onboarded ........... [RUN]
19:02:17  231 of 235 START sql table model pr_2397.rf4_trusted_users_share_of_transactions  [RUN]
19:02:19  218 of 235 OK created sql table model pr_2397.onchain_metrics_by_project_v1 .... [CREATE TABLE (0.0 rows, 0 processed) in 2.65s]
19:02:20  229 of 235 OK created sql table model pr_2397.rf4_trusted_transaction_count .... [CREATE TABLE (0.0 rows, 0 processed) in 3.38s]
19:02:21  227 of 235 OK created sql table model pr_2397.rf4_trusted_monthly_active_users . [CREATE TABLE (0.0 rows, 0 processed) in 3.42s]
19:02:21  226 of 235 OK created sql table model pr_2397.rf4_trusted_daily_active_users ... [CREATE TABLE (0.0 rows, 0 processed) in 3.48s]
19:02:21  219 of 235 OK created sql table model pr_2397.rf4_daily_active_addresses ....... [CREATE TABLE (0.0 rows, 0 processed) in 3.53s]
19:02:21  228 of 235 OK created sql table model pr_2397.rf4_trusted_recurring_users ...... [CREATE TABLE (0.0 rows, 0 processed) in 3.67s]
19:02:21  220 of 235 OK created sql table model pr_2397.rf4_gas_fees ..................... [CREATE TABLE (0.0 rows, 0 processed) in 3.71s]
19:02:21  224 of 235 OK created sql table model pr_2397.rf4_recurring_addresses .......... [CREATE TABLE (0.0 rows, 0 processed) in 3.86s]
19:02:21  225 of 235 OK created sql table model pr_2397.rf4_transactions ................. [CREATE TABLE (0.0 rows, 0 processed) in 3.88s]
19:02:21  230 of 235 OK created sql table model pr_2397.rf4_trusted_users_onboarded ...... [CREATE TABLE (0.0 rows, 0 processed) in 3.92s]
19:02:21  223 of 235 OK created sql table model pr_2397.rf4_power_user_addresses ......... [CREATE TABLE (0.0 rows, 0 processed) in 4.35s]
19:02:22  231 of 235 OK created sql table model pr_2397.rf4_trusted_users_share_of_transactions  [CREATE TABLE (0.0 rows, 0 processed) in 4.97s]
19:02:29  222 of 235 OK created sql table model pr_2397.rf4_openrank_trusted_users_count . [CREATE TABLE (0.0 rows, 8.9 GiB processed) in 12.24s]
19:02:31  221 of 235 OK created sql table model pr_2397.rf4_monthly_active_addresses ..... [CREATE TABLE (0.0 rows, 0 processed) in 13.93s]
19:02:31  232 of 235 START sql table model pr_2397.rf4_impact_metrics_by_project ......... [RUN]
19:02:35  232 of 235 OK created sql table model pr_2397.rf4_impact_metrics_by_project .... [CREATE TABLE (0.0 rows, 101.9 KiB processed) in 3.86s]
19:02:35  152 of 235 OK created sql table model pr_2397.int_events_daily_to_artifact ..... [CREATE TABLE (3.3m rows, 766.9 MiB processed) in 40.91s]
19:04:59  194 of 235 OK created sql table model pr_2397.int_timeseries_code_metrics__developers  [CREATE TABLE (0.0 rows, 767.1 MiB processed) in 180.73s]
19:04:59  233 of 235 START sql view model pr_2397.int_code_metric__fulltime_developers_average  [RUN]
19:04:59  233 of 235 OK created sql view model pr_2397.int_code_metric__fulltime_developers_average  [CREATE VIEW (0 processed) in 0.68s]
19:04:59  234 of 235 START sql table model pr_2397.int_code_metrics_by_project ........... [RUN]
19:05:25  234 of 235 OK created sql table model pr_2397.int_code_metrics_by_project ...... [CREATE TABLE (9.0 rows, 767.2 MiB processed) in 25.21s]
19:05:25  235 of 235 START sql table model pr_2397.code_metrics_by_project_v1 ............ [RUN]
19:05:27  235 of 235 OK created sql table model pr_2397.code_metrics_by_project_v1 ....... [CREATE TABLE (9.0 rows, 1.1 KiB processed) in 2.26s]
19:05:27  
19:05:27  Finished running 82 view models, 66 incremental models, 87 table models in 0 hours 4 minutes and 55.85 seconds (295.85s).
19:05:27  
19:05:27  Completed with 1 error and 0 warnings:
19:05:27  
19:05:27    Runtime Error in model stg_ossd__missing_sbom (warehouse/dbt/models/staging/oss-directory/stg_ossd__missing_sbom.sql)
  404 Not found: Table opensource-observer:ossd.missing_sbom was not found in location US; reason: notFound, message: Not found: Table opensource-observer:ossd.missing_sbom was not found in location US

  Location: US
  Job ID: 49c9645a-e732-4eb8-a7fd-7949e9198367

19:05:27  
19:05:27  Done. PASS=234 WARN=0 ERROR=1 SKIP=0 TOTAL=235

DBT stderr: