generated from FlipsideCrypto/evm-models-template
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdbt_project.yml
167 lines (138 loc) · 4.99 KB
/
dbt_project.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
# Name your project! Project names should contain only lowercase characters
# and underscores. A good package name should reflect your organization's
# name or the intended use of these models
name: "ink_models" # replace with the name of the chain
version: "1.0.0"
config-version: 2
# This setting configures which "profile" dbt uses for this project.
profile: "ink" # replace with the name of the chain
# These configurations specify where dbt should look for different types of files.
# The `source-paths` config, for example, states that models in this project can be
# found in the "models/" directory. You probably won't need to change these!
model-paths: ["models"]
analysis-paths: ["analysis"]
test-paths: ["tests"]
seed-paths: ["data"]
macro-paths: ["macros"]
snapshot-paths: ["snapshots"]
docs-paths: ["dbt_packages/fsc_evm/doc_descriptions", "models/doc_descriptions", "models"]
target-path: "target" # directory which will store compiled SQL files
clean-targets: # directories to be removed by `dbt clean`
- "target"
- "dbt_modules"
- "dbt_packages"
tests:
ink_models: # replace with the name of the chain
+store_failures: true # all tests
fsc_evm:
+store_failures: true
on-run-start:
- "{{ fsc_evm.create_sps() }}"
- "{{ fsc_evm.create_udfs() }}"
on-run-end:
- '{{ fsc_evm.apply_meta_as_tags(results) }}'
dispatch:
- macro_namespace: dbt
search_order:
- ink_models
- dbt_snowflake_query_tags
- dbt
query-comment:
comment: '{{ dbt_snowflake_query_tags.get_query_comment(node) }}'
append: true # Snowflake removes prefixed comments.
# Configuring models
# Full documentation: https://docs.getdbt.com/docs/configuring-models
models:
ink_models: # replace with the name of the chain
+copy_grants: true
+persist_docs:
relation: true
columns: true
+on_schema_change: "append_new_columns"
livequery_models:
+materialized: ephemeral
fsc_evm:
+enabled: false # disable fsc_evm package by default
+copy_grants: true
+persist_docs:
relation: true
columns: true
+on_schema_change: "append_new_columns"
main_package:
+enabled: false # disable main_package by default, enabled other packages as needed
core:
+enabled: true # enable subpackages, as needed
github_actions:
+enabled: true
prices:
+enabled: true
utils:
+enabled: true
decoder_package:
+enabled: false
abis:
+enabled: true
decoded_logs:
+enabled: true
vars:
"dbt_date:time_zone": GMT
STREAMLINE_INVOKE_STREAMS: False
STREAMLINE_USE_DEV_FOR_EXTERNAL_TABLES: False
UPDATE_UDFS_AND_SPS: False
UPDATE_SNOWFLAKE_TAGS: True
OBSERV_FULL_TEST: False
WAIT: 0
HEAL_MODEL: False
HEAL_MODELS: []
START_GHA_TASKS: False
#### STREAMLINE 2.0 BEGIN ####
API_INTEGRATION: '{{ var("config")[target.name]["API_INTEGRATION"] if var("config")[target.name] else var("config")["dev"]["API_INTEGRATION"] }}'
EXTERNAL_FUNCTION_URI: '{{ var("config")[target.name]["EXTERNAL_FUNCTION_URI"] if var("config")[target.name] else var("config")["dev"]["EXTERNAL_FUNCTION_URI"] }}'
ROLES: |
["INTERNAL_DEV"]
config:
# The keys correspond to dbt profiles and are case sensitive
dev:
API_INTEGRATION: AWS_INK_API_STG_V2
EXTERNAL_FUNCTION_URI: s5obssl6ba.execute-api.us-east-1.amazonaws.com/stg/
ROLES:
- AWS_LAMBDA_INK_API # replace with the name of the chain
- INTERNAL_DEV
prod:
API_INTEGRATION: AWS_INK_API_PROD_V2
EXTERNAL_FUNCTION_URI: uk8xhyg8pl.execute-api.us-east-1.amazonaws.com/prod/
ROLES:
- AWS_LAMBDA_INK_API # replace with the name of the chain
- INTERNAL_DEV
- DBT_CLOUD_INK # replace with the name of the chain
#### STREAMLINE 2.0 END ####
#### FSC_EVM BEGIN ####
# Please visit https://github.com/FlipsideCrypto/fsc-evm/wiki for more information on required and optional variables
### GLOBAL VARIABLES BEGIN ###
## REQUIRED
GLOBAL_PROD_DB_NAME: 'ink'
GLOBAL_NODE_SECRET_PATH: 'Vault/prod/ink/quicknode/mainnet'
GLOBAL_BLOCKS_PER_HOUR: 3600
GLOBAL_WRAPPED_ASSET_ADDRESS: '0x4200000000000000000000000000000000000006'
### GLOBAL VARIABLES END ###
### MAIN_PACKAGE VARIABLES BEGIN ###
### CORE ###
TRACES_HISTORY_NEW_BUILD: True
TRACES_HISTORY_SQL_LIMIT: 1500000
TRACES_HISTORY_PRODUCER_BATCH_SIZE: 3000
TRACES_HISTORY_WORKER_BATCH_SIZE: 1000
TRACES_FULL_RELOAD_START_BLOCK: 1500000
# GOLD_FULL_REFRESH: True #comment out for prod
# SILVER_FULL_REFRESH: True #comment out for prod
# BRONZE_FULL_REFRESH: True #comment out for prod
### PRICES ###
PRICES_NATIVE_SYMBOLS: "ETH"
PRICES_PROVIDER_PLATFORMS: ["ink"]
### MAIN_PACKAGE VARIABLES END ###
### DECODER_PACKAGE VARIABLES BEGIN ###
## REQUIRED
BLOCK_EXPLORER_NAME: "InkOnChain"
BLOCK_EXPLORER_ABI_URL: "https://explorer.inkonchain.com/api/v2/smart-contracts/"
# BRONZE_CONTRACT_ABIS_FULL_REFRESH: True #comment out for incremental runs
### DECODER_PACKAGE VARIABLES END ###
#### FSC_EVM END ####