* new transfers models - still a few edge cases
* fix 1 withdrawal 2 deposited edge case
* upd filter in legacy model
* core union all and view -> incremental
* rm silver so
* tx actors model
* upd silver
* gold ez tbl
* segment out actors from tx-level participants
* Add alias
* add rn to de-duplicate join in ez
* add incremental_predicates
* final add mod ts cluster, tx_succeeded
* an-5198-upd-block-gap-test
* evm block gap test
* evm gaps tests
* blocks and txs tests
* logs tests
* add evm gap test to daily test gha
* run evm job in separate gha workflow
* bridge complete model
* depr notice on ez. Tests on fact bridge. TODOs - naming convention for amount and use chain IDs??
* ez and fact bridging
* dex swaps
* fix id col name. add platform to dex
* rm adj
* move models to bronze
* blocks backfill logic ez ez ez
* streamline_load models for all 4 methods
* add back a set of views for the complete models to use
* del dbt run history gha workflow
* migrate txs final to modified ts
* upd events to modified
* set default val for LOAD_BACKFILL_VERSION in project yml
* update curated model incr logic
* new swap model
* comment todos
* swaps aggregator model
* swap aggregator parsing
* upd requested fixes
* add date coalesce to ez view
* swaps agg yml
* platform doc
* test a from the base line on env var
* quotes
* fine tune trasnactions and results
* format
* error
* increasing producer_batch_size
* add: transactions mainnet
* mainet 18
* reducing job
* var del
* increasing producer batch size
* increasing batch size and worker
* workers limit
* reducing producer
* add fin
* fix doubled key values
* test a from the base line on env var
* quotes
* fine tune trasnactions and results
* format
* error
* increasing producer_batch_size
* add: transactions mainnet
* mainet 18
* reducing job
* var del
* increasing producer batch size
* increasing batch size and worker
* workers limit
* reducing producer
* test a from the base line on env var
* quotes
* fine tune trasnactions and results
* format
* error
* increasing producer_batch_size
* add: transactions mainnet
* mainet 18
* reducing job
* var del
* increasing producer batch size
* increasing batch size and worker
* workers limit
* test a from the base line on env var
* quotes
* fine tune trasnactions and results
* format
* error
* increasing producer_batch_size
* add: transactions mainnet
* mainet 18
* reducing job
* var del
* increasing producer batch size
* increasing batch size and worker
* test a from the base line on env var
* quotes
* fine tune trasnactions and results
* format
* error
* increasing producer_batch_size
* add: transactions mainnet
* mainet 18
* reducing job
* var del
* increasing producer batch size
* test a from the base line on env var
* quotes
* fine tune trasnactions and results
* format
* error
* increasing producer_batch_size
* add: transactions mainnet
* mainet 18
* reducing job
* var del
* test a from the base line on env var
* quotes
* fine tune trasnactions and results
* format
* error
* increasing producer_batch_size
* add: transactions mainnet
* mainet 18
* upd sources, convert blocks to loop model, fix collections history
* multiple external tbl query macro and blocks update
* del network version.yml output
* add back rt blocks
* lower blocks
* revert str blocks and collections and move change to history view
* bronze history views and move into folders
* history workflow - blocks
* del history step from streamline blocks
* create complete get history models and upd get history streamline views - BLOCKS
* upd remaining method get history views to use history complete tables
* upd txs history dependency note
* upd history gha and del parameterized models
* fix collections external table config
* collections template fix
* upd txs templates
* upd history views
* fix to tx results template / views
* set history schedule to hourly
* del commented out backfill from streamline RT GHAs
* move blocks filter up to cte
* modify how dbt performs merges by default
* require at least dbt 1.4
* adjust cluster keys, add incremental pred
* ensure query is being pruned on timestamp
* add cluster key
* archive parameterized model
* create views for each network ver
* network version views
* newline
* switch tx results realtime back to us-east-1
* del blocks history mainnet23
* add backfill step to streamline GHA
* newline
* rm dup WHERE
* upd name and del dup where from template
* core views
* defi schema
* bridge test upd
* gov schema
* nft schema
* price schema
* move tx count to blocks model
* add collection_count_agg to blocks
* upd core views to UNION ALL
* upd collections cluster_by
* upd dim moment metadata to qualify
* upd dim moment metadata test
* upd core dim contract labels to qualify and silver (cw) to incr
* upd str blocks lookback`
* txs final and upd streamline tests w 1 hr inserted timestamp buffer
* copy silver models into silver_cw dir
* txs final, events model, curated model _s copies
* add pending col to txs final
* test config for pending_result_response
* add coalesce to tx id in txs final
* rem tests on inserted timestamp
* uppercase gap test vars
* add retry for null block timestamp and del mainnet23 filter from events
* address adj append 0x, add network ver to blocks, etc
* upd coalesce on events data
* saving event migration test, disabled
* req changes
* upd txs final ingested logic
* topshot metadata pull v1
* before swap from lambda
* ready for stress test / batch sizing tmrw
* define unique key in helper tbl
* typo
* add todo deloy udf_api
* slight format tweak
* named
* migrate to livequery schema
* add parameter yml
* add livequery model yml, need tests
* alter metadata job run
* del old streamline macros
* silver upd - in flight
* clean up py model
* limit comment
* revert silver topshot metadata
* new silver model
* union new lq data into nft metadata table(s)
* del block_timestamp from metadata needed view
* untag silver nft allday metadata
* set limit to 3500
* addback topshot tag
* update schedule to hourly
* folder structures
* new views
* update docs overview
* upd sources
* upd sources and move silver from base to core
* del flipside prod db prices v2
* add scheduled tag to new views
* 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>
* blocks completeness
* block tx count external api model
* txs completeness model
* add col alias
* test result agg cte and temp test range
* curr range test
* revert source change - other pr
* xchain silver
* nuke api key & move to secrets, create workflow
* add scheduled tag
* update workflow w cache
* add obs tag
* rem testing range from txs complete
* comment out schedule and del double comman
* add default null for key var
* 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
* removed debug logs
---------
Co-authored-by: shah <info@shahnewazkhan.ca>
