Commit Graph

21 Commits

Author SHA1 Message Date
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