Jared Rhizor (Airbyte)
user
01/21/2021, 12:08 AMuser
01/21/2021, 12:10 AMroot@ca0be5786d74:/tmp/workspace/17/0/normalize/models/generated# cat stargazers.sql
with
stargazers_node as (
select
_airbyte_emitted_at,
{{ dbt_utils.current_timestamp_in_utc() }} as _airbyte_normalized_at,
cast({{ json_extract_scalar('_airbyte_data', ['user_id']) }} as {{ dbt_utils.type_float() }}) as user_id,
cast({{ json_extract_scalar('_airbyte_data', ['starred_at']) }} as {{ dbt_utils.type_string() }}) as starred_at,
cast({{ json_extract_scalar('_airbyte_data', ['_sdc_repository']) }} as {{ dbt_utils.type_string() }}) as _sdc_repository
from {{ source('public', '_airbyte_raw_stargazers') }}
),
stargazers_with_id as (
select
*,
{{ dbt_utils.surrogate_key(['user_id',
'starred_at',
'_sdc_repository']) }} as _airbyte_stargazers_hashid
from stargazers_node
)
user
01/21/2021, 12:10 AMuser
01/21/2021, 12:10 AMuser
01/21/2021, 12:10 AMroot@ca0be5786d74:/tmp/workspace/17/0# cat catalog.json
{"streams":[{"stream":{"name":"stargazers","json_schema":{"type":"object","properties":{"user":{"type":"object"},"user_id":{"type":"number"},"starred_at":{"type":"string"},"_sdc_repository":{"type":"string"}}},"supported_sync_modes":["incremental"],"source_defined_cursor":false,"default_cursor_field":[]},"sync_mode":"incremental","cursor_field":["user"]}]}
user
01/21/2021, 12:10 AMuser
01/21/2021, 12:11 AMuser
01/21/2021, 12:11 AMuser
01/21/2021, 12:11 AMuser
01/21/2021, 12:11 AMuser
01/21/2021, 12:11 AMuser
01/21/2021, 12:12 AMuser
01/21/2021, 12:13 AMuser
01/21/2021, 12:13 AMuser
01/21/2021, 12:13 AMuser
01/21/2021, 12:13 AMuser
01/21/2021, 12:14 AMuser
01/21/2021, 12:15 AMuser
01/21/2021, 12:16 AMuser
01/21/2021, 12:16 AMuser
01/21/2021, 12:16 AMuser
01/21/2021, 12:17 AMuser
01/21/2021, 12:17 AMuser
01/21/2021, 12:18 AMuser
01/21/2021, 12:18 AMuser
01/21/2021, 12:18 AMuser
01/21/2021, 12:19 AMuser
01/21/2021, 12:19 AMuser
01/21/2021, 12:19 AMuser
01/21/2021, 12:19 AMuser
01/21/2021, 12:20 AMuser
01/21/2021, 12:20 AMuser
01/21/2021, 12:20 AMuser
01/21/2021, 12:21 AMuser
01/21/2021, 12:23 AMuser
01/21/2021, 12:23 AMuser
01/21/2021, 12:31 AM