Microsoft SQL Server

SQL Server connector using pyodbc and sqlglot TSQL parsing.

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

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	*