[FEATURE] MS Fabric support

[jx1226]

Hello greetings,

I would like to evaluate dbtvault in MS Fabric environment. I was wondering if you already have a some idea of what is necessary to get dbtvault to run on MS Fabric or maybe already started working on this.

Depending on the effort, glad be able to help reach the support of Ms Fabric.

Best regards

AB#5347

[rudolf-sauer-mw]

One idea could be to simply copy the dispatch logic from "sqlserver" and call it "fabric" and your good to go.

Here is one example "type_timestamp.sql"

{%- macro type_timestamp() -%}
{{- return(adapter.dispatch('type_timestamp', 'automate_dv')()) -}}
{%- endmacro -%}

{%- macro default__type_timestamp() -%}
TIMESTAMP_NTZ
{%- endmacro -%}

{%- macro sqlserver__type_timestamp() -%}
DATETIME2
{%- endmacro -%}

{%- macro fabric__type_timestamp() -%}
DATETIME2
{%- endmacro -%}

If you use this approach everything works fine - except the dbt model versions ( https://docs.getdbt.com/reference/resource-properties/versions )

[mattiasthalen]

This is what I'm doing

One idea could be to simply copy the dispatch logic from "sqlserver" and call it "fabric" and your good to go.

Here is one example "type_timestamp.sql"

{%- macro type_timestamp() -%} {{- return(adapter.dispatch('type_timestamp', 'automate_dv')()) -}} {%- endmacro -%}

{%- macro default__type_timestamp() -%} TIMESTAMP_NTZ {%- endmacro -%}

{%- macro sqlserver__type_timestamp() -%} DATETIME2 {%- endmacro -%}

{%- macro fabric__type_timestamp() -%} DATETIME2 {%- endmacro -%}

If you use this approach everything works fine - except the dbt model versions ( https://docs.getdbt.com/reference/resource-properties/versions )

That's how I do it

Edit:
I went ahead and made a pull request: Add Fabric Support

[DVAlexHiggs]

Thank you for this request and sorry for the delayed response. MS Fabric and AWS Redshift are next on the roadmap for support.