search

googledatalab / datalab

Interactive tools and developer experiences for Big Data on Google Cloud Platform.
Apache License 2.0
974 stars 249 forks source link

Connecting to a non-BigQuery SQL Database #1021

Open ashernevins opened 8 years ago

ashernevins commented 8 years ago

It appears that %%sql refers to BigQuery. How can we perform analysis from regular SQL databases like Google Cloud SQL?

qimingj commented 8 years ago

Google Cloud SQL query is not supported yet in Datalab. We are working on it.

tswast commented 7 years ago

Do we have a separate issue to track Cloud SQL support in general (not just the %sql magic)?

Even before the magic command is supported, I'd like to see:

  1. Run the Cloud SQL proxy in the Datalab container, having it use the same gcloud credentials.
  2. Bundle sqlalchemy in the included packages so that we can use Pandas' SQL support.
  3. PyMySQL bundled for MySQL support (supports Python 2 and 3).
gpopovic commented 7 years ago

@qimingj any news on cloud sql support?

qimingj commented 7 years ago

Sorry. Nobody is actively working on it now. We are open to contributions!

EamonKeane commented 6 years ago

The lack of support for Cloud SQL is puzzling... are there workarounds people have used, like adding sqlalchemy and white-listing an IP or some such?

begelundmuller commented 6 years ago

+1. I'm surprised that Google Datalab wasn't launched with Google Cloud SQL support. It boggles my mind that it's still not supported 21 months after this issue was filed.

Edit: I noticed the roadmap hasn't been updated in more than a year. Have you ceased development of Datalab? Would be nice to know before I invest more time in it.

saeed349 commented 5 years ago

@qimingj , any update on how to connect SQL DB to datalab.

brunneranalytics commented 5 years ago

Appears to be dead in the water. Maybe Datalab is being left to a quiet death.