- Categories:
System functions (System Control)
SYSTEM$VALIDATE_ CONSUMER_ ACCOUNT¶
Checks whether an account exists and is not a trial account, so that a listing provider can confirm the account is valid before adding it to a listing as a listing consumer. The account is identified by its organization name and account alias.
The function returns only a validity flag. It does not return any other account information.
Syntax¶
Arguments¶
org_name.account_aliasThe name of the account to validate, in
ORG.ALIASformat, for exampleORG1.ACCT1. The name is matched case-insensitively.
Returns¶
Returns a VARCHAR value that contains a JSON object with a single property, is_valid:
trueif the account exists and is not a trial account.falseif the account does not exist, or if it is a trial account. A trial account is an account whose type isTRIAL, or an account that belongs to a trial organization.
Access control requirements¶
The caller can’t be a trial account. If a trial account calls this function, Snowflake returns the same error that it returns for an unknown function.
Other than the trial-account restriction, no privileges are required to call this function.
Examples¶
Validate an account:
Example output: