Connect alteryx designer to cloudsql MySQL(Private IP)

[ganesh_02]

Hi,

I am trying to connect cloudsql MYSQL database with alteryx. I was able to connect to DB if it has public IP, but want to know about the ways how this can be done if th e DB has only private IP. One way I thought is using authenticate proxy in local system and use it. Not sure if this thought is correct. 

Please suggest me some ways how this we connect connect to cloudsql MYSQL instance if it has private IP.

Thanks in advance !

[apathetichell]

I am 80% sure that I did this via authenticating the proxy in local system. so yes -> I'd say this is correct. to clarify -> this is a GCP Cloud SQL MySQL right? https://cloud.google.com/sql/docs/mysql/connect-auth-proxy#windows-64-bit ?

[ganesh_02]

Thanks for the response. Yes,It is cloudSQL MySQL.
Suppose the workflow is stored in alteryx gallery and shared across team, I thought we can use RUN Command tool so that authenticates in any system where it runs. Will it work in that case.

[apathetichell]

I'm sorry - I have minimal experience in this and off the top of my head I can only think about setting this up on the server/worker nodes as you would on your local and connecting that way. I assume you'd want to connect as an end user vs a service account - and I don't know if your server/worker nodes are on GCP/have GCP service accounts/roles.  (note to any non GCP people - service accounts in GCP can mean one of two things 1) - something akin to an AWS role 2) a vernacular service account with a .json/jwt password - in this case I'm talking about the permission to use an internal service account as AWS role). I'd have to dive into this for a while and can't give you a good answer here. My assumption is that this would be easier replicating your data to BQ. -> or at least there would be more documentation/potential solutions for a BQ implementation.

[ganesh_02]

I appreciate your time and thoughts. Definetly moving it to BQ is a good option as we have separate connection for BQ. I am just curious to know if this proxy thing can work, when instead of running the worflow in local system workflow is running in some remote alteryx servers.

Thank you so much for the thoughts

[apathetichell]

This cloud sql instance has no public ip - right? If so you'd definitely need to set up the gcloud auth locally on each server/worker you were planning to connect. This would be easiest if they are already gcloud vms (compute engine) with existing service accounts tied into them. If they are not GCP or AWS EC2s -> you'd have to do this mostly manually. you'd then want to install the same software/drivers you have locally.

[ganesh_02]

Got it, thanks for the help