Commit Graph

7 Commits

Author SHA1 Message Date
drethereum
0f30a4b0a2
add tasks (#296) 2024-03-14 16:20:31 -06:00
Shah Newaz Khan
6b30fbc606
Stream 346 coingecko backfill (#224)
* prices udf success

* removed unused make directives

* removed unussed ohlc udf

* added CTE to generate tokens per chain

* generating time spine from dim_dates

* add dim_date ref()

* added uid filter to runtime cte

* added generic get_prices make directive

* added uid as unique key to complete_get_prices

* removed platform specific get prices model

* removed platform filter for get_prices_history

* fixed udf ponter for get prices

* added backfill gha

* fixed gha dbt command

* add  flag

* add role echo

* revert adhoc run roles echo

* added input type to adhoc run gha

* set use external dev tables

* cache deps

* revert cache

* text STREAMLINE_USE_DEV_FOR_EXTERNAL_TABLES envar

* fix envar capitalization

* echo vars

* revert var echo

* set update udfs to false for backfill gha

* moved UPDATE_UDFS_AND_SPS to dbt_project.yml

* update to use UID

* partition by uid

* added crossjoin uid to runtimes cte

* complete / runtimes

* use bronze view

* added udf params | added erro exclusion

* SO and cluster

* added prices backfill tag | renamed complete model

* pre-pended streamline to tags

* renamed concise tags

* renamed sl prices_history model | added appropriate tags to gha

---------

Co-authored-by: shah <info@shahnewazkhan.ca>
Co-authored-by: Austin <austin@flipsidecrypto.com>
2023-12-21 08:16:01 -08:00
desmond-hui
54dd848a90
remove legacy and unused resources (#89) 2023-01-17 10:08:20 -08:00
Graham Onders
dbadd6cac0
Ens table (#65)
* added ENS table codes

* added ENS and udfs
2022-11-15 13:57:16 -05:00
desmond-hui
06f2f37fd6
integrate with coingecko prices endpoints: (#19) 2022-08-24 13:27:31 -07:00
desmond-hui
c79ec93d98
An 1740/new crosschain prices (#4)
* integrate coin market cap asset ohlc api

* revert, accidentally moved this file

* add sample profile
2022-07-22 08:58:02 -07:00
desmond-hui
8aa7e64587
An 1698/prices pipeline (#1)
* add resources for prices pipeline integration

* trigger historical price gap fill with post hook
2022-07-12 12:14:13 -04:00