search

dbt-msft / tsql-utils

dbt-utils for the dbt-msft family of packages
MIT License
25 stars 25 forks source link

add support for date_spine #28

Closed TwoMinds closed 3 years ago

TwoMinds commented 3 years ago

added date_spine macro. Glad to be able to give back to the community.

thanks, -Serge

dataders commented 3 years ago

@TwoMinds last request -- can you add a CHANGELOG.MD and make it's contents look something like this?

# Changelog

## `0.6.4.1`

- add support for `date-spine` [#28](https://github.com/dbt-msft/tsql-utils/pull/28) thanks [@TwoMinds](https://github.com/TwoMinds)

## `0.6.4`

as of now, all 39 of dbt-utils's macros work on `dbt-sqlserver` and `dbt-synapse` except for the 10 listed below. We hope to bring these macros in a future release!

    insert_by_period materialization
    date_spine
    test_mutually_exclusive_ranges() #18
    all the url macros (get_url_host, get_url_path, get_url_host()
    generate_series()
    get_relations_by_pattern()
    get_relations_by_prefix_and_union()
    union_relations()

these 5 macros are supported for SQL Server and Azure SQL, but aren't yet officially supported right now on Synapse because of https://github.com/dbt-msft/dbt-synapse/issues/36 breaks dbt-utils's integration tests.  

    dateadd()
    datediff()
    split_part()
    last_day()
    test-hash()