text: USE [test_normalization];
      execute('create view _airbyte_test_normalization."nested_stream_with_co__lting_into_long_names_ab1__dbt_tmp" as
      
  -- SQL model to parse JSON blob stored in a single column and extract into separated field columns as described by the JSON Schema
  select
      json_value(_airbyte_data, ''$."id"'') as id,
      json_value(_airbyte_data, ''$."date"'') as "date",
      json_query(_airbyte_data, ''$."partition"'') as "partition",
      _airbyte_ab_id,
      _airbyte_emitted_at,
      SYSDATETIME() as _airbyte_normalized_at
  from "test_normalization".test_normalization._airbyte_raw_nested_stream_with_complex_columns_resulting_into_long_names as table_alias
  -- nested_stream_with_co__lting_into_long_names
  where 1 = 1
  
      ');
  
  