[google-cloud-sql-discuss] Re: Query Google Big Query from Cloud SQl

As the SQL query is executed on the database this would require the use of federated tables. Unfortunately BigQuery only supports Google Cloud Storage and Google Drive as federated data sources, and MySQL only supports other MySQL databases.

Adding CloudSQL/MySQL as a federated data source for BigQuery sounds like a good feature to request on the issue tracker.

On Monday, June 20, 2016 at 3:45:36 PM UTC-4, Hajar Homayouni wrote:

Actually, I have a R application in which I want to read data from GBQ tables and write into CloudSql tables through a single query:

insert into [CloudSql table]

 select x from [GBQ]

I need something to connect CloudSql to GBQ (integrate them). Any idea would be really appreciated.

On Monday, June 20, 2016 at 1:32:00 PM UTC-6, Adam (Cloud Platform Support) wrote:

It's a bit unclear what you need to do. Are you asking how to import a subset of your BigQuery data into a Cloud SQL database?

On Monday, June 20, 2016 at 12:18:23 PM UTC-4, Hajar Homayouni wrote:

Thank you Rob, could you please explain more how to do this?

On Monday, June 20, 2016 at 10:13:30 AM UTC-6, Rob wrote:

ParaSQL's Hyper Connect will allow you to do this. 

On Friday, June 17, 2016 at 1:11:56 PM UTC-4, Hajar Homayouni wrote:

Hi all,

I have a large dataset in GBQ, and I want to query (select) a small part of it in Cloud SQL. Is there any way to do this?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/e6651215-2742-4ebc-8e8a-9b0a0ef56c07%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.