fivetran / dbt_zendesk_source

Fivetran's Zendesk Support source dbt package
https://fivetran.github.io/dbt_zendesk_source/#!/overview
Apache License 2.0
13 stars 18 forks source link

BUG - order by causing resources exceeded error #12

Closed MarkMacArdle closed 3 years ago

MarkMacArdle commented 3 years ago

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

- [x] 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?

kristin-bagnall commented 3 years ago

@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.