Hello 👋
I have gone throw the following tutorials:
https://cloud.google.com/bigquery/docs/cloud-sql-federated-queries
https://www.youtube.com/watch?v=0cyTHbkARwY&ab_channel=GoogleCloudTech
But every time I try to do an external query to my MySQL database on Google cloud, from Big Query, I receive the following error:
Invalid table-valued function EXTERNAL_QUERY Failed to connect to MySQL database. Error: MysqlErrorCode(1045): Access denied for user 'xxxxx'@'cloudsqlproxy~' (using password: YES) at [1:15]
Does anybody had a similar issue?
It seems your post has already been answered here.