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

fix: flatten npm manifest structure #2524

Merged
merged 4 commits into from
Nov 26, 2024
Merged

fix: flatten npm manifest structure #2524

merged 4 commits into from
Nov 26, 2024

Conversation

Jabolol
Copy link
Contributor

@Jabolol Jabolol commented Nov 26, 2024

The npm manifest fields previously had multiple formats, causing dlt to create multiple tables and cluttering the schema with inconsistent columns. This PR addresses the issue by flattening the manifest to establish a consistent structure. Additionally, it updates the downstream dbt models to align with the new schema.

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

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

Test deployment for PR #2524 failed on commit 53da85fa380fa6ec2785792b641ae7b9063cb8f3. 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:

18:47:23  Running with dbt=1.8.7
18:47:28  Registered adapter: bigquery=1.8.3
18:47:28  Unable to do partial parsing because saved manifest not found. Starting full parse.
18:47:31  Found 250 models, 132 sources, 509 macros
18:47:31  
18:47:31  Concurrency: 32 threads (target='playground')
18:47:31  
18:47:31  1 of 248 START sql view model pr_2524.int_time_intervals ....................... [RUN]
18:47:31  2 of 248 START sql table model pr_2524.rf4_repos_by_app ........................ [RUN]
18:47:31  3 of 248 START sql incremental model pr_2524.rf4_transactions_window ........... [RUN]
18:47:31  4 of 248 START sql incremental model pr_2524.stg_arbitrum_one__deployers ....... [RUN]
18:47:31  5 of 248 START sql incremental model pr_2524.stg_arbitrum_one__factories ....... [RUN]
18:47:31  6 of 248 START sql incremental model pr_2524.stg_arbitrum_one__proxies ......... [RUN]
18:47:31  7 of 248 START sql incremental model pr_2524.stg_base__deployers ............... [RUN]
18:47:31  8 of 248 START sql incremental model pr_2524.stg_base__factories ............... [RUN]
18:47:31  9 of 248 START sql incremental model pr_2524.stg_base__first_time_addresses .... [RUN]
18:47:31  10 of 248 START sql table model pr_2524.stg_base__potential_bots ............... [RUN]
18:47:31  11 of 248 START sql incremental model pr_2524.stg_base__proxies ................ [RUN]
18:47:31  12 of 248 START sql incremental model pr_2524.stg_deps_dev__dependencies ....... [RUN]
18:47:31  13 of 248 START sql incremental model pr_2524.stg_ethereum__deployers .......... [RUN]
18:47:31  14 of 248 START sql view model pr_2524.stg_ethereum_attestation_service__optimism  [RUN]
18:47:31  15 of 248 START sql view model pr_2524.stg_farcaster__addresses ................ [RUN]
18:47:31  16 of 248 START sql view model pr_2524.stg_farcaster__profiles ................. [RUN]
18:47:31  17 of 248 START sql incremental model pr_2524.stg_frax__deployers .............. [RUN]
18:47:31  18 of 248 START sql incremental model pr_2524.stg_frax__factories .............. [RUN]
18:47:31  19 of 248 START sql incremental model pr_2524.stg_frax__first_time_addresses ... [RUN]
18:47:31  20 of 248 START sql table model pr_2524.stg_frax__potential_bots ............... [RUN]
18:47:32  21 of 248 START sql incremental model pr_2524.stg_frax__proxies ................ [RUN]
18:47:32  22 of 248 START sql view model pr_2524.stg_gitcoin__donations .................. [RUN]
18:47:32  23 of 248 START sql view model pr_2524.stg_gitcoin__matching ................... [RUN]
18:47:32  24 of 248 START sql view model pr_2524.stg_gitcoin__project_groups ............. [RUN]
18:47:32  25 of 248 START sql view model pr_2524.stg_gitcoin__project_lookup ............. [RUN]
18:47:32  26 of 248 START sql table model pr_2524.stg_karma3__globaltrust ................ [RUN]
18:47:32  27 of 248 START sql table model pr_2524.stg_karma3__localtrust ................. [RUN]
18:47:32  28 of 248 START sql view model pr_2524.stg_lens__owners ........................ [RUN]
18:47:32  29 of 248 START sql view model pr_2524.stg_lens__profiles ...................... [RUN]
18:47:32  30 of 248 START sql incremental model pr_2524.stg_metal__deployers ............. [RUN]
18:47:32  31 of 248 START sql incremental model pr_2524.stg_metal__factories ............. [RUN]
18:47:32  32 of 248 START sql incremental model pr_2524.stg_metal__first_time_addresses .. [RUN]
18:47:34  1 of 248 OK created sql view model pr_2524.int_time_intervals .................. [CREATE VIEW (0 processed) in 2.19s]
18:47:34  33 of 248 START sql table model pr_2524.stg_metal__potential_bots .............. [RUN]
18:47:34  23 of 248 OK created sql view model pr_2524.stg_gitcoin__matching .............. [CREATE VIEW (0 processed) in 2.57s]
18:47:34  34 of 248 START sql incremental model pr_2524.stg_metal__proxies ............... [RUN]
18:47:34  16 of 248 OK created sql view model pr_2524.stg_farcaster__profiles ............ [CREATE VIEW (0 processed) in 2.59s]
18:47:34  35 of 248 START sql incremental model pr_2524.stg_mode__deployers .............. [RUN]
18:47:34  14 of 248 OK created sql view model pr_2524.stg_ethereum_attestation_service__optimism  [CREATE VIEW (0 processed) in 2.65s]
18:47:34  36 of 248 START sql incremental model pr_2524.stg_mode__factories .............. [RUN]
18:47:34  28 of 248 OK created sql view model pr_2524.stg_lens__owners ................... [CREATE VIEW (0 processed) in 2.65s]
18:47:34  37 of 248 START sql incremental model pr_2524.stg_mode__first_time_addresses ... [RUN]
18:47:34  24 of 248 OK created sql view model pr_2524.stg_gitcoin__project_groups ........ [CREATE VIEW (0 processed) in 2.66s]
18:47:34  22 of 248 OK created sql view model pr_2524.stg_gitcoin__donations ............. [CREATE VIEW (0 processed) in 2.67s]
18:47:34  29 of 248 OK created sql view model pr_2524.stg_lens__profiles ................. [CREATE VIEW (0 processed) in 2.66s]
18:47:34  15 of 248 OK created sql view model pr_2524.stg_farcaster__addresses ........... [CREATE VIEW (0 processed) in 2.68s]
18:47:34  25 of 248 OK created sql view model pr_2524.stg_gitcoin__project_lookup ........ [CREATE VIEW (0 processed) in 2.68s]
18:47:34  38 of 248 START sql table model pr_2524.stg_mode__potential_bots ............... [RUN]
18:47:34  39 of 248 START sql incremental model pr_2524.stg_mode__proxies ................ [RUN]
18:47:34  40 of 248 START sql view model pr_2524.stg_npm__downloads ...................... [RUN]
18:47:34  41 of 248 START sql view model pr_2524.stg_npm__manifests ...................... [RUN]
18:47:34  42 of 248 START sql view model pr_2524.stg_open_collective__deposits ........... [RUN]
18:47:35  BigQuery adapter: https://console.cloud.google.com/bigquery?project=oso-pull-requests&j=bq:US:a2d70f6c-305e-406e-b8c5-6dfa798e64ab&page=queryresults
18:47:35  41 of 248 ERROR creating sql view model pr_2524.stg_npm__manifests ............. [ERROR in 0.65s]
18:47:35  43 of 248 START sql view model pr_2524.stg_open_collective__expenses ........... [RUN]
18:47:36  5 of 248 OK created sql incremental model pr_2524.stg_arbitrum_one__factories .. [CREATE TABLE (0.0 rows, 21.2 MiB processed) in 4.05s]
18:47:36  44 of 248 START sql table model pr_2524.stg_optimism__airdrop_addresses ........ [RUN]
18:47:36  42 of 248 OK created sql view model pr_2524.stg_open_collective__deposits ...... [CREATE VIEW (0 processed) in 1.25s]
18:47:36  45 of 248 START sql incremental model pr_2524.stg_optimism__deployers .......... [RUN]
18:47:36  4 of 248 OK created sql incremental model pr_2524.stg_arbitrum_one__deployers .. [CREATE TABLE (0.0 rows, 328.0 Bytes processed) in 4.17s]
18:47:36  40 of 248 OK created sql view model pr_2524.stg_npm__downloads ................. [CREATE VIEW (0 processed) in 1.32s]
18:47:36  46 of 248 START sql incremental model pr_2524.stg_optimism__factories .......... [RUN]
18:47:36  47 of 248 START sql incremental model pr_2524.stg_optimism__first_time_addresses  [RUN]
18:47:36  7 of 248 OK created sql incremental model pr_2524.stg_base__deployers .......... [CREATE TABLE (0.0 rows, 15.7 KiB processed) in 4.40s]
18:47:36  48 of 248 START sql table model pr_2524.stg_optimism__potential_bots ........... [RUN]
18:47:36  2 of 248 OK created sql table model pr_2524.rf4_repos_by_app ................... [CREATE TABLE (821.0 rows, 705.0 KiB processed) in 4.42s]
18:47:36  43 of 248 OK created sql view model pr_2524.stg_open_collective__expenses ...... [CREATE VIEW (0 processed) in 0.92s]
18:47:36  49 of 248 START sql incremental model pr_2524.stg_optimism__proxies ............ [RUN]
18:47:36  50 of 248 START sql view model pr_2524.stg_ossd__current_collections ........... [RUN]
18:47:36  6 of 248 OK created sql incremental model pr_2524.stg_arbitrum_one__proxies .... [CREATE TABLE (0.0 rows, 32.4 MiB processed) in 4.48s]
18:47:36  51 of 248 START sql view model pr_2524.stg_ossd__current_projects .............. [RUN]
18:47:36  8 of 248 OK created sql incremental model pr_2524.stg_base__factories .......... [CREATE TABLE (0.0 rows, 9.0 MiB processed) in 4.62s]
18:47:36  52 of 248 START sql view model pr_2524.stg_ossd__current_repositories .......... [RUN]
18:47:36  9 of 248 OK created sql incremental model pr_2524.stg_base__first_time_addresses  [CREATE TABLE (0.0 rows, 6.8 MiB processed) in 4.69s]
18:47:36  53 of 248 START sql view model pr_2524.stg_ossd__missing_sbom .................. [RUN]
18:47:36  31 of 248 OK created sql incremental model pr_2524.stg_metal__factories ........ [CREATE TABLE (0.0 rows, 0 processed) in 4.74s]
18:47:36  17 of 248 OK created sql incremental model pr_2524.stg_frax__deployers ......... [CREATE TABLE (0.0 rows, 0 processed) in 4.77s]
18:47:36  54 of 248 START sql view model pr_2524.stg_ossd__repository_point_in_time ...... [RUN]
18:47:36  55 of 248 START sql view model pr_2524.stg_passport__scores .................... [RUN]
18:47:36  30 of 248 OK created sql incremental model pr_2524.stg_metal__deployers ........ [CREATE TABLE (0.0 rows, 0 processed) in 4.91s]
18:47:36  56 of 248 START sql incremental model pr_2524.stg_pgn__deployers ............... [RUN]
18:47:36  12 of 248 OK created sql incremental model pr_2524.stg_deps_dev__dependencies .. [CREATE TABLE (1.0 rows, 0 processed) in 4.95s]
18:47:37  57 of 248 START sql incremental model pr_2524.stg_pgn__factories ............... [RUN]
18:47:37  21 of 248 OK created sql incremental model pr_2524.stg_frax__proxies ........... [CREATE TABLE (0.0 rows, 0 processed) in 4.99s]
18:47:37  18 of 248 OK created sql incremental model pr_2524.stg_frax__factories ......... [CREATE TABLE (0.0 rows, 0 processed) in 5.04s]
18:47:37  11 of 248 OK created sql incremental model pr_2524.stg_base__proxies ........... [CREATE TABLE (0.0 rows, 12.7 MiB processed) in 5.07s]
18:47:37  20 of 248 OK created sql table model pr_2524.stg_frax__potential_bots .......... [CREATE TABLE (0.0 rows, 0 processed) in 5.05s]
18:47:37  58 of 248 START sql incremental model pr_2524.stg_pgn__first_time_addresses .... [RUN]
18:47:37  59 of 248 START sql table model pr_2524.stg_pgn__potential_bots ................ [RUN]
18:47:37  60 of 248 START sql incremental model pr_2524.stg_pgn__proxies ................. [RUN]
18:47:37  61 of 248 START sql table model pr_2524.stg_utility__calendar .................. [RUN]
18:47:37  19 of 248 OK created sql incremental model pr_2524.stg_frax__first_time_addresses  [CREATE TABLE (0.0 rows, 0 processed) in 5.18s]
18:47:37  32 of 248 OK created sql incremental model pr_2524.stg_metal__first_time_addresses  [CREATE TABLE (0.0 rows, 0 processed) in 5.17s]
18:47:37  62 of 248 START sql incremental model pr_2524.stg_zora__deployers .............. [RUN]
18:47:37  63 of 248 START sql incremental model pr_2524.stg_zora__factories .............. [RUN]
18:47:37  52 of 248 OK created sql view model pr_2524.stg_ossd__current_repositories ..... [CREATE VIEW (0 processed) in 0.83s]
18:47:37  53 of 248 OK created sql view model pr_2524.stg_ossd__missing_sbom ............. [CREATE VIEW (0 processed) in 0.81s]
18:47:37  64 of 248 START sql incremental model pr_2524.stg_zora__first_time_addresses ... [RUN]
18:47:37  50 of 248 OK created sql view model pr_2524.stg_ossd__current_collections ...... [CREATE VIEW (0 processed) in 1.14s]
18:47:37  65 of 248 START sql table model pr_2524.stg_zora__potential_bots ............... [RUN]
18:47:37  66 of 248 START sql incremental model pr_2524.stg_zora__proxies ................ [RUN]
18:47:37  51 of 248 OK created sql view model pr_2524.stg_ossd__current_projects ......... [CREATE VIEW (0 processed) in 1.17s]
18:47:37  67 of 248 START sql view model pr_2524.int_gitcoin_funding_events .............. [RUN]
18:47:37  33 of 248 OK created sql table model pr_2524.stg_metal__potential_bots ......... [CREATE TABLE (0.0 rows, 0 processed) in 3.54s]
18:47:37  35 of 248 OK created sql incremental model pr_2524.stg_mode__deployers ......... [CREATE TABLE (0.0 rows, 0 processed) in 3.08s]
18:47:37  68 of 248 START sql view model pr_2524.int_users ............................... [RUN]
18:47:37  69 of 248 START sql view model pr_2524.int_events__open_collective ............. [RUN]
18:47:38  55 of 248 OK created sql view model pr_2524.stg_passport__scores ............... [CREATE VIEW (0 processed) in 1.08s]
18:47:38  70 of 248 START sql view model pr_2524.int_events__dependencies ................ [RUN]
18:47:38  54 of 248 OK created sql view model pr_2524.stg_ossd__repository_point_in_time . [CREATE VIEW (0 processed) in 1.15s]
18:47:38  71 of 248 START sql incremental model pr_2524.stg_github__events ............... [RUN]
18:47:38  36 of 248 OK created sql incremental model pr_2524.stg_mode__factories ......... [CREATE TABLE (0.0 rows, 698.0 Bytes processed) in 3.51s]
18:47:38  72 of 248 START sql view model pr_2524.int_collections ......................... [RUN]
18:47:38  34 of 248 OK created sql incremental model pr_2524.stg_metal__proxies .......... [CREATE TABLE (0.0 rows, 0 processed) in 3.89s]
18:47:38  73 of 248 START sql view model pr_2524.int_artifacts_in_ossd_by_project ........ [RUN]
18:47:38  67 of 248 OK created sql view model pr_2524.int_gitcoin_funding_events ......... [CREATE VIEW (0 processed) in 0.95s]
18:47:38  74 of 248 START sql view model pr_2524.int_projects ............................ [RUN]
18:47:38  37 of 248 OK created sql incremental model pr_2524.stg_mode__first_time_addresses  [CREATE TABLE (0.0 rows, 352.0 Bytes processed) in 4.02s]
18:47:38  75 of 248 START sql view model pr_2524.int_projects_by_collection .............. [RUN]
18:47:38  45 of 248 OK created sql incremental model pr_2524.stg_optimism__deployers ..... [CREATE TABLE (0.0 rows, 984.0 Bytes processed) in 2.70s]
18:47:38  76 of 248 START sql view model pr_2524.int_point_in_time_from_sources .......... [RUN]
18:47:38  69 of 248 OK created sql view model pr_2524.int_events__open_collective ........ [CREATE VIEW (0 processed) in 1.10s]
18:47:38  68 of 248 OK created sql view model pr_2524.int_users .......................... [CREATE VIEW (0 processed) in 1.21s]
18:47:38  77 of 248 START sql table model pr_2524.users_v1 ............................... [RUN]
18:47:39  39 of 248 OK created sql incremental model pr_2524.stg_mode__proxies ........... [CREATE TABLE (0.0 rows, 801.0 Bytes processed) in 4.21s]
18:47:39  70 of 248 OK created sql view model pr_2524.int_events__dependencies ........... [CREATE VIEW (0 processed) in 1.01s]
18:47:39  72 of 248 OK created sql view model pr_2524.int_collections .................... [CREATE VIEW (0 processed) in 0.86s]
18:47:39  78 of 248 START sql table model pr_2524.collections_v1 ......................... [RUN]
18:47:39  38 of 248 OK created sql table model pr_2524.stg_mode__potential_bots .......... [CREATE TABLE (14.0 rows, 5.7 MiB processed) in 4.37s]
18:47:39  73 of 248 OK created sql view model pr_2524.int_artifacts_in_ossd_by_project ... [CREATE VIEW (0 processed) in 0.75s]
18:47:39  79 of 248 START sql view model pr_2524.int_gitcoin_project_directory ........... [RUN]
18:47:39  46 of 248 OK created sql incremental model pr_2524.stg_optimism__factories ..... [CREATE TABLE (0.0 rows, 16.1 MiB processed) in 3.17s]
18:47:39  47 of 248 OK created sql incremental model pr_2524.stg_optimism__first_time_addresses  [CREATE TABLE (0.0 rows, 105.5 KiB processed) in 3.24s]
18:47:39  76 of 248 OK created sql view model pr_2524.int_point_in_time_from_sources ..... [CREATE VIEW (0 processed) in 0.77s]
18:47:39  80 of 248 START sql table model pr_2524.point_in_time_v0 ....................... [RUN]
18:47:39  74 of 248 OK created sql view model pr_2524.int_projects ....................... [CREATE VIEW (0 processed) in 0.96s]
18:47:39  81 of 248 START sql table model pr_2524.projects_v1 ............................ [RUN]
18:47:39  49 of 248 OK created sql incremental model pr_2524.stg_optimism__proxies ....... [CREATE TABLE (0.0 rows, 24.7 MiB processed) in 3.35s]
18:47:39  75 of 248 OK created sql view model pr_2524.int_projects_by_collection ......... [CREATE VIEW (0 processed) in 1.05s]
18:47:39  82 of 248 START sql table model pr_2524.projects_by_collection_v1 .............. [RUN]
18:47:39  26 of 248 OK created sql table model pr_2524.stg_karma3__globaltrust ........... [CREATE TABLE (24.0m rows, 733.7 MiB processed) in 7.90s]
18:47:40  57 of 248 OK created sql incremental model pr_2524.stg_pgn__factories .......... [CREATE TABLE (0.0 rows, 0 processed) in 3.08s]
18:47:40  79 of 248 OK created sql view model pr_2524.int_gitcoin_project_directory ...... [CREATE VIEW (0 processed) in 1.02s]
18:47:40  56 of 248 OK created sql incremental model pr_2524.stg_pgn__deployers .......... [CREATE TABLE (0.0 rows, 0 processed) in 3.37s]
18:47:40  58 of 248 OK created sql incremental model pr_2524.stg_pgn__first_time_addresses  [CREATE TABLE (0.0 rows, 0 processed) in 3.29s]
18:47:40  60 of 248 OK created sql incremental model pr_2524.stg_pgn__proxies ............ [CREATE TABLE (0.0 rows, 0 processed) in 3.44s]
18:47:40  59 of 248 OK created sql table model pr_2524.stg_pgn__potential_bots ........... [CREATE TABLE (0.0 rows, 11.8 KiB processed) in 3.55s]
18:47:40  63 of 248 OK created sql incremental model pr_2524.stg_zora__factories ......... [CREATE TABLE (0.0 rows, 901.0 KiB processed) in 3.37s]
18:47:40  83 of 248 START sql table model pr_2524.int_factories .......................... [RUN]
18:47:40  62 of 248 OK created sql incremental model pr_2524.stg_zora__deployers ......... [CREATE TABLE (0.0 rows, 492.0 Bytes processed) in 3.47s]
18:47:40  84 of 248 START sql table model pr_2524.int_deployers .......................... [RUN]
18:47:40  85 of 248 START sql view model pr_2524.int_deployers_by_project ................ [RUN]
18:47:40  66 of 248 OK created sql incremental model pr_2524.stg_zora__proxies ........... [CREATE TABLE (0.0 rows, 1.3 MiB processed) in 3.35s]
18:47:40  64 of 248 OK created sql incremental model pr_2524.stg_zora__first_time_addresses  [CREATE TABLE (0.0 rows, 206.7 KiB processed) in 3.36s]
18:47:40  86 of 248 START sql view model pr_2524.int_proxies ............................. [RUN]
18:47:40  87 of 248 START sql table model pr_2524.int_safes .............................. [RUN]
18:47:40  88 of 248 START sql view model pr_2524.int_first_time_addresses ................ [RUN]
18:47:41  44 of 248 OK created sql table model pr_2524.stg_optimism__airdrop_addresses ... [CREATE TABLE (611.5k rows, 38.6 MiB processed) in 5.57s]
18:47:41  89 of 248 START sql table model pr_2524.rf4_trusted_users ...................... [RUN]
18:47:41  71 of 248 OK created sql incremental model pr_2524.stg_github__events .......... [CREATE TABLE (0.0 rows, 3.2 MiB processed) in 3.66s]
18:47:41  90 of 248 START sql view model pr_2524.stg_github__comments .................... [RUN]
18:47:41  91 of 248 START sql view model pr_2524.stg_github__issues ...................... [RUN]
18:47:41  92 of 248 START sql view model pr_2524.stg_github__pull_request_merge_events ... [RUN]
18:47:41  93 of 248 START sql view model pr_2524.stg_github__pull_requests ............... [RUN]
18:47:41  94 of 248 START sql view model pr_2524.stg_github__push_events ................. [RUN]
18:47:41  95 of 248 START sql view model pr_2524.stg_github__releases .................... [RUN]
18:47:41  96 of 248 START sql view model pr_2524.stg_github__stars_and_forks ............. [RUN]
18:47:41  86 of 248 OK created sql view model pr_2524.int_proxies ........................ [CREATE VIEW (0 processed) in 0.83s]
18:47:41  78 of 248 OK created sql table model pr_2524.collections_v1 .................... [CREATE TABLE (28.0 rows, 1.4 KiB processed) in 2.82s]
18:47:41  88 of 248 OK created sql view model pr_2524.int_first_time_addresses ........... [CREATE VIEW (0 processed) in 0.92s]
18:47:42  85 of 248 OK created sql view model pr_2524.int_deployers_by_project ........... [CREATE VIEW (0 processed) in 1.26s]
18:47:42  97 of 248 START sql view model pr_2524.int_artifacts_by_address ................ [RUN]
18:47:42  80 of 248 OK created sql table model pr_2524.point_in_time_v0 .................. [CREATE TABLE (3.0k rows, 38.9 KiB processed) in 2.72s]
18:47:42  3 of 248 OK created sql incremental model pr_2524.rf4_transactions_window ...... [CREATE TABLE (11.5m rows, 2.6 GiB processed) in 10.60s]
18:47:42  81 of 248 OK created sql table model pr_2524.projects_v1 ....................... [CREATE TABLE (9.0 rows, 762.0 Bytes processed) in 2.96s]
18:47:42  98 of 248 START sql view model pr_2524.int_oss_funding_grants_to_project ....... [RUN]
18:47:42  82 of 248 OK created sql table model pr_2524.projects_by_collection_v1 ......... [CREATE TABLE (73.0 rows, 77.1 KiB processed) in 2.86s]
18:47:42  95 of 248 OK created sql view model pr_2524.stg_github__releases ............... [CREATE VIEW (0 processed) in 0.97s]
18:47:42  93 of 248 OK created sql view model pr_2524.stg_github__pull_requests .......... [CREATE VIEW (0 processed) in 1.01s]
18:47:42  97 of 248 OK created sql view model pr_2524.int_artifacts_by_address ........... [CREATE VIEW (0 processed) in 0.67s]
18:47:42  96 of 248 OK created sql view model pr_2524.stg_github__stars_and_forks ........ [CREATE VIEW (0 processed) in 1.08s]
18:47:42  91 of 248 OK created sql view model pr_2524.stg_github__issues ................. [CREATE VIEW (0 processed) in 1.09s]
18:47:42  90 of 248 OK created sql view model pr_2524.stg_github__comments ............... [CREATE VIEW (0 processed) in 1.18s]
18:47:42  92 of 248 OK created sql view model pr_2524.stg_github__pull_request_merge_events  [CREATE VIEW (0 processed) in 1.18s]
18:47:42  99 of 248 START sql table model pr_2524.int_events_aux_issues .................. [RUN]
18:47:42  100 of 248 START sql view model pr_2524.int_github_pr_issue_threads ............ [RUN]
18:47:42  94 of 248 OK created sql view model pr_2524.stg_github__push_events ............ [CREATE VIEW (0 processed) in 1.19s]
18:47:42  101 of 248 START sql view model pr_2524.stg_github__commits .................... [RUN]
18:47:43  98 of 248 OK created sql view model pr_2524.int_oss_funding_grants_to_project .. [CREATE VIEW (0 processed) in 0.87s]
18:47:43  84 of 248 OK created sql table model pr_2524.int_deployers ..................... [CREATE TABLE (0.0 rows, 0 processed) in 2.80s]
18:47:43  83 of 248 OK created sql table model pr_2524.int_factories ..................... [CREATE TABLE (0.0 rows, 0 processed) in 2.91s]
18:47:43  102 of 248 START sql view model pr_2524.int_derived_contracts .................. [RUN]
18:47:43  87 of 248 OK created sql table model pr_2524.int_safes ......................... [CREATE TABLE (0.0 rows, 0 processed) in 2.77s]
18:47:43  101 of 248 OK created sql view model pr_2524.stg_github__commits ............... [CREATE VIEW (0 processed) in 0.83s]
18:47:43  103 of 248 START sql view model pr_2524.stg_github__distinct_main_commits ...... [RUN]
18:47:43  100 of 248 OK created sql view model pr_2524.int_github_pr_issue_threads ....... [CREATE VIEW (0 processed) in 0.91s]
18:47:44  102 of 248 OK created sql view model pr_2524.int_derived_contracts ............. [CREATE VIEW (0 processed) in 0.75s]
18:47:44  104 of 248 START sql table model pr_2524.contracts_v0 .......................... [RUN]
18:47:44  105 of 248 START sql table model pr_2524.int_contracts_by_project .............. [RUN]
18:47:44  106 of 248 START sql table model pr_2524.rf4_agora_contract_discovery .......... [RUN]
18:47:44  107 of 248 START sql table model pr_2524.rf4_oso_contract_discovery ............ [RUN]
18:47:44  103 of 248 OK created sql view model pr_2524.stg_github__distinct_main_commits . [CREATE VIEW (0 processed) in 0.79s]
18:47:44  108 of 248 START sql view model pr_2524.stg_github__distinct_commits_resolved_mergebot  [RUN]
18:47:45  99 of 248 OK created sql table model pr_2524.int_events_aux_issues ............. [CREATE TABLE (0.0 rows, 0 processed) in 2.74s]
18:47:45  109 of 248 START sql table model pr_2524.timeseries_events_aux_issues_by_artifact_v0  [RUN]
18:47:45  108 of 248 OK created sql view model pr_2524.stg_github__distinct_commits_resolved_mergebot  [CREATE VIEW (0 processed) in 1.17s]
18:47:45  110 of 248 START sql table model pr_2524.int_events__github .................... [RUN]
18:47:46  77 of 248 OK created sql table model pr_2524.users_v1 .......................... [CREATE TABLE (1.2m rows, 97.1 MiB processed) in 7.09s]
18:47:47  104 of 248 OK created sql table model pr_2524.contracts_v0 ..................... [CREATE TABLE (0.0 rows, 0 processed) in 3.59s]
18:47:47  48 of 248 OK created sql table model pr_2524.stg_optimism__potential_bots ...... [CREATE TABLE (1.2k rows, 1.9 GiB processed) in 11.59s]
18:47:48  109 of 248 OK created sql table model pr_2524.timeseries_events_aux_issues_by_artifact_v0  [CREATE TABLE (0.0 rows, 0 processed) in 2.32s]
18:47:48  106 of 248 OK created sql table model pr_2524.rf4_agora_contract_discovery ..... [CREATE TABLE (3.9k rows, 693.7 KiB processed) in 3.71s]
18:47:48  10 of 248 OK created sql table model pr_2524.stg_base__potential_bots .......... [CREATE TABLE (11.4k rows, 5.9 GiB processed) in 16.64s]
18:47:48  105 of 248 OK created sql table model pr_2524.int_contracts_by_project ......... [CREATE TABLE (366.0 rows, 21.6 KiB processed) in 4.35s]
18:47:48  111 of 248 START sql view model pr_2524.int_all_artifacts ...................... [RUN]
18:47:48  112 of 248 START sql table model pr_2524.rf4_network_share ..................... [RUN]
18:47:48  107 of 248 OK created sql table model pr_2524.rf4_oso_contract_discovery ....... [CREATE TABLE (327.0 rows, 427.2 KiB processed) in 4.42s]
18:47:48  113 of 248 START sql table model pr_2524.rf4_contracts_by_app .................. [RUN]
18:47:49  65 of 248 OK created sql table model pr_2524.stg_zora__potential_bots .......... [CREATE TABLE (1.8k rows, 1.0 GiB processed) in 12.27s]
18:47:49  114 of 248 START sql view model pr_2524.int_potential_bots ..................... [RUN]
18:47:49  111 of 248 OK created sql view model pr_2524.int_all_artifacts ................. [CREATE VIEW (0 processed) in 1.16s]
18:47:49  115 of 248 START sql incremental model pr_2524.int_arbitrum_one_traces ......... [RUN]
18:47:49  116 of 248 START sql incremental model pr_2524.int_arbitrum_one_transactions ... [RUN]
18:47:49  117 of 248 START sql view model pr_2524.int_artifact_types ..................... [RUN]
18:47:49  118 of 248 START sql view model pr_2524.int_artifacts_by_collection ............ [RUN]
18:47:49  119 of 248 START sql view model pr_2524.int_artifacts_by_project ............... [RUN]
18:47:49  120 of 248 START sql incremental model pr_2524.int_base_traces ................. [RUN]
18:47:49  121 of 248 START sql incremental model pr_2524.int_base_transactions ........... [RUN]
18:47:49  122 of 248 START sql incremental model pr_2524.int_frax_traces ................. [RUN]
18:47:49  123 of 248 START sql incremental model pr_2524.int_frax_transactions ........... [RUN]
18:47:49  124 of 248 START sql incremental model pr_2524.int_metal_traces ................ [RUN]
18:47:49  125 of 248 START sql incremental model pr_2524.int_metal_transactions .......... [RUN]
18:47:49  126 of 248 START sql incremental model pr_2524.int_mode_traces ................. [RUN]
18:47:49  127 of 248 START sql incremental model pr_2524.int_mode_transactions ........... [RUN]
18:47:49  128 of 248 START sql incremental model pr_2524.int_optimism_traces ............. [RUN]
18:47:49  129 of 248 START sql incremental model pr_2524.int_optimism_transactions ....... [RUN]
18:47:49  130 of 248 START sql incremental model pr_2524.int_pgn_traces .................. [RUN]
18:47:49  131 of 248 START sql incremental model pr_2524.int_pgn_transactions ............ [RUN]
18:47:49  132 of 248 START sql incremental model pr_2524.int_zora_traces ................. [RUN]
18:47:49  133 of 248 START sql incremental model pr_2524.int_zora_transactions ........... [RUN]
18:47:50  110 of 248 OK created sql table model pr_2524.int_events__github ............... [CREATE TABLE (0.0 rows, 35.9 KiB processed) in 4.64s]
18:47:50  114 of 248 OK created sql view model pr_2524.int_potential_bots ................ [CREATE VIEW (0 processed) in 1.09s]
18:47:50  61 of 248 OK created sql table model pr_2524.stg_utility__calendar ............. [CREATE TABLE (31.8k rows, 0 processed) in 13.79s]
18:47:50  134 of 248 START sql view model pr_2524.int_addresses_by_user .................. [RUN]
18:47:50  135 of 248 START sql incremental model pr_2524.stg_base__addresses_gas_and_usage  [RUN]
18:47:51  136 of 248 START sql incremental model pr_2524.stg_frax__addresses_gas_and_usage  [RUN]
18:47:51  137 of 248 START sql incremental model pr_2524.stg_metal__addresses_gas_and_usage  [RUN]
18:47:51  138 of 248 START sql incremental model pr_2524.stg_mode__addresses_gas_and_usage  [RUN]
18:47:51  139 of 248 START sql incremental model pr_2524.stg_optimism__addresses_gas_and_usage  [RUN]
18:47:51  140 of 248 START sql incremental model pr_2524.stg_pgn__addresses_gas_and_usage  [RUN]
18:47:51  141 of 248 START sql incremental model pr_2524.stg_zora__addresses_gas_and_usage  [RUN]
18:47:51  113 of 248 OK created sql table model pr_2524.rf4_contracts_by_app ............. [CREATE TABLE (3.1k rows, 617.6 KiB processed) in 2.76s]
18:47:51  142 of 248 START sql table model pr_2524.rf4_transactions_by_app ............... [RUN]
18:47:51  117 of 248 OK created sql view model pr_2524.int_artifact_types ................ [CREATE VIEW (0 processed) in 1.76s]
18:47:52  119 of 248 OK created sql view model pr_2524.int_artifacts_by_project .......... [CREATE VIEW (0 processed) in 2.08s]
18:47:52  118 of 248 OK created sql view model pr_2524.int_artifacts_by_collection ....... [CREATE VIEW (0 processed) in 2.09s]
18:47:52  143 of 248 START sql table model pr_2524.artifacts_by_project_v1 ............... [RUN]
18:47:52  144 of 248 START sql table model pr_2524.artifacts_by_collection_v1 ............ [RUN]
18:47:52  134 of 248 OK created sql view model pr_2524.int_addresses_by_user ............. [CREATE VIEW (0 processed) in 1.41s]
18:47:52  145 of 248 START sql view model pr_2524.int_superchain_trusted_users ........... [RUN]
18:47:53  145 of 248 OK created sql view model pr_2524.int_superchain_trusted_users ...... [CREATE VIEW (0 processed) in 1.11s]
18:47:53  89 of 248 OK created sql table model pr_2524.rf4_trusted_users ................. [CREATE TABLE (3.0m rows, 214.7 MiB processed) in 12.06s]
18:47:54  112 of 248 OK created sql table model pr_2524.rf4_network_share ................ [CREATE TABLE (412.1k rows, 2.3 GiB processed) in 5.29s]
18:47:54  135 of 248 OK created sql incremental model pr_2524.stg_base__addresses_gas_and_usage  [CREATE TABLE (0.0 rows, 240.0 Bytes processed) in 3.95s]
18:47:54  137 of 248 OK created sql incremental model pr_2524.stg_metal__addresses_gas_and_usage  [CREATE TABLE (0.0 rows, 240.0 Bytes processed) in 3.96s]
18:47:55  139 of 248 OK created sql incremental model pr_2524.stg_optimism__addresses_gas_and_usage  [CREATE TABLE (0.0 rows, 240.0 Bytes processed) in 4.01s]
18:47:55  138 of 248 OK created sql incremental model pr_2524.stg_mode__addresses_gas_and_usage  [CREATE TABLE (0.0 rows, 240.0 Bytes processed) in 4.04s]
18:47:55  140 of 248 OK created sql incremental model pr_2524.stg_pgn__addresses_gas_and_usage  [CREATE TABLE (0.0 rows, 240.0 Bytes processed) in 4.08s]
18:47:55  141 of 248 OK created sql incremental model pr_2524.stg_zora__addresses_gas_and_usage  [CREATE TABLE (0.0 rows, 240.0 Bytes processed) in 4.10s]
18:47:55  136 of 248 OK created sql incremental model pr_2524.stg_frax__addresses_gas_and_usage  [CREATE TABLE (0.0 rows, 240.0 Bytes processed) in 4.69s]
18:47:55  146 of 248 START sql view model pr_2524.int_addresses_usage .................... [RUN]
18:47:56  123 of 248 OK created sql incremental model pr_2524.int_frax_transactions ...... [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 6.34s]
18:47:56  147 of 248 START sql incremental model pr_2524.int_frax_contract_invocation_events  [RUN]
18:47:56  131 of 248 OK created sql incremental model pr_2524.int_pgn_transactions ....... [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 6.38s]
18:47:56  148 of 248 START sql incremental model pr_2524.int_pgn_contract_invocation_events  [RUN]
18:47:56  130 of 248 OK created sql incremental model pr_2524.int_pgn_traces ............. [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 6.44s]
18:47:56  146 of 248 OK created sql view model pr_2524.int_addresses_usage ............... [CREATE VIEW (0 processed) in 0.87s]
18:47:56  126 of 248 OK created sql incremental model pr_2524.int_mode_traces ............ [CREATE TABLE (0.0 rows, 95.4 KiB processed) in 6.88s]
18:47:56  116 of 248 OK created sql incremental model pr_2524.int_arbitrum_one_transactions  [CREATE TABLE (0.0 rows, 1.1 MiB processed) in 6.90s]
18:47:56  115 of 248 OK created sql incremental model pr_2524.int_arbitrum_one_traces .... [CREATE TABLE (0.0 rows, 94.9 MiB processed) in 6.91s]
18:47:56  132 of 248 OK created sql incremental model pr_2524.int_zora_traces ............ [CREATE TABLE (0.0 rows, 5.0 MiB processed) in 6.87s]
18:47:56  127 of 248 OK created sql incremental model pr_2524.int_mode_transactions ...... [CREATE TABLE (0.0 rows, 94.2 KiB processed) in 6.88s]
18:47:56  125 of 248 OK created sql incremental model pr_2524.int_metal_transactions ..... [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 6.89s]
18:47:56  149 of 248 START sql incremental model pr_2524.int_arbitrum_one_contract_invocation_events  [RUN]
18:47:56  150 of 248 START sql incremental model pr_2524.int_mode_contract_invocation_events  [RUN]
18:47:56  151 of 248 START sql incremental model pr_2524.int_metal_contract_invocation_events  [RUN]
18:47:57  122 of 248 OK created sql incremental model pr_2524.int_frax_traces ............ [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 7.21s]
18:47:57  120 of 248 OK created sql incremental model pr_2524.int_base_traces ............ [CREATE TABLE (0.0 rows, 42.2 MiB processed) in 7.23s]
18:47:57  121 of 248 OK created sql incremental model pr_2524.int_base_transactions ...... [CREATE TABLE (0.0 rows, 8.1 MiB processed) in 7.25s]
18:47:57  152 of 248 START sql incremental model pr_2524.int_base_contract_invocation_events  [RUN]
18:47:57  129 of 248 OK created sql incremental model pr_2524.int_optimism_transactions .. [CREATE TABLE (0.0 rows, 240.5 KiB processed) in 7.25s]
18:47:57  153 of 248 START sql incremental model pr_2524.int_optimism_contract_invocation_events  [RUN]
18:47:57  143 of 248 OK created sql table model pr_2524.artifacts_by_project_v1 .......... [CREATE TABLE (1.4k rows, 205.1 KiB processed) in 5.13s]
18:47:57  128 of 248 OK created sql incremental model pr_2524.int_optimism_traces ........ [CREATE TABLE (0.0 rows, 59.9 MiB processed) in 7.31s]
18:47:57  154 of 248 START sql view model pr_2524.int_code_metric__time_to_first_response_days_average  [RUN]
18:47:57  155 of 248 START sql view model pr_2524.int_code_metric__time_to_merge_days_average  [RUN]
18:47:57  156 of 248 START sql table model pr_2524.rf4_4337_events ....................... [RUN]
18:47:57  124 of 248 OK created sql incremental model pr_2524.int_metal_traces ........... [CREATE TABLE (0.0 rows, 93.5 KiB processed) in 7.71s]
18:47:57  144 of 248 OK created sql table model pr_2524.artifacts_by_collection_v1 ....... [CREATE TABLE (9.1k rows, 282.1 KiB processed) in 5.54s]
18:47:57  133 of 248 OK created sql incremental model pr_2524.int_zora_transactions ...... [CREATE TABLE (0.0 rows, 374.6 KiB processed) in 7.74s]
18:47:57  157 of 248 START sql incremental model pr_2524.int_zora_contract_invocation_events  [RUN]
18:47:58  154 of 248 OK created sql view model pr_2524.int_code_metric__time_to_first_response_days_average  [CREATE VIEW (0 processed) in 0.93s]
18:47:58  155 of 248 OK created sql view model pr_2524.int_code_metric__time_to_merge_days_average  [CREATE VIEW (0 processed) in 1.16s]
18:47:58  142 of 248 OK created sql table model pr_2524.rf4_transactions_by_app .......... [CREATE TABLE (1.7m rows, 1.1 GiB processed) in 6.92s]
18:47:58  158 of 248 START sql table model pr_2524.rf4_onchain_eligibility_checks ........ [RUN]
18:48:00  147 of 248 OK created sql incremental model pr_2524.int_frax_contract_invocation_events  [CREATE TABLE (0.0 rows, 21.5 KiB processed) in 3.97s]
18:48:00  148 of 248 OK created sql incremental model pr_2524.int_pgn_contract_invocation_events  [CREATE TABLE (0.0 rows, 21.5 KiB processed) in 3.93s]
18:48:00  149 of 248 OK created sql incremental model pr_2524.int_arbitrum_one_contract_invocation_events  [CREATE TABLE (0.0 rows, 21.5 KiB processed) in 3.84s]
18:48:00  156 of 248 OK created sql table model pr_2524.rf4_4337_events .................. [CREATE TABLE (0.0 rows, 123.0 KiB processed) in 3.51s]
18:48:00  151 of 248 OK created sql incremental model pr_2524.int_metal_contract_invocation_events  [CREATE TABLE (0.0 rows, 21.5 KiB processed) in 4.04s]
18:48:01  150 of 248 OK created sql incremental model pr_2524.int_mode_contract_invocation_events  [CREATE TABLE (0.0 rows, 21.5 KiB processed) in 4.18s]
18:48:01  153 of 248 OK created sql incremental model pr_2524.int_optimism_contract_invocation_events  [CREATE TABLE (0.0 rows, 21.5 KiB processed) in 4.19s]
18:48:01  152 of 248 OK created sql incremental model pr_2524.int_base_contract_invocation_events  [CREATE TABLE (0.0 rows, 21.5 KiB processed) in 4.37s]
18:48:02  157 of 248 OK created sql incremental model pr_2524.int_zora_contract_invocation_events  [CREATE TABLE (0.0 rows, 21.5 KiB processed) in 4.31s]
18:48:02  159 of 248 START sql table model pr_2524.int_events__blockchain ................ [RUN]
18:48:02  27 of 248 OK created sql table model pr_2524.stg_karma3__localtrust ............ [CREATE TABLE (237.0m rows, 8.8 GiB processed) in 30.66s]
18:48:04  159 of 248 OK created sql table model pr_2524.int_events__blockchain ........... [CREATE TABLE (0.0 rows, 0 processed) in 2.75s]
18:48:04  160 of 248 START sql table model pr_2524.int_events ............................ [RUN]
18:48:05  158 of 248 OK created sql table model pr_2524.rf4_onchain_eligibility_checks ... [CREATE TABLE (462.0 rows, 198.2 MiB processed) in 6.68s]
18:48:06  13 of 248 OK created sql incremental model pr_2524.stg_ethereum__deployers ..... [CREATE TABLE (4.7m rows, 736.9 MiB processed) in 34.24s]
18:48:39  160 of 248 OK created sql table model pr_2524.int_events ....................... [CREATE TABLE (6.1m rows, 1.6 GiB processed) in 34.88s]
18:48:39  161 of 248 START sql table model pr_2524.event_types_v1 ........................ [RUN]
18:48:39  162 of 248 START sql view model pr_2524.int_artifacts_by_user .................. [RUN]
18:48:39  163 of 248 START sql view model pr_2524.int_artifacts_history .................. [RUN]
18:48:39  164 of 248 START sql table model pr_2524.int_events_daily_to_artifact .......... [RUN]
18:48:39  165 of 248 START sql view model pr_2524.int_events_to_project .................. [RUN]
18:48:39  166 of 248 START sql table model pr_2524.int_funding_metrics_by_project ........ [RUN]
18:48:39  167 of 248 START sql table model pr_2524.oso_events_v0 ......................... [RUN]
18:48:39  168 of 248 START sql view model pr_2524.superchain_metric__daily_active_addresses_avg_6_months  [RUN]
18:48:39  169 of 248 START sql view model pr_2524.superchain_metric__gas_fees_sum_6_months  [RUN]
18:48:39  170 of 248 START sql view model pr_2524.superchain_metric__monthly_active_addresses_avg_6_months  [RUN]
18:48:39  171 of 248 START sql view model pr_2524.superchain_metric__transactions_sum_6_months  [RUN]
18:48:39  172 of 248 START sql view model pr_2524.superchain_metric__trusted_daily_active_users_avg_6_months  [RUN]
18:48:39  173 of 248 START sql view model pr_2524.superchain_metric__trusted_monthly_active_users_avg_6_months  [RUN]
18:48:39  174 of 248 START sql view model pr_2524.superchain_metric__trusted_transactions_sum_6_months  [RUN]
18:48:39  175 of 248 START sql view model pr_2524.superchain_metric__trusted_users_onboarded_sum_6_months  [RUN]
18:48:39  176 of 248 START sql table model pr_2524.timeseries_events_by_artifact_v0 ...... [RUN]
18:48:41  168 of 248 OK created sql view model pr_2524.superchain_metric__daily_active_addresses_avg_6_months  [CREATE VIEW (0 processed) in 1.48s]
18:48:41  171 of 248 OK created sql view model pr_2524.superchain_metric__transactions_sum_6_months  [CREATE VIEW (0 processed) in 1.51s]
18:48:41  170 of 248 OK created sql view model pr_2524.superchain_metric__monthly_active_addresses_avg_6_months  [CREATE VIEW (0 processed) in 1.57s]
18:48:41  163 of 248 OK created sql view model pr_2524.int_artifacts_history ............. [CREATE VIEW (0 processed) in 1.65s]
18:48:41  177 of 248 START sql view model pr_2524.int_artifacts .......................... [RUN]
18:48:41  169 of 248 OK created sql view model pr_2524.superchain_metric__gas_fees_sum_6_months  [CREATE VIEW (0 processed) in 1.69s]
18:48:41  162 of 248 OK created sql view model pr_2524.int_artifacts_by_user ............. [CREATE VIEW (0 processed) in 1.79s]
18:48:41  178 of 248 START sql table model pr_2524.artifacts_by_user_v1 .................. [RUN]
18:48:41  173 of 248 OK created sql view model pr_2524.superchain_metric__trusted_monthly_active_users_avg_6_months  [CREATE VIEW (0 processed) in 1.82s]
18:48:41  174 of 248 OK created sql view model pr_2524.superchain_metric__trusted_transactions_sum_6_months  [CREATE VIEW (0 processed) in 1.82s]
18:48:41  172 of 248 OK created sql view model pr_2524.superchain_metric__trusted_daily_active_users_avg_6_months  [CREATE VIEW (0 processed) in 1.83s]
18:48:41  175 of 248 OK created sql view model pr_2524.superchain_metric__trusted_users_onboarded_sum_6_months  [CREATE VIEW (0 processed) in 1.90s]
18:48:41  179 of 248 START sql view model pr_2524.int_timeseries_superchain_metrics__all . [RUN]
18:48:41  165 of 248 OK created sql view model pr_2524.int_events_to_project ............. [CREATE VIEW (0 processed) in 2.02s]
18:48:41  180 of 248 START sql table model pr_2524.events_daily_to_artifact .............. [RUN]
18:48:41  181 of 248 START sql table model pr_2524.events_daily_to_project ............... [RUN]
18:48:41  182 of 248 START sql table model pr_2524.events_daily_to_project_by_source ..... [RUN]
18:48:41  183 of 248 START sql view model pr_2524.int_addresses_to_project ............... [RUN]
18:48:41  184 of 248 START sql view model pr_2524.int_contributors_to_project ............ [RUN]
18:48:41  185 of 248 START sql view model pr_2524.int_events_daily_to_project ............ [RUN]
18:48:41  186 of 248 START sql view model pr_2524.int_events_to_collection ............... [RUN]
18:48:41  187 of 248 START sql table model pr_2524.int_repo_metrics_by_project ........... [RUN]
18:48:42  177 of 248 OK created sql view model pr_2524.int_artifacts ..................... [CREATE VIEW (0 processed) in 0.89s]
18:48:42  188 of 248 START sql table model pr_2524.artifacts_v1 .......................... [RUN]
18:48:42  179 of 248 OK created sql view model pr_2524.int_timeseries_superchain_metrics__all  [CREATE VIEW (0 processed) in 1.15s]
18:48:42  186 of 248 OK created sql view model pr_2524.int_events_to_collection .......... [CREATE VIEW (0 processed) in 1.13s]
18:48:42  189 of 248 START sql table model pr_2524.events_daily_to_collection ............ [RUN]
18:48:42  190 of 248 START sql table model pr_2524.events_daily_to_collection_by_source .. [RUN]
18:48:42  183 of 248 OK created sql view model pr_2524.int_addresses_to_project .......... [CREATE VIEW (0 processed) in 1.16s]
18:48:42  191 of 248 START sql view model pr_2524.int_address_rfm_segments_by_project .... [RUN]
18:48:42  192 of 248 START sql view model pr_2524.int_addresses_daily_activity ........... [RUN]
18:48:43  184 of 248 OK created sql view model pr_2524.int_contributors_to_project ....... [CREATE VIEW (0 processed) in 1.42s]
18:48:43  185 of 248 OK created sql view model pr_2524.int_events_daily_to_project ....... [CREATE VIEW (0 processed) in 1.46s]
18:48:43  193 of 248 START sql view model pr_2524.int_code_metric__active_developers ..... [RUN]
18:48:43  194 of 248 START sql view model pr_2524.int_code_metric__commits_prs_issues .... [RUN]
18:48:43  195 of 248 START sql view model pr_2524.int_code_metric__contributors .......... [RUN]
18:48:43  196 of 248 START sql view model pr_2524.int_code_metric__new_contributors ...... [RUN]
18:48:43  197 of 248 START sql view model pr_2524.int_developer_status_monthly_by_project  [RUN]
18:48:43  198 of 248 START sql view model pr_2524.int_events_alltime_to_project .......... [RUN]
18:48:43  199 of 248 START sql view model pr_2524.int_events_monthly_to_project .......... [RUN]
18:48:43  200 of 248 START sql view model pr_2524.int_first_last_event_by_artifact ....... [RUN]
18:48:43  201 of 248 START sql table model pr_2524.int_onchain_metric__active_addresses .. [RUN]
18:48:43  202 of 248 START sql table model pr_2524.int_onchain_metric__active_contracts .. [RUN]
18:48:43  203 of 248 START sql table model pr_2524.int_onchain_metric__days_since_first_transaction  [RUN]
18:48:43  204 of 248 START sql table model pr_2524.int_onchain_metric__gas_fees .......... [RUN]
18:48:43  205 of 248 START sql table model pr_2524.int_onchain_metric__high_low_activity_addresses  [RUN]
18:48:43  206 of 248 START sql table model pr_2524.int_onchain_metric__multi_project_addresses  [RUN]
18:48:43  207 of 248 START sql table model pr_2524.int_onchain_metric__new_addresses ..... [RUN]
18:48:43  208 of 248 START sql table model pr_2524.int_onchain_metric__returning_addresses  [RUN]
18:48:43  209 of 248 START sql table model pr_2524.int_onchain_metric__transactions ...... [RUN]
18:48:44  191 of 248 OK created sql view model pr_2524.int_address_rfm_segments_by_project  [CREATE VIEW (0 processed) in 1.11s]
18:48:44  210 of 248 START sql table model pr_2524.int_timeseries_code_metrics__developers  [RUN]
18:48:44  192 of 248 OK created sql view model pr_2524.int_addresses_daily_activity ...... [CREATE VIEW (0 processed) in 1.33s]
18:48:44  211 of 248 START sql view model pr_2524.int_active_addresses_daily_to_project .. [RUN]
18:48:44  193 of 248 OK created sql view model pr_2524.int_code_metric__active_developers  [CREATE VIEW (0 processed) in 1.16s]
18:48:44  212 of 248 START sql view model pr_2524.int_active_addresses_monthly_to_project  [RUN]
18:48:44  195 of 248 OK created sql view model pr_2524.int_code_metric__contributors ..... [CREATE VIEW (0 processed) in 1.58s]
18:48:44  213 of 248 START sql view model pr_2524.int_address_totals_by_project .......... [RUN]
18:48:44  196 of 248 OK created sql view model pr_2524.int_code_metric__new_contributors . [CREATE VIEW (0 processed) in 1.59s]
18:48:44  194 of 248 OK created sql view model pr_2524.int_code_metric__commits_prs_issues  [CREATE VIEW (0 processed) in 1.65s]
18:48:44  199 of 248 OK created sql view model pr_2524.int_events_monthly_to_project ..... [CREATE VIEW (0 processed) in 1.66s]
18:48:44  214 of 248 START sql view model pr_2524.int_code_metric__bus_factor ............ [RUN]
18:48:45  197 of 248 OK created sql view model pr_2524.int_developer_status_monthly_by_project  [CREATE VIEW (0 processed) in 1.83s]
18:48:45  198 of 248 OK created sql view model pr_2524.int_events_alltime_to_project ..... [CREATE VIEW (0 processed) in 1.84s]
18:48:45  200 of 248 OK created sql view model pr_2524.int_first_last_event_by_artifact .. [CREATE VIEW (0 processed) in 1.92s]
18:48:45  212 of 248 OK created sql view model pr_2524.int_active_addresses_monthly_to_project  [CREATE VIEW (0 processed) in 1.22s]
18:48:45  211 of 248 OK created sql view model pr_2524.int_active_addresses_daily_to_project  [CREATE VIEW (0 processed) in 1.28s]
18:48:45  214 of 248 OK created sql view model pr_2524.int_code_metric__bus_factor ....... [CREATE VIEW (0 processed) in 0.87s]
18:48:45  161 of 248 OK created sql table model pr_2524.event_types_v1 ................... [CREATE TABLE (3.0 rows, 43.4 MiB processed) in 6.15s]
18:48:46  213 of 248 OK created sql view model pr_2524.int_address_totals_by_project ..... [CREATE VIEW (0 processed) in 1.13s]
18:48:48  176 of 248 OK created sql table model pr_2524.timeseries_events_by_artifact_v0 . [CREATE TABLE (6.1m rows, 986.9 MiB processed) in 8.82s]
18:48:49  187 of 248 OK created sql table model pr_2524.int_repo_metrics_by_project ...... [CREATE TABLE (895.0 rows, 668.8 MiB processed) in 7.98s]
18:48:49  215 of 248 START sql table model pr_2524.rf4_repo_stats_by_project ............. [RUN]
18:48:49  178 of 248 OK created sql table model pr_2524.artifacts_by_user_v1 ............. [CREATE TABLE (179.3k rows, 699.7 MiB processed) in 8.38s]
18:48:50  181 of 248 OK created sql table model pr_2524.events_daily_to_project .......... [CREATE TABLE (0.0 rows, 402.5 MiB processed) in 8.21s]
18:48:50  216 of 248 START sql table model pr_2524.events_monthly_to_project ............. [RUN]
18:48:50  217 of 248 START sql table model pr_2524.events_weekly_to_project .............. [RUN]
18:48:50  182 of 248 OK created sql table model pr_2524.events_daily_to_project_by_source  [CREATE TABLE (0.0 rows, 500.9 MiB processed) in 8.53s]
18:48:50  218 of 248 START sql table model pr_2524.event_indexing_status_by_project_v1 ... [RUN]
18:48:50  219 of 248 START sql table model pr_2524.events_monthly_to_project_by_source ... [RUN]
18:48:50  220 of 248 START sql table model pr_2524.events_weekly_to_project_by_source .... [RUN]
18:48:50  180 of 248 OK created sql table model pr_2524.events_daily_to_artifact ......... [CREATE TABLE (0.0 rows, 402.5 MiB processed) in 8.65s]
18:48:50  221 of 248 START sql table model pr_2524.events_monthly_to_artifact ............ [RUN]
18:48:50  222 of 248 START sql table model pr_2524.events_weekly_to_artifact ............. [RUN]
18:48:50  167 of 248 OK created sql table model pr_2524.oso_events_v0 .................... [CREATE TABLE (0.0 rows, 1.9 GiB processed) in 11.05s]
18:48:50  190 of 248 OK created sql table model pr_2524.events_daily_to_collection_by_source  [CREATE TABLE (0.0 rows, 501.0 MiB processed) in 8.02s]
18:48:50  223 of 248 START sql table model pr_2524.events_monthly_to_collection_by_source  [RUN]
18:48:50  224 of 248 START sql table model pr_2524.events_weekly_to_collection_by_source . [RUN]
18:48:51  189 of 248 OK created sql table model pr_2524.events_daily_to_collection ....... [CREATE TABLE (0.0 rows, 402.6 MiB processed) in 8.14s]
18:48:51  225 of 248 START sql table model pr_2524.events_monthly_to_collection .......... [RUN]
18:48:51  226 of 248 START sql table model pr_2524.events_weekly_to_collection ........... [RUN]
18:48:51  166 of 248 OK created sql table model pr_2524.int_funding_metrics_by_project ... [CREATE TABLE (29.3k rows, 1.9 GiB processed) in 11.84s]
18:48:51  204 of 248 OK created sql table model pr_2524.int_onchain_metric__gas_fees ..... [CREATE TABLE (0.0 rows, 767.1 MiB processed) in 8.36s]
18:48:51  209 of 248 OK created sql table model pr_2524.int_onchain_metric__transactions . [CREATE TABLE (0.0 rows, 767.1 MiB processed) in 8.37s]
18:48:51  227 of 248 START sql table model pr_2524.funding_metrics_by_project_v1 ......... [RUN]
18:48:52  203 of 248 OK created sql table model pr_2524.int_onchain_metric__days_since_first_transaction  [CREATE TABLE (0.0 rows, 720.8 MiB processed) in 8.75s]
18:48:52  201 of 248 OK created sql table model pr_2524.int_onchain_metric__active_addresses  [CREATE TABLE (0.0 rows, 720.8 MiB processed) in 8.78s]
18:48:52  202 of 248 OK created sql table model pr_2524.int_onchain_metric__active_contracts  [CREATE TABLE (0.0 rows, 720.8 MiB processed) in 8.81s]
18:48:52  215 of 248 OK created sql table model pr_2524.rf4_repo_stats_by_project ........ [CREATE TABLE (635.0 rows, 217.9 KiB processed) in 2.66s]
18:48:52  217 of 248 OK created sql table model pr_2524.events_weekly_to_project ......... [CREATE TABLE (0.0 rows, 0 processed) in 2.55s]
18:48:52  216 of 248 OK created sql table model pr_2524.events_monthly_to_project ........ [CREATE TABLE (0.0 rows, 0 processed) in 2.61s]
18:48:52  208 of 248 OK created sql table model pr_2524.int_onchain_metric__returning_addresses  [CREATE TABLE (0.0 rows, 720.8 MiB processed) in 9.50s]
18:48:52  221 of 248 OK created sql table model pr_2524.events_monthly_to_artifact ....... [CREATE TABLE (0.0 rows, 0 processed) in 2.49s]
18:48:52  219 of 248 OK created sql table model pr_2524.events_monthly_to_project_by_source  [CREATE TABLE (0.0 rows, 0 processed) in 2.66s]
18:48:53  220 of 248 OK created sql table model pr_2524.events_weekly_to_project_by_source  [CREATE TABLE (0.0 rows, 0 processed) in 2.69s]
18:48:53  207 of 248 OK created sql table model pr_2524.int_onchain_metric__new_addresses  [CREATE TABLE (0.0 rows, 720.8 MiB processed) in 9.87s]
18:48:53  206 of 248 OK created sql table model pr_2524.int_onchain_metric__multi_project_addresses  [CREATE TABLE (0.0 rows, 720.8 MiB processed) in 9.92s]
18:48:53  222 of 248 OK created sql table model pr_2524.events_weekly_to_artifact ........ [CREATE TABLE (0.0 rows, 0 processed) in 2.77s]
18:48:53  218 of 248 OK created sql table model pr_2524.event_indexing_status_by_project_v1  [CREATE TABLE (0.0 rows, 707.0 Bytes processed) in 2.98s]
18:48:53  188 of 248 OK created sql table model pr_2524.artifacts_v1 ..................... [CREATE TABLE (180.7k rows, 861.0 MiB processed) in 10.97s]
18:48:53  228 of 248 SKIP relation pr_2524.int_artifact_ownership ........................ [SKIP]
18:48:53  229 of 248 START sql table model pr_2524.rf4_events_daily_to_project ........... [RUN]
18:48:53  223 of 248 OK created sql table model pr_2524.events_monthly_to_collection_by_source  [CREATE TABLE (0.0 rows, 0 processed) in 2.58s]
18:48:53  205 of 248 OK created sql table model pr_2524.int_onchain_metric__high_low_activity_addresses  [CREATE TABLE (0.0 rows, 767.1 MiB processed) in 10.39s]
18:48:53  230 of 248 START sql table model pr_2524.int_onchain_metrics_by_project ........ [RUN]
18:48:53  224 of 248 OK created sql table model pr_2524.events_weekly_to_collection_by_source  [CREATE TABLE (0.0 rows, 0 processed) in 2.83s]
18:48:53  225 of 248 OK created sql table model pr_2524.events_monthly_to_collection ..... [CREATE TABLE (0.0 rows, 0 processed) in 2.79s]
18:48:53  226 of 248 OK created sql table model pr_2524.events_weekly_to_collection ...... [CREATE TABLE (0.0 rows, 0 processed) in 2.88s]
18:48:54  227 of 248 OK created sql table model pr_2524.funding_metrics_by_project_v1 .... [CREATE TABLE (29.3k rows, 4.3 MiB processed) in 2.34s]
18:48:56  230 of 248 OK created sql table model pr_2524.int_onchain_metrics_by_project ... [CREATE TABLE (0.0 rows, 220.0 Bytes processed) in 3.23s]
18:48:56  231 of 248 START sql table model pr_2524.onchain_metrics_by_project_v1 ......... [RUN]
18:48:58  231 of 248 OK created sql table model pr_2524.onchain_metrics_by_project_v1 .... [CREATE TABLE (0.0 rows, 0 processed) in 2.07s]
18:49:02  229 of 248 OK created sql table model pr_2524.rf4_events_daily_to_project ...... [CREATE TABLE (0.0 rows, 700.5 MiB processed) in 8.74s]
18:49:02  232 of 248 START sql table model pr_2524.rf4_daily_active_addresses ............ [RUN]
18:49:02  233 of 248 START sql table model pr_2524.rf4_gas_fees .......................... [RUN]
18:49:02  234 of 248 START sql table model pr_2524.rf4_monthly_active_addresses .......... [RUN]
18:49:02  235 of 248 START sql table model pr_2524.rf4_openrank_trusted_users_count ...... [RUN]
18:49:02  236 of 248 START sql table model pr_2524.rf4_power_user_addresses .............. [RUN]
18:49:02  237 of 248 START sql table model pr_2524.rf4_recurring_addresses ............... [RUN]
18:49:02  238 of 248 START sql table model pr_2524.rf4_transactions ...................... [RUN]
18:49:02  239 of 248 START sql table model pr_2524.rf4_trusted_daily_active_users ........ [RUN]
18:49:02  240 of 248 START sql table model pr_2524.rf4_trusted_monthly_active_users ...... [RUN]
18:49:02  241 of 248 START sql table model pr_2524.rf4_trusted_recurring_users ........... [RUN]
18:49:02  242 of 248 START sql table model pr_2524.rf4_trusted_transaction_count ......... [RUN]
18:49:02  243 of 248 START sql table model pr_2524.rf4_trusted_users_onboarded ........... [RUN]
18:49:02  244 of 248 START sql table model pr_2524.rf4_trusted_users_share_of_transactions  [RUN]
18:49:05  234 of 248 OK created sql table model pr_2524.rf4_monthly_active_addresses ..... [CREATE TABLE (0.0 rows, 0 processed) in 2.99s]
18:49:05  232 of 248 OK created sql table model pr_2524.rf4_daily_active_addresses ....... [CREATE TABLE (0.0 rows, 0 processed) in 3.19s]
18:49:05  233 of 248 OK created sql table model pr_2524.rf4_gas_fees ..................... [CREATE TABLE (0.0 rows, 0 processed) in 3.24s]
18:49:05  237 of 248 OK created sql table model pr_2524.rf4_recurring_addresses .......... [CREATE TABLE (0.0 rows, 0 processed) in 3.24s]
18:49:05  240 of 248 OK created sql table model pr_2524.rf4_trusted_monthly_active_users . [CREATE TABLE (0.0 rows, 0 processed) in 3.28s]
18:49:05  244 of 248 OK created sql table model pr_2524.rf4_trusted_users_share_of_transactions  [CREATE TABLE (0.0 rows, 0 processed) in 3.27s]
18:49:05  239 of 248 OK created sql table model pr_2524.rf4_trusted_daily_active_users ... [CREATE TABLE (0.0 rows, 0 processed) in 3.29s]
18:49:05  238 of 248 OK created sql table model pr_2524.rf4_transactions ................. [CREATE TABLE (0.0 rows, 0 processed) in 3.32s]
18:49:05  242 of 248 OK created sql table model pr_2524.rf4_trusted_transaction_count .... [CREATE TABLE (0.0 rows, 0 processed) in 3.33s]
18:49:05  243 of 248 OK created sql table model pr_2524.rf4_trusted_users_onboarded ...... [CREATE TABLE (0.0 rows, 0 processed) in 3.53s]
18:49:05  241 of 248 OK created sql table model pr_2524.rf4_trusted_recurring_users ...... [CREATE TABLE (0.0 rows, 0 processed) in 3.59s]
18:49:06  236 of 248 OK created sql table model pr_2524.rf4_power_user_addresses ......... [CREATE TABLE (0.0 rows, 0 processed) in 3.85s]
18:49:07  235 of 248 OK created sql table model pr_2524.rf4_openrank_trusted_users_count . [CREATE TABLE (0.0 rows, 8.9 GiB processed) in 4.93s]
18:49:07  245 of 248 START sql table model pr_2524.rf4_impact_metrics_by_project ......... [RUN]
18:49:10  245 of 248 OK created sql table model pr_2524.rf4_impact_metrics_by_project .... [CREATE TABLE (0.0 rows, 101.9 KiB processed) in 2.94s]
18:49:22  210 of 248 OK created sql table model pr_2524.int_timeseries_code_metrics__developers  [CREATE TABLE (0.0 rows, 767.1 MiB processed) in 38.65s]
18:49:22  246 of 248 START sql view model pr_2524.int_code_metric__fulltime_developers_average  [RUN]
18:49:22  164 of 248 OK created sql table model pr_2524.int_events_daily_to_artifact ..... [CREATE TABLE (3.3m rows, 766.9 MiB processed) in 43.14s]
18:49:23  246 of 248 OK created sql view model pr_2524.int_code_metric__fulltime_developers_average  [CREATE VIEW (0 processed) in 1.02s]
18:49:23  247 of 248 START sql table model pr_2524.int_code_metrics_by_project ........... [RUN]
18:49:48  247 of 248 OK created sql table model pr_2524.int_code_metrics_by_project ...... [CREATE TABLE (9.0 rows, 767.4 MiB processed) in 24.31s]
18:49:48  248 of 248 START sql table model pr_2524.code_metrics_by_project_v1 ............ [RUN]
18:49:50  248 of 248 OK created sql table model pr_2524.code_metrics_by_project_v1 ....... [CREATE TABLE (9.0 rows, 1.2 KiB processed) in 2.05s]
18:49:50  
18:49:50  Finished running 90 view models, 66 incremental models, 92 table models in 0 hours 2 minutes and 18.91 seconds (138.91s).
18:49:50  
18:49:50  Completed with 1 error and 0 warnings:
18:49:50  
18:49:50    Database Error in model stg_npm__manifests (warehouse/dbt/models/staging/npm/stg_npm__manifests.sql)
  Not found: Table opensource-observer:npm.manifests was not found in location US
  compiled code at target/run/opensource_observer/warehouse/dbt/models/staging/npm/stg_npm__manifests.sql
18:49:50  
18:49:50  Done. PASS=246 WARN=0 ERROR=1 SKIP=1 TOTAL=248

DBT stderr:

@Jabolol Jabolol added this pull request to the merge queue Nov 26, 2024
Merged via the queue into main with commit 7118352 Nov 26, 2024
8 of 9 checks passed
@Jabolol Jabolol deleted the jabolol/npm-manifests-model branch November 26, 2024 18:59
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.
1 participant
@Jabolol