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 allDataFrame
operations can be applied to it.You can create a
Table
object by callingSession.table()
with the name of the table in Snowflake. See examples inSession.table()
.Methods
delete
()Deletes rows in a Table and returns a
DeleteResult
, representing the number of rows deleted.Drops the table from the Snowflake database.
merge
()Merges this
Table
withDataFrame
source on the specified join expression and a list of matched or not-matched clauses, and returns aMergeResult
, 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 aUpdateResult
, representing the number of rows modified and the number of multi-joined rows modified.Attributes
Whether the table is cached.
The table name