How to manage connections in Airflow

Connections are a core concept of Airflow. As a best-in-class orchestrator, Airflow is designed to integrate with any tool in the data ecosystem, and these integrations require using connections to manage authentication. Understanding connections and setting them up correctly is key to ensuring that Airflow interacts securely with every service you’re orchestrating.
In this webinar, we cover everything you need to know about managing connections in Airflow, including, methods for creating connections, tips for troubleshooting, and how Astro, Astronomer’s managed Airflow service, provides an integrated secrets backend with additional functionality for managing connections across multiple Airflow deployments.

[@looklook6075]

32:29 why "test' connection button is disabled. SO frustrating. Aifrflow makes it so hard to connect to anything. Not intuitive at all. And your video just skipped on how to enable "test". And ask me to contact my deployment admin. lol, I am the deployment admin. Can you show me how? I checked its website and the documentation is not helpful at all. I have been stuck for over a week on how to connect airflow to an MSSQL Sever.

[@Astronomer]

The `test` connection button is disabled by default starting in Airflow 2.7 for security reasons. You can enable it by setting the test_connection core config to Enabled. docs.astronomer.io/learn/connections#test-a-connection. We also have some guidance on connecting to an MSSQL server, although the process can vary depending on your exact setup: docs.astronomer.io/learn/connections/ms-sqlserver

[@quintonflorence6492]

@@Astronomer Hi, where can I find the core config to make this update? I'm currently using Astro CLI. I'm not seeing this setting in the two .yaml files in the project. Thank you.