Eric Laurello
94c675dd69
.
2024-11-17 07:51:51 -05:00
Eric Laurello
a53826ae1a
bc
2024-11-12 11:28:06 -05:00
Eric Laurello
c292a8cde9
to prod
2024-11-12 11:07:57 -05:00
Eric Laurello
5b899cc5d7
500->200
2024-07-29 12:13:52 -04:00
Eric Laurello
5de77b6c76
de-batch
2024-07-29 09:45:06 -04:00
Eric Laurello
c5de5ded4c
osmosis -> blockjoy
2024-06-18 09:49:11 -04:00
Eric Laurello
ce6c632dc1
upgrade keys change batche sizes
2024-06-03 10:29:49 -04:00
Eric Laurello
c608f8a370
revert api key
2024-05-31 16:06:18 -04:00
Eric Laurello
0681d419af
atn update api key
2024-05-31 15:54:39 -04:00
Eric Laurello
f85048a4c5
speed up inc
2024-05-22 10:01:28 -04:00
Eric Laurello
fec4213460
missing url
2024-05-21 13:39:33 -04:00
eric-laurello
9253282a82
AN-4772 SL2.0 ( #153 )
...
Upgrade to sl2.0
---------
Co-authored-by: xiuy001 <xiuyang@flipsidecrypto.com>
2024-05-21 13:23:38 -04:00
Eric Laurello
ab0eaf9342
vault, fsc-utils workstream
2024-03-05 11:20:17 -05:00
eric-laurello
77bcbdfbe3
An-4550_stats ( #151 )
...
* On branch An-4550_stats
Changes to be committed:
modified: models/descriptions/__overview__.md
modified: models/descriptions/inserted_timestamp.md
new file: models/descriptions/modified_timestamp.md
new file: models/descriptions/pk.md
new file: models/descriptions/stats_core.md
new file: models/gold/stats/stats__ez_core_metrics_hourly.sql
new file: models/gold/stats/stats__ez_core_metrics_hourly.yml
new file: models/silver/stats/silver_stats__core_metrics_block_hourly.sql
new file: models/silver/stats/silver_stats__core_metrics_block_hourly.yml
new file: models/silver/stats/silver_stats__core_metrics_hourly.sql
new file: models/silver/stats/silver_stats__core_metrics_hourly.yml
* decimals
* blockchain 100 per
* speed up
* 5-> 50
2024-02-26 14:11:28 -05:00
Eric Laurello
a2662b1584
block_number
2023-12-18 07:29:43 -05:00
Eric Laurello
afae30e3d3
models
2023-10-25 12:41:19 -04:00
eric-laurello
13742ffb2f
Streamline cutover ( #141 )
...
* ready for cutover
* bronze to a table
* requested and var
* sources
* sources
* inc schedule change
2023-10-19 15:56:56 -04:00
xiuy001
e4c9432131
Add streamline models ( #136 )
...
* updated and added the rest api client and call
* updated
* increased sql limit
* updated params
* refresh
* updated
* updated the rest api call format
* updated
* updated
* updated
2023-09-26 16:03:26 -04:00
eric-laurello
bdd7b68ebd
add select tags ( #135 )
2023-09-08 08:59:36 -04:00
Ryan-Loofy
f7c577d8dc
Update get_blockchain_api.sql ( #133 )
2023-08-07 15:05:48 -04:00
Eric Laurello
c885a3a28f
block gaps
2023-05-23 11:27:20 -04:00
Jessica Huhnke
874e458d38
require version 1.4.0 or above dbt-core ( #111 )
...
* require version 1.4.0 or above dbt-core
* 1.4.0 dbt changes
2023-03-02 12:38:45 -06:00
eric-laurello
aff529847f
AN-2736 pools ( #99 )
...
* check in
* check in
* silver
* gold views
* remove dupe test, adjust silver logiv
* warning for pools with > 4 assets
2023-02-08 09:50:11 -05:00
eric-laurello
dd4bcc2d32
tags ( #94 )
2023-01-19 13:08:52 -05:00
eric-laurello
118b0af8c3
update rpc URL to be dynamic ( #85 )
2022-12-15 12:14:57 -05:00
eric-laurello
18a4d003fe
custom query tags ( #80 )
2022-12-13 17:30:33 -08:00
desmond-hui
a9c76a7046
An 2461/use latest streamline endpoints ( #81 )
...
* use streamline db location for source data
* use new streamline endpoints
* remove limits, now controlled from streamline at runtime
2022-12-12 13:49:43 -08:00
eric-laurello
368752d740
AN-2381 tx count macro and silver table ( #70 )
...
* tx count macro and silver table
* change to rpc call and schema change
* maxing out at 40K blocks per macro run
* column name changes
2022-11-14 11:08:57 -05:00
eric-laurello
e3482847d3
AN-2245 superfluid staked balances ( #64 )
...
* check in
* WIP check in
* WIP check in
* locked LP actions and balances
* add business logic test, fix test failure & typos
* ds store
* ds store
* more logic tests
2022-10-21 13:18:58 -04:00
eric-laurello
f8585d7764
better way to check for prod env ( #61 )
2022-10-12 11:45:45 -04:00
desmond-hui
f591b8a21e
organize streamline files, add all lp wallets to balances call ( #52 )
2022-07-18 14:04:06 -07:00
desmond-hui
ca228da608
combine udf create statements ( #49 )
2022-06-29 14:38:00 -07:00
desmond-hui
fe65b87238
add integration to get pool balances ( #47 )
2022-06-29 12:46:08 -07:00
desmond-hui
e6accf253c
An 1398/udf for validator metadata route ( #39 )
...
* udf and sp to call validator_metadata endpoint
* remove db name, let is run based on db context
2022-06-14 11:15:25 -07:00
desmond-hui
5cf0ef5eba
An 1325/integrate balances lambda ( #27 )
...
* integrate balances api, add raw balances external table
* remove silver balances placeholder
* fix hardcoded table names
* update snapshot date
2022-06-01 12:52:25 -07:00
desmond-hui
04fe197b7a
look for gaps excluding current date ( #24 )
2022-05-23 08:40:04 -07:00
desmond-hui
2ce56b09bd
An 1196/auto create ext tbls on dev refresh ( #9 )
...
* set dev db ownership for func and proc objects
* remove tasks, make callable from dbt cloud
2022-05-04 15:08:38 -07:00
desmond-hui
85368245d2
An 1132/asset metadata refresh process ( #8 )
...
* wip
* create udfs and sp to support api call
* these were accidentally removed
* add view/udf/sp needed for api integration
* dedupe asset metadata before putting into silver
* add ignore list to view
* add model descriptions
* fix where logic
2022-05-04 08:08:15 -07:00
eric-laurello
9272b2dca2
AN-1074 (1075 & 1076) Initial push of silver txn tables ( #6 )
...
* initial commit
* PR updates
* remove pivot from msg attribs
2022-04-28 11:06:52 -04:00
Jessica Huhnke
0c5cb5baa1
An 1073 silverblocks ( #4 )
...
* comments
* table description in yml
2022-04-26 07:56:58 -05:00
Desmond Hui
4f57683b61
fix name
2022-04-14 08:36:55 -07:00
Desmond Hui
fdd80a2850
initial setup files
2022-04-13 11:37:02 -07:00
