Skip to content
New issue

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

Sign up for GitHub

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

Already on GitHub? Sign in to your account

Jump to bottom

add: npm ownership intermediate model #2520

Merged
merged 6 commits into from
Nov 26, 2024
Merged

add: npm ownership intermediate model #2520

merged 6 commits into from
Nov 26, 2024

Conversation

Jabolol
Copy link
Contributor

@Jabolol Jabolol commented Nov 26, 2024

This PR closes #2459 by introducing a new intermediate model, int_artifact_ownership, which links npm artifacts to their remote sources (e.g., GitHub repositories). This model will serve as the "source of truth" for ownership information.

Additionally, two new npm staging models are added: stg_npm__downloads and stg_npm__manifests. These models provide weekly snapshots of package downloads and the manifest file, respectively, which includes details like dependencies and repository information. The intermediate model then exposes the actual remote source that "owns" each package by extracting the remote from the manifest file for each package.

@vercel Vercel
Copy link

vercel bot commented Nov 26, 2024 •
edited
Loading

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 Nov 26, 2024 4:34pm
oso-www ✅ Ready (Inspect) Visit Preview 💬 Add feedback Nov 26, 2024 4:34pm

oso-prs[bot]
oso-prs bot approved these changes Nov 26, 2024
View reviewed changes
Copy link

@oso-prs oso-prs bot left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Auto-approved! please merge responsibly 😄

@oso-prs
Copy link

oso-prs bot commented Nov 26, 2024 •
edited
Loading

Test deployment for PR #2520 failed on commit 44e33cbd34094c0e27e2ff360190d5114f53a3b3. 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:518:28)
    at ChildProcess.emit (node:domain:489:12)
    at maybeClose (node:internal/child_process:1104:16)
    at Socket.<anonymous> (node:internal/child_process:456:11)
    at Socket.emit (node:events:518:28)
    at Socket.emit (node:domain:489:12)
    at Pipe.<anonymous> (node:net:343:12)

DBT stdout:

16:29:00  Running with dbt=1.8.7
16:29:04  Registered adapter: bigquery=1.8.3
16:29:04  Unable to do partial parsing because saved manifest not found. Starting full parse.
16:29:07  Found 250 models, 132 sources, 509 macros
16:29:07  
16:29:08  Concurrency: 32 threads (target='playground')
16:29:08  
16:29:08  1 of 248 START sql view model pr_2520.int_time_intervals ....................... [RUN]
16:29:08  2 of 248 START sql table model pr_2520.rf4_repos_by_app ........................ [RUN]
16:29:08  3 of 248 START sql incremental model pr_2520.rf4_transactions_window ........... [RUN]
16:29:08  4 of 248 START sql incremental model pr_2520.stg_arbitrum_one__deployers ....... [RUN]
16:29:08  5 of 248 START sql incremental model pr_2520.stg_arbitrum_one__factories ....... [RUN]
16:29:08  6 of 248 START sql incremental model pr_2520.stg_arbitrum_one__proxies ......... [RUN]
16:29:08  7 of 248 START sql incremental model pr_2520.stg_base__deployers ............... [RUN]
16:29:08  8 of 248 START sql incremental model pr_2520.stg_base__factories ............... [RUN]
16:29:08  9 of 248 START sql incremental model pr_2520.stg_base__first_time_addresses .... [RUN]
16:29:08  10 of 248 START sql table model pr_2520.stg_base__potential_bots ............... [RUN]
16:29:08  11 of 248 START sql incremental model pr_2520.stg_base__proxies ................ [RUN]
16:29:08  12 of 248 START sql incremental model pr_2520.stg_deps_dev__dependencies ....... [RUN]
16:29:08  13 of 248 START sql incremental model pr_2520.stg_ethereum__deployers .......... [RUN]
16:29:08  14 of 248 START sql view model pr_2520.stg_ethereum_attestation_service__optimism  [RUN]
16:29:08  15 of 248 START sql view model pr_2520.stg_farcaster__addresses ................ [RUN]
16:29:08  16 of 248 START sql view model pr_2520.stg_farcaster__profiles ................. [RUN]
16:29:08  17 of 248 START sql incremental model pr_2520.stg_frax__deployers .............. [RUN]
16:29:08  18 of 248 START sql incremental model pr_2520.stg_frax__factories .............. [RUN]
16:29:08  19 of 248 START sql incremental model pr_2520.stg_frax__first_time_addresses ... [RUN]
16:29:08  20 of 248 START sql table model pr_2520.stg_frax__potential_bots ............... [RUN]
16:29:08  21 of 248 START sql incremental model pr_2520.stg_frax__proxies ................ [RUN]
16:29:08  22 of 248 START sql view model pr_2520.stg_gitcoin__donations .................. [RUN]
16:29:08  23 of 248 START sql view model pr_2520.stg_gitcoin__matching ................... [RUN]
16:29:08  24 of 248 START sql view model pr_2520.stg_gitcoin__project_groups ............. [RUN]
16:29:08  25 of 248 START sql view model pr_2520.stg_gitcoin__project_lookup ............. [RUN]
16:29:08  26 of 248 START sql table model pr_2520.stg_karma3__globaltrust ................ [RUN]
16:29:08  27 of 248 START sql table model pr_2520.stg_karma3__localtrust ................. [RUN]
16:29:08  28 of 248 START sql view model pr_2520.stg_lens__owners ........................ [RUN]
16:29:08  29 of 248 START sql view model pr_2520.stg_lens__profiles ...................... [RUN]
16:29:08  30 of 248 START sql incremental model pr_2520.stg_metal__deployers ............. [RUN]
16:29:08  31 of 248 START sql incremental model pr_2520.stg_metal__factories ............. [RUN]
16:29:08  32 of 248 START sql incremental model pr_2520.stg_metal__first_time_addresses .. [RUN]
16:29:10  1 of 248 OK created sql view model pr_2520.int_time_intervals .................. [CREATE VIEW (0 processed) in 2.30s]
16:29:10  33 of 248 START sql table model pr_2520.stg_metal__potential_bots .............. [RUN]
16:29:11  16 of 248 OK created sql view model pr_2520.stg_farcaster__profiles ............ [CREATE VIEW (0 processed) in 2.66s]
16:29:11  34 of 248 START sql incremental model pr_2520.stg_metal__proxies ............... [RUN]
16:29:11  23 of 248 OK created sql view model pr_2520.stg_gitcoin__matching .............. [CREATE VIEW (0 processed) in 2.70s]
16:29:11  25 of 248 OK created sql view model pr_2520.stg_gitcoin__project_lookup ........ [CREATE VIEW (0 processed) in 2.71s]
16:29:11  35 of 248 START sql incremental model pr_2520.stg_mode__deployers .............. [RUN]
16:29:11  36 of 248 START sql incremental model pr_2520.stg_mode__factories .............. [RUN]
16:29:11  28 of 248 OK created sql view model pr_2520.stg_lens__owners ................... [CREATE VIEW (0 processed) in 2.71s]
16:29:11  24 of 248 OK created sql view model pr_2520.stg_gitcoin__project_groups ........ [CREATE VIEW (0 processed) in 2.72s]
16:29:11  37 of 248 START sql incremental model pr_2520.stg_mode__first_time_addresses ... [RUN]
16:29:11  38 of 248 START sql table model pr_2520.stg_mode__potential_bots ............... [RUN]
16:29:11  15 of 248 OK created sql view model pr_2520.stg_farcaster__addresses ........... [CREATE VIEW (0 processed) in 2.76s]
16:29:11  22 of 248 OK created sql view model pr_2520.stg_gitcoin__donations ............. [CREATE VIEW (0 processed) in 2.79s]
16:29:11  39 of 248 START sql incremental model pr_2520.stg_mode__proxies ................ [RUN]
16:29:11  14 of 248 OK created sql view model pr_2520.stg_ethereum_attestation_service__optimism  [CREATE VIEW (0 processed) in 2.87s]
16:29:11  29 of 248 OK created sql view model pr_2520.stg_lens__profiles ................. [CREATE VIEW (0 processed) in 2.84s]
16:29:11  40 of 248 START sql view model pr_2520.stg_npm__downloads ...................... [RUN]
16:29:11  41 of 248 START sql view model pr_2520.stg_npm__manifests ...................... [RUN]
16:29:11  42 of 248 START sql view model pr_2520.stg_open_collective__deposits ........... [RUN]
16:29:11  BigQuery adapter: https://console.cloud.google.com/bigquery?project=oso-pull-requests&j=bq:US:3203dc9c-68d2-4342-90ad-b9dbddd1a3ca&page=queryresults
16:29:11  40 of 248 ERROR creating sql view model pr_2520.stg_npm__downloads ............. [ERROR in 0.56s]
16:29:11  43 of 248 START sql view model pr_2520.stg_open_collective__expenses ........... [RUN]
16:29:12  BigQuery adapter: https://console.cloud.google.com/bigquery?project=oso-pull-requests&j=bq:US:b05dfb78-d701-4319-a803-65a9d2dc448d&page=queryresults
16:29:12  41 of 248 ERROR creating sql view model pr_2520.stg_npm__manifests ............. [ERROR in 0.60s]
16:29:12  44 of 248 START sql table model pr_2520.stg_optimism__airdrop_addresses ........ [RUN]
16:29:12  42 of 248 OK created sql view model pr_2520.stg_open_collective__deposits ...... [CREATE VIEW (0 processed) in 0.98s]
16:29:12  45 of 248 START sql incremental model pr_2520.stg_optimism__deployers .......... [RUN]
16:29:12  43 of 248 OK created sql view model pr_2520.stg_open_collective__expenses ...... [CREATE VIEW (0 processed) in 0.76s]
16:29:12  46 of 248 START sql incremental model pr_2520.stg_optimism__factories .......... [RUN]
16:29:12  12 of 248 OK created sql incremental model pr_2520.stg_deps_dev__dependencies .. [MERGE (1.0 rows, 0 processed) in 4.41s]
16:29:12  47 of 248 START sql incremental model pr_2520.stg_optimism__first_time_addresses  [RUN]
16:29:13  2 of 248 OK created sql table model pr_2520.rf4_repos_by_app ................... [CREATE TABLE (821.0 rows, 705.0 KiB processed) in 4.91s]
16:29:13  48 of 248 START sql table model pr_2520.stg_optimism__potential_bots ........... [RUN]
16:29:13  20 of 248 OK created sql table model pr_2520.stg_frax__potential_bots .......... [CREATE TABLE (0.0 rows, 0 processed) in 5.08s]
16:29:13  49 of 248 START sql incremental model pr_2520.stg_optimism__proxies ............ [RUN]
16:29:13  33 of 248 OK created sql table model pr_2520.stg_metal__potential_bots ......... [CREATE TABLE (0.0 rows, 0 processed) in 3.14s]
16:29:13  50 of 248 START sql view model pr_2520.stg_ossd__current_collections ........... [RUN]
16:29:14  50 of 248 OK created sql view model pr_2520.stg_ossd__current_collections ...... [CREATE VIEW (0 processed) in 0.73s]
16:29:14  51 of 248 START sql view model pr_2520.stg_ossd__current_projects .............. [RUN]
16:29:15  51 of 248 OK created sql view model pr_2520.stg_ossd__current_projects ......... [CREATE VIEW (0 processed) in 0.71s]
16:29:15  52 of 248 START sql view model pr_2520.stg_ossd__current_repositories .......... [RUN]
16:29:16  52 of 248 OK created sql view model pr_2520.stg_ossd__current_repositories ..... [CREATE VIEW (0 processed) in 0.81s]
16:29:16  53 of 248 START sql view model pr_2520.stg_ossd__missing_sbom .................. [RUN]
16:29:16  26 of 248 OK created sql table model pr_2520.stg_karma3__globaltrust ........... [CREATE TABLE (24.0m rows, 733.7 MiB processed) in 7.79s]
16:29:16  54 of 248 START sql view model pr_2520.stg_ossd__repository_point_in_time ...... [RUN]
16:29:16  53 of 248 OK created sql view model pr_2520.stg_ossd__missing_sbom ............. [CREATE VIEW (0 processed) in 0.60s]
16:29:16  55 of 248 START sql view model pr_2520.stg_passport__scores .................... [RUN]
16:29:16  38 of 248 OK created sql table model pr_2520.stg_mode__potential_bots .......... [CREATE TABLE (14.0 rows, 5.7 MiB processed) in 5.54s]
16:29:16  56 of 248 START sql incremental model pr_2520.stg_pgn__deployers ............... [RUN]
16:29:17  54 of 248 OK created sql view model pr_2520.stg_ossd__repository_point_in_time . [CREATE VIEW (0 processed) in 0.75s]
16:29:17  57 of 248 START sql incremental model pr_2520.stg_pgn__factories ............... [RUN]
16:29:17  55 of 248 OK created sql view model pr_2520.stg_passport__scores ............... [CREATE VIEW (0 processed) in 0.94s]
16:29:17  58 of 248 START sql incremental model pr_2520.stg_pgn__first_time_addresses .... [RUN]
16:29:18  6 of 248 OK created sql incremental model pr_2520.stg_arbitrum_one__proxies .... [SCRIPT (0 processed) in 9.63s]
16:29:18  59 of 248 START sql table model pr_2520.stg_pgn__potential_bots ................ [RUN]
16:29:18  44 of 248 OK created sql table model pr_2520.stg_optimism__airdrop_addresses ... [CREATE TABLE (611.5k rows, 38.6 MiB processed) in 6.07s]
16:29:18  5 of 248 OK created sql incremental model pr_2520.stg_arbitrum_one__factories .. [SCRIPT (0 processed) in 9.69s]
16:29:18  60 of 248 START sql incremental model pr_2520.stg_pgn__proxies ................. [RUN]
16:29:18  61 of 248 START sql table model pr_2520.stg_utility__calendar .................. [RUN]
16:29:18  8 of 248 OK created sql incremental model pr_2520.stg_base__factories .......... [SCRIPT (0 processed) in 9.92s]
16:29:18  62 of 248 START sql incremental model pr_2520.stg_zora__deployers .............. [RUN]
16:29:18  3 of 248 OK created sql incremental model pr_2520.rf4_transactions_window ...... [MERGE (11.5m rows, 2.6 GiB processed) in 10.12s]
16:29:18  63 of 248 START sql incremental model pr_2520.stg_zora__factories .............. [RUN]
16:29:18  4 of 248 OK created sql incremental model pr_2520.stg_arbitrum_one__deployers .. [SCRIPT (0 processed) in 10.24s]
16:29:18  64 of 248 START sql incremental model pr_2520.stg_zora__first_time_addresses ... [RUN]
16:29:18  18 of 248 OK created sql incremental model pr_2520.stg_frax__factories ......... [SCRIPT (0 processed) in 10.34s]
16:29:18  65 of 248 START sql table model pr_2520.stg_zora__potential_bots ............... [RUN]
16:29:18  30 of 248 OK created sql incremental model pr_2520.stg_metal__deployers ........ [SCRIPT (0 processed) in 10.45s]
16:29:18  66 of 248 START sql incremental model pr_2520.stg_zora__proxies ................ [RUN]
16:29:19  7 of 248 OK created sql incremental model pr_2520.stg_base__deployers .......... [SCRIPT (0 processed) in 10.56s]
16:29:19  67 of 248 START sql view model pr_2520.int_gitcoin_funding_events .............. [RUN]
16:29:19  31 of 248 OK created sql incremental model pr_2520.stg_metal__factories ........ [SCRIPT (0 processed) in 10.57s]
16:29:19  68 of 248 START sql view model pr_2520.int_users ............................... [RUN]
16:29:19  19 of 248 OK created sql incremental model pr_2520.stg_frax__first_time_addresses  [SCRIPT (0 processed) in 10.65s]
16:29:19  69 of 248 START sql view model pr_2520.int_events__open_collective ............. [RUN]
16:29:19  11 of 248 OK created sql incremental model pr_2520.stg_base__proxies ........... [SCRIPT (0 processed) in 10.84s]
16:29:19  70 of 248 START sql view model pr_2520.int_events__dependencies ................ [RUN]
16:29:19  17 of 248 OK created sql incremental model pr_2520.stg_frax__deployers ......... [SCRIPT (0 processed) in 10.84s]
16:29:19  71 of 248 START sql view model pr_2520.int_collections ......................... [RUN]
16:29:19  21 of 248 OK created sql incremental model pr_2520.stg_frax__proxies ........... [SCRIPT (0 processed) in 10.98s]
16:29:19  72 of 248 START sql view model pr_2520.int_projects ............................ [RUN]
16:29:19  32 of 248 OK created sql incremental model pr_2520.stg_metal__first_time_addresses  [SCRIPT (0 processed) in 10.98s]
16:29:19  73 of 248 START sql view model pr_2520.int_projects_by_collection .............. [RUN]
16:29:19  9 of 248 OK created sql incremental model pr_2520.stg_base__first_time_addresses  [SCRIPT (0 processed) in 11.23s]
16:29:19  74 of 248 START sql view model pr_2520.int_artifacts_in_ossd_by_project ........ [RUN]
16:29:19  35 of 248 OK created sql incremental model pr_2520.stg_mode__deployers ......... [SCRIPT (0 processed) in 8.55s]
16:29:19  75 of 248 START sql incremental model pr_2520.stg_github__events ............... [RUN]
16:29:19  36 of 248 OK created sql incremental model pr_2520.stg_mode__factories ......... [SCRIPT (0 processed) in 8.60s]
16:29:19  76 of 248 START sql view model pr_2520.int_point_in_time_from_sources .......... [RUN]
16:29:19  67 of 248 OK created sql view model pr_2520.int_gitcoin_funding_events ......... [CREATE VIEW (0 processed) in 0.89s]
16:29:19  77 of 248 START sql table model pr_2520.rf4_trusted_users ...................... [RUN]
16:29:19  68 of 248 OK created sql view model pr_2520.int_users .......................... [CREATE VIEW (0 processed) in 0.88s]
16:29:19  69 of 248 OK created sql view model pr_2520.int_events__open_collective ........ [CREATE VIEW (0 processed) in 0.83s]
16:29:20  78 of 248 START sql table model pr_2520.users_v1 ............................... [RUN]
16:29:20  70 of 248 OK created sql view model pr_2520.int_events__dependencies ........... [CREATE VIEW (0 processed) in 0.66s]
16:29:20  34 of 248 OK created sql incremental model pr_2520.stg_metal__proxies .......... [SCRIPT (0 processed) in 8.89s]
16:29:20  37 of 248 OK created sql incremental model pr_2520.stg_mode__first_time_addresses  [SCRIPT (0 processed) in 8.90s]
16:29:20  71 of 248 OK created sql view model pr_2520.int_collections .................... [CREATE VIEW (0 processed) in 0.86s]
16:29:20  79 of 248 START sql table model pr_2520.collections_v1 ......................... [RUN]
16:29:20  72 of 248 OK created sql view model pr_2520.int_projects ....................... [CREATE VIEW (0 processed) in 0.91s]
16:29:20  80 of 248 START sql table model pr_2520.projects_v1 ............................ [RUN]
16:29:20  39 of 248 OK created sql incremental model pr_2520.stg_mode__proxies ........... [SCRIPT (0 processed) in 9.19s]
16:29:20  73 of 248 OK created sql view model pr_2520.int_projects_by_collection ......... [CREATE VIEW (0 processed) in 1.08s]
16:29:20  81 of 248 START sql table model pr_2520.projects_by_collection_v1 .............. [RUN]
16:29:20  76 of 248 OK created sql view model pr_2520.int_point_in_time_from_sources ..... [CREATE VIEW (0 processed) in 0.80s]
16:29:20  82 of 248 START sql table model pr_2520.point_in_time_v0 ....................... [RUN]
16:29:20  74 of 248 OK created sql view model pr_2520.int_artifacts_in_ossd_by_project ... [CREATE VIEW (0 processed) in 1.00s]
16:29:20  83 of 248 START sql view model pr_2520.int_gitcoin_project_directory ........... [RUN]
16:29:20  46 of 248 OK created sql incremental model pr_2520.stg_optimism__factories ..... [SCRIPT (0 processed) in 8.12s]
16:29:20  45 of 248 OK created sql incremental model pr_2520.stg_optimism__deployers ..... [SCRIPT (0 processed) in 8.42s]
16:29:21  59 of 248 OK created sql table model pr_2520.stg_pgn__potential_bots ........... [CREATE TABLE (0.0 rows, 11.8 KiB processed) in 3.25s]
16:29:21  83 of 248 OK created sql view model pr_2520.int_gitcoin_project_directory ...... [CREATE VIEW (0 processed) in 0.84s]
16:29:21  47 of 248 OK created sql incremental model pr_2520.stg_optimism__first_time_addresses  [SCRIPT (0 processed) in 8.66s]
16:29:21  49 of 248 OK created sql incremental model pr_2520.stg_optimism__proxies ....... [SCRIPT (0 processed) in 8.15s]
16:29:23  80 of 248 OK created sql table model pr_2520.projects_v1 ....................... [CREATE TABLE (9.0 rows, 762.0 Bytes processed) in 2.77s]
16:29:23  84 of 248 START sql view model pr_2520.int_oss_funding_grants_to_project ....... [RUN]
16:29:23  82 of 248 OK created sql table model pr_2520.point_in_time_v0 .................. [CREATE TABLE (3.0k rows, 38.9 KiB processed) in 2.65s]
16:29:23  81 of 248 OK created sql table model pr_2520.projects_by_collection_v1 ......... [CREATE TABLE (73.0 rows, 77.1 KiB processed) in 3.02s]
16:29:23  13 of 248 OK created sql incremental model pr_2520.stg_ethereum__deployers ..... [SCRIPT (0 processed) in 15.30s]
16:29:24  84 of 248 OK created sql view model pr_2520.int_oss_funding_grants_to_project .. [CREATE VIEW (0 processed) in 1.08s]
16:29:24  48 of 248 OK created sql table model pr_2520.stg_optimism__potential_bots ...... [CREATE TABLE (1.2k rows, 1.9 GiB processed) in 10.93s]
16:29:24  79 of 248 OK created sql table model pr_2520.collections_v1 .................... [CREATE TABLE (28.0 rows, 1.4 KiB processed) in 4.20s]
16:29:24  10 of 248 OK created sql table model pr_2520.stg_base__potential_bots .......... [CREATE TABLE (11.4k rows, 5.9 GiB processed) in 16.12s]
16:29:24  57 of 248 OK created sql incremental model pr_2520.stg_pgn__factories .......... [SCRIPT (0 processed) in 7.81s]
16:29:25  56 of 248 OK created sql incremental model pr_2520.stg_pgn__deployers .......... [SCRIPT (0 processed) in 8.35s]
16:29:25  58 of 248 OK created sql incremental model pr_2520.stg_pgn__first_time_addresses  [SCRIPT (0 processed) in 8.04s]
16:29:25  60 of 248 OK created sql incremental model pr_2520.stg_pgn__proxies ............ [SCRIPT (0 processed) in 7.66s]
16:29:26  62 of 248 OK created sql incremental model pr_2520.stg_zora__deployers ......... [SCRIPT (0 processed) in 7.62s]
16:29:26  85 of 248 START sql table model pr_2520.int_deployers .......................... [RUN]
16:29:26  86 of 248 START sql view model pr_2520.int_deployers_by_project ................ [RUN]
16:29:26  64 of 248 OK created sql incremental model pr_2520.stg_zora__first_time_addresses  [SCRIPT (0 processed) in 7.81s]
16:29:26  87 of 248 START sql view model pr_2520.int_first_time_addresses ................ [RUN]
16:29:26  78 of 248 OK created sql table model pr_2520.users_v1 .......................... [CREATE TABLE (1.2m rows, 97.1 MiB processed) in 6.70s]
16:29:26  66 of 248 OK created sql incremental model pr_2520.stg_zora__proxies ........... [SCRIPT (0 processed) in 7.88s]
16:29:26  88 of 248 START sql view model pr_2520.int_proxies ............................. [RUN]
16:29:26  89 of 248 START sql table model pr_2520.int_safes .............................. [RUN]
16:29:26  63 of 248 OK created sql incremental model pr_2520.stg_zora__factories ......... [SCRIPT (0 processed) in 8.34s]
16:29:26  90 of 248 START sql table model pr_2520.int_factories .......................... [RUN]
16:29:26  75 of 248 OK created sql incremental model pr_2520.stg_github__events .......... [SCRIPT (0 processed) in 7.15s]
16:29:27  91 of 248 START sql view model pr_2520.stg_github__comments .................... [RUN]
16:29:27  92 of 248 START sql view model pr_2520.stg_github__issues ...................... [RUN]
16:29:27  93 of 248 START sql view model pr_2520.stg_github__pull_request_merge_events ... [RUN]
16:29:27  94 of 248 START sql view model pr_2520.stg_github__pull_requests ............... [RUN]
16:29:27  95 of 248 START sql view model pr_2520.stg_github__push_events ................. [RUN]
16:29:27  96 of 248 START sql view model pr_2520.stg_github__releases .................... [RUN]
16:29:27  97 of 248 START sql view model pr_2520.stg_github__stars_and_forks ............. [RUN]
16:29:27  87 of 248 OK created sql view model pr_2520.int_first_time_addresses ........... [CREATE VIEW (0 processed) in 1.00s]
16:29:27  98 of 248 START sql view model pr_2520.int_artifacts_by_address ................ [RUN]
16:29:27  86 of 248 OK created sql view model pr_2520.int_deployers_by_project ........... [CREATE VIEW (0 processed) in 1.55s]
16:29:27  88 of 248 OK created sql view model pr_2520.int_proxies ........................ [CREATE VIEW (0 processed) in 0.79s]
16:29:28  97 of 248 OK created sql view model pr_2520.stg_github__stars_and_forks ........ [CREATE VIEW (0 processed) in 0.96s]
16:29:28  91 of 248 OK created sql view model pr_2520.stg_github__comments ............... [CREATE VIEW (0 processed) in 1.04s]
16:29:28  93 of 248 OK created sql view model pr_2520.stg_github__pull_request_merge_events  [CREATE VIEW (0 processed) in 1.05s]
16:29:28  92 of 248 OK created sql view model pr_2520.stg_github__issues ................. [CREATE VIEW (0 processed) in 1.09s]
16:29:28  98 of 248 OK created sql view model pr_2520.int_artifacts_by_address ........... [CREATE VIEW (0 processed) in 0.63s]
16:29:28  96 of 248 OK created sql view model pr_2520.stg_github__releases ............... [CREATE VIEW (0 processed) in 1.19s]
16:29:28  94 of 248 OK created sql view model pr_2520.stg_github__pull_requests .......... [CREATE VIEW (0 processed) in 1.25s]
16:29:28  99 of 248 START sql table model pr_2520.int_events_aux_issues .................. [RUN]
16:29:28  100 of 248 START sql view model pr_2520.int_github_pr_issue_threads ............ [RUN]
16:29:28  95 of 248 OK created sql view model pr_2520.stg_github__push_events ............ [CREATE VIEW (0 processed) in 1.31s]
16:29:28  101 of 248 START sql view model pr_2520.stg_github__commits .................... [RUN]
16:29:28  85 of 248 OK created sql table model pr_2520.int_deployers ..................... [CREATE TABLE (0.0 rows, 0 processed) in 2.76s]
16:29:28  65 of 248 OK created sql table model pr_2520.stg_zora__potential_bots .......... [CREATE TABLE (1.8k rows, 1.0 GiB processed) in 10.05s]
16:29:28  102 of 248 START sql view model pr_2520.int_potential_bots ..................... [RUN]
16:29:29  100 of 248 OK created sql view model pr_2520.int_github_pr_issue_threads ....... [CREATE VIEW (0 processed) in 0.82s]
16:29:29  101 of 248 OK created sql view model pr_2520.stg_github__commits ............... [CREATE VIEW (0 processed) in 0.85s]
16:29:29  103 of 248 START sql view model pr_2520.stg_github__distinct_main_commits ...... [RUN]
16:29:29  102 of 248 OK created sql view model pr_2520.int_potential_bots ................ [CREATE VIEW (0 processed) in 0.60s]
16:29:29  104 of 248 START sql view model pr_2520.int_addresses_by_user .................. [RUN]
16:29:29  90 of 248 OK created sql table model pr_2520.int_factories ..................... [CREATE TABLE (0.0 rows, 0 processed) in 2.75s]
16:29:29  105 of 248 START sql view model pr_2520.int_derived_contracts .................. [RUN]
16:29:30  61 of 248 OK created sql table model pr_2520.stg_utility__calendar ............. [CREATE TABLE (31.8k rows, 0 processed) in 12.16s]
16:29:30  106 of 248 START sql incremental model pr_2520.stg_base__addresses_gas_and_usage  [RUN]
16:29:30  107 of 248 START sql incremental model pr_2520.stg_frax__addresses_gas_and_usage  [RUN]
16:29:30  108 of 248 START sql incremental model pr_2520.stg_metal__addresses_gas_and_usage  [RUN]
16:29:30  109 of 248 START sql incremental model pr_2520.stg_mode__addresses_gas_and_usage  [RUN]
16:29:30  110 of 248 START sql incremental model pr_2520.stg_optimism__addresses_gas_and_usage  [RUN]
16:29:30  111 of 248 START sql incremental model pr_2520.stg_pgn__addresses_gas_and_usage  [RUN]
16:29:30  112 of 248 START sql incremental model pr_2520.stg_zora__addresses_gas_and_usage  [RUN]
16:29:30  103 of 248 OK created sql view model pr_2520.stg_github__distinct_main_commits . [CREATE VIEW (0 processed) in 1.12s]
16:29:30  89 of 248 OK created sql table model pr_2520.int_safes ......................... [CREATE TABLE (0.0 rows, 0 processed) in 3.77s]
16:29:30  104 of 248 OK created sql view model pr_2520.int_addresses_by_user ............. [CREATE VIEW (0 processed) in 1.12s]
16:29:30  113 of 248 START sql view model pr_2520.stg_github__distinct_commits_resolved_mergebot  [RUN]
16:29:30  105 of 248 OK created sql view model pr_2520.int_derived_contracts ............. [CREATE VIEW (0 processed) in 0.95s]
16:29:30  114 of 248 START sql view model pr_2520.int_superchain_trusted_users ........... [RUN]
16:29:30  115 of 248 START sql table model pr_2520.contracts_v0 .......................... [RUN]
16:29:30  116 of 248 START sql table model pr_2520.int_contracts_by_project .............. [RUN]
16:29:30  117 of 248 START sql table model pr_2520.rf4_agora_contract_discovery .......... [RUN]
16:29:30  118 of 248 START sql table model pr_2520.rf4_oso_contract_discovery ............ [RUN]
16:29:31  99 of 248 OK created sql table model pr_2520.int_events_aux_issues ............. [CREATE TABLE (0.0 rows, 0 processed) in 2.98s]
16:29:31  119 of 248 START sql table model pr_2520.timeseries_events_aux_issues_by_artifact_v0  [RUN]
16:29:31  77 of 248 OK created sql table model pr_2520.rf4_trusted_users ................. [CREATE TABLE (3.0m rows, 214.7 MiB processed) in 11.73s]
16:29:31  113 of 248 OK created sql view model pr_2520.stg_github__distinct_commits_resolved_mergebot  [CREATE VIEW (0 processed) in 0.96s]
16:29:31  120 of 248 START sql table model pr_2520.int_events__github .................... [RUN]
16:29:32  114 of 248 OK created sql view model pr_2520.int_superchain_trusted_users ...... [CREATE VIEW (0 processed) in 1.59s]
16:29:33  119 of 248 OK created sql table model pr_2520.timeseries_events_aux_issues_by_artifact_v0  [CREATE TABLE (0.0 rows, 0 processed) in 2.46s]
16:29:34  115 of 248 OK created sql table model pr_2520.contracts_v0 ..................... [CREATE TABLE (0.0 rows, 0 processed) in 3.45s]
16:29:34  27 of 248 OK created sql table model pr_2520.stg_karma3__localtrust ............ [CREATE TABLE (237.0m rows, 8.8 GiB processed) in 26.32s]
16:29:34  117 of 248 OK created sql table model pr_2520.rf4_agora_contract_discovery ..... [CREATE TABLE (3.9k rows, 693.7 KiB processed) in 4.12s]
16:29:35  120 of 248 OK created sql table model pr_2520.int_events__github ............... [CREATE TABLE (0.0 rows, 35.9 KiB processed) in 3.64s]
16:29:35  116 of 248 OK created sql table model pr_2520.int_contracts_by_project ......... [CREATE TABLE (366.0 rows, 21.6 KiB processed) in 4.82s]
16:29:35  121 of 248 START sql view model pr_2520.int_all_artifacts ...................... [RUN]
16:29:35  122 of 248 START sql table model pr_2520.rf4_network_share ..................... [RUN]
16:29:36  121 of 248 OK created sql view model pr_2520.int_all_artifacts ................. [CREATE VIEW (0 processed) in 0.83s]
16:29:36  123 of 248 START sql incremental model pr_2520.int_arbitrum_one_traces ......... [RUN]
16:29:36  124 of 248 START sql incremental model pr_2520.int_arbitrum_one_transactions ... [RUN]
16:29:36  125 of 248 START sql view model pr_2520.int_artifact_types ..................... [RUN]
16:29:36  126 of 248 START sql view model pr_2520.int_artifacts_by_collection ............ [RUN]
16:29:36  127 of 248 START sql view model pr_2520.int_artifacts_by_project ............... [RUN]
16:29:36  128 of 248 START sql incremental model pr_2520.int_base_traces ................. [RUN]
16:29:36  129 of 248 START sql incremental model pr_2520.int_base_transactions ........... [RUN]
16:29:36  130 of 248 START sql incremental model pr_2520.int_frax_traces ................. [RUN]
16:29:36  131 of 248 START sql incremental model pr_2520.int_frax_transactions ........... [RUN]
16:29:36  132 of 248 START sql incremental model pr_2520.int_metal_traces ................ [RUN]
16:29:36  133 of 248 START sql incremental model pr_2520.int_metal_transactions .......... [RUN]
16:29:36  134 of 248 START sql incremental model pr_2520.int_mode_traces ................. [RUN]
16:29:36  135 of 248 START sql incremental model pr_2520.int_mode_transactions ........... [RUN]
16:29:36  136 of 248 START sql incremental model pr_2520.int_optimism_traces ............. [RUN]
16:29:36  137 of 248 START sql incremental model pr_2520.int_optimism_transactions ....... [RUN]
16:29:36  138 of 248 START sql incremental model pr_2520.int_pgn_traces .................. [RUN]
16:29:36  139 of 248 START sql incremental model pr_2520.int_pgn_transactions ............ [RUN]
16:29:36  140 of 248 START sql incremental model pr_2520.int_zora_traces ................. [RUN]
16:29:36  141 of 248 START sql incremental model pr_2520.int_zora_transactions ........... [RUN]
16:29:37  107 of 248 OK created sql incremental model pr_2520.stg_frax__addresses_gas_and_usage  [SCRIPT (0 processed) in 7.02s]
16:29:37  112 of 248 OK created sql incremental model pr_2520.stg_zora__addresses_gas_and_usage  [SCRIPT (0 processed) in 7.17s]
16:29:37  111 of 248 OK created sql incremental model pr_2520.stg_pgn__addresses_gas_and_usage  [SCRIPT (0 processed) in 7.53s]
16:29:37  109 of 248 OK created sql incremental model pr_2520.stg_mode__addresses_gas_and_usage  [SCRIPT (0 processed) in 7.61s]
16:29:38  126 of 248 OK created sql view model pr_2520.int_artifacts_by_collection ....... [CREATE VIEW (0 processed) in 1.65s]
16:29:38  106 of 248 OK created sql incremental model pr_2520.stg_base__addresses_gas_and_usage  [SCRIPT (0 processed) in 7.80s]
16:29:38  142 of 248 START sql table model pr_2520.artifacts_by_collection_v1 ............ [RUN]
16:29:38  125 of 248 OK created sql view model pr_2520.int_artifact_types ................ [CREATE VIEW (0 processed) in 1.72s]
16:29:38  127 of 248 OK created sql view model pr_2520.int_artifacts_by_project .......... [CREATE VIEW (0 processed) in 2.03s]
16:29:38  143 of 248 START sql table model pr_2520.artifacts_by_project_v1 ............... [RUN]
16:29:38  108 of 248 OK created sql incremental model pr_2520.stg_metal__addresses_gas_and_usage  [SCRIPT (0 processed) in 8.19s]
16:29:38  110 of 248 OK created sql incremental model pr_2520.stg_optimism__addresses_gas_and_usage  [SCRIPT (0 processed) in 8.23s]
16:29:38  144 of 248 START sql view model pr_2520.int_addresses_usage .................... [RUN]
16:29:39  144 of 248 OK created sql view model pr_2520.int_addresses_usage ............... [CREATE VIEW (0 processed) in 0.66s]
16:29:39  118 of 248 OK created sql table model pr_2520.rf4_oso_contract_discovery ....... [CREATE TABLE (327.0 rows, 427.2 KiB processed) in 8.59s]
16:29:39  145 of 248 START sql table model pr_2520.rf4_contracts_by_app .................. [RUN]
16:29:41  122 of 248 OK created sql table model pr_2520.rf4_network_share ................ [CREATE TABLE (412.1k rows, 2.3 GiB processed) in 5.74s]
16:29:42  145 of 248 OK created sql table model pr_2520.rf4_contracts_by_app ............. [CREATE TABLE (3.1k rows, 617.6 KiB processed) in 2.87s]
16:29:42  146 of 248 START sql table model pr_2520.rf4_transactions_by_app ............... [RUN]
16:29:43  142 of 248 OK created sql table model pr_2520.artifacts_by_collection_v1 ....... [CREATE TABLE (9.1k rows, 282.1 KiB processed) in 4.97s]
16:29:43  143 of 248 OK created sql table model pr_2520.artifacts_by_project_v1 .......... [CREATE TABLE (1.4k rows, 205.1 KiB processed) in 5.16s]
16:29:43  147 of 248 START sql view model pr_2520.int_code_metric__time_to_first_response_days_average  [RUN]
16:29:43  148 of 248 START sql view model pr_2520.int_code_metric__time_to_merge_days_average  [RUN]
16:29:43  149 of 248 START sql table model pr_2520.rf4_4337_events ....................... [RUN]
16:29:44  148 of 248 OK created sql view model pr_2520.int_code_metric__time_to_merge_days_average  [CREATE VIEW (0 processed) in 0.82s]
16:29:44  147 of 248 OK created sql view model pr_2520.int_code_metric__time_to_first_response_days_average  [CREATE VIEW (0 processed) in 0.82s]
16:29:44  123 of 248 OK created sql incremental model pr_2520.int_arbitrum_one_traces .... [SCRIPT (0 processed) in 8.29s]
16:29:45  140 of 248 OK created sql incremental model pr_2520.int_zora_traces ............ [SCRIPT (0 processed) in 8.54s]
16:29:45  124 of 248 OK created sql incremental model pr_2520.int_arbitrum_one_transactions  [SCRIPT (0 processed) in 8.99s]
16:29:45  150 of 248 START sql incremental model pr_2520.int_arbitrum_one_contract_invocation_events  [RUN]
16:29:45  139 of 248 OK created sql incremental model pr_2520.int_pgn_transactions ....... [SCRIPT (0 processed) in 9.16s]
16:29:45  151 of 248 START sql incremental model pr_2520.int_pgn_contract_invocation_events  [RUN]
16:29:45  137 of 248 OK created sql incremental model pr_2520.int_optimism_transactions .. [SCRIPT (0 processed) in 9.22s]
16:29:45  141 of 248 OK created sql incremental model pr_2520.int_zora_transactions ...... [SCRIPT (0 processed) in 9.22s]
16:29:45  152 of 248 START sql incremental model pr_2520.int_optimism_contract_invocation_events  [RUN]
16:29:45  153 of 248 START sql incremental model pr_2520.int_zora_contract_invocation_events  [RUN]
16:29:45  131 of 248 OK created sql incremental model pr_2520.int_frax_transactions ...... [SCRIPT (0 processed) in 9.44s]
16:29:45  154 of 248 START sql incremental model pr_2520.int_frax_contract_invocation_events  [RUN]
16:29:46  129 of 248 OK created sql incremental model pr_2520.int_base_transactions ...... [SCRIPT (0 processed) in 9.57s]
16:29:46  155 of 248 START sql incremental model pr_2520.int_base_contract_invocation_events  [RUN]
16:29:46  135 of 248 OK created sql incremental model pr_2520.int_mode_transactions ...... [SCRIPT (0 processed) in 9.69s]
16:29:46  156 of 248 START sql incremental model pr_2520.int_mode_contract_invocation_events  [RUN]
16:29:46  128 of 248 OK created sql incremental model pr_2520.int_base_traces ............ [SCRIPT (0 processed) in 9.76s]
16:29:46  133 of 248 OK created sql incremental model pr_2520.int_metal_transactions ..... [SCRIPT (0 processed) in 9.76s]
16:29:46  157 of 248 START sql incremental model pr_2520.int_metal_contract_invocation_events  [RUN]
16:29:46  132 of 248 OK created sql incremental model pr_2520.int_metal_traces ........... [SCRIPT (0 processed) in 9.92s]
16:29:46  138 of 248 OK created sql incremental model pr_2520.int_pgn_traces ............. [SCRIPT (0 processed) in 10.12s]
16:29:46  134 of 248 OK created sql incremental model pr_2520.int_mode_traces ............ [SCRIPT (0 processed) in 10.32s]
16:29:46  149 of 248 OK created sql table model pr_2520.rf4_4337_events .................. [CREATE TABLE (0.0 rows, 123.0 KiB processed) in 3.30s]
16:29:48  136 of 248 OK created sql incremental model pr_2520.int_optimism_traces ........ [SCRIPT (0 processed) in 11.96s]
16:29:48  146 of 248 OK created sql table model pr_2520.rf4_transactions_by_app .......... [CREATE TABLE (3.5m rows, 2.2 GiB processed) in 6.41s]
16:29:48  158 of 248 START sql table model pr_2520.rf4_onchain_eligibility_checks ........ [RUN]
16:29:49  130 of 248 OK created sql incremental model pr_2520.int_frax_traces ............ [SCRIPT (0 processed) in 12.99s]
16:29:52  150 of 248 OK created sql incremental model pr_2520.int_arbitrum_one_contract_invocation_events  [SCRIPT (0 processed) in 7.47s]
16:29:52  153 of 248 OK created sql incremental model pr_2520.int_zora_contract_invocation_events  [SCRIPT (0 processed) in 7.20s]
16:29:53  152 of 248 OK created sql incremental model pr_2520.int_optimism_contract_invocation_events  [SCRIPT (0 processed) in 7.30s]
16:29:53  151 of 248 OK created sql incremental model pr_2520.int_pgn_contract_invocation_events  [SCRIPT (0 processed) in 7.38s]
16:29:53  154 of 248 OK created sql incremental model pr_2520.int_frax_contract_invocation_events  [SCRIPT (0 processed) in 7.21s]
16:29:53  156 of 248 OK created sql incremental model pr_2520.int_mode_contract_invocation_events  [SCRIPT (0 processed) in 7.26s]
16:29:53  157 of 248 OK created sql incremental model pr_2520.int_metal_contract_invocation_events  [SCRIPT (0 processed) in 7.26s]
16:29:54  155 of 248 OK created sql incremental model pr_2520.int_base_contract_invocation_events  [SCRIPT (0 processed) in 8.59s]
16:29:54  159 of 248 START sql table model pr_2520.int_events__blockchain ................ [RUN]
16:29:57  159 of 248 OK created sql table model pr_2520.int_events__blockchain ........... [CREATE TABLE (0.0 rows, 0 processed) in 2.80s]
16:29:57  160 of 248 START sql table model pr_2520.int_events ............................ [RUN]
16:30:00  158 of 248 OK created sql table model pr_2520.rf4_onchain_eligibility_checks ... [CREATE TABLE (462.0 rows, 396.0 MiB processed) in 11.73s]
16:30:44  160 of 248 OK created sql table model pr_2520.int_events ....................... [CREATE TABLE (6.1m rows, 1.6 GiB processed) in 47.19s]
16:30:44  161 of 248 START sql table model pr_2520.event_types_v1 ........................ [RUN]
16:30:44  162 of 248 START sql view model pr_2520.int_artifacts_by_user .................. [RUN]
16:30:44  163 of 248 START sql view model pr_2520.int_artifacts_history .................. [RUN]
16:30:44  164 of 248 START sql table model pr_2520.int_events_daily_to_artifact .......... [RUN]
16:30:44  165 of 248 START sql view model pr_2520.int_events_to_project .................. [RUN]
16:30:44  166 of 248 START sql table model pr_2520.int_funding_metrics_by_project ........ [RUN]
16:30:44  167 of 248 START sql table model pr_2520.oso_events_v0 ......................... [RUN]
16:30:44  168 of 248 START sql view model pr_2520.superchain_metric__daily_active_addresses_avg_6_months  [RUN]
16:30:44  169 of 248 START sql view model pr_2520.superchain_metric__gas_fees_sum_6_months  [RUN]
16:30:44  170 of 248 START sql view model pr_2520.superchain_metric__monthly_active_addresses_avg_6_months  [RUN]
16:30:44  171 of 248 START sql view model pr_2520.superchain_metric__transactions_sum_6_months  [RUN]
16:30:44  172 of 248 START sql view model pr_2520.superchain_metric__trusted_daily_active_users_avg_6_months  [RUN]
16:30:44  173 of 248 START sql view model pr_2520.superchain_metric__trusted_monthly_active_users_avg_6_months  [RUN]
16:30:44  174 of 248 START sql view model pr_2520.superchain_metric__trusted_transactions_sum_6_months  [RUN]
16:30:44  175 of 248 START sql view model pr_2520.superchain_metric__trusted_users_onboarded_sum_6_months  [RUN]
16:30:44  176 of 248 START sql table model pr_2520.timeseries_events_by_artifact_v0 ...... [RUN]
16:30:46  162 of 248 OK created sql view model pr_2520.int_artifacts_by_user ............. [CREATE VIEW (0 processed) in 1.34s]
16:30:46  177 of 248 START sql table model pr_2520.artifacts_by_user_v1 .................. [RUN]
16:30:46  163 of 248 OK created sql view model pr_2520.int_artifacts_history ............. [CREATE VIEW (0 processed) in 1.40s]
16:30:46  178 of 248 START sql view model pr_2520.int_artifacts .......................... [RUN]
16:30:46  169 of 248 OK created sql view model pr_2520.superchain_metric__gas_fees_sum_6_months  [CREATE VIEW (0 processed) in 1.52s]
16:30:46  170 of 248 OK created sql view model pr_2520.superchain_metric__monthly_active_addresses_avg_6_months  [CREATE VIEW (0 processed) in 1.53s]
16:30:46  168 of 248 OK created sql view model pr_2520.superchain_metric__daily_active_addresses_avg_6_months  [CREATE VIEW (0 processed) in 1.66s]
16:30:46  171 of 248 OK created sql view model pr_2520.superchain_metric__transactions_sum_6_months  [CREATE VIEW (0 processed) in 1.70s]
16:30:46  175 of 248 OK created sql view model pr_2520.superchain_metric__trusted_users_onboarded_sum_6_months  [CREATE VIEW (0 processed) in 1.72s]
16:30:46  173 of 248 OK created sql view model pr_2520.superchain_metric__trusted_monthly_active_users_avg_6_months  [CREATE VIEW (0 processed) in 1.74s]
16:30:46  174 of 248 OK created sql view model pr_2520.superchain_metric__trusted_transactions_sum_6_months  [CREATE VIEW (0 processed) in 1.96s]
16:30:46  172 of 248 OK created sql view model pr_2520.superchain_metric__trusted_daily_active_users_avg_6_months  [CREATE VIEW (0 processed) in 2.05s]
16:30:46  179 of 248 START sql view model pr_2520.int_timeseries_superchain_metrics__all . [RUN]
16:30:47  178 of 248 OK created sql view model pr_2520.int_artifacts ..................... [CREATE VIEW (0 processed) in 1.04s]
16:30:47  180 of 248 START sql table model pr_2520.artifacts_v1 .......................... [RUN]
16:30:48  179 of 248 OK created sql view model pr_2520.int_timeseries_superchain_metrics__all  [CREATE VIEW (0 processed) in 1.19s]
16:30:48  165 of 248 OK created sql view model pr_2520.int_events_to_project ............. [CREATE VIEW (0 processed) in 3.75s]
16:30:48  181 of 248 START sql table model pr_2520.events_daily_to_artifact .............. [RUN]
16:30:48  182 of 248 START sql table model pr_2520.events_daily_to_project ............... [RUN]
16:30:48  183 of 248 START sql table model pr_2520.events_daily_to_project_by_source ..... [RUN]
16:30:48  184 of 248 START sql view model pr_2520.int_addresses_to_project ............... [RUN]
16:30:48  185 of 248 START sql view model pr_2520.int_contributors_to_project ............ [RUN]
16:30:48  186 of 248 START sql view model pr_2520.int_events_daily_to_project ............ [RUN]
16:30:48  187 of 248 START sql view model pr_2520.int_events_to_collection ............... [RUN]
16:30:48  188 of 248 START sql table model pr_2520.int_repo_metrics_by_project ........... [RUN]
16:30:49  185 of 248 OK created sql view model pr_2520.int_contributors_to_project ....... [CREATE VIEW (0 processed) in 1.21s]
16:30:49  184 of 248 OK created sql view model pr_2520.int_addresses_to_project .......... [CREATE VIEW (0 processed) in 1.31s]
16:30:49  189 of 248 START sql view model pr_2520.int_address_rfm_segments_by_project .... [RUN]
16:30:49  190 of 248 START sql view model pr_2520.int_addresses_daily_activity ........... [RUN]
16:30:49  187 of 248 OK created sql view model pr_2520.int_events_to_collection .......... [CREATE VIEW (0 processed) in 1.41s]
16:30:49  191 of 248 START sql table model pr_2520.events_daily_to_collection ............ [RUN]
16:30:49  192 of 248 START sql table model pr_2520.events_daily_to_collection_by_source .. [RUN]
16:30:50  186 of 248 OK created sql view model pr_2520.int_events_daily_to_project ....... [CREATE VIEW (0 processed) in 2.16s]
16:30:50  193 of 248 START sql view model pr_2520.int_code_metric__active_developers ..... [RUN]
16:30:50  194 of 248 START sql view model pr_2520.int_code_metric__commits_prs_issues .... [RUN]
16:30:50  195 of 248 START sql view model pr_2520.int_code_metric__contributors .......... [RUN]
16:30:50  196 of 248 START sql view model pr_2520.int_code_metric__new_contributors ...... [RUN]
16:30:50  197 of 248 START sql view model pr_2520.int_developer_status_monthly_by_project  [RUN]
16:30:50  198 of 248 START sql view model pr_2520.int_events_alltime_to_project .......... [RUN]
16:30:50  199 of 248 START sql view model pr_2520.int_events_monthly_to_project .......... [RUN]
16:30:50  200 of 248 START sql view model pr_2520.int_first_last_event_by_artifact ....... [RUN]
16:30:50  201 of 248 START sql table model pr_2520.int_onchain_metric__active_addresses .. [RUN]
16:30:50  202 of 248 START sql table model pr_2520.int_onchain_metric__active_contracts .. [RUN]
16:30:50  203 of 248 START sql table model pr_2520.int_onchain_metric__days_since_first_transaction  [RUN]
16:30:50  204 of 248 START sql table model pr_2520.int_onchain_metric__gas_fees .......... [RUN]
16:30:50  205 of 248 START sql table model pr_2520.int_onchain_metric__high_low_activity_addresses  [RUN]
16:30:50  206 of 248 START sql table model pr_2520.int_onchain_metric__multi_project_addresses  [RUN]
16:30:50  207 of 248 START sql table model pr_2520.int_onchain_metric__new_addresses ..... [RUN]
16:30:50  208 of 248 START sql table model pr_2520.int_onchain_metric__returning_addresses  [RUN]
16:30:50  209 of 248 START sql table model pr_2520.int_onchain_metric__transactions ...... [RUN]
16:30:51  190 of 248 OK created sql view model pr_2520.int_addresses_daily_activity ...... [CREATE VIEW (0 processed) in 1.22s]
16:30:51  189 of 248 OK created sql view model pr_2520.int_address_rfm_segments_by_project  [CREATE VIEW (0 processed) in 1.57s]
16:30:51  210 of 248 START sql table model pr_2520.int_timeseries_code_metrics__developers  [RUN]
16:30:51  211 of 248 START sql view model pr_2520.int_active_addresses_daily_to_project .. [RUN]
16:30:52  161 of 248 OK created sql table model pr_2520.event_types_v1 ................... [CREATE TABLE (3.0 rows, 43.4 MiB processed) in 7.70s]
16:30:52  212 of 248 START sql view model pr_2520.int_active_addresses_monthly_to_project  [RUN]
16:30:52  194 of 248 OK created sql view model pr_2520.int_code_metric__commits_prs_issues  [CREATE VIEW (0 processed) in 1.70s]
16:30:52  213 of 248 START sql view model pr_2520.int_address_totals_by_project .......... [RUN]
16:30:52  200 of 248 OK created sql view model pr_2520.int_first_last_event_by_artifact .. [CREATE VIEW (0 processed) in 1.79s]
16:30:52  198 of 248 OK created sql view model pr_2520.int_events_alltime_to_project ..... [CREATE VIEW (0 processed) in 1.88s]
16:30:52  193 of 248 OK created sql view model pr_2520.int_code_metric__active_developers  [CREATE VIEW (0 processed) in 1.91s]
16:30:52  197 of 248 OK created sql view model pr_2520.int_developer_status_monthly_by_project  [CREATE VIEW (0 processed) in 1.92s]
16:30:52  196 of 248 OK created sql view model pr_2520.int_code_metric__new_contributors . [CREATE VIEW (0 processed) in 1.95s]
16:30:52  195 of 248 OK created sql view model pr_2520.int_code_metric__contributors ..... [CREATE VIEW (0 processed) in 2.01s]
16:30:52  211 of 248 OK created sql view model pr_2520.int_active_addresses_daily_to_project  [CREATE VIEW (0 processed) in 1.25s]
16:30:53  199 of 248 OK created sql view model pr_2520.int_events_monthly_to_project ..... [CREATE VIEW (0 processed) in 2.37s]
16:30:53  214 of 248 START sql view model pr_2520.int_code_metric__bus_factor ............ [RUN]
16:30:53  212 of 248 OK created sql view model pr_2520.int_active_addresses_monthly_to_project  [CREATE VIEW (0 processed) in 1.08s]
16:30:53  213 of 248 OK created sql view model pr_2520.int_address_totals_by_project ..... [CREATE VIEW (0 processed) in 1.10s]
16:30:54  176 of 248 OK created sql table model pr_2520.timeseries_events_by_artifact_v0 . [CREATE TABLE (6.1m rows, 986.9 MiB processed) in 9.47s]
16:30:54  214 of 248 OK created sql view model pr_2520.int_code_metric__bus_factor ....... [CREATE VIEW (0 processed) in 1.36s]
16:30:55  167 of 248 OK created sql table model pr_2520.oso_events_v0 .................... [CREATE TABLE (0.0 rows, 1.9 GiB processed) in 11.13s]
16:30:57  177 of 248 OK created sql table model pr_2520.artifacts_by_user_v1 ............. [CREATE TABLE (179.3k rows, 699.7 MiB processed) in 11.20s]
16:30:57  182 of 248 OK created sql table model pr_2520.events_daily_to_project .......... [CREATE TABLE (0.0 rows, 402.5 MiB processed) in 9.53s]
16:30:57  215 of 248 START sql table model pr_2520.events_monthly_to_project ............. [RUN]
16:30:57  216 of 248 START sql table model pr_2520.events_weekly_to_project .............. [RUN]
16:30:58  192 of 248 OK created sql table model pr_2520.events_daily_to_collection_by_source  [CREATE TABLE (0.0 rows, 501.0 MiB processed) in 8.53s]
16:30:58  217 of 248 START sql table model pr_2520.events_monthly_to_collection_by_source  [RUN]
16:30:58  218 of 248 START sql table model pr_2520.events_weekly_to_collection_by_source . [RUN]
16:30:58  181 of 248 OK created sql table model pr_2520.events_daily_to_artifact ......... [CREATE TABLE (0.0 rows, 402.5 MiB processed) in 10.25s]
16:30:58  219 of 248 START sql table model pr_2520.events_monthly_to_artifact ............ [RUN]
16:30:58  220 of 248 START sql table model pr_2520.events_weekly_to_artifact ............. [RUN]
16:30:58  180 of 248 OK created sql table model pr_2520.artifacts_v1 ..................... [CREATE TABLE (180.7k rows, 861.0 MiB processed) in 11.64s]
16:30:58  221 of 248 SKIP relation pr_2520.int_artifact_ownership ........................ [SKIP]
16:30:58  222 of 248 START sql table model pr_2520.rf4_events_daily_to_project ........... [RUN]
16:30:58  188 of 248 OK created sql table model pr_2520.int_repo_metrics_by_project ...... [CREATE TABLE (895.0 rows, 668.8 MiB processed) in 10.39s]
16:30:58  223 of 248 START sql table model pr_2520.rf4_repo_stats_by_project ............. [RUN]
16:30:59  191 of 248 OK created sql table model pr_2520.events_daily_to_collection ....... [CREATE TABLE (0.0 rows, 402.6 MiB processed) in 9.12s]
16:30:59  224 of 248 START sql table model pr_2520.events_monthly_to_collection .......... [RUN]
16:30:59  225 of 248 START sql table model pr_2520.events_weekly_to_collection ........... [RUN]
16:30:59  183 of 248 OK created sql table model pr_2520.events_daily_to_project_by_source  [CREATE TABLE (0.0 rows, 500.9 MiB processed) in 11.32s]
16:30:59  226 of 248 START sql table model pr_2520.event_indexing_status_by_project_v1 ... [RUN]
16:30:59  227 of 248 START sql table model pr_2520.events_monthly_to_project_by_source ... [RUN]
16:30:59  228 of 248 START sql table model pr_2520.events_weekly_to_project_by_source .... [RUN]
16:31:00  203 of 248 OK created sql table model pr_2520.int_onchain_metric__days_since_first_transaction  [CREATE TABLE (0.0 rows, 720.8 MiB processed) in 9.64s]
16:31:00  166 of 248 OK created sql table model pr_2520.int_funding_metrics_by_project ... [CREATE TABLE (29.3k rows, 1.9 GiB processed) in 15.72s]
16:31:00  229 of 248 START sql table model pr_2520.funding_metrics_by_project_v1 ......... [RUN]
16:31:00  216 of 248 OK created sql table model pr_2520.events_weekly_to_project ......... [CREATE TABLE (0.0 rows, 0 processed) in 2.74s]
16:31:00  215 of 248 OK created sql table model pr_2520.events_monthly_to_project ........ [CREATE TABLE (0.0 rows, 0 processed) in 2.86s]
16:31:01  218 of 248 OK created sql table model pr_2520.events_weekly_to_collection_by_source  [CREATE TABLE (0.0 rows, 0 processed) in 2.78s]
16:31:01  209 of 248 OK created sql table model pr_2520.int_onchain_metric__transactions . [CREATE TABLE (0.0 rows, 767.1 MiB processed) in 10.71s]
16:31:01  217 of 248 OK created sql table model pr_2520.events_monthly_to_collection_by_source  [CREATE TABLE (0.0 rows, 0 processed) in 3.18s]
16:31:01  219 of 248 OK created sql table model pr_2520.events_monthly_to_artifact ....... [CREATE TABLE (0.0 rows, 0 processed) in 2.96s]
16:31:01  224 of 248 OK created sql table model pr_2520.events_monthly_to_collection ..... [CREATE TABLE (0.0 rows, 0 processed) in 2.61s]
16:31:01  225 of 248 OK created sql table model pr_2520.events_weekly_to_collection ...... [CREATE TABLE (0.0 rows, 0 processed) in 2.63s]
16:31:01  220 of 248 OK created sql table model pr_2520.events_weekly_to_artifact ........ [CREATE TABLE (0.0 rows, 0 processed) in 3.01s]
16:31:01  204 of 248 OK created sql table model pr_2520.int_onchain_metric__gas_fees ..... [CREATE TABLE (0.0 rows, 767.1 MiB processed) in 11.04s]
16:31:01  201 of 248 OK created sql table model pr_2520.int_onchain_metric__active_addresses  [CREATE TABLE (0.0 rows, 720.8 MiB processed) in 11.23s]
16:31:02  228 of 248 OK created sql table model pr_2520.events_weekly_to_project_by_source  [CREATE TABLE (0.0 rows, 0 processed) in 2.63s]
16:31:02  202 of 248 OK created sql table model pr_2520.int_onchain_metric__active_contracts  [CREATE TABLE (0.0 rows, 720.8 MiB processed) in 11.82s]
16:31:02  207 of 248 OK created sql table model pr_2520.int_onchain_metric__new_addresses  [CREATE TABLE (0.0 rows, 720.8 MiB processed) in 12.02s]
16:31:02  227 of 248 OK created sql table model pr_2520.events_monthly_to_project_by_source  [CREATE TABLE (0.0 rows, 0 processed) in 2.92s]
16:31:03  223 of 248 OK created sql table model pr_2520.rf4_repo_stats_by_project ........ [CREATE TABLE (635.0 rows, 217.9 KiB processed) in 4.07s]
16:31:03  208 of 248 OK created sql table model pr_2520.int_onchain_metric__returning_addresses  [CREATE TABLE (0.0 rows, 720.8 MiB processed) in 12.56s]
16:31:03  229 of 248 OK created sql table model pr_2520.funding_metrics_by_project_v1 .... [CREATE TABLE (29.3k rows, 4.3 MiB processed) in 3.15s]
16:31:03  206 of 248 OK created sql table model pr_2520.int_onchain_metric__multi_project_addresses  [CREATE TABLE (0.0 rows, 720.8 MiB processed) in 12.87s]
16:31:03  205 of 248 OK created sql table model pr_2520.int_onchain_metric__high_low_activity_addresses  [CREATE TABLE (0.0 rows, 767.1 MiB processed) in 12.96s]
16:31:03  230 of 248 START sql table model pr_2520.int_onchain_metrics_by_project ........ [RUN]
16:31:03  226 of 248 OK created sql table model pr_2520.event_indexing_status_by_project_v1  [CREATE TABLE (0.0 rows, 707.0 Bytes processed) in 3.90s]
16:31:07  230 of 248 OK created sql table model pr_2520.int_onchain_metrics_by_project ... [CREATE TABLE (0.0 rows, 220.0 Bytes processed) in 3.92s]
16:31:07  231 of 248 START sql table model pr_2520.onchain_metrics_by_project_v1 ......... [RUN]
16:31:09  222 of 248 OK created sql table model pr_2520.rf4_events_daily_to_project ...... [CREATE TABLE (0.0 rows, 700.5 MiB processed) in 11.12s]
16:31:09  232 of 248 START sql table model pr_2520.rf4_daily_active_addresses ............ [RUN]
16:31:09  233 of 248 START sql table model pr_2520.rf4_gas_fees .......................... [RUN]
16:31:09  234 of 248 START sql table model pr_2520.rf4_monthly_active_addresses .......... [RUN]
16:31:09  235 of 248 START sql table model pr_2520.rf4_openrank_trusted_users_count ...... [RUN]
16:31:09  236 of 248 START sql table model pr_2520.rf4_power_user_addresses .............. [RUN]
16:31:09  237 of 248 START sql table model pr_2520.rf4_recurring_addresses ............... [RUN]
16:31:09  238 of 248 START sql table model pr_2520.rf4_transactions ...................... [RUN]
16:31:09  239 of 248 START sql table model pr_2520.rf4_trusted_daily_active_users ........ [RUN]
16:31:09  240 of 248 START sql table model pr_2520.rf4_trusted_monthly_active_users ...... [RUN]
16:31:09  241 of 248 START sql table model pr_2520.rf4_trusted_recurring_users ........... [RUN]
16:31:09  242 of 248 START sql table model pr_2520.rf4_trusted_transaction_count ......... [RUN]
16:31:09  243 of 248 START sql table model pr_2520.rf4_trusted_users_onboarded ........... [RUN]
16:31:09  244 of 248 START sql table model pr_2520.rf4_trusted_users_share_of_transactions  [RUN]
16:31:10  231 of 248 OK created sql table model pr_2520.onchain_metrics_by_project_v1 .... [CREATE TABLE (0.0 rows, 0 processed) in 2.61s]
16:31:12  233 of 248 OK created sql table model pr_2520.rf4_gas_fees ..................... [CREATE TABLE (0.0 rows, 0 processed) in 2.97s]
16:31:13  232 of 248 OK created sql table model pr_2520.rf4_daily_active_addresses ....... [CREATE TABLE (0.0 rows, 0 processed) in 3.29s]
16:31:13  242 of 248 OK created sql table model pr_2520.rf4_trusted_transaction_count .... [CREATE TABLE (0.0 rows, 0 processed) in 3.22s]
16:31:13  239 of 248 OK created sql table model pr_2520.rf4_trusted_daily_active_users ... [CREATE TABLE (0.0 rows, 0 processed) in 3.71s]
16:31:13  234 of 248 OK created sql table model pr_2520.rf4_monthly_active_addresses ..... [CREATE TABLE (0.0 rows, 0 processed) in 3.73s]
16:31:13  240 of 248 OK created sql table model pr_2520.rf4_trusted_monthly_active_users . [CREATE TABLE (0.0 rows, 0 processed) in 3.77s]
16:31:13  238 of 248 OK created sql table model pr_2520.rf4_transactions ................. [CREATE TABLE (0.0 rows, 0 processed) in 3.80s]
16:31:13  237 of 248 OK created sql table model pr_2520.rf4_recurring_addresses .......... [CREATE TABLE (0.0 rows, 0 processed) in 3.97s]
16:31:13  244 of 248 OK created sql table model pr_2520.rf4_trusted_users_share_of_transactions  [CREATE TABLE (0.0 rows, 0 processed) in 3.97s]
16:31:14  243 of 248 OK created sql table model pr_2520.rf4_trusted_users_onboarded ...... [CREATE TABLE (0.0 rows, 0 processed) in 3.98s]
16:31:14  236 of 248 OK created sql table model pr_2520.rf4_power_user_addresses ......... [CREATE TABLE (0.0 rows, 0 processed) in 4.54s]
16:31:14  241 of 248 OK created sql table model pr_2520.rf4_trusted_recurring_users ...... [CREATE TABLE (0.0 rows, 0 processed) in 4.58s]
16:31:14  235 of 248 OK created sql table model pr_2520.rf4_openrank_trusted_users_count . [CREATE TABLE (0.0 rows, 8.9 GiB processed) in 5.01s]
16:31:14  245 of 248 START sql table model pr_2520.rf4_impact_metrics_by_project ......... [RUN]
16:31:18  245 of 248 OK created sql table model pr_2520.rf4_impact_metrics_by_project .... [CREATE TABLE (0.0 rows, 101.9 KiB processed) in 3.53s]
16:31:36  164 of 248 OK created sql table model pr_2520.int_events_daily_to_artifact ..... [CREATE TABLE (3.3m rows, 766.9 MiB processed) in 51.60s]
16:31:53  210 of 248 OK created sql table model pr_2520.int_timeseries_code_metrics__developers  [CREATE TABLE (0.0 rows, 767.1 MiB processed) in 62.36s]
16:31:53  246 of 248 START sql view model pr_2520.int_code_metric__fulltime_developers_average  [RUN]
16:31:54  246 of 248 OK created sql view model pr_2520.int_code_metric__fulltime_developers_average  [CREATE VIEW (0 processed) in 0.64s]
16:31:54  247 of 248 START sql table model pr_2520.int_code_metrics_by_project ........... [RUN]
16:32:31  247 of 248 OK created sql table model pr_2520.int_code_metrics_by_project ...... [CREATE TABLE (9.0 rows, 767.4 MiB processed) in 36.92s]
16:32:31  248 of 248 START sql table model pr_2520.code_metrics_by_project_v1 ............ [RUN]
16:32:33  248 of 248 OK created sql table model pr_2520.code_metrics_by_project_v1 ....... [CREATE TABLE (9.0 rows, 1.2 KiB processed) in 2.35s]
16:32:33  
16:32:33  Finished running 90 view models, 66 incremental models, 92 table models in 0 hours 3 minutes and 26.05 seconds (206.05s).
16:32:34  
16:32:34  Completed with 2 errors and 0 warnings:
16:32:34  
16:32:34    Database Error in model stg_npm__downloads (warehouse/dbt/models/staging/npm/stg_npm__downloads.sql)
  Access Denied: Table opensource-observer:npm.downloads: User does not have permission to query table opensource-observer:npm.downloads, or perhaps it does not exist.
  compiled code at target/run/opensource_observer/warehouse/dbt/models/staging/npm/stg_npm__downloads.sql
16:32:34  
16:32:34    Database Error in model stg_npm__manifests (warehouse/dbt/models/staging/npm/stg_npm__manifests.sql)
  Access Denied: Table opensource-observer:npm.manifests: User does not have permission to query table opensource-observer:npm.manifests, or perhaps it does not exist.
  compiled code at target/run/opensource_observer/warehouse/dbt/models/staging/npm/stg_npm__manifests.sql
16:32:34  
16:32:34  Done. PASS=245 WARN=0 ERROR=2 SKIP=1 TOTAL=248

DBT stderr:

@Jabolol Jabolol added this pull request to the merge queue Nov 26, 2024
@Jabolol Jabolol removed this pull request from the merge queue due to a manual request Nov 26, 2024
@Jabolol Jabolol added this pull request to the merge queue Nov 26, 2024
Merged via the queue into main with commit dcceca0 Nov 26, 2024
8 of 9 checks passed
@Jabolol Jabolol deleted the jabolol/npm-package-ownership branch November 26, 2024 16:41
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers

@oso-prs oso-prs[bot] oso-prs[bot] approved these changes

Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.

Validate npm package ownership
1 participant
@Jabolol