Unit tests: error - Incorrect syntax near the keyword 'WITH'

[rgargour]

I am working with Microsoft Fabric and have implemented a unit test in dbt, but I encountered an error while running it.

It seems that dbt attempts to execute a query like the following:

select TOP 0 * from (
            
WITH  __dbt__cte__source_table as (
SELECT
  'toto' AS col_1,
  'titi' AS col_2
), 
src AS (
    SELECT * FROM __dbt__cte__source_table
)

SELECT
   *
FROM src 
WHERE col_1 = 'toto' -- this is my dbt model, I simplified it to be more concise
    OPTION (LABEL = 'dbt-fabric-dw');

The issue appears to be related to the WITH clause in this query.

[prdpsvs]

@rgargour , which version of adapter were you using?

[rgargour]

I am using this versions of dbt-core and dbt-fabric:

[prdpsvs]

I am releasing a new version of the adapter in a couple of days that should fix this issue.

[tabit01]

@prdpsvs I see this release is slated to be 1.9.1. Following the docs, this implies that the new release of the adapter will be compatible with dbt-core version 1.9.1?

[prdpsvs]

The only requirement from Fabric adapter is to use "dbt-core>=1.8.0". It should work with any new version.
All my tests are on"dbt-core==1.10.0-a1"