shah
96c18610c7
fix udf 2 api integration
2024-02-13 08:05:28 -08:00
WHYTEWYLL
35c6053bcd
Finetune ( #266 )
...
* test a from the base line on env var
* quotes
2024-02-13 11:30:01 -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
6d53230f0a
Fix labels ( #265 )
...
* add deleted
* hotfix
2024-01-31 16:11:00 -03:00
WHYTEWYLL
39d17e3f12
add deleted ( #264 )
2024-01-31 14:20:56 -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
WHYTEWYLL
1a6a72f5f2
An 4442 flow dbt1.7 ( #261 )
...
* pkg lock and dbt docs
* update: 1.7
* profile
* update docs
---------
Co-authored-by: forgash_ <jmfxyz@pm.me>
2024-01-30 15:44:19 -03:00
Jack Forgash
e3e9b6ec89
NFLAD Challenge - del dup wallets ( #260 )
...
* del 3/4 dup wallets
* del last
2024-01-22 12:02:30 -07:00
Jack Forgash
cb95faf856
beta view w rosters ( #259 )
2024-01-20 14:32:15 -07:00
Jack Forgash
e0818966ad
AN-4428/add user agent to topshot and upd metadata job ( #258 )
...
* add user agent to topshot and upd metadata job
* upd agent
* upd limit to 600
2024-01-18 09:19:18 -07:00
WHYTEWYLL
59b3a5b4b5
fix: parse ( #248 )
...
* fix: parse
* fix: hex parse
* fix: format
* add: fix
* delete: last month filter
* a
* fix: parser
* delete: date filter
2024-01-16 12:09:37 -07:00
WHYTEWYLL
2fe9333eea
add: user agent to not get ban ( #257 )
2024-01-10 14:29:37 -03: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
ed9f306241
upd schedule to hourly ( #254 )
...
* upd schedule to hourly
* revert allday metadata
2024-01-03 16:33:56 -07:00
Jack Forgash
b26bf67732
upd desc on views ( #251 )
2023-12-19 17:26:19 -05:00
Jack Forgash
6e666d29a7
upd history cron - daily ( #250 )
2023-12-19 16:09:14 -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
50962af5a5
fix: usdc mint transfers ( #247 )
...
* fix: usdc mint transfers
* format
* refactor
2023-12-18 11:57:18 -03:00
WHYTEWYLL
5c4e7bfdf8
fix: errors ( #246 )
...
* fix: errors
* format
* fix: typo
2023-12-15 07:21:42 -08:00
Jack Forgash
9690c3102c
chg schedule to 3x/hour ( #244 )
...
* chg schedule to 3x/hour
* blocks
* dbt schd
2023-12-13 19:32:13 -07:00
Jack Forgash
cf26afc365
chg schedule to 4x/hour ( #243 )
2023-12-13 08:33:54 -07: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
Jack Forgash
c51d0c38b3
incr to 3x/hr ( #242 )
2023-12-11 16:52:05 -07:00
Jack Forgash
28e4dd0981
upd lookback in tx res cte ( #241 )
...
* upd lookback in tx res cte
* autofmt
2023-12-06 16:13:17 -07:00
Jack Forgash
971d555dff
update prod clone macro ( #240 )
2023-12-06 13:12:46 -07: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
WHYTEWYLL
150fbea1ab
fix: dedeuplicates ( #237 )
2023-11-29 08:44:07 -08:00
WHYTEWYLL
3e5e0a4bdd
Update silver__nft_allday_metadata_s.sql ( #236 )
2023-11-29 08:29:39 -08:00
WHYTEWYLL
d3b3c9667f
Update dbt_run_moments_metadata.yml ( #235 )
2023-11-29 06:44:14 -08:00
Jack Forgash
df7b62123c
Streamline Backfill: upd workflow activate txs tx results ( #233 )
...
* upd workflow activate txs tx results
* upd schedule to 30 mins
2023-11-27 12:22:55 -07:00
desmond-hui
b0c422cfdf
reduce risk of running livequery_models accidentally ( #234 )
2023-11-27 08:09:06 -08:00
WHYTEWYLL
6d6f478df6
alldaynft metadata with LQ ( #229 )
...
* base
* clean up; add: silver model
* add: new standards
* fix: refactor
* delete: folders
* refactor simplying
* remove no longer needed
* fix: refactor to silver layer
* ready to merge
---------
Co-authored-by: Desmond Hui <desmond@flipsidecrypto.com>
2023-11-27 07:55:44 -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
Jack Forgash
f7fa714ddc
Update dbt_run_history.yml ( #226 )
2023-11-10 16:29:25 -07:00
Jack Forgash
80c2462ac4
core v non-core tags and gha workflow ( #225 )
2023-11-10 14:30:57 -07:00
Jack Forgash
fc83740b50
upd nv csv ( #224 )
2023-11-08 09:37:24 -07:00
Jack Forgash
5b096dd83f
upd labels source ( #223 )
2023-11-07 11:48:11 -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
366f25b1d3
fix to 1 line ( #220 )
2023-10-31 22:06:42 -06:00
Jack Forgash
7f5f9c79b5
upd history to blocks and collections, 5x/hr ( #219 )
2023-10-31 21:49:01 -06:00
Jack Forgash
59097b6a1f
upd history run to every half hour ( #218 )
2023-10-31 15:51:24 -06:00
Jack Forgash
cc6f797d71
alter test on bitquery job ( #217 )
2023-10-31 11:48:27 -06:00
Jack Forgash
cd39800d32
add streamline vars as repo vars and upd history workflow ( #216 )
2023-10-31 11:24:07 -06:00
Jack Forgash
eb40b6d91d
Backfill Model - Incorporate all external tables ( #211 )
...
* 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
2023-10-26 11:31:19 -06:00
desmond-hui
63ab57f844
An 4065/incremental load tuning ( #215 )
...
* 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
2023-10-26 07:02:53 -07:00
