snowflake.snowpark.Table¶

class snowflake.snowpark.Table(table_name: str, session: Optional[Session] = None)[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.16.0/src/snowflake/snowpark/table.py#L260-L701)¶

Bases: DataFrame

Represents a lazily-evaluated Table. It extends DataFrame so all DataFrame operations can be applied to it.

You can create a Table object by calling Session.table() with the name of the table in Snowflake. See examples in Session.table().

Methods

delete()	Deletes rows in a Table and returns a DeleteResult, representing the number of rows deleted.
drop_table()	Drops the table from the Snowflake database.
merge()	Merges this Table with DataFrame source on the specified join expression and a list of matched or not-matched clauses, and returns a MergeResult, representing the number of rows inserted, updated and deleted by this merge action.
sample([frac, n, seed, sampling_method])	Samples rows based on either the number of rows to be returned or a percentage of rows to be returned.
update()	Updates rows in the Table with specified assignments and returns a UpdateResult, representing the number of rows modified and the number of multi-joined rows modified.

Attributes

is_cached	Whether the table is cached.
table_name	The table name