SQLLimit type: sql_limit#

class lumen.transforms.sql.SQLLimit(*, limit, controls, name)#: Performs a LIMIT SQL operation on the query

Parameters#

limit

type: int
default: 1000
bounds: None
Limit on the number of rows to return

SQLLimit.apply(sql_in)#

Given an SQL statement, manipulate it, and return a new SQL statement.

Parameters:: sql_in (string) – The initial SQL query to be manipulated.
Returns:: New SQL query derived from the above query.
Return type:: string

SQLLimit.to_spec(context: Dict[str, Any] | None = None) → Dict[str, Any]#

Exports the full specification to reconstruct this component.