text: 
    create or replace  view "AIRBYTE_DATABASE"._AIRBYTE_TEST_NORMALIZATION."NESTED_STREAM_WITH_COMPLEX_COLUMNS_RESULTING_INTO_LONG_NAMES_64A_PARTITION_AB3"  as (
      
  -- SQL model to build a hash column based on the values of this record
  select
      *,
      md5(cast(
      
      coalesce(cast(_AIRBYTE_NESTED_STREAM_WITH_COMPLEX_COLUMNS_RESULTING_INTO_LONG_NAMES_HASHID as 
      varchar
  ), '') || '-' || coalesce(cast(DOUBLE_ARRAY_DATA as 
      varchar
  ), '') || '-' || coalesce(cast(DATA as 
      varchar
  ), '')
  
   as 
      varchar
  )) as _AIRBYTE_PARTITION_HASHID
  from "AIRBYTE_DATABASE"._AIRBYTE_TEST_NORMALIZATION."NESTED_STREAM_WITH_COMPLEX_COLUMNS_RESULTING_INTO_LONG_NAMES_64A_PARTITION_AB2"
  -- PARTITION at nested_stream_with_complex_columns_resulting_into_long_names/partition
    );
  