SQL Data Loading Unloading DDL

Question 1

ALTER FILE FORMAT

Answer 1

Modifies the properties for an existing file format object.

Question 2

ALTER PIPE

Answer 2

Modifies a limited set of properties for an existing pipe object.

Question 3

ALTER STAGE

Answer 3

Modifies the properties for an existing named internal or external stage.

Question 4

CREATE FILE FORMAT

Answer 4

Creates a named file format that describes a set of staged data to access or load into Snowflake tables.

Question 5

CREATE PIPE

Answer 5

Creates a new pipe in the system for defining theCOPY INTO statement used bySnowpipeto load data from an ingestion queue into tables.

Question 6

CREATE STAGE

Answer 6

Creates a new namedinternalorexternalstage to use for loading data from files into Snowflake tables and unloading data from tables into files.

Question 7

DESCRIBE FILE FORMAT

Answer 7

Describes the properties and their current values for a file format, as well as the default values for each property.

Question 8

DESCRIBE PIPE

Answer 8

Describes the properties specified for a pipe, as well as the default values of the properties.

Question 9

DESCRIBE STAGE

Answer 9

Describes the values specified for the properties in a stage (file format, copy, and location), as well as the default values for each property.

Question 10

DROP FILE FORMAT

Answer 10

Removes the specified file format from the current/specified schema.

Question 11

DROP PIPE

Answer 11

Removes the specified pipe from the current/specified schema.

Question 12

DROP STAGE

Answer 12

Removes the specified named internal or external stage from the current/specified schema.

Question 13

SHOW FILE FORMATS

Answer 13

Lists the file formats for which you have access privileges.

Question 14

SHOW PIPES

Answer 14

Lists the pipes for which you have access privileges.

Question 15

SHOW STAGES

Answer 15

Lists all the stages for which you have access privileges.