MSSQL.read_sql_query

MSSQL.read_sql_query(sql_query, method, max_size_spooled, delimiter, tempfile_kwargs, stringio_kwargs, **kwargs)[source]

Execute 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.