* unifai sl ingestion bronze and silver
* use call_function_v2 and add exploded_key
* use exploded key
* adjust float values
* use data col
* use secret
* add chain to qualify and pk
* update worker
* 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>
* update sp macro
* reducing lambda
* second debug
* wait fix
* fix batch
* try just with 1
* simplify batch results and retry logic
* make response_data table temporary
* remove unused var
* fix syntax
* remove union, limit 1000 endpoints per run
* run every hour
* add comment
* do not execute if 0 rows or remaining calls less than needed for a batch
---------
Co-authored-by: WHYTEWYLL <juanmiblanco1@gmail.com>
* add: base github
* fix: arrays
* fix: list
* fix: SW script to javascript
* fix: execite
* working version
* env_variable
* add: frecuency
* rentry logic
* stable code'
* delete extra
* refactor no SYSTEMWAIT
* limit
* Working version
* jobs and working version
* deleting: type column
* data unpacking
* silver model and test
* fix: limit; delete: not used functions;
* working version
* add: date
* secret name
* add: secret string
* coin gecko and cmc prices tables for all blockchains
* all_providers prices draft
* standardized platform column
* asset metadata, priority prices, and core dimensional/fact/ez tables for prices, metadata and contracts
* yml changes
* resolved issues with compiling
* prioritized symbol in prices
* unique address on ez prices
* updates to asset_metadata for efficiency
* asset_metadata updates for blockchain and unique_key
* prioritized coingecko symbol and decimals
* removed test
* removed eth pow and eth classic
* SO on priority prices model
* moved symbol and decimal joins to view layer
* moved dim_contracts join to asset_metadata view
* moved asset_metadata contracts join to view layer
* priority model for ez_asset_metadata and docs
* qualify statements modified
