mirror of
https://github.com/FlipsideCrypto/external-models.git
synced 2026-02-06 16:26:52 +00:00
20a1126d5b
Co-authored-by: San Yong <22216004+SanYongxie@users.noreply.github.com> Co-authored-by: gregoriustanleyy <gstanleytejakusuma@gmail.com>
10 lines
446 B
SQL
10 lines
446 B
SQL
{{ config (
|
|
materialized = 'view'
|
|
) }}
|
|
{{ streamline_external_table_query_v2(
|
|
model = 'bitquery',
|
|
partition_function = "CAST(SPLIT_PART(SPLIT_PART(file_name, '/', 3), '_', 1) AS INTEGER)",
|
|
partition_name = "partition_key",
|
|
other_cols = "to_date(value:DATE_DAY::STRING,'YYYYMMDD') AS DATE_DAY, to_date(value:DATE_DAY::STRING,'YYYYMMDD') AS DATE_DAY, value:BLOCKCHAIN::STRING AS BLOCKCHAIN, value:METRIC::STRING AS METRIC"
|
|
) }}
|