Jack Forgash
da45d3f781
incr limit on evm address threshold to 110k ( #438 )
...
* incr limit on evm address threshold to 110k
* severity - warn
2025-04-30 10:57:22 -06:00
Jack Forgash
d2b6a46a9d
stop testing for null points ( #429 )
2025-04-09 09:26:48 -06:00
Jack Forgash
5725799ff6
Points Balance Reschedule ( #426 )
2025-04-07 18:31:03 -06:00
Jack Forgash
7a3eb1ef46
AN-5887/points fix, add complete model ( #419 )
2025-04-02 07:49:15 -06:00
Jack Forgash
2a4846b972
Quickfix rewards balances ( #412 )
...
* chg test threshold and decrease concurrency
* rm created_at null tests
* elevate response json, fix qualify loc
* fix unique key
* chg gha silver to 2utc
2025-02-20 12:38:16 -07:00
Jack Forgash
f0d6462111
Rewards points batch ( #405 )
...
* chg batch size
* add website and org id to minting assets
* upd test config
* typo
* worker batch size
2025-02-06 10:12:14 -07:00
Jack Forgash
56a247a6bd
AN-5671/rewards gold views ( #389 )
...
* rewards gold views
* yml files
* incr upper limit of evm addresses
* document fields
* upd xfers model desc
* upd test and col
* upd to exploded key and silver model
* add test range to data_mb
* addback qualify
* Silver to table
* split load and flatten
* add at_least_one test
2025-01-16 08:38:29 -07:00
Jack Forgash
7edd60669c
AN-5418/Flow x EVM address mapping ( #377 )
...
* address mapping
* gold
* upd comment, recency threshold, kill distinct
2024-11-11 12:50:01 -07:00
Jack Forgash
f1c0a24186
upd native token address ( #372 )
2024-10-29 10:22:35 -06:00
Jack Forgash
da6606c12f
Update core__ez_token_transfers.yml ( #367 )
2024-10-10 12:12:14 -06:00
Jack Forgash
96755a007d
AN-5236/new transfers model ( #364 )
...
* 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
2024-09-19 13:31:36 -06:00
Jack Forgash
2988813d42
upd tag to non-core ( #362 )
2024-09-13 13:21:24 -06:00
Jack Forgash
9a7151bfc1
AN-5209/Upd staking model ( #358 )
...
* Upd staking model
* drop _s suffix
* rm event_data col
* upd desc
2024-09-13 11:07:37 -06:00
Jack Forgash
ccf595e199
AN-5100/tx actors model ( #361 )
...
* 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
2024-09-13 09:40:45 -06:00
Jack Forgash
14d52208aa
rm deprecated views ( #359 )
2024-09-11 09:09:52 -06:00
Jack Forgash
eb3247ca26
last _adj ( #348 )
2024-08-01 10:25:11 -06:00
Jack Forgash
433e62a63c
AN-4553/deploy new defi gold views ( #345 )
...
* 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
2024-08-01 10:22:24 -06:00
Jack Forgash
a600e38457
upd dim metadata tests ( #347 )
2024-07-31 11:41:57 -06:00
Jack Forgash
30ce62f6a0
AN-4936/Backfill Migration Final ( #335 )
...
* del cw models
* core views
* defi views
* gov view
* nft_views
* rm ref to old cw models
* del internal cols
* nv 13-15
* nv 13-15
* nv 17-18
* nv 20
* del temp logic
* upd tests on allday metadata
* upd to warn
2024-07-01 13:27:42 -06:00
Jack Forgash
f3e6d0bfab
del deprecating price models ( #332 )
2024-06-12 12:02:08 -06:00
Jack Forgash
ffcb6d1492
add args to core fact_transactions ( #331 )
2024-06-06 22:34:28 -06:00
Jack Forgash
5ecb01870e
add script field to fact transactions ( #330 )
...
* add script field
* add to yml
2024-06-06 21:20:42 -06:00
WHYTEWYLL
a0e441d668
deprecation and new view ( #318 )
...
* deprecation and new view
* reorg
* is_deprecated
* deprecated
* upd dbt model tag
---------
Co-authored-by: forgash_ <jmfxyz@pm.me>
2024-05-01 13:49:33 -06:00
Jack Forgash
894788f9b8
AA-4660 / dex swaps upd ( #314 )
...
* 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
2024-04-22 09:59:21 -06:00
WHYTEWYLL
989fdb6cfa
add stats flow, gas pending ( #279 )
...
* add stats flow, gas pending
* fee to table
* stats flow
* fix float, schedule
2024-02-26 16:13:58 -03:00
WHYTEWYLL
759836fc8d
An 4437 add or account for all day burned moments ( #263 )
...
* a
* filter previus attempts
* fix empty pack
* del filt
* severity adjust
2024-02-05 15:07:51 -03:00
WHYTEWYLL
e7615a0cc6
Update labels ( #262 )
...
* a
* lavels source updated
* add core view
* unique id
* delete coalesces
2024-01-31 13:44:59 -03:00
Jack Forgash
cb95faf856
beta view w rosters ( #259 )
2024-01-20 14:32:15 -07:00
Jack Forgash
7c87cd4225
Beta allday espn id view ( #255 )
2024-01-05 12:57:55 -07:00
Jack Forgash
074c11c55a
fix id col in dim allday metadata ( #253 )
2024-01-04 09:03:25 -07:00
Jack Forgash
b26bf67732
upd desc on views ( #251 )
2023-12-19 17:26:19 -05:00
Jack Forgash
4c4ef12ca8
AN-4333/beta views for archiving espn ids for livequery use ( #249 )
...
* beta views for archiving espn ids for livequery use
* list cols
2023-12-19 13:40:30 -05:00
WHYTEWYLL
5c4e7bfdf8
fix: errors ( #246 )
...
* fix: errors
* format
* fix: typo
2023-12-15 07:21:42 -08:00
WHYTEWYLL
e8851383c9
Flow - add pk/inserted & modified dates/_invocation id ( #239 )
...
* add: keys core
* add: silver labels jk
* add: silver metadata jk
* add silver prices pk
* add: silver staking jk
* add: silver swaps and transfers jk
* fix: doc
* gold core pk
* gold: defi keys
* price and half nfts
* add missing comma in silver__streamline_blocks
* add: nfts
* fix: models
* list col names in swaps_events_s
* add underscore _invocation
* fix: gold layer
* delete: description
* fix: order and names
* delete: unecesarry qualify
* fix: errors
* fix: name
* dix: name
* rename id
* add: pk to topshot
* add: dim rename
* fix dim metadata views
---------
Co-authored-by: Jack Forgash <58153492+forgxyz@users.noreply.github.com>
2023-12-12 11:49:18 -08:00
WHYTEWYLL
9dae9f240f
Pipeline metadata ( #238 )
...
* add: if condition
* removed row_list
* add: gold view, fix macro, and silver models
* gold view extension
* add: test bronce
* g
* adding test
* add: test
* add: working test
* delete: tags
* delete: hardcode ref
2023-12-04 07:16:32 -08:00
Jack Forgash
b33dc89a39
swap set description col ( #232 )
...
* swap set description col
* cast str
2023-11-20 16:39:47 -07:00
Jack Forgash
c82c04ad5d
del invocation id from gold ( #231 )
2023-11-20 16:30:38 -07:00
Jack Forgash
121c3e6a2c
AN-4203/ufc strike metadata ( #230 )
...
* ufc strike metadata, plus organized nft folder better
* upd db tag on gold
* upd col name to serial number
* del listing id
* add back listing id
2023-11-20 16:26:39 -07:00
Jack Forgash
821214294c
AN-4096/DEX Swaps Bug ( #228 )
...
* add event counts col to easily ignore infra events
* excl txs where to/from is null
* add tests
2023-11-15 17:15:56 -07:00
Jack Forgash
cff19a7bb6
upd test window ( #227 )
2023-11-14 17:42:25 -07:00
WHYTEWYLL
d17d5f06d7
deprecation ( #222 )
...
* deprecation
* del old udf creation
---------
Co-authored-by: forgash_ <jmfxyz@pm.me>
2023-11-07 10:40:24 -07:00
Jack Forgash
ea46f3ee02
Adj Test on Beta and Upd Staking Actions ( #206 )
2023-10-16 18:17:45 -06:00
Jack Forgash
75901993ad
del tests from deprecating core models ( #205 )
2023-10-16 13:13:28 -06:00
Jack Forgash
be73c9ba99
Upd workflows for streamline models. Disables CW models. ( #202 )
...
* upd workflows for streamline models. Disables CW models.
* repo var
* upd tx_count null test
* ch to 6 hrs
2023-10-12 17:35:59 -06:00
Jack Forgash
bd08ee7f8f
An 4015/streamline cutover ( #200 )
...
* 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`
2023-10-12 16:23:20 -06:00
Jack Forgash
caf9f4804c
An 3780/schema reorg ( #153 )
...
* 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
2023-08-31 10:38:17 -06:00
Jack Forgash
45f72e71d8
An 3660/observability models ( #155 )
...
* 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
2023-08-23 13:37:16 -06:00
Jack Forgash
12e951471d
upd slack msg ( #139 )
...
* upd slack msg
* Update dbt_test_alert.py
* !
* alter tests
2023-08-01 10:29:14 -06:00
Jack Forgash
7552fb7dfe
seed and test adj ( #133 )
...
* seed and test adj
* rm_typo
2023-07-25 11:00:32 -06:00
Jack Forgash
d25b02df55
Prices from Swaps update ( #126 )
...
* workflow_prod and core->gold
* update prices from swaps
2023-06-07 16:42:53 -06:00
