-
|
I cannot use any major BI tool, powerBi, Metabase, Tableau, Google Data Studio to connect with the PlanetScale database. I tried all of these tools using the MySQL connector but get failure on everyone with/out SSL. I can't believe this isn't being talked about more as a major limitation. I haven't seen any discussions around this. How are folks visualizing their data today? |
Beta Was this translation helpful? Give feedback.
Replies: 6 comments 14 replies
-
|
Hello @shelbyt! We definitely have users that have been testing things out with PlanetScale and Metabase in recent months (there's a small internal adjustment we need to make to switch the database over to our new Gen4 Query Planner, but those users didn't have trouble connecting to the PlanetScale database itself as far as I can recall, but the Gen4 Query Planner adjustment was needed for the additional operations that Metabase wanted to use after adding in a new database...for example, Metabase runs some metadata collection queries to learn more about the tables/fields in the database you are adding in). As far as I can recall, we haven't had any users report trying to use PowerBI, Tableau, or Google Data Studio so far. The SSL connection to the PlanetScale database should work however (so long as each of those tools supports the option). I'd be curious if any of those tools might require the Gen4 Query Planner feature to be enabled as well after confirming that an SSL connection is able to be established successfully. If you can please reach out to us via: So we can assist you further (you can't directly attach anything upon initial submission of your ticket on that page, but once the ticket is created you can reply with additional screenshots and other info and we can see if we can get some of those BI tools working for you with your PlanetScale database). |
Beta Was this translation helpful? Give feedback.
-
|
I need to create a connection with a user who has only select privilege, any tips? This doesn't work: CREATE USER 'user_test'@'%' IDENTIFIED BY 'user_test_pass';
GRANT SELECT, SHOW VIEW ON `my-table` . * TO 'user_test'@'%'; |
Beta Was this translation helpful? Give feedback.
-
|
Did you find a way to create select only users? I'm having the same issue (1105 error) and found this thread. |
Beta Was this translation helpful? Give feedback.
-
|
We recently added full support for PlanetScale on Draxlr(https://draxlr.com), Both for the Query Builder and the Raw SQL Queries. |
Beta Was this translation helpful? Give feedback.
-
|
we also get around some of the limitations which usually break some of the BI tools like the option to add custom join in the query builder(since you can't add Foreign Key Constraints, bi tools won't fetch the relation between tables) |
Beta Was this translation helpful? Give feedback.
-
|
I also tried using Google Data Studio, and it doesn't connect at all. Has anyone done it, or is it planned to make this possible? |
Beta Was this translation helpful? Give feedback.
-
|
Hey @dluan, I saw that you also opened a ticket. I have responded to it earlier today, but am also going to drop a copy of my response here. Hopefully it's going to be of use for others as well. Updated instructions: Note that if we ever change our SSL certificate provider you will need to update this certificate. We don't have any plans to change our provider Let's Encrypt anytime soon, but I wanted to mention it nonetheless. Yet another way to connect PlanetScale with external resources is Airbyte, an Open Source data integration service. We currently only support the self-hosted version, but setting it up is relatively trivial. We have that process documented here. |
Beta Was this translation helpful? Give feedback.
-
|
Thanks, @fooforge, it worked perfectly with the certificate you provided. I'll reread the documentation on that part again, because I must have done something wrong and given the wrong certificate when trying to connect to Data Studio. |
Beta Was this translation helpful? Give feedback.
-
|
Is this still supported? I tried it just now, but I’m getting errors at the Looker Studio side unfortunately. |
Beta Was this translation helpful? Give feedback.
-
|
@eelco I have just verified that this still works as expected. It would have been a surprise if it didn't. All you will need to do is to upload our CA's root certificate. I am going to attach it as a
|
Beta Was this translation helpful? Give feedback.
-
|
To answer the original question, we have shipped PlanetScale Connect at the end of May which should help with extracting data from PlanetScale and pushing it to other destinations for analysis, transformation, archival, etc. The only caveat is that you cannot configure PlanetScale as a destination in Airbyte yet, only as a source. And, although a MySQL connector exists, it requires the use of I also want to highlight @nirnejak's comment in this thread. Thanks for adding support for PlanetScale! :-) Last but not least, if you're running into connectivity issues, reach out to us at https://support.planetscale.com/ and we will see what we can do to help. |
Beta Was this translation helpful? Give feedback.
-
|
Thanks for the update @fooforge. WIll PlanetScale will be available as a source in Airbyte Cloud when it's out of beta? The page you linked to notes it's only available in Airbyte Open Source. |
Beta Was this translation helpful? Give feedback.
-
|
@kiwioverseas We would love to, but it's not so easy. Airbyte is used to take over maintenance for connectors once they have been written and submitted to their monorepo. However, we did not just want to throw our Open Source connector over the wall and be done with it, but rather maintain it ourselves -- especially as PlanetScale is still rapidly expanding its feature set and functionality. It just didn't feel right to us at this time. My latest information is that Airbyte is working out the operational and legal bits, though, to allow other companies to submit their connectors to Airbyte Cloud and to maintain them themselves. Once that is in place we're definitely going to revisit. |
Beta Was this translation helpful? Give feedback.
-
|
@fooforge Any update regarding this matter? |
Beta Was this translation helpful? Give feedback.
-
|
Checking in on Airbyte Cloud support! |
Beta Was this translation helpful? Give feedback.
-
|
The PlanetScale connector is still only available in self-hosted Airbyte. It looks like there was some some movement toward including it last year but that seems to have fizzled out airbytehq/airbyte#24965. If you need a hosted solution perhaps one of the other ETL platforms supported by PlanetScale Connect will do? |
Beta Was this translation helpful? Give feedback.
-
|
Could I get help with Databox? It requires more than the SSL CA
|
Beta Was this translation helpful? Give feedback.
-
Beta Was this translation helpful? Give feedback.
-
|
Has anyone found a solution to this? |
Beta Was this translation helpful? Give feedback.
-
|
Example how to connect PlanetScale to Google Looker Studio - works for me:
Enjoy your Google Looker real-time dashboard! |
Beta Was this translation helpful? Give feedback.
To answer the original question, we have shipped PlanetScale Connect at the end of May which should help with extracting data from PlanetScale and pushing it to other destinations for analysis, transformation, archival, etc.
The only caveat is that you cannot configure PlanetScale as a destination in Airbyte yet, only as a source. And, although a MySQL connector exists, it requires the use of
LOAD DATA LOCAL INFILEand Common Table Expressions, neither of which are currently supported in Vitess or PlanetScale so, sadly, that's not an option either.I also want to highlight @nirnejak's comment in this thread. Thanks for adding support for PlanetScale! :-)
Last but not least, if you're runn…