polars.SQLContext.register#

SQLContext.register(name: str, frame: CompatibleFrameType | None) → Self[source]#

Register a single frame as a table, using the given name.

Parameters:

name: Name of the table.
frame: eager/lazy frame to associate with this table name.

See also

register_globals
register_many
unregister

Examples

>>> df = pl.DataFrame({"hello": ["world"]})
>>> ctx = pl.SQLContext()
>>> ctx.register("frame_data", df).execute("SELECT * FROM frame_data").collect()
shape: (1, 1)
┌───────┐
│ hello │
│ ---   │
│ str   │
╞═══════╡
│ world │
└───────┘