text: {{ config(
      indexes = [{'columns':['_airbyte_unique_key'],'unique':True}],
      unique_key = "_airbyte_unique_key",
      schema = "test_normalization",
      tags = [ "top-level" ]
  ) }}
  -- Final base SQL model
  -- depends_on: {{ ref('pos_dedup_cdcx_scd') }}
  select
      _airbyte_unique_key,
      {{ adapter.quote('id') }},
      {{ adapter.quote('name') }},
      _ab_cdc_lsn,
      _ab_cdc_updated_at,
      _ab_cdc_deleted_at,
      _ab_cdc_log_pos,
      _airbyte_ab_id,
      _airbyte_emitted_at,
      {{ current_timestamp() }} as _airbyte_normalized_at,
      _airbyte_pos_dedup_cdcx_hashid
  from {{ ref('pos_dedup_cdcx_scd') }}
  -- pos_dedup_cdcx from {{ source('test_normalization', '_airbyte_raw_pos_dedup_cdcx') }}
  where 1 = 1
  and _airbyte_active_row = 1
  {{ incremental_clause('_airbyte_emitted_at') }}
  
  