dbt2looker: Column Type None Error - Field's Not Converting To Dimensions
When running dbt2looker --tag marts on my mart models, I receive dozens of errors around none type conversions.
20:54:28 WARNING Column type None not supported for conversion from snowflake to looker. No dimension will be created.
Here is the example of the schema.yml file.
The interesting thing is that it correctly recognizes the doc that corresponds to the model. The explore within the model file is correct and has the correct documentation.
Not sure if I can be of any more help but let me know if there is anything!
About this issue
- Original URL
- State: closed
- Created 3 years ago
- Comments: 19
Nevermind, I see the comment in the code. With that, I think this is a resolved issue!
That seemed to do the trick! I noticed that
TIMESTAMP_TZseems to be producing an error. This is helpful in pointing out columns that I need to convert toTIMESTAMP_NTZbut figured I’d flag.@sisu-callum nice! Thanks so much for helping with this by the way.
dbt2lookerpulls comments from themanifest.jsonnotcatalog.json. That way I’d expect it to work withoutpersist_docs.There’s definitely something wrong in
dbt2lookerwith snowflake because you have all the information needed in your files. I’ll improve the logging to help pinpoint the problem.