How can I add the authentication info into ingestion yaml file?

Hi, you can directly put the authentication in ingestion yaml or create environment variable like "*MSSQL_PASSWORD*" and pass it value in yaml as shown below

source:
  type: mssql
  config:
    username: sa
    password: ${MSSQL_PASSWORD}
    database: DemoData