mirror of
https://github.com/FlipsideCrypto/solana-models.git
synced 2026-02-06 13:01:50 +00:00
85876493df
* wip * wip udf * bronze and silver models for txcounts (wip) * optimize for chainhead * check for blocks with 0 txs * change tx count call to solscan blocks * only call 1000 at a time to solscan due to rate limits * update rewards realtime task (#378) * run solscan blocks multiple times per workflow dispatch * fix name * disable full refresh on bronze api table
12 lines
216 B
SQL
12 lines
216 B
SQL
{{ config(
|
|
materialized = 'table',
|
|
cluster_by = 'round(_id,-3)'
|
|
) }}
|
|
|
|
SELECT
|
|
ROW_NUMBER() over (
|
|
ORDER BY
|
|
SEQ4()
|
|
) - 1 :: INT AS _id
|
|
FROM
|
|
TABLE(GENERATOR(rowcount => 50000000)) |