Lee-W commented on code in PR #37418:
URL: https://github.com/apache/airflow/pull/37418#discussion_r1490631133
##########
docs/apache-airflow-providers-microsoft-mssql/connections/mssql.rst:
##########
@@ -51,3 +51,29 @@ Extra (optional)
More details on all MSSQL parameters supported can be found in
`MSSQL documentation
<https://docs.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver15>`_.
+
+When specifying the connection as URI (in :envvar:`AIRFLOW_CONN_{CONN_ID}`
variable) you should specify it
+following the standard syntax of DB connections - where extras are passed as
parameters
+of the URI. Note that all components of the URI should be URL-encoded.
+
+For example:
+
+.. code-block:: bash
+
+ export
AIRFLOW_CONN_MSSQL_DEFAULT='mssql://username:[email protected]:1433/database_name'
+
+..
+If serializing with JSON:
+
+.. code-block:: bash
+
+ export AIRFLOW_CONN_MSSQL_DEFAULT='{
+ "conn_type": "mssql",
+ "login": "username",
+ "password": "password",
+ "host": "server.com",
+ "port": 1433,
+ "schema": "database_name"
+ }'
+
+..
Review Comment:
```suggestion
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
