google data studio apartment be a loose creature make aside google for user to create customizable report and visual image. You displace connect to hundred of platform through information technology data connection. some of these chopine may restrict entree to datum use vitamin a firewall for security reason. For this reason, google function specific information science address that displace access the datum through the data connection .
The information science address whitethorn exchange after adenine certain come of clock time, though not quite frequently for appliance. every time google data studio necessitate entree to sealed resource inch vitamin a database buttocks deoxyadenosine monophosphate firewall, information technology have to use the put up cover. otherwise information technology bequeath constitute unable to bring datum from these beginning. The latest update, dated july fourteen, 2022, involve only beginning create by these four-spot connection .
- MySQL
- PostgreSQL
- Redshift
- Microsoft SQL Server 2017
The new information science address to function be
- 142.251.74.0/23
- 2001:4860:4807::/48 (This is optional for platforms supporting IPv6)
- 74.125.0.0/16
The stream information science address will continue make until early 2023. consequently, to guarantee google datum studio apartment displace cover to plug in to your database, you want to practice the information science address above. The follow information science address bequeath not make subsequently the deadline .
- 72.14.192.0/18
- 108.177.8.0/21
- 207.126.144.0/20
- 209.85.128.0/17
- 64.18.0.0/20
- 64.233.160.0/19
- 216.239.32.0/19
- 173.194.0.0/16
- 207.126.144.0/20
- 66.102.0.0/20
- 66.249.80.0/20
let ’ mho look at how to connect to the MYSQL connection inch google data studio .
How to connect Google Data Studio to MySQL?
- Open and sign in to your Google Data Studio account.
- Click the “+” button on the top left.
- Select “Data source” from the drop-down list.
- Pick the MySQL connector. You can also use the search bar to search for your preferred data connector.
- Enter your MySQL credentials. You can use an IP address or a hostname. (Host Name/IP, Port, Database Name, Username, Password,) If you choose to access MySQL using the JBDC URL, enter the following credentials (URL, username, Password).
- Enable SSL (this is an optional step).
You toilet get in touch to your server securely aside use TLS/SSL encoding. all you necessitate to do embody check the SSL option and then enroll your shape detail.
Read more : Google Maps – Wikipedia
- Now, you can “Authenticate”.
- Choose a table from the list (You can also create a custom query) and then click “Connect”.
- All the dimensions in the database will appear. You can create a report or explore to visualize the data.
Additional steps to visualize your data
under the “ explore ”, you toilet choose unlike chart to visualize your data .
For exercise, google data studio bequeath create a visual image mechanically when one choose a pie chart. merely you can edit operating room create your own custom visual image american samoa well .
IP Address Important Notes
- Google Data Studio cannot access the local host. You need to set a public IP address or hostname.
- THE MySQL connector can query a maximum of 150k rows.
- Google Data Studio only supports ASCII characters as the column hears/Field names.
- The supported MySQL versions are 5.6, 5.7 and 8.0
Final Thoughts
google datum studio allow information technology drug user to plug in to different type of database such a MySQL, PostgreSQL, Microsoft waiter, and red shift. some whitethorn be protected aside angstrom firewall ; thus, you necessitate to practice the provide information science address to plug in, which be 142.251.74.0/23 from early 2023. The previous information science address volition not work.
Read more : Google Maps – Wikipedia
one hope this be helpful ! If you need to learn more, find free to subscribe to my newsletter oregon take vitamin a look at one of my course .
active splashboard and data analysis with google data studio apartment – 2022
If you want to memorize how to build herculean data visual image and unlock insight that can help you drive commercial enterprise result for your node operating room employer, claim ampere look at my wide course on Udemy .
Google BigQuery for Marketers and Agencies
This course be designed to bridge the gap between datum analysis and digital market, and help you become ampere data-driven decision-maker. information technology cover the more technical foul expression of join and datum blend adenine well. You can access the full class here adenine well .