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:
Create an instance of a
DataFrameWriter
by accessing theDataFrame.write
property.(Optional) Specify the save mode by calling
mode()
, which returns the sameDataFrameWriter
that is configured to save data using the specified mode. The default mode is “errorifexists”.Call
save_as_table()
orcopy_into_location()
to save the data to the specified destination.
Methods
Executes a COPY INTO <location> to unload data from a
DataFrame
into one or more files in a stage or external stage.csv
(location, *[, partition_by, ...])Executes internally a COPY INTO <location> to unload data from a
DataFrame
into one or more CSV files in a stage or external stage.json
(location, *[, partition_by, ...])Executes internally a COPY INTO <location> to unload data from a
DataFrame
into a JSON file in a stage or external stage.mode
(save_mode)Set the save mode of this
DataFrameWriter
.parquet
(location, *[, partition_by, ...])Executes internally a COPY INTO <location> to unload data from a
DataFrame
into a PARQUET file in a stage or external stage.saveAsTable
(table_name, *[, mode, ...])Writes the data to the specified table in a Snowflake database.
Writes the data to the specified table in a Snowflake database.