Issue with case sensitive DB table columns/fields using PostGres
I am exploring Google Data Studio as a possible solution for reports on our PostGres DB.
I am running into a problem where I cannot use any component that makes use of table fields that have uppercase letters (we use camel casing for our fields).
So I get an error similar to the following everywhere:
"There`s a query error.
Error with SQL statement: ERROR: column "shipperbusinessid" does not exist Hint: Perhaps you meant to reference the column "t0.shipperBusinessId". Position: 12
Error ID: ca1f99d2"