Tom O'Neill

When an incremental model's varchar size increases beyond the current default e.g. from VARCHAR(50) - (150) , dbt attempts to replace the column, however it makes syntax errors in SQL...

Add testing models for the macros

1

I can open a PR for this with samples from dbt-utils. Options: 1. We provide project that installs dbt-utils and tsql-utils in correct way, then runs the tests from dbt-utils....

Incremental table creation has unneccessary indexes, write temp table as a HEAP

1

When you create an incremental table, this is generally a 2 step process: 1. Create the initial table as a table. 2. Create the incremental updates as new row inserts...

Dict object has no attribute `file_key_name` on Singular tests

1

Fairly confident that this is only an issue on ['singular data tests' ](https://docs.getdbt.com/docs/build/data-tests#singular-data-tests) configured in the tests/ folder. I assume this is because the file is not directly referenced. Doesn't...

--no-partial-parse flag fails with this library enabled on branch

4

Hi @LewisDavies, Firstly huge thanks on your work pulling this package together, it's a great tool and helps us with workflows! A small bug I noticed whilst trying to get...

Add DATE to dateadd macro

6

Fixes #405 tl;dr, helps you avoid errors like: ``` Binder Error: Could not choose a best candidate function for the function call "+(STRING_LITERAL, INTERVAL)". In order to select one, please...

Duck Db support of DATEADD from Core

1

I tried the example here: https://docs.getdbt.com/sql-reference/dateadd ``` SELECT {{ dateadd(datepart="month", interval=1, from_date_or_timestamp="'2021-08-12'") }} ``` This fails. I tweaked and this works: ``` SELECT {{ dateadd(datepart="month", interval=1, from_date_or_timestamp="DATE '2021-08-12'") }} AS...

Context: I want to raise all warnings as error, except the model contracts error, but it's either not possible, or I can't work out how. https://github.com/dbt-labs/dbt-core/discussions/7213 specifies the origination history...