[Bug] Some fields not being calculated due to incorrect dependency error

[rrivera-ut]

Is there an existing issue for this?

• [X] I have searched the existing issues

Describe the issue

Certain fields from SFDC are not being calculated using formulas by incorrectly stating dependent fields are not being synced.

For example, from object SBQQ_Quote_c:

• Calculation for UZ_CalculatedSubscriptionTermc, dependent field is SBQQStartDate__c

• Field is being captured via Fivetran

• Field name is being changed by the connector to sbqq_start_date_c

Relevant error log or model output

No response

Expected behavior

If fivetran connector is changing the name of the field, the formula should change the name in the same manner to perform the calculation

dbt Project configurations

n/a

Package versions

packages:

• package: dbt-labs/audit_helper version: [">=0.8.0", "<0.10.0"]

• package: dbt-labs/codegen version: 0.9.0

  - package: elementary-data/elementary

  version: 0.7.8

  Docs: https://docs.elementary-data.com

• package: entechlog/dbt_snow_mask version: 0.2.4

• package: fivetran/greenhouse version: 0.6.0

• package: fivetran/zendesk version: 0.10.1

• package: Fleetio/dbt_segment version: 0.1.1

• package: fivetran/salesforce_formula_utils version: [">=0.9.0", "<0.10.0"]

What database are you using dbt with?

snowflake

dbt Version

1.5

Additional Context

No response

Are you willing to open a PR to help address this issue?

• [ ] Yes.
• [ ] Yes, but I will need assistance and will schedule time during our office hours for guidance
• [ ] No.

[fivetran-jamie]

hey there @RichardThRivera! thanks for taking the time to open this.

i'm wondering if the issue here is around a field missing from the SBQQ_QuoteLineGroup__c table rather than SBQQ__QuoteLine__c, based on failure_detail_1?

[rrivera-ut]

Let me take a look - I'll reply to this ticket; Thanks Jamie!

[fivetran-joemarkiewicz]

Hi @RichardThRivera were you able to take a look into this and if there is a field missing?