Removing Cloud SQL from a Cluster
Remove Oracle Cloud SQL from a Big Data Service cluster.
Important
Removing Cloud SQL from a cluster deletes the query server node and deletes any files on that node. The VM is deleted. This action is irreversible.
Removing Cloud SQL from a cluster deletes the query server node and deletes any files on that node. The VM is deleted. This action is irreversible.
Removing Cloud SQL from a cluster has the following additional results:
- Removes Cloud SQL cells from the cluster worker nodes
- Deletes the query server node and deletes any files or work that you have on that host. (The VM is deleted.)
- Ends the billing for Cloud SQL. You no longer pay for Cloud SQL after it's removed.
- Removing Cloud SQL from a cluster has no impact on Hive metadata or the sources that Cloud SQL accesses.
- Open the navigation menu and click Analytics & AI. Under Data Lake, click Big Data Service.
- Under Compartment, select the compartment that contains the cluster.
- In the list of clusters, click the name of the cluster.
- On the Cluster details page, click More actions, and then select Remove cloud SQL.
- In the Remove cloud SQL panel, enter the cluster administrator password.
- Click Remove.
Use the oci bds cloudsql remove command and required parameters to remove Cloud SQL from the cluster.
oci bds cloudsql remove --bds-instance-id <bds_instance_id> --cluster-admin-password <cluster_admin_password> [OPTIONS]
For a complete list of flags and variable options for CLI commands, see the Command Line Reference for Big Data.
Use the RemoveCloudSql operation to remove Cloud SQL to the cluster.