snowflake.snowpark.Session.table

Session.table(name: Union[str, Iterable[str]]) → Table[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.26.0/snowpark-python/src/snowflake/snowpark/session.py#L2257-L2301)

Returns a Table that points the specified table.

Parameters:

  • name – A string or list of strings that specify the table name or fully-qualified object identifier (database name, schema name, and table name).

  • _emit_ast – Whether to emit AST statements.

  • Note – If your table name contains special characters, use double quotes to mark it like this, session.table('"my table"'). For fully qualified names, you need to use double quotes separately like this, session.table('"my db"."my schema"."my.table"'). Refer to Identifier Requirements.

Examples:

>>> df1 = session.create_dataframe([[1, 2], [3, 4]], schema=["a", "b"])
>>> df1.write.save_as_table("my_table", mode="overwrite", table_type="temporary")
>>> session.table("my_table").collect()
[Row(A=1, B=2), Row(A=3, B=4)]
>>> current_db = session.get_current_database()
>>> current_schema = session.get_current_schema()
>>> session.table([current_db, current_schema, "my_table"]).collect()
[Row(A=1, B=2), Row(A=3, B=4)]
Copy
Language: English