SQL Account & Session DDK Flashcards
ALTER ACCOUNT
Modifies an account.
ALTER CONNECTION
Modifies the properties for an existing connection.
ALTER FAILOVER GROUP
Modifies the properties for an existingfailover group.
ALTER REPLICATION GROUP
Modifies the properties for an existingreplication group.
ALTER SESSION
Sets parameters that change the behavior for the current session.
CREATE ACCOUNT
Creates a new account in your organization.
CREATE CONNECTION
Creates a new connection in the account.
CREATE FAILOVER GROUP
Creates a new failover group of specified objects in the system.
CREATE MANAGED ACCOUNT
Creates a new managed account.
CREATE REPLICATION GROUP
Creates a new replication group of specified objects in the system.
DESCRIBE RESULT
Describes the columns in the result of a query.
DESCRIBE TRANSACTION
Describes thetransaction, including the start time and the state (running, committed, rolled back).
DROP CONNECTION
Removes a connection from the account.
DROP FAILOVER GROUP
Removes a failover group from the account.
DROP MANAGED ACCOUNT
Removes a managed account, including all objects created in the account, and immediately restricts access to the account.
DROP REPLICATION GROUP
Removes areplication groupfrom the account.
SET
Initializes the value of asession variableto the result of a SQL expression.
SHOW CONNECTIONS
Lists the connections for which you have access privileges.
SHOW DATABASES IN FAILOVER GROUP
Lists databases in a failover group.
SHOW DATABASES IN REPLICATION GROUP
Lists databases in a replication group.
SHOW FAILOVER GROUPS
Lists each primary or secondary failover group in this account.
SHOW FUNCTIONS
Lists all the native (i.e. system-defined/built-in) scalar functions provided by Snowflake, as well as any user-defined functions (UDFs) or external functions that have been created for your account.
SHOW GLOBAL ACCOUNTS
Lists all the accounts in your organization that are enabled for replication and indicates the Snowflake Region in which each account is located.
SHOW MANAGED ACCOUNTS
Lists the managed accounts created for your account.
SHOW ORGANIZATION ACCOUNTS
Lists all the accounts in your organization, excludingmanaged accounts.
SHOW PARAMETERS
Lists all the account, session, and object parameters that can be set, as well as the current and default values for each parameter.
SHOW REGIONS
Lists all theregionsin which accounts can be created.
SHOW REPLICATION ACCOUNTS
Lists all the accounts in your organization that are enabled for replication and indicates theregionin which each account is located.
SHOW REPLICATION DATABASES
Lists all the primary and secondary databases (i.e. all databases for which replication has been enabled) in your organization and indicates theregionin which each account is located.
SHOW REPLICATION GROUPS
Lists each primary or secondary replication or failover group in this account.
SHOW SHARES IN FAILOVER GROUP
Lists shares in a failover group.
SHOW SHARES IN REPLICATION GROUP
Lists shares in a replication group.
SHOW VARIABLES
Lists allvariablesdefined in the current session.
UNSET
Drops asession variable.
