Instance Groups

How Do I Create a New Instance Group?

Go to the Fabric Studio, select the LU > Instance Groups and right click and select New Instance Group.
Write a valid SQL query to select the instances to be included in the Instance Group.
- The query can be written using the Query Builder by clicking Open Query Builder.
Validate the query by clicking Validate Query.
Save the Instance Group.

The Instance Group is deployed together with its LU.

Example

BATCH Customer.customer_IG_600To700 FABRIC_COMMAND="sync_instance CUSTOMER.?" with JOB_AFFINITY='10.21.2.102' async='true';

The Instance Group is defined from Fabric Studio - customer_IG_600To700

Result:

All instances with ID values between 600 and 700 are synced into Fabric.

fabric>BATCH Customer.customer_IG_600To700 FABRIC_COMMAND="sync_instance CUSTOMER.?";

|Added|Updated|Unchanged|Failed|Total|Duration|
+-----+-------+---------+------+-----+--------+
|99   |0      |0        |0     |99   |875     |

Go to the Fabric Studio, select the LU > Instance Groups and right click and select New Instance Group.
Write a valid SQL query to select the instances to be included in the Instance Group.
- The query can be written using the Query Builder by clicking Open Query Builder.
Validate the query by clicking Validate Query.
Save the Instance Group.