Updates for dbt-utils to dbt-core cross-db macro migration

[fivetran-sheringuyen]

This pull request was created automatically 🎉 Before merging this PR (refer to Detailed Update Sheet 10/2022 for more information):

• [x] Verify dbt_project.yml & integration_tests/dbt_project.yml versions are properly bumped
• [x] Spot check for dispatch updates, dbt_utils.macro -> dbt.macro
• [x] Verify that .circleci directory has been removed
• [x] Verify integration_tests/requirements.txt adapters have been updated to 1.2.0 and dbt-databricks is added
• [x] Verify .buildkite directory has been added with the following: hooks/pre-command, scripts/run_models.sh, pipeline.yml
• [x] Update packages.yml, will need to bump source package (FT utils should be bumped)
• [x] Update .buildkite/scripts/run_models.sh with vars as applicable, if N/A then remove relevant lines from script
• [x] Remove databricks block from .buildkite/pipeline.yml if package is incompatible
• [x] Update schema names in integration_tests/ci/sample.profiles.yml
• [x] Update "spark" strings where applicable
• [x] Update CHANGELOG template and remove surrogate keys if not applicable to package
• [x] Update README for dbt version badge, install package version range and dependencies for: Fivetran_utils, dbt-utils and source packages
• [x] Regenerate docs
• [x] Follow Instructions for adding Buildkite
• [x] Follow instructions for removing Circleci

[coisnepe]

Hi @fivetran-sheringuyen, do you have a rough idea of when this PR will be merged? I've pulled my hair out trying to figure out why my packages weren't updating and finally pinpointed the issue to fivetran packages. Everything is up to date by commenting hubspot and google_ads out, but now uncommenting them breaks the installation… Thanks for your work!

packages:
  - package: dbt-labs/dbt_utils
    version: [">=0.8.0", "<2.0.0"]

  - package: dbt-labs/dbt_project_evaluator
    version: [">=0.2.0", "<0.3.0"]

  - package: dbt-labs/codegen
    version: [">=0.5.0", "<1.0.0"]

  - package: dbt-labs/audit_helper
    version: [">=0.5.0", "<0.7.0"]

  - package: calogica/dbt_expectations
    version: [">=0.5.0", "<0.8.0"]

  - package: calogica/dbt_date
    version: [">=0.5.0", "<0.7.0"]

  # - package: fivetran/hubspot
  #   version: [">=0.6.0", "<1.0.0"]

  # - package: fivetran/google_ads
  #   version: [">=0.8.0", "<1.0.0"]

  - package: brooklyn-data/dbt_artifacts
    version: [">=2.0.0", "<2.5.0"]

[fivetran-joemarkiewicz]

Hi @fivetran-sheringuyen, do you have a rough idea of when this PR will be merged? I've pulled my hair out trying to figure out why my packages weren't updating and finally pinpointed the issue to fivetran packages. Everything is up to date by commenting hubspot and google_ads out, but now uncommenting them breaks the installation… Thanks for your work!

packages:
  - package: dbt-labs/dbt_utils
    version: [">=0.8.0", "<2.0.0"]

  - package: dbt-labs/dbt_project_evaluator
    version: [">=0.2.0", "<0.3.0"]

  - package: dbt-labs/codegen
    version: [">=0.5.0", "<1.0.0"]

  - package: dbt-labs/audit_helper
    version: [">=0.5.0", "<0.7.0"]

  - package: calogica/dbt_expectations
    version: [">=0.5.0", "<0.8.0"]

  - package: calogica/dbt_date
    version: [">=0.5.0", "<0.7.0"]

  # - package: fivetran/hubspot
  #   version: [">=0.6.0", "<1.0.0"]

  # - package: fivetran/google_ads
  #   version: [">=0.8.0", "<1.0.0"]

  - package: brooklyn-data/dbt_artifacts
    version: [">=2.0.0", "<2.5.0"]

Hi @coisnepe thanks for reaching out here! There are actually a number of updates in this PR that will require the official release of the dbt-utils v1.0.0 version. Unfortunately we are not able to control that release and will have to wait until that is live before pushing these PRs (they are across all our packages) out.

Last we have heard from dbt Slack, we may see a release in late November (maybe next week)? Once that release is out, we will be sure to prioritize rolling out these updates. I apologize for this dependency inconvenience. Let me know if there is anything I can do to help answer any other questions.