Categories:

System Functions (System Control)

SYSTEM$LINK_ACCOUNT_OBJECTS_BY_NAME

Business Critical Feature

Requires Business Critical Edition (or higher). To inquire about upgrading, please contact Snowflake Support.

Preview Feature — Open

The Account Replication preview is open to all accounts. To enable replication for your account, see Prerequisite: Enable Replication for Accounts in the Organization.

Adds a global identifier to account objects in the target (current) account that were created using scripts and that match objects with the same names in the source account.

Global identifiers are only added to account objects that are included in a replication or failover group for the following object types:

• RESOURCE_MONITOR

• ROLE

• USER

• WAREHOUSE

For more details, see Step 5. Apply Global IDs to Objects Created by Scripts in Target Accounts — Optional.

Syntax

SYSTEM$LINK_ACCOUNT_OBJECTS_BY_NAME('<group_name>')

Arguments

group_name

Specifies the identifier for the replication or failover group.

Usage Notes

• Only account administrators (users with the ACCOUNTADMIN role) can execute this SQL function.

• To retain account objects that exist only in the target account, replicate them manually in the source account before executing this function.

Examples

SELECT SYSTEM$LINK_ACCOUNT_OBJECTS_BY_NAME('myfg');