updating models for deleted records

[fivetran-sheringuyen]

Are you a current Fivetran customer?

Fivetran Employee

What change(s) does this PR introduce?

Updates

• The is_deleted field has been renamed within the below models:

  • stg_hubspot__company ( is_company_deleted)
  • stg_hubspot__deal (is_deal_deleted)
  • stg_hubspot__ticket (is_ticket_deleted)

• The _fivetran_deleted field has been renamed within the below models:

  • stg_husbpot__contact_list_member (is_contact_list_member_deleted)
  • stg_hubspot__contact_list (is_contact_list_deleted)
  • stg_hubspot__contact (is_contact_list_deleted)
  • stg_hubspot__deal_pipeline_stage (is_deal_pipeline_stage_deleted)
  • stg_hubspot__deal_pipeline (is_deal_pipeline_deleted)
  • stg_hubspot__ticket_pipeline_stage (is_ticket_pipeline_stage_deleted)
  • stg_hubspot__ticket_pipeline (is_ticket_pipeline_deleted)

Features

• Filtering deleted records with the methods where not coalesce(is_deleted, false) or where not coalesce(_fivetran_deleted, false) has been removed from the above models. Instead, the new is_<model>_deleted flags will now offer customers flexibility to filter models for deleted records as necessary.

Did you update the CHANGELOG?

• [x] Yes

Does this PR introduce a breaking change?

• [ ] Yes (please provide breaking change details below.)
• [ ] No (please provide an explanation as to how the change is non-breaking below.) Maybe - want to discuss

Did you update the dbt_project.yml files with the version upgrade (please leverage standard semantic versioning)? (In both your main project and integration_tests)

• [x] Yes

Is this PR in response to a previously created Bug or Feature Request

• [x] Yes, Issue/Feature [#87]
• [ ] No

How did you test the PR changes?

• [x] Buildkite
• [x] Local (please provide additional testing details below)

Select which warehouse(s) were used to test the PR

• [x] BigQuery
• [x] Redshift
• [x] Snowflake
• [x] Postgres
• [x] Databricks
• [ ] Other (provide details below)

Provide an emoji that best describes your current mood

:dancer: **Feedback** We are so excited you decided to contribute to the Fivetran community dbt package! We continue to work to improve the packages and would greatly appreciate your [feedback](https://www.surveymonkey.com/r/DQ7K7WW) on our existing dbt packages or what you'd like to see next.

[jamesrayoub]

@fivetran-sheringuyen this should solve the issue I raised in #94; I'll close my PR!