dbt_linreg
dbt_linreg copied to clipboard
Linear regression in SQL using dbt
It's possible to materialize the Snowflake implementation as a UDF using pre-hook and post-hook tricks, similar to what I do in https://github.com/dwreeves/dbt_pca. This should be the default Snowflake implementation.
Resolves #10 Currently WIP. Only the tests are (mostly) set up; actual implementation needs to happen as well. Additionally, need to handle special cases of 0var and 1var in tests.
Redshift does not handle either `covar` or `covar_pop`, which means `default__regress` doesn't work. There may be other databases where this is true. ### Current solution The best solution is to...