Airbyte with dbt snowflake error

Is this your first time deploying Airbyte:Yes
OS Version / Instance: Windows 10
Memory / Disk: 250gb
Deployment: Docker
Airbyte Version: 0.35.45-alpha
Source: sportsapi (dev)
Destination: Snowflake (0.4.17)
Description: I’m added dbt transformations & I’m trying to sync and the process failed.
logs-180.txt (41.7 KB)
And related SQL files which are used In dbt are correct but they are failing after adding to the GUI
sample SQL file that which is running successful in sql server but failing in airbyte GUI


create or replace  table "DB".PUBLIC."LISTS"  as
(select * from(

with __dbt__cte__LISTS_AB1 as (

-- SQL model to parse JSON blob stored in a single column and extract into separated field columns as described by the JSON Schema
-- depends_on: "DB".PUBLIC._AIRBYTE_RAW_LISTS
select
    get_path(parse_json(_airbyte_data), '"golf"') as GOLF,
    get_path(parse_json(_airbyte_data), '"cricket"') as CRICKET,
    get_path(parse_json(_airbyte_data), '"football"') as FOOTBALL,
    _AIRBYTE_AB_ID,
    _AIRBYTE_EMITTED_AT,
    convert_timezone('UTC', current_timestamp()) as _AIRBYTE_NORMALIZED_AT
from "DB".PUBLIC._AIRBYTE_RAW_LISTS as table_alias
-- LISTS
where 1 = 1

),  __dbt__cte__LISTS_AB2 as (

-- SQL model to cast each column to its adequate SQL type converted from the JSON schema type
-- depends_on: __dbt__cte__LISTS_AB1
select
    GOLF,
    CRICKET,
    FOOTBALL,
    _AIRBYTE_AB_ID,
    _AIRBYTE_EMITTED_AT,
    convert_timezone('UTC', current_timestamp()) as _AIRBYTE_NORMALIZED_AT
from __dbt__cte__LISTS_AB1
-- LISTS
where 1 = 1

),  __dbt__cte__LISTS_AB3 as (

-- SQL model to build a hash column based on the values of this record
-- depends_on: __dbt__cte__LISTS_AB2
select
    md5(cast(coalesce(cast(GOLF as
    varchar
), '') || '-' || coalesce(cast(CRICKET as
    varchar
), '') || '-' || coalesce(cast(FOOTBALL as
    varchar
), '') as
    varchar
)) as _AIRBYTE_LISTS_HASHID,
    tmp.*
from __dbt__cte__LISTS_AB2 tmp
-- LISTS
where 1 = 1

)-- Final base SQL model
-- depends_on: __dbt__cte__LISTS_AB3
select
    GOLF,
    CRICKET,
    FOOTBALL,
    _AIRBYTE_AB_ID,
    _AIRBYTE_EMITTED_AT,
    convert_timezone('UTC', current_timestamp()) as _AIRBYTE_NORMALIZED_AT,
    _AIRBYTE_LISTS_HASHID
from __dbt__cte__LISTS_AB3
-- LISTS from "DB".PUBLIC._AIRBYTE_RAW_LISTS
where 1 = 1

            ) order by (_AIRBYTE_EMITTED_AT)
      );
    alter table "DB".PUBLIC."LISTS" cluster by (_AIRBYTE_EMITTED_AT);

Hi @Bharath ,
According to your sample SQL it looks like you used the compiled DBT models to declare your DBT custom transformation. You should rather host non compiled models, Airbyte will compile these models for you.