Commit Graph

104 Commits

Author SHA1 Message Date
desmond-hui
d573bf32cb
An 2145/hot swap (#130)
* update table references

* rename of *2 models

* swap old and *2 models; update refs

* An 2145/add error col to completed log (#126)

* add error column to completed table output

* fix group by

* add error column for completed blocks update

* auto fill block gaps

* gap test for blocks2

* re-request missing txs real-time

* test for bronze to silver data load

* add error col, match updated

* test for missing partition in transactions or votes

* test for tx gaps in streamline data

* exclude partition 1877

* fix group by

* remove hardcoded prod db references

* change v2 references to v1

* make version change same as main

* no longer need historical staking lp actions, included in regular model (#128)

* no longer need historical staking lp actions, included in regular model

* remove additional resources related to historical staking lp actions

* avoid name clash, remove duplicate test

* remove ingested_at from models

* tx_count no longer a col

* remove invalid condition, col didnt exist

* remove min block_id filter

* remove deprecated columns

Co-authored-by: tarikceric <tarik@flipsidecrypto.com>
2022-10-13 11:19:41 -07:00
desmond-hui
cf75e9f70f
fix nft seller issue, add output test cases (#121) 2022-10-06 15:08:08 -07:00
desmond-hui
af2ce900af
An 1605/nft mints refactor (#102)
* refactor nft mints model

* An 1949/bt (#95)

* date limit some program

* block timestamp

* fixes

* fix

* An 1937/blocks txs2 (#94)

* blocks

* transactions and deduping wip

* silver reorganization

* remove tx count from blocks

* wip

* load blocks backfill incrementally

* wip

* wip

* wip

* remove unused comments

* fix ref to wrong table

* update to tests

* test fixes

* moved yawww bids

* merge main & fix refs

Co-authored-by: Desmond Hui <desmond@flipsidecrypto.com>

* description updates (#96)

* fix missing incremental block (#97)

* reduce batch load size (#98)

* Adjust tx2 incremental load size (#99)

* reduce batch load size

* revert change

* revert change

* minor cleanup and add model output comparison test

* move models to nft folder

* add test case

* update/add descriptions and tests

* adjust unique key

* adjust unique key, add columns to output

* add alias for new tx_id name from underlying model

* add index + inner_index to output and unique key

* remove inner index test

* fix unique key

Co-authored-by: Jessica Huhnke <91915469+jhuhnke@users.noreply.github.com>
2022-09-14 07:50:59 -07:00
Desmond Hui
9c07fdb96b dbt proj files and sp setup 2022-02-25 14:49:40 -08:00