modin.pandas.DataFrame.to_snowflake

DataFrame.to_snowflake(name: Union[str, Iterable[str]], if_exists: Optional[Literal['fail', 'replace', 'append']] = 'fail', index: bool = True, index_label: Optional[Union[Hashable, Sequence[Hashable]]] = None, table_type: Literal['', 'temp', 'temporary', 'transient'] = '') → None[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.26.0/snowpark-python/src/snowflake/snowpark/modin/plugin/extensions/dataframe_extensions.py#L29-L65)

Save the Snowpark pandas DataFrame as a Snowflake table.

Parameters:

  • name – Name of the SQL table or fully-qualified object identifier

  • if_exists – How to behave if table already exists. default ‘fail’ - fail: Raise ValueError. - replace: Drop the table before inserting new values. - append: Insert new values to the existing table. The order of insertion is not guaranteed.

  • index – default True If true, save DataFrame index columns as table columns.

  • index_label – Column label for index column(s). If None is given (default) and index is True, then the index names are used. A sequence should be given if the DataFrame uses MultiIndex.

  • table_type – The table type of table to be created. The supported values are: temp, temporary, and transient. An empty string means to create a permanent table. Learn more about table types here.

See also

Language: English