instance_connection

This function is used by an agent to get a connection string for a source on an available instance database.

If all of the available instances have already been assigned to agents then this function will raise an exception.

Available in a network database and requires the star$append role.

Parameters:

Name	Optional	Type	Description
tag$	Mandatory	Text	The source tag that will use the connection

Examples:

SELECT instance_connection('temp-123'); -- returns connection string connection string for an instance node

Tips:

• The star$sources view lists existing source tags