Sources
MSSQL (Microsoft SQL Server)
Configuration
To set up the MSSQL source, provide the following configuration parameters:
Key | Description | Sample Value |
---|---|---|
database | Name of the database you want to read data from. | msdb |
host | Hostname of the MSSQL database, including port number at the end (e.g., host,port ). | 172.20.0.2,1433 |
password | Password for the MSSQL user to access the database. | abc123... |
port | Port where the database is running (typically 1433 ). | 1433 |
schema | Schema of the database you want to read data from. | public |
username | Username that will access the database (must have read and write permissions to the specified schema). | guest |
Optional Configuration
Key | Description | Sample Value |
---|---|---|
authentication | Authentication mode for connecting to MSSQL with Azure Active Directory authentication. | ActiveDirectoryServicePrincipal |
batch_fetch_limit | Number of rows to fetch per batch (defaults to 50,000). Adjust if your instance has more memory. | 50000 |
driver | ODBC driver for SQL Server. | ODBC Driver 18 for SQL Server |