Naming Convention of Columns

Just sharing some info with community:

I recently started to use Googles Data Studio for some advanced reporting outside of Glide. We are pulling the data and populating a MySQL db (due to large volume). My column names had spaces in them which Data Studio doesn’t like, so I will have to rename my columns in Glide (not a big issue) but something for the rest of the community to keep in mind.

Secondly in Glide the “/” character is used to create groups of columns, but in SQL that is a special character, again easy to fix as you can can “select rating/driver as rating_driver”

Hope its helpful to some and if anyone has any experience with Data Studio and is aware of any other Gotchas will be appreciate the heads up.

4 Likes

Thanks for sharing!