SAI
779f8ea3a4
csv
2025-05-27 00:10:24 -05:00
Jack Forgash
0b4bb81bd8
AN-5454/ABIs ( #388 )
...
* abi streamline pipeline - in prog
* add coalesce
* gha workflow
* CRs
2024-12-04 09:28:25 -07:00
Jack Forgash
88df737fa2
AN-5203/Deploy flowEVM ( #343 )
...
* 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
2024-09-05 20:43:33 -06:00
Jack Forgash
e3e9b6ec89
NFLAD Challenge - del dup wallets ( #260 )
...
* del 3/4 dup wallets
* del last
2024-01-22 12:02:30 -07:00
Jack Forgash
cb95faf856
beta view w rosters ( #259 )
2024-01-20 14:32:15 -07:00
Jack Forgash
fc83740b50
upd nv csv ( #224 )
2023-11-08 09:37:24 -07:00
WHYTEWYLL
d17d5f06d7
deprecation ( #222 )
...
* deprecation
* del old udf creation
---------
Co-authored-by: forgash_ <jmfxyz@pm.me>
2023-11-07 10:40:24 -07:00
WHYTEWYLL
6ce17a7219
Streamline Realtime and Backfill Models ( #156 )
...
* add: model to backfill
* fix: node's string format
* add tags
* upd collection model
* mainnet21 hardcoded collections history model
* del tag
* mainnet 21 getblock
* tag for 21
* realtime models
* alias num as height
* realtime tags
* add missing tag and newlines
* backfiller
* backfiller
* move script to folder (renamed) python, upd test accordingly w dir name ch
* upd script to accept model input, update jobs per method call
* error w use_dev arg
* add: silver mdoels
* limit backfill job in python script
* rename silver dbt models to streamline_ and move into silver/core
* explicit casting to silver streamline models
* add documentation to silver streamline models
* run only current mainnet and history mainnet 22 first
* activate schedule for gha
* del hardcoded mainnet models
* move history modes out of subdirs into history dir
* fix GHA vars
* del upstream 1+ from history step
* del tag
---------
Co-authored-by: Jack Forgash <jmfxyz@pm.me>
2023-08-30 08:38:01 -06:00
Shah Newaz Khan
1beb5f8ad6
Stream 392 lq udf ( #151 )
...
* node url join optimized | warehouse privilege grants
* added udf api
* revert udtf alias
---------
Co-authored-by: shah <info@shahnewazkhan.ca>
2023-08-22 10:29:42 -07:00
Shah Newaz Khan
d14843bd0c
Stream 98 fix nodeurl ( #141 )
...
* fixed node urls
* limited streamline_blocks to candidate node 7 root height
---------
Co-authored-by: shah <info@shahnewazkhan.ca>
2023-08-03 12:30:13 -07:00
Shah Newaz Khan
b344373700
Stream 98 node url seed ( #138 )
...
* added clone purge fix make directive
* fixed json parsing for get blocks history
* added aws_lambda_role envar to undo_clone directive | added database grants to lambda role
* get_node_url parsing error
* fixed varchar return type for get_node_url
* node mapping window function success
* removed get_node_url macro | added node_url seed
* removed debug logs | removed create node_url macro
* added filter to node_mapping CTE
* Update models/silver/streamline/core/streamline__blocks.sql
* fixed merge conflict
* Reduce columns for get_blocks_history
---------
Co-authored-by: shah <info@shahnewazkhan.ca>
2023-08-01 14:56:15 -07:00
Jack Forgash
7552fb7dfe
seed and test adj ( #133 )
...
* seed and test adj
* rm_typo
2023-07-25 11:00:32 -06:00
Jack Forgash
a06fac90ba
update version seed ( #131 )
...
* update version sewed
* newline
2023-07-23 09:28:22 -06:00
WHYTEWYLL
de09e6e00f
add: 248 celer id ( #127 )
2023-06-27 12:07:39 -07:00
Jack Forgash
23feeb5bc6
update seed
2023-06-02 15:44:18 -06:00
Jack Forgash
47e679b9d8
tweaks ( #107 )
2023-02-02 13:38:43 -07:00
Jack Forgash
232d2f61a0
id ( #85 )
2022-11-09 15:38:04 -07:00
Jack Forgash
b81c6c11ea
mainnet-20 ( #81 )
2022-11-02 13:03:37 -06:00
Jack Forgash
506de6354d
An 2242/nftz ( #71 )
...
* nft_two
* fixed - just move the logic over to the main model
* fix 2 marketplace interactions
* findpack nft
2022-10-07 14:07:09 -06:00
Jack Forgash
ee7efe3851
AN-2168/Add network ( #65 )
...
* net data
* add version
2022-09-19 17:48:12 -04:00
Jack Forgash
505f166046
AN-1945/fixes ( #59 )
...
* nft sales and dep tag
* fixes before removing dup tests
* test fixes
* nft sales
* avoid dupes
* return silver blocks test to split out that change in another pr
* last tweak
2022-09-02 13:51:19 -06:00
Jack Forgash
c5e8289666
AN-1865/bridge fix ( #52 )
...
* seed update
* usdc fix
2022-08-18 13:55:31 -06:00
Jack Forgash
f0e071cc6a
AN-1714/prices from swaps ( #37 )
...
* init silver model
* cluster by block_timestamp
* column fixes
* prices from swaps, need to update core to add symbol & contract
* token labels seed and updated core view
* docs
2022-07-06 16:36:41 -04:00
Desmond Hui
fdc4e6cf12
initial setup files
2022-04-14 11:34:12 -07:00
