awswrangler.timestream.query

awswrangler.timestream.query(sql: str, boto3_session: Optional[boto3.session.Session] = None) → pandas.core.frame.DataFrame

Run a query and retrieve the result as a Pandas DataFrame.

Parameters

  • sql (str) – SQL query.

  • boto3_session (boto3.Session(), optional) – Boto3 Session. The default boto3 Session will be used if boto3_session receive None.

Returns

Pandas DataFrame https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.html

Return type

pd.DataFrame

Examples

Running a query and storing the result as a Pandas DataFrame

>>> import awswrangler as wr
>>> df = wr.timestream.query('SELECT * FROM "sampleDB"."sampleTable" ORDER BY time DESC LIMIT 10')