dbt-labs / dbt-labs/redshift

if customized schema is used the redshift macro writes the admin views in the wrong schema

Open
#39 1 comment 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

If we use:
{{
config({
"materialized":"table",
"schema": "raw",
"sort": "load_dts",
"dist": "all",
"comprows": 1000,
"post-hook": [
"{{ redshift.compress_table(this.schema, this.table, drop_backup=True) }}"
]
})
}}

the schema field is not getting picked up by the redshift.compress_table expression and hence writing to the wrong schema

### Steps to reproduce

Please use provided config for a model

### Expected results

should use the same schema as passed in the config clause

### Actual results

using the default schema as provided in the profiles.yml

### Screenshots and log output

If applicable, add screenshots or log output to help explain your problem.

### System information
**The contents of your `packages.yml` file:**

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

**The output of `dbt --version`:**
```

```

**The operating system you're using:**

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

### Additional context

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.