Commit Graph

54 Commits

Author SHA1 Message Date
Eric Laurello
2394e39329 disable failing test
Some checks failed
docs_update / run_dbt_jobs (push) Has been cancelled
docs_update / notify-failure (push) Has been cancelled
dbt_run_streamline_solscan_token_list / run_dbt_jobs (push) Has been cancelled
dbt_run_streamline_solscan_token_list / notify-failure (push) Has been cancelled
dbt_test_scheduled_weekly / run_dbt_jobs (push) Has been cancelled
dbt_test_scheduled_weekly / notify-failure (push) Has been cancelled
2025-11-07 14:54:15 -05:00
tarikceric
db6bbe8fb5 hot fix decoded test 2025-10-01 13:00:29 -07:00
tarikceric
cdfe5bc958
remove decoded logs v1 from workflow (#877)
* remove decoded logs v1 from workflow

* remove v2 decode test
2025-09-18 09:44:53 -07:00
tarikceric
c476a8f9fb
model (#825)
* model

* test

* revert

* add test for stake accounts recency

* ref cleanup

* add comment
2025-04-07 14:28:45 -07:00
desmond-hui
ebda48ad1d
use row_number to dedupe (#798) 2025-02-12 07:02:24 -08:00
desmond-hui
82e792e3dc revert temp warn 2025-01-02 07:42:46 -08:00
Eric Laurello
3a96baa41a temp warm 2024-12-27 00:02:23 -05:00
Eric Laurello
73aec3f807 temp change to warn 2024-12-26 23:18:30 -05:00
desmond-hui
044f8e8473 hotfix remove test for legacy streamline job 2024-12-16 07:33:52 -08:00
desmond-hui
a3b8cf8458
Deprecate legacy block txs pipeline (#735)
* move to backfill folder

* remove legacy udfs and calls

* use streamline 2.0 data after cutover block & partition

* update start block to do checks, add streamline 2.0 data

* fix ambiguous reference

* this test isnt used, it is currently ignored in the test workflow

* get partition from streamline 2.0 upstream when available

* add TODOs

* update partition and block cutoffs
2024-12-12 15:40:01 -08:00
tarikceric
f1839dcf91 hot fix enable test 2024-12-06 17:31:54 -08:00
desmond-hui
78a46b54b3 hotfix disable test due to solscan limits 2024-12-06 07:07:34 -08:00
desmond-hui
75ecb7fc78
remove partial partitions test (#722) 2024-12-02 08:46:46 -08:00
tarikceric
e4de79882d
An 5223/jupiter limit orders (#689)
* add limit order logic

* limit signers

* filter out incorrectly labeled limit swaps
2024-11-05 12:28:12 -08:00
desmond-hui
b962553b98
turn off legacy snowflake tasks that populate bronze.blocks2 (#690) 2024-11-04 08:56:05 -08:00
desmond-hui
b3ac67247c hotfix missing comma 2024-10-18 09:21:51 -07:00
desmond-hui
0e6555d975
fix buffer to be 12 hours instead of 1 day (#674) 2024-10-11 12:08:09 -07:00
desmond-hui
c450df542d remove strealime 1.0 check for rewards, its deprecated 2024-10-11 07:11:52 -07:00
desmond-hui
0d32c421e1
deprecate rewards models built on streamline 1.0 raw data (#668)
* deprecate rewards models built on streamline 1.0 raw data

* remove streamline 1.0 block rewards udf and tasks

* disable streamline 1.0 block rewards request views

* disable complete block rewards, change ref to source
2024-10-08 09:43:16 -07:00
tarikceric
8fff4ba7d1
add new dca signer addresses (#665) 2024-10-04 08:21:24 -07:00
desmond-hui
195651a0cc
add to dca keeper whitelist (#644) 2024-08-26 09:06:05 -07:00
desmond-hui
fad077ebe2
add test for new dca signers (#642) 2024-08-22 09:53:24 -07:00
desmond-hui
f2ba9fb086
Auto heal block rewards and test (#639)
* add test for missing streamline rewards

* self re-request missing streamline rewards
2024-08-20 07:21:37 -07:00
desmond-hui
775518e8bf
Hotfix/streamline legacy tasks (#628)
* add tests for solana legacy streamline pipeline disruptions

* formatting
2024-08-05 09:38:58 -07:00
desmond-hui
7cb093967d
Fix/solscan test for new silver transactions logic (#625)
* dedupe ids when unioning tx and votes + formatting

* dedupe ids when unioning tx and votes + formatting

* remove group by
2024-07-29 08:10:16 -07:00
desmond-hui
d9cad4cecb update partition pointer for test 2024-07-05 08:12:27 -07:00
desmond-hui
c5ca9c0466 update test start point 2024-06-28 11:22:17 -07:00
desmond-hui
66bff2a769
move marker for test, confirmed OK via other tests/manual check (#560) 2024-05-15 08:35:34 -07:00
desmond-hui
dc33a825af
Tag hourly tests (#559)
* tag hourly tests

* exclude hourly tests from daily run

* use new tag to run daily tests
2024-05-14 09:07:44 -07:00
tarikceric
9184b7f677
An 4281/token account owners (#501)
* wip

* wip

* add core, clean up

* update per pr comments

* update incremental config

* update logic

* FR model

* logic update for daily fr

* remove model

* recency test for token_account_owners

* refs and sysdate

---------

Co-authored-by: Eric Laurello <eric.laurello@flipsidecrypto.com>
2024-04-04 17:24:02 -07:00
desmond-hui
7327dd6f1b
add tests to tags and include/exclude using tag (#511) 2024-03-13 07:49:38 -07:00
desmond-hui
63ba7fce26
An 4544/add test to check idl decoding error rates (#506)
* test current error rates against past 90 days per program

* add static error threshold test

* lower static threshold

* fix hardcoded

* check 7 days worth of data

* rename

* run decoder error rate 7 day tests weekly
2024-03-12 06:43:26 -07:00
desmond-hui
39e4a6c076
adjust missing parts tests (#504) 2024-03-11 06:59:25 -07:00
desmond-hui
5da67c478c
An 4565/missing block txs and votes (#496)
* wip

* rename

* remove inserted timestamp filter

* revert

* remove semi colon

* add silver tx data quality checks, test hourly

* re-ingest any discrepancies found in solcan+silver check

* limit amount we can retry at one time
2024-02-27 08:07:55 -08:00
desmond-hui
542d0dec92
remove upperbound when searching for completed, too strict (#492) 2024-02-16 08:06:45 -08:00
desmond-hui
1bddbd88e9
make <= (#484) 2024-02-13 07:43:20 -08:00
Desmond Hui
8ddfe4e3c0 hotfix range of data being selected for test 2024-02-09 06:52:04 -08:00
Desmond Hui
620e3214cb remove ; 2024-02-08 09:17:47 -08:00
desmond-hui
9bc47cac30
add hourly test to check missing completed (#481) 2024-02-08 07:40:39 -08:00
desmond-hui
8901daf5de
add test to check for missing decoded instructs in silver (#438) 2024-01-09 08:31:00 -08:00
desmond-hui
b56b117c46
should use least partition loaded between votes and txs at time of test (#232) 2023-02-02 10:53:56 -08:00
desmond-hui
5ba1b4150a
hourly test to check bronze partitions are loaded properly into silver (#208) 2023-01-12 11:51:05 -08:00
Desmond Hui
b360766cb4 remove ; 2022-10-17 10:39:33 -07:00
desmond-hui
075f2bb493
output gap range instead of single block id (#134) 2022-10-14 11:04:47 -07:00
desmond-hui
c29d990444
An 2145/fix tests (#132)
* deprecate test no longer have tx_count col

* add block filter for null test

* rename
2022-10-13 15:31:34 -07:00
desmond-hui
9d6841fabb
change v2 references (#131) 2022-10-13 11:48:55 -07:00
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
Jessica Huhnke
66f9a18bc6
store test failures (#75)
* store test failures

* rename bespoke tests
2022-07-22 12:57:23 -07:00
desmond-hui
5bcf415235
add missing mints without mint price (#67)
* add missing mints without mint price

* fix block gap test

* fix to incremental

* add incremental to 1st part of union

* add incremental to 1st part of union

Co-authored-by: jhuhnke <jessica@flipsidecrypto.com>
2022-06-30 12:59:13 -07:00
Desmond Hui
9de8a198a5 hotfix: remove issue test so project compiles 2022-06-06 05:59:56 -07:00