You are viewing documentation about an older version (1.14.0). View latest version

snowflake.snowpark.DataFrameWriter

class snowflake.snowpark.DataFrameWriter(dataframe: DataFrame)[source]

Bases: object

Provides methods for writing data from a DataFrame to supported output destinations.

To use this object:

  1. Create an instance of a DataFrameWriter by accessing the DataFrame.write property.

  2. (Optional) Specify the save mode by calling mode(), which returns the same DataFrameWriter that is configured to save data using the specified mode. The default mode is “errorifexists”.

  3. Call save_as_table() or copy_into_location() to save the data to the specified destination.

Methods

copy_into_location()

Executes a COPY INTO <location> to unload data from a DataFrame into one or more files in a stage or external stage.

mode(save_mode)

Set the save mode of this DataFrameWriter.

saveAsTable(table_name, *[, mode, ...])

Writes the data to the specified table in a Snowflake database.

save_as_table()

Writes the data to the specified table in a Snowflake database.