dbt-labs / dbt-labs/redshift

stl_query base model doesn't match Redshift

Open
#44 0 comments 0 reactions 0 assignees View on GitHub
bug
Dominant language
PLpgSQL
Stars
105
Forks
39
PR merge metrics
No merged PRs in 30d

Description

### Describe the bug
According to the documentation, the base models are supposed to closely match 1-1 with Redshift.

> Each of these base models maps 1-to-1 with the underlying Redshift table. Some renaming has been performed to make the field names grokable.

However the stl_query base model is missing a number of fields, including the querytxt. The full list of fields is at: https://docs.aws.amazon.com/redshift/latest/dg/r_STL_QUERY.html

Other base models may also be affected.

### Steps to reproduce
```
SELECT
q.querytxt
FROM {{ ref('redshift', 'stl_query') }} q
```

### Expected results
The model should build successfully.

### Actual results
" column q.querytxt does not exist"

### Screenshots and log output
None

### System information
**The contents of your `packages.yml` file:**
```
- package: fishtown-analytics/redshift
version: 0.4.1
```

**Which database are you using dbt with?**
- [ ] postgres
- [X] redshift
- [ ] bigquery
- [ ] snowflake
- [ ] other (specify: ____________)

**The output of `dbt --version`:**
```
installed version: 0.18.0
latest version: 0.19.1

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

Plugins:
- bigquery: 0.18.0
- snowflake: 0.18.0
- redshift: 0.18.0
- postgres: 0.18.0
```

**The operating system you're using:**
``` Ubuntu 18.04.5 LTS```

**The output of `python --version`:**
```Python 3.6.9```

### Additional context
None

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.