zafar mahmood

05/04/2023, 11:01 AM
Hi I are working on dagster with API version 1.1. where I have DBT running as an ECS task Definition separate ECS cluster. Which is invoked using dagster. However, the problem I am facing is. Some of my models that are written in DBT have column in capital-case. And later those models expects those columns in lower-case which throws an error. is there any possible way that DBT that can work without having case-sensitiveness in columns ?
:dagster-bot-responded-by-community: 1


05/05/2023, 10:44 AM
This is more of a dbt question than dagster question, tbh, but what database are you using? If you’re on snowflake, you’d need to put your columns in double quotes so it’s case sensitive.
Although I’d highly suggest you fix this problem at the source and use case-insensitive columns. To me this just sounds like a recipe for disaster down the line.