- Added Quickstart model counts to README. (#29)
- Corrected references to connectors and connections in the README. (#29)
PR #28 is a breaking change due to upstream updates:
- Updated
*_id
fields in upstreamstg_*
models to be cast as strings to ensure compatibility in downstream joins by avoiding potential type mismatches.- Note: most IDs were previously stored as integers, so
*_id
fields in the end models will now also be strings.
- Note: most IDs were previously stored as integers, so
- Added dbt documentation definitions.
- Update README formatting.
- Added an additional integration test to verify functionality when
greenhouse_using_*
variables are disabled.
PR #25 is a breaking change due to upstream updates:
-
Updated the logic for
stg_greenhouse__tag
andstg_greenhouse__user
to account for the presence of the singularly or plurally-named titular source tables, tag(s) and user(s).- The source table
tag
was renamed totags
for connectors created on or after July 18, 2024 and the tableuser
was renamed tousers
in October 2024.
- The source table
-
This is a breaking change for customers with the plurally-named tables, as they have not been able to run the models previously.
-
For more information, refer to the upstream CHANGELOG.
- Added validation tests under the
integration_tests/tests
folder.
- Databricks and PostgreSQL compatibility! (#19)
- Incorporated the new
fivetran_utils.drop_schemas_automation
macro into the end of each Buildkite integration test job. (#17) - Updated the pull request templates. (#17)
PR #13 includes the following breaking changes:
- Dispatch update for dbt-utils to dbt-core cross-db macros migration. Specifically
{{ dbt_utils.<macro> }}
have been updated to{{ dbt.<macro> }}
for the below macros:any_value
bool_or
cast_bool_to_text
concat
date_trunc
dateadd
datediff
escape_single_quotes
except
hash
intersect
last_day
length
listagg
position
replace
right
safe_cast
split_part
string_literal
type_bigint
type_float
type_int
type_numeric
type_string
type_timestamp
array_append
array_concat
array_construct
- For
current_timestamp
andcurrent_timestamp_in_utc
macros, the dispatch AND the macro names have been updated to the below, respectively:dbt.current_timestamp_backcompat
dbt.current_timestamp_in_utc_backcompat
dbt_utils.surrogate_key
has also been updated todbt_utils.generate_surrogate_key
. Since the method for creating surrogate keys differ, we suggest all users do afull-refresh
for the most accurate data. For more information, please refer to dbt-utils release notes for this update.- Dependencies on
fivetran/fivetran_utils
have been upgraded, previously[">=0.3.0", "<0.4.0"]
now[">=0.4.0", "<0.5.0"]
.
- Updated README documentation for easier navigation and dbt package setup.
🎉 dbt v1.0.0 Compatibility 🎉
- Adjusts the
require-dbt-version
to now be within the range [">=1.0.0", "<2.0.0"]. Additionally, the package has been updated for dbt v1.0.0 compatibility. If you are using a dbt version <1.0.0, you will need to upgrade in order to leverage the latest version of the package.- For help upgrading your package, I recommend reviewing this GitHub repo's Release Notes on what changes have been implemented since your last upgrade.
- For help upgrading your dbt project to dbt v1.0.0, I recommend reviewing dbt-labs upgrading to 1.0.0 docs for more details on what changes must be made.
- Upgrades the package dependency to refer to the latest
dbt_greenhouse_source
. Additionally, the latestdbt_greenhouse_source
package has a dependency on the latestdbt_fivetran_utils
. Further, the latestdbt_fivetran_utils
package also has a dependency ondbt_utils
[">=0.8.0", "<0.9.0"].- Please note, if you are installing a version of
dbt_utils
in yourpackages.yml
that is not in the range above then you will encounter a package dependency error.
- Please note, if you are installing a version of
Refer to the relevant release notes on the Github repository for specific details for the previous releases. Thank you!