Skip to main content
Version: Next
Azure Synapse Analytics is a cloud-based enterprise data warehouse from Microsoft that combines big data and data warehousing.
Installation
Required packages: pymssqlpymssql
Drivers
PyPI Package: pymssql
mssql+pymssql://{username}:{password}@{host}:{port}/{database}
Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Time Grains
Common Time Grains:
SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR
Resources
Official Documentation
Help improve this documentation by editing the engine spec:
Edit mssql.py