Dbt: Unable to run dbt against Panoply Redshift

[gautam-ndk]

Issue

Unable to run dbt against Panoply redshift

Issue description

Am testing out the sample model provided by dbt init (my_first_dbt_model.sql)

{{ config(materialized='view') }}
select 1 as id

Am able to execute dbt run in a dev environment (Postgres) and it works fine.
But, when I run it against the Panoply redshift, it throws the error

Results

I expect it to create a view. But, it throws the below syntax error

Encountered an error:
Database Error
  syntax error at or near "with"
  LINE 14:             relkind as kind

Attached is the dbt log snippet dbt.log

To make a note, when I copied the query from dbt.log and pasted it into Panoply console, it works fine.

System information

The output of dbt --version:

installed version: 0.13.0-a1
   latest version: 0.13.1

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

Note: I had the latest dbt earlier. But, when I posted the same question in slack's support channel, I was recommended to try out fix in https://github.com/kevinsanz93/dbt (and that is why the version appears not up to date)

The operating system am running on is Ubuntu 18.04

The python version you're using (probably the output of python --version)
Python 3.6.7

Steps to reproduce

dbt run against panoply redshift should throw an exception

[gautam-ndk]

Removing the comments here fixes the issue.

I'm following up with Panoply team to get the issue fixed on their part. I can leave an update here once it is fixed.

[wesseljt]

I’m still having issues with this as well. Didn’t get anywhere getting it fixed with panoply.

[gautam-ndk]

There are two issues working with Panoply.

1. Syntax error while executing dbt run
2. Syntax error while executing dbt docs generate

The changes in https://github.com/fishtown-analytics/dbt/pull/1674 fix the first issue mentioned but not the second one. I spent some time figuring out the second issue but I couldn't :(

[patricktrainer]

Any ideas when 14.1 will be released? This bug is blocking me from using DBT at the moment..

[wesseljt]

Same. Excited for the fix.

On Mon, Aug 26, 2019 at 5:03 PM patricktrainer [e-mail]
wrote:

Any ideas when 14.1 will be released? This bug is blocking me from using
DBT at the moment..

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
https://github.com/fishtown-analytics/dbt/issues/1479?email_source=notifications&email_token=AAY6DGJ43N2OJI4A3G5QTX3QGRAJBA5CNFSM4HPMECPKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD5FVQ6Y#issuecomment-525031547,
or mute the thread
https://github.com/notifications/unsubscribe-auth/AAY6DGJBICBQVNF5CK6LYQ3QGRAJBANCNFSM4HPMECPA
.

>

---

John Wessel
[email protected]
Mobile: [phone]

[drewbanin]

A release candidate for dbt v0.14.1 is currently available on pypi, homebrew and in dbt Cloud. We plan on testing the RC for about a week before doing a final release of 0.14.1.

[wesseljt]

Awesome. Thanks Drew!

On Mon, Aug 26, 2019 at 9:13 PM Drew Banin [e-mail] wrote:

A release candidate for dbt v0.14.1 is currently available on pypi
https://pypi.org/project/dbt/0.14.1rc1/, homebrew
https://github.com/fishtown-analytics/homebrew-dbt/blob/master/Formula/dbt%400.14.0-rc1.rb
and in dbt Cloud. We plan on testing the RC for about a week before doing a
final release of 0.14.1.

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
https://github.com/fishtown-analytics/dbt/issues/1479?email_source=notifications&email_token=AAY6DGM7ZCYJNPQBMOA56CLQGR5R7A5CNFSM4HPMECPKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD5GEVGA#issuecomment-525093528,
or mute the thread
https://github.com/notifications/unsubscribe-auth/AAY6DGO5EECXPXBXXGOOFALQGR5R7ANCNFSM4HPMECPA
.

>

---

John Wessel
[email protected]
Mobile: [phone]

[taucamp]

I upgraded to 15.0 and had same issue. Worked with Drew who recommended the following and it solved the problem

Configure DBT to not create comments at the beginning of the queries by inseritng the following in your project.yml file

query-comment: null