I've been struggling with this problem for some time and would like some input from other people - I come from an Analytics background and never had to deal with this sort of thing prior to leading this project. Also, I'd like to point out that we would prefer not to use any pre-built data connectors third-party services, if possible.
Given the context, I basically have two questions:
- I know that Bigquery can access Cloud SQL data using federated queries, so creating a SQL Server instance in Cloud SQL and somehow connecting it to our on premise db is an option - although I might be completely out of range here, since I'm not sure if that's the best option. If this is a good option, how exactly should I build this connection (which kind of services should I use and documentation should I read)? Any network configurations necessary in the on premise db server can be carried out by our internal specialists.
- If the previous item seems absurd to you or if you simply see an easier/cheaper option, how would that go?
Thanks in advance
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/25e49b3b-d4e8-4cf2-97ed-936a4ffecf03n%40googlegroups.com.
No comments:
Post a Comment