text: {{ config(
      cluster_by = "_airbyte_emitted_at",
      partition_by = {"field": "_airbyte_emitted_at", "data_type": "timestamp", "granularity": "day"},
      unique_key = env_var('AIRBYTE_DEFAULT_UNIQUE_KEY', '_airbyte_ab_id'),
      schema = "_airbyte_test_normalization",
      tags = [ "top-level-intermediate" ]
  ) }}
  -- SQL model to cast each column to its adequate SQL type converted from the JSON schema type
  select
      cast(id as {{ dbt_utils.type_string() }}) as id,
      cast(conflict_stream_name as {{ type_json() }}) as conflict_stream_name,
      _airbyte_ab_id,
      _airbyte_emitted_at,
      {{ current_timestamp() }} as _airbyte_normalized_at
  from {{ ref('conflict_stream_name_ab1') }}
  -- conflict_stream_name
  where 1 = 1
  
  