Testing case sensitive column names

Our users love case sensitive column names like CustomerID.
When I try to put a test (unique or not null) on this column, the db does not recognize the column.
I used “CustomerID” and ‘CustomerID’ but when the statement is sent over to the db the " and ’ are removed and are thus not existing columns.
Is there a workaround for this other than not using case sensitive columns?

Hey @marc.clijsters - check out the docs for column-level quoting in schema.yml files. This feature is new in dbt v0.16.0 :slight_smile:

Thanks @drew !

I am having the same issues but it appears the document seems to have moved? I get redirected to a more generic doc at:

instead of the original link that went to:

Is there an updated URL for that document?



Found it: