Skip to main content
Version: Next
Microsoft SQL Server is a relational database management system.
Installation
Required packages: pymssql
Drivers
PyPI Package: pymssql
mssql+pymssql://{username}:{password}@{host}:{port}/{database}
Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Feature Score: 44/201
Time Grains
Common Time Grains:
SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR
Extended Time Grains:
FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR
Troubleshooting
Common error messages you may encounter when connecting to or querying Microsoft SQL Server, along with their causes and solutions.
Help improve this documentation by editing the engine spec: