Skip to main content

ALTER SERVICES_CLUSTER IN TABLE

Description​

Change to a different Cluster to run Table Services for the table.

Note that the SQL statement does not end with ;

Syntax​

ALTER SERVICES_CLUSTER IN TABLE `<table_name>`
  LAKE = <string>
  DATABASE = <string>
  SERVICES_CLUSTER = <string>

Sample response

Examples​

ALTER SERVICES_CLUSTER IN TABLE transactions
  LAKE = 'retail_data_lake'
  DATABASE = 'retail_database'
  SERVICES_CLUSTER = 'managed_cluster_retail'

Required parameters​

  • <table_name>: Name of the table.
  • LAKE: Name of the lake containing the specified table.
  • DATABASE: Name of the database containing the specified table.
  • SERVICES_CLUSTER: Change to this Cluster to run Table Services for the specified table.