* backfill macro for all verified IDLs for specified date
* fix checking for completed after single date retry
* add block_id predicate for completed subset
* add retry macro for single date
* make macro names consistent
* call streamline 2.0 endpoints
* update request query
* update to use streamline 2.0 data after cutoff
* formatting
* use new complete tables for backfill macros
* add larger lookback for first run, revert after
* fix comments
* update requests model
* only call streamline 2.0 endpoint
* use streamline 2.0 data after cutoff, formatting
* fix id column reference
* remove FR and add comment
* update helper to use new completed table
* update cutoff date, extend lookback
* initial
* block range macro and model work
* fix incr
* drop _2 update workflow
* delete the right file
---------
Co-authored-by: Desmond Hui <desmond@flipsidecrypto.com>
* wip
* change udf name, fix surrogate key for inner instruct calls
* (wip) decoded instructions backfill helpers
* complete backfill helpers, clean up views with 0 requests
* rename
* revert
* temp change will revert
* rename
* use streamline 2.0 verify idl api endpoint
* this is placeholder model, will replace existing when ready
* reorg files
* add workflow for decode instructions real time
* use pip cache
* update with prod endpoints
* update sql limit to real value, should be union all
* use ref for model names
* remove placeholder, replace existing model logic
* add new decoder flow to gha
* temp disable incremental
* add inner index to core tables
* match existing behavior until we properly incorporate inner_instruction txs
* temp disable
* wip
* change udf name, fix surrogate key for inner instruct calls
* (wip) decoded instructions backfill helpers
* complete backfill helpers, clean up views with 0 requests
* rename
* revert
* temp change will revert
* rename
* use streamline 2.0 verify idl api endpoint
* this is placeholder model, will replace existing when ready
* reorg files
* add workflow for decode instructions real time
* use pip cache
* update with prod endpoints
* update sql limit to real value, should be union all
* wip
* seperating out tokens / nfts still wip
* wip - token burns
* move nft / token burns into same model
* daily nft balance change
* signers add in NFT balances
* wip
* wip - ready to test
* signers
* signers change
* make the incremental / FR work
* added in reference to account ownership change table
* wip - ready to test
* wip
* remove test address
* add in token account column into the mints table
* merge main & fixes to incremental
* remove null signers
* add batch load macro that adds alias
* incremental update
* simplify model & remove column from signers
* fix it
---------
Co-authored-by: Desmond Hui <desmond@flipsidecrypto.com>
* wip
* seperating out tokens / nfts still wip
* wip - token burns
* move nft / token burns into same model
* daily nft balance change
* signers add in NFT balances
* wip
* wip - ready to test
* signers
* signers change
* make the incremental / FR work
* added in reference to account ownership change table
* wip - ready to test
* wip
* remove test address
* add in token account column into the mints table
* merge main & fixes to incremental
* remove null signers
* add batch load macro that adds alias
* incremental update
---------
Co-authored-by: Desmond Hui <desmond@flipsidecrypto.com>
* wip
* wip
* wip
* change dev owner to use new access role
* wip
* update names
* wip
* use macro for dynamic incremental logic
* change names, split stakes acct and token acct into own tables
* workflow to backfill
* disable new models from incremental while it backfills
* include mint of token account on creation
* inner index should not have no null tests, add mint to yml
* make inner_index -1 so that it can be included in unique key merge
* pr fixes
* add dupe tests
* change to full refresh only, works faster for backfills at least
* fix typo
* fix mint null test, only for create events
* account initialization also has mint value
* add ordering based on events to fix same block event issues
* simplify temporary exclude
