Input/Output¶

Flat file

`read_csv`(filepath_or_buffer, *[, sep, ...])	Read csv file(s) into a Snowpark pandas DataFrame.
`read_excel`(io[, sheet_name, header, names, ...])	Read an Excel file into a Snowpark pandas DataFrame.
`read_json`(path_or_buf, *[, orient, typ, ...])	Read new-line delimited json file(s) into a Snowpark pandas DataFrame.
`read_parquet`(path[, engine, columns, ...])	Read parquet file(s) into a Snowpark pandas DataFrame.
`read_orc`(path[, columns, dtype_backend, ...])	Load an ORC object from the file path, returning a DataFrame.
`read_sas`(filepath_or_buffer, *[, format, ...])	Read SAS files stored as either XPORT or SAS7BDAT format files.
`read_pickle`(filepath_or_buffer[, ...])	Load pickled pandas object (or any object) from file and return unpickled object.
`read_html`(io, *[, match, flavor, header, ...])	Read HTML tables into a list of DataFrame objects.
`read_xml`(path_or_buffer, *[, xpath, ...])	Read XML document into a DataFrame object.
`read_stata`(filepath_or_buffer, *[, ...])	Read Stata file into DataFrame.

SQL

`read_snowflake`(name_or_query[, index_col, ...])	Read a Snowflake table or SQL Query to a Snowpark pandas DataFrame.
`to_dynamic_table`(obj, name, *, warehouse, lag)	Creates a dynamic table that captures the computation expressed by the given DataFrame or Series.
`to_iceberg`(obj, table_name, *, iceberg_config)	Writes the given DataFrame or Series data to the specified iceberg table in a Snowflake database.
`to_snowflake`(obj, name[, if_exists, index, ...])	Save the Snowpark pandas DataFrame or Series as a Snowflake table.
`to_snowpark`(obj[, index, index_label])	Convert the Snowpark pandas DataFrame or Series to a Snowpark DataFrame.
`to_view`(obj, name, *[, comment, index, ...])	Creates a view that captures the computation expressed by the given DataFrame or Series.

pandas

to_pandas(obj, *[, statement_params])

Convert Snowpark pandas DataFrame or Series to pandas DataFrame or Series