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

snowflake.snowpark.Table

class snowflake.snowpark.Table(table_name: str, session: Optional[Session] = None)[source]

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