mirror of
https://github.com/FlipsideCrypto/flow-models.git
synced 2026-02-06 19:16:43 +00:00
88df737fa2
* flow evm init * flow evm testnet - blocks * deploy dev udfs, update typo * send block height as hex * dev limit * use stg external table * some links * add query to side doc * upd external tbl to stg & testnet * silver and evm txs * testnet silver models pt1 * testnet events final, decode hash udf * udf get evm chainhead * upd resource list * new udf. receipts pipeline. upd testnet model cols. expand readme * receipts silver * traces * vault * reorg to evm dir * rm testnet, blocks lookback * lookbacks, move qualify * macro and align naming * del testnet, reset namespace to gen * silver_evm - receipts and txs * core_evm fact_blocks & fact_transactions * fix vault path in get blocks. Logs v1 (need sample) * core_evm fact_logs * CR updates * del readme and add workflow * upd vault path, batch size * incr logic on modified to core_evm * use local utils.udf, add blockNumber col to complete blocks check * rm col * correct _invocation_id * upd nv csv * incr batch limit due to late start * add evm tag to model run
9 lines
209 B
SQL
9 lines
209 B
SQL
{{ config (
|
|
materialized = 'view'
|
|
) }}
|
|
|
|
{{ streamline_external_table_query_v2(
|
|
model = "evm_blocks",
|
|
partition_function = "CAST(SPLIT_PART(SPLIT_PART(file_name, '/', 3), '_', 1) AS INTEGER )"
|
|
) }}
|