mikekaminsky/dbt-helper

`dbt-helper bootstrap` doesn't work for snowflake

Opened this issue · 2 comments

Apparently, dbt-helper bootstrap --schemas analytics does not work for snowflake. I suspect this has to do with capitalization and quoting conventions, but I'm not positive.

See details here: #18

I have not replicated this, but perhaps someone with a snowflake DB wants to chime in with more details (and / or ideas for a fix)

Hey @mikekaminsky I'd be happy to look into this. I built a similar thing for my team that works with Snowflake but it is more "manual" and only compatible with Snowflake. I could at least trouble shoot further and probably help finding a solution.

I indeed get the error described in #18 even when specifying the schema. I looked at your code a bit and my first steps would be to try and see what this line returns (https://github.com/mikekaminsky/dbt-helper/blob/master/core/bootstrap.py#L88) where do you dump the logs? Should help me in confirming or debunking your suspicion of upper case and other snowflake oddities.

@bastienboutonnet thanks for volunteering to help out! There isn't much logging setup in this library right now -- I think the easiest thing to do would be to install dbt-helper from source (using pip install . -e) and then drop an ipdb debugger in the code to play around.