{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":21223,"path":"integrate-applications/integration-hub/gcloud-sql-spoke.md","title":"Google Cloud SQL Spoke","bundle":null,"doc_type":null,"release":"australia","body":"\n# Google Cloud SQL Spoke\n\nMange provisioning of MySQL and PostgreSQL in Google Cloud SQL from your ServiceNow instance.\n\n## Request apps on the Store\n\nVisit the [ServiceNow Store](https://store.servicenow.com/sn_appstore_store.do#!/store/home) to view all the available apps, and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the [ServiceNow Store version history release notes](https://www.servicenow.com/docs/r/store-release-notes/sn-store-release-notes.html).\n\n## Integration Hub subscription\n\nThis spoke requires an Integration Hub subscription. For more information, see [Legal schedules - IntegrationHub overview](https://www.servicenow.com/content/dam/servicenow-assets/public/en-us/doc-type/legal/snc-addendum-integrationhub.pdf).\n\n## Spoke version\n\nGoogle Cloud SQL spoke v1.0.1 is the latest version. For version history of the spoke, see [Google Cloud SQL spoke release notes](https://www.servicenow.com/docs/r/store-release-notes/store-integrationhub-rn-google-cloud-sql.html).\n\n## Supported versions\n\nThis spoke was built for Google Cloud SQL v1beta4, but may be compatible with later versions.\n\n## Spoke requirements\n\n-   Google Cloud Platform account\n-   Google Identity and Access spoke \\(sn\\_gcpcloudsql\\_spk\\)\n\n## Spoke dependencies\n\nIf you’re having trouble installing the app, ensure that these dependent plugins are installed:\n\n-   • ServiceNow IntegrationHub Action Template - Data Stream \\(com.glide.hub.action\\_type.datastream\\)\n-   • ServiceNow IntegrationHub Action Step - REST \\(com.glide.hub.action\\_step.rest\\)\n-   • ServiceNow IntegrationHub Runtime \\(com.glide.hub.integration.runtime\\)\n-   • ServiceNow Flow Designer - Dynamic Inputs \\(com.glide.hub.dynamic\\_inputs\\)\n-   • Complex Object \\(com.glide.cobject\\)\n\n**Note:** Some of these plugins are licensable features and require appropriate licenses, if used outside the spoke implementation.\n\n## Spoke actions\n\nThe Google Cloud SQL provides actions to automate  tasks when events occurs in your ServiceNow instance. Available actions include:\n\n|Category|Action|Description|Required Permission|\n|--------|------|-----------|-------------------|\n|Back up Run Management:|Create Backup|Creates a backup.|cloudsql.backupRuns.create|\n|Delete Backup Run|Deletes a backup.|cloudsql.backupRuns.delete|\n|Get Backup Run|Retrieves details of the backup.|cloudsql.backupRuns.get|\n|Look up Backup Runs|Retrieves a list of the backup runs.|cloudsql.backupRuns.list|\n|Database Management|Create Database|Creates a database.|cloudsql.databases.create|\n|Delete Database|Deletes a database.|cloudsql.databases.delete|\n|Get Database|Retrieves details of the instance.|cloudsql.databases.get|\n|Look up Databases|Retrieves a list of the databases.|cloudsql.databases.list|\n|Update Database|Updates a database.|cloudsql.databases.update|\n|Instance Management|Clone Instance|Clones an instance.|cloudsql.instances.clone|\n|Create Instance|Creates an instance.|cloudsql.instances.create|\n|Delete Instance|Deletes an instance.|cloudsql.instances.delete|\n|Get Instance|Retrieves details of the instance.|cloudsql.instances.get|\n|Look up Instances|Retrieves a list of the instances.|cloudsql.instances.clone|\n|Restart Instance|Restarts an instance.|cloudsql.instances.restart|\n|Update Instance|Updates an instance.|cloudsql.instances.update|\n|Operations|Get Operation|Retrieves details of the operation.|N/A|\n|Look up Operations|Retrieves a list of the operations.|N/A|\n|Tiers|Look up Tiers|Retrieves a list of the tiers.|N/A|\n|User Management|Create User|Creates a user.|cloudsql.users.create|\n|Delete User|Deletes a user.|cloudsql.users.delete|\n|Look up User|Retrieves a list of the users.|cloudsql.users.list|\n|Update User|Updates a user.|cloudsql.users.update|\n\n## Connection and credential alias requirements\n\nIntegration Hub uses aliases to manage connection and credential information, and OAuth credentials. Using an alias eliminates the need to configure multiple credentials and connection information profiles when using multiple environments. If the connection or credential information changes, you don't need to update any actions that use the connection.\n\nFor information about setting up the spoke, see [Set up the Google Cloud SQL spoke](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/integration-hub/setup-gcloud-sql.md).\n\n"}}