BUG - order by causing resources exceeded error

[MarkMacArdle]

Are you a current Fivetran customer?

Mark MacArdle, Bought by Many

Describe the bug

An order by in the stg_zendesk__ticket_field_history model is causing a resources exceeded error in bigquery

Steps to reproduce

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior

Project variables configuration

copy dbt_project.yml here

Package Version

packages:
  - package: fishtown-analytics/dbt_utils
    version: 0.6.4  # dbt recommend pinning all packages, `*` doesn't work.

  # will also import fivetran/zendesk_source as a dependency
  - package: fivetran/zendesk
    version: 0.4.1

Warehouse

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

Additional context

Screenshots

Please indicate the level of urgency

Low

Are you interested in contributing to this package?

• Yes, I can do this and open a PR for your review.
• Possibly, but I'm not quite sure how to do this. I'd be happy to do a live coding session with someone to get this fixed.
• No, I'd prefer if someone else fixed this. I don't have the time and/or don't know what the root cause of the problem is.

[kristin-bagnall]

@MarkMacArdle thanks for bringing this to our attention!

I just approved & merged the PR related to this fix. A new release, version 0.3.1 was just created and this will be available on dbt's hub in the next 1-24 hours.