text: 
    create view _airbyte_test_normalization.`nested_stream_with_co_1g_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_extract(table_alias._airbyte_data, 
      '$."partition"') as `partition`,
      _airbyte_emitted_at
  from test_normalization._airbyte_raw_nested_s__lting_into_long_names as table_alias
  -- nested_stream_with_co__lting_into_long_names
    );
  