Skip to content

Snowflake materialized view fails on 2nd run #14

@sandopolus

Description

@sandopolus

DBT Version: 0.20.0

If i create a simple materialized view in snowflake and do dbt run it creates the Materialized View fine.
But on the 2nd run of dbt run it fails because it thinks there is a view rather than a materialized view present.
This causes it to try and run the drop view command

I am new to DBT and have been trying to look into it more
It seems like the following query is used to lookup the information about the object
show terse objects in <DB>.<SCHEMA>
When i run this in the snowflake console it is returning info about the objects, but it lists both views and materialized views as just view. Which i assume is causing the problem.

I have been trying to modify the macros and adaptors to work around the problem. But still in the learning phase of this project. So i am bumping into quite a few unknowns at the moment.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions