ssugar issues

Repositories
Issues
Comments

Results 2 issues of


                                            ssugar

coalesce statements in models/staging/stg_products.sql fail in MSSQL

Coalesce statements don't work in MSSQL - they may only work in postgres I think (although I could be wrong there). Example: ```sql coalesce(type = 'jaffle', false) as is_food_item ```...

Fabric adapter doesnt work with default cents_to_dollars macro

Using dbt-fabric adapter, trying to run dbt build fails with the following error: ('42000', "[42000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Incorrect syntax near '::'. (102) (SQLMoreResults)") Adding a fabric...