[Bug] stripe.yml trailing tabs breaking .yml spec

[niccoloalexander]

Is there an existing issue for this?

• I have searched the existing issues

Describe the issue

I was unable to run my dbt project due to trailing tabs in your stripe.yml file.

Here are similar issues:

• 40/yaml-scanner-scannererror-while-scanning-for-the-next-token-found-character-t
• Bug "Found character that cannot start any token" with trailing tab character. yaml/pyyaml#450
• dbt breaks with tabs in dbt_project.yml dbt-labs/dbt-core#21

Relevant error log or model output

Multiple cases of the following on multiple lines:

Raw Error:
    ------------------------------
    while scanning for the next token
    found character '\t' that cannot start any token
      in "<unicode string>", line 957, column 27:
              - name: effective_at

Expected behavior

Without error:
dbt parse

Possible solution

Remove trailing tabs that are inconsistently present on multiple field names

dbt Project configurations

stripe_database: internal_analytics
stripe_schema: stripe
stripe__standardized_billing_model_enabled: True

Package versions

packages:

- package: dbt-labs/dbt_utils # Hubspot package recommends to remove this

version: 1.2.0

• package: dbt-labs/codegen
  version: 0.12.1
• package: dbt-labs/audit_helper
  version: 0.12.0
• package: calogica/dbt_expectations
  version: 0.10.4
• package: fivetran/hubspot
  version: [">=0.18.0", "<0.19.0"]
• package: fivetran/stripe
  version: [">=0.15.0", "<0.16.0"]
• package: fivetran/ad_reporting
  version: [">=1.9.0", "<1.10.0"]

What database are you using dbt with?

snowflake

How are you running this dbt package?

Fivetran Transformations, dbt Core™

dbt Version

1.8.6

Additional Context

No response

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

• Yes.
• Yes, but I will need assistance.
• No.
  * fix!: Remove trailing tabs to avoid conflict with .yml spec and blocking dbt parse #95

[fivetran-joemarkiewicz]

Hi @niccoloalexander thanks for opening this issue and also providing a PR to address the issue you are experiencing!

Before looking further, I would like to get a better understanding of this issue. Would you be able to share the steps you took to recreate this error? I'm unable to recreate the error with the latest version of the package and curious if there are any additional steps I need to take in order to encounter the same issue.

I mainly ask because I imagine these trailing tabs exist in a number of our other package. I want to understand if this is something that needs to be addressed in other packages as well. Thanks!

[fivetran-joemarkiewicz]

@niccoloalexander, bumping my previous question. Since this is something that exists in most of our packages I want to make sure we understand the root of this issue before making changes at the package level. Let me know if you're able to share the steps taken to reproduce the error. Thanks!

[niccoloalexander]

Hi @fivetran-joemarkiewicz, thanks for looking into this. I run into the issue on MacOS. I found another related thread: https://www.reddit.com/r/programminghorror/comments/qvzj7i/spent_1_hour_trying_to_work_out_why_dbt_on_macos/

This is the only package among my fivetran packages installed with trailing whitespace in its models yml