AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
5.1K members online now
5.1K 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?

Issue with case sensitive DB table columns/fields using PostGres

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

The problem is the column name has uppercase letter, but in google datastudio, it just use lowercase. we need change all uppercase to lowercace, for example SELECT "shipperBusinessId" as "shipperbusinessid" from yourtable