SET LOCAL REGION Statement

Specifies which region your operations will target in a multi-region environment. By setting a local region, you ensure that your queries and updates are directed to the right regional data store, supporting performance and data locality requirements.

Use the following command to set the local region

SET LOCAL REGION my_local_region;

Note:

You can set the local region only once. After you set the local region, any attempt to change it again results in the following error.

sql-> set local region IAD;
Error handling command set local region IAD: 
	Failure 1: 1/SetLocalRegionName IAD failed.: Cannot change local region name, multi-region tables are active (25.3.21) on [2026-01-14 21:03:15.493 UTC]