[Bug] DBT Run- Duplicate Column Name Error - Salesforce to Snowflake

Is there an existing issue for this?

[X] I have searched the existing issues

Describe the issue

Using the Salesforce to Snowflake connector, we do dbt run and get a duplicate column name sql error. Going into snowflake and renaming one of the columns fixes this issue, but when the model runs every sync it fails and the query must be redone.

Relevant error log or model output

dbt run --select models/

Running with dbt=1.3.0
Found 3 models, 0 tests, 0 snapshots, 0 analyses, 626 macros, 0 operations, 0 seed files, 1 source, 0 exposures, 0 metrics

Concurrency: 1 threads (target='prod')

1 of 3 START sql view model SALESFORCE.account_formulas ........................ [RUN]
1 of 3 ERROR creating sql view model SALESFORCE.account_formulas ............... [ERROR in 1.18s]
2 of 3 START sql view model SALESFORCE.opportunity_formulas .................... [RUN]
2 of 3 ERROR creating sql view model SALESFORCE.opportunity_formulas ........... [ERROR in 0.88s]
3 of 3 START sql view model SALESFORCE.user_formulas ........................... [RUN]
3 of 3 OK created sql view model SALESFORCE.user_formulas ...................... [SUCCESS 1 in 1.30s]

Finished running 3 view models in 0 hours 0 minutes and 4.97 seconds (4.97s).

Completed with 2 errors and 0 warnings:

Database Error in model account_formulas (models/account_formulas.sql)
  002025 (42S21): SQL compilation error:
  duplicate column name 'BILLING_GROUP_C'
  compiled Code at target/run/final_try/models/account_formulas.sql

Database Error in model opportunity_formulas (models/opportunity_formulas.sql)
  002025 (42S21): SQL compilation error:
  duplicate column name 'LEAD_ADVISOR_C'
  compiled Code at target/run/final_try/models/opportunity_formulas.sql

Done. PASS=1 WARN=0 ERROR=2 SKIP=0 TOTAL=3

Expected behavior

The queries should not contain duplicate column names. The output contains a field that has "as [fieldName]" twice.

dbt Project configurations

Default configuration

Package versions

packages:

package: fivetran/salesforce_formula_utils version: [">=0.7.0", "<0.8.0"]

What database are you using dbt with?

snowflake

dbt Version

Core:

installed: 1.3.0
latest: 1.3.1 - Update available!

Your version of dbt-core is out of date! You can find instructions for upgrading here: https://docs.getdbt.com/docs/installation

Plugins:

snowflake: 1.3.0 - Up to date!

Additional Context

These errors were resolved by manually taking out the auto created ",mt.lead_advisor_c" and ",mt.BILLING_GROUP_C" - these shared a namespace with the formula in the query, like with "AS LEAD_ADVISOR_C".

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

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

fivetran / dbt_salesforce_formula_utils