All SnowSQL commands start with an exclamation point (!) followed by the command name.

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

All SnowSQL commands start with an exclamation point (!) followed by the command name.

Explanation:
SnowSQL separates client-side control commands from SQL statements. Commands that control the SnowSQL client—like getting help, setting options, or changing the active warehouse—are issued as meta-commands that start with an exclamation point followed by the command name. This prefix signals the CLI to perform a client action rather than sending SQL to Snowflake. When you want to run SQL, you type standard SQL without the exclamation mark, and those statements are executed by Snowflake. So, for SnowSQL’s own commands, using the exclamation prefix is the rule, making this statement true.

SnowSQL separates client-side control commands from SQL statements. Commands that control the SnowSQL client—like getting help, setting options, or changing the active warehouse—are issued as meta-commands that start with an exclamation point followed by the command name. This prefix signals the CLI to perform a client action rather than sending SQL to Snowflake. When you want to run SQL, you type standard SQL without the exclamation mark, and those statements are executed by Snowflake. So, for SnowSQL’s own commands, using the exclamation prefix is the rule, making this statement true.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy