I get the following error when I attempt to run this function within google sheets:
Exception: You do not have permission to call Jdbc.getCloudSqlConnection
any idea on how to fix this?
var connectionName = 'cosmic-tenure-310821:us-central1:propertydata';
var rootPwd = "password";
var user = "root";
var userPwd = 'password';
v
ar db = 'propertydata';
v
ar root = 'root';
v
ar instanceUrl = "jdbc:google:mysql://" + connectionName;
var dbUrl = instanceUrl + "/" + db;
f
unction createTable()
var conn = Jdbc.getCloudSqlConnection(dbUrl, user, userPwd);
conn.createStatement().execute('CREATE TABLE myProperties(APN INT, APNObject MEDIUMBLOB)');
}