Microsoft SQL Server

SQL Server connector using pyodbc and sqlglot TSQL parsing.

Property	Value
Key	mssql
Source type	database
Implementation	planned
Active by default	no
Default cache strategy	deterministic_first
Capabilities	supports_discovery, supports_field_permissions, supports_ingestion, supports_query

Implementation is how complete the adapter is. It is not a release status: what the project supports and has certified is on Feature status and in the connector support matrix, and nothing is past public beta yet.

Connection configuration

Secret fields should be given as a reference, <field>_ref, such as env://NAME, rather than a literal.

Key	Secret
host	no
port	no
database	no
user	no
password_ref	no
driver	no
password	yes; prefer password_ref

Default role templates

Offered when a source is created with default roles. Edit them to fit.

blocked

Effect	Action	Resource type	Pattern
deny	*	*	*

read

Effect	Action	Resource type	Pattern
allow	db.schema.list	db.schema	*
allow	db.table.describe	db.table	*.*
allow	db.table.select	db.table	*.*
allow	discovery.search	discovery.asset	*
allow	discovery.asset.read	discovery.asset	*