Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Snowflake: after_commit in post-hooks #723

Closed
jtcohen6 opened this issue Apr 4, 2018 · 1 comment
Closed

Snowflake: after_commit in post-hooks #723

jtcohen6 opened this issue Apr 4, 2018 · 1 comment
Assignees
@drewbanin
Labels
snowflake

Comments

@jtcohen6
Copy link
Contributor

jtcohen6 commented Apr 4, 2018

Related to [this concept] in the docs, Snowflake executes post-hooks before renaming MODEL_NAME__dbt_tmp table to MODEL_NAME.

When after_commit is specified in a post-hook, it compiles as:

On MODEL_NAME: {"sql": "\n\n    \n\n    \n\n ... [post-hook macro] ...
Snowflake error: 001003 (42000): SQL compilation error:
syntax error line 1 at position 1 unexpected '"sql"'.
@jtcohen6 jtcohen6 mentioned this issue Apr 4, 2018
Closed
@jtcohen6
Copy link
Contributor Author

I believe this is fixed as an indirect product of #940

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@drewbanin drewbanin

Labels
snowflake
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@drewbanin @jtcohen6