I am running dbt transformations on Postgresql db. To make the row retrieval faster i want to create indices but the casing of column is not letting me.
I defined index as follows:
{{ config(
indexes=[
{‘columns’: [“paidDate”],‘type’:‘hash’}
]
)}}
The problem I’m having
column "paiddate" does not exist
dbt expects paiddate with lower case. but my column is in camelCase
What I’ve already tried
name: stats_table
columns:
- name: paidDate
quote: true
Please suggest any solution