Commit Graph

263 Commits

Author SHA1 Message Date
WHYTEWYLL
7b9ca34107 fix: test 2023-12-14 19:00:58 +01:00
WHYTEWYLL
0e82edc158 add: dim rename 2023-12-12 19:02:56 +01:00
WHYTEWYLL
91ba3b124d add: pk to topshot 2023-12-12 18:47:33 +01:00
WHYTEWYLL
602fb709d3 rename id 2023-12-12 18:33:54 +01:00
WHYTEWYLL
1a68407027 dix: name 2023-12-12 17:55:13 +01:00
WHYTEWYLL
fe4e20544c fix: name 2023-12-12 15:30:54 +01:00
WHYTEWYLL
8918d84e26 fix: errors 2023-12-12 02:10:39 +01:00
WHYTEWYLL
2d17556347 delete: unecesarry qualify 2023-12-12 01:13:25 +01:00
WHYTEWYLL
c4d8782d88 fix: order and names 2023-12-12 01:08:59 +01:00
WHYTEWYLL
66922d244f delete: description 2023-12-12 00:54:19 +01:00
WHYTEWYLL
16e0f0fec1 fix: gold layer 2023-12-12 00:29:02 +01:00
Jack Forgash
86f8f5a6a6 add underscore _invocation 2023-12-11 15:08:14 -07:00
Jack Forgash
3a62cb8152 list col names in swaps_events_s 2023-12-11 15:03:09 -07:00
WHYTEWYLL
2c9e46555a fix: models 2023-12-11 22:46:26 +01:00
WHYTEWYLL
99792596f6 Merge branch 'pk-ids' of github.com:FlipsideCrypto/flow-models into pk-ids 2023-12-11 20:54:38 +01:00
WHYTEWYLL
80150e2021 add: nfts 2023-12-11 20:51:57 +01:00
Jack Forgash
43b85cd59d add missing comma in silver__streamline_blocks 2023-12-11 12:33:48 -07:00
WHYTEWYLL
afd360b681 price and half nfts 2023-12-11 20:10:27 +01:00
WHYTEWYLL
1b17e901c3 gold: defi keys 2023-12-11 19:33:29 +01:00
WHYTEWYLL
246d374634 gold core pk 2023-12-11 17:58:50 +01:00
WHYTEWYLL
94cc002579 fix: doc 2023-12-11 15:15:26 +01:00
WHYTEWYLL
26fe33c903 add: silver swaps and transfers jk 2023-12-05 16:43:43 -03:00
WHYTEWYLL
f934e7c636 add: silver staking jk 2023-12-05 16:06:02 -03:00
WHYTEWYLL
588f678178 add silver prices pk 2023-12-05 15:58:01 -03:00
WHYTEWYLL
093427209e add: silver metadata jk 2023-12-05 15:04:00 -03:00
WHYTEWYLL
68b95e2503 add: silver labels jk 2023-12-05 12:00:11 -03:00
WHYTEWYLL
b25fac32e9 add: keys core 2023-12-05 11:39:02 -03: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