Staging model for Find My Items

stg_find_my_item.sql

{{
  config(
    materialized='table'
  )
}}

with raw as (
  select
    name as name,
    timestamp as ts,
    location ->> 'latitude' as latitude,
    location ->> 'longitude' as longitude,
    location ->> 'altitude' as altitude,
    role ->> 'emoji' as emoji
  from {{ source('tap_findmy', 'item') }}
)

select
  latitude::float,
  longitude::float,
  altitude::float,
  ts,
  emoji,
  name
from raw