Will Sweet

icon indicating a website link https://williebsweet.com/

icon company Big Time Data icon location Data @Big-Time-Data | Former Data/DX @ Datafold and Data @ Cypress.io

Results 1 issues of Will Sweet

Use PandasCursor for Athena dataframes in fetchdf magic

4 comment

Only applies to the `%%fetchdf` magic command (although it could be expanded). Replaces the generic `pandas.read_sql_query()` with [PandasCursor](https://laughingman7743.github.io/PyAthena/pandas.html#pandascursor) for improved I/O performance. --- With `pandas.read_sql_query()`: 1. Query executes in Athena...