* 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>
