MSSQL.read_sql_query

MSSQL.read_sql_query(sql_query, method='tempfile', max_size_spooled=1, delimiter=',', tempfile_kwargs=None, stringio_kwargs=None, **kwargs)[source]

Executes a SQL query and read the result into a DataFrame.

Parameters:

  • sql_query (str) – SQL query to execute.

  • method (str) – Method for reading the query result.

  • max_size_spooled (int) – Maximum size in bytes before spooling to disk.

  • delimiter (str) – Delimiter to use for reading the query result.

  • tempfile_kwargs (dict) – Additional keyword arguments for tempfile.

  • stringio_kwargs (dict) – Additional keyword arguments for StringIO.

  • kwargs – [Optional] Additional arguments passed to the reading method.