mssql

class atscale.db.connections.mssql.MSSQL

The child class of SQLConnection whose implementation is meant to handle interactions with MSSQL. Notes that a different class is required for interacting with Synapse SQL DW at this point in time. For this to work, in addition to dependencies indicated in setup.py, it is necessary to install an ODBC driver.

For MAC, you can use Brew to install unixodbc via brew install unixodbc You can then follow Microsoft instructions for the rest of pyodbc here: https://www.microsoft.com/en-us/sql-server/developer-get-started/python/mac/?rtc=1 Specifically for the following: brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release brew update HOMEBREW_NO_ENV_FILTERING=1 ACCEPT_EULA=Y brew install msodbcsql17 mssql-tools Common errors are discussed here: https://stackoverflow.com/questions/44527452/cant-open-lib-odbc-driver-13-for-sql-server-sym-linking-issue And other places. If you experience driver/connection issues, it is suggested that you first try and connect directly using sqlcmd as indicated in the Microsoft instructions posted above. Once you’re able to connect, you can inspect run the command odbcinst -j to inspect the file: odbcinst.ini which should indicate what string you should use to pass in for the driver parameter to this class. At present time, the string is “ODBC Driver 17 for SQL Server”

clear_auth

Clears any authentication information, like password or token from the connection.

platform_type_str : str = 'mssql'

The string representation of the platform type, matches with atscale