EXECUTE NOTEBOOK¶

Executes all the cells in the live version of a notebook. The live version is the active version of the notebook that’s accessible through the Snowsight UI. You don’t need to manage or change versions during preview, but you can use the DESCRIBE NOTEBOOK command to see the available versions.

Note

EXECUTE NOTEBOOK also requires the QUERY_WAREHOUSE parameter to be set, otherwise an error occurs. To set the QUERY_WAREHOUSE parameter, use the ALTER NOTEBOOK command.

Syntax¶

EXECUTE NOTEBOOK <name> ()

Copy

Required parameters¶

name: Specifies the identifier for the notebook to execute.

Access control requirements¶

A role used to execute this SQL command must have the following privileges at a minimum:

Privilege	Object	Notes
USAGE or OWNERSHIP	Notebook	OWNERSHIP is a special privilege on an object that is automatically granted to the role that created the object, but can also be transferred using the GRANT OWNERSHIP command to a different role by the owning role (or any role with the MANAGE GRANTS privilege).

The USAGE privilege on the parent database and schema are required to perform operations on any object in a schema.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

Examples¶

The following example executes a notebook named my_notebook:

EXECUTE NOTEBOOK my_notebook();

Copy