CREATE DATASET¶

Creates a new machine learning dataset in the current schema or the schema that you specify.

See also:: ALTER DATASET , ALTER DATASET … ADD VERSION , ALTER DATASET … DROP VERSION, SHOW DATASETS

Syntax¶

CREATE [ OR REPLACE ] [ IF NOT EXISTS ] DATASET <name>

name: The name of the dataset that you’re creating within the current schema or a schema that you specify.

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

Privilege	Object	Notes
CREATE DATASET	Schema	Only provides the privilege to create a dataset. You must also have the USAGE privilege on the schema.

Operating on an object in a schema requires at least one privilege on the parent database and at least one privilege on the parent 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.

Regarding metadata:

Attention

Customers should ensure that no personal data (other than for a User object), sensitive data, export-controlled data, or other regulated data is entered as metadata when using the Snowflake service. For more information, see Metadata fields in Snowflake.

The following example creates a dataset called my_dataset:

CREATE DATASET my_dataset;

The following example creates or replaces a dataset called my_dataset:

CREATE OR REPLACE DATASET my_dataset;