Data Studio
3.8K members online now
3.8K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Issue with case sensitive DB table columns/fields using PostGres

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello,

 

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"

Any suggestion?

 

Thanks,

 

Christophe

Issue with case sensitive DB table columns/fields using PostGres

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Hey, did you manage to fined the solution?

Issue with case sensitive DB table columns/fields using PostGres

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

I'm having the same exact issue... still looking for a workaround. 

Issue with case sensitive DB table columns/fields using PostGres

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Same issue for me. Anybody solved it?