Every attempt of every task instance has a log. In the Grid, click a square and open Logs: Airflow writes when the attempt started, which try it is, what the task returned, and, when it fails, the full Python traceback. Read a traceback from the bottom up: the last line is the exception, and the line above it is your code that raised it.
Anything your task prints or sends through Python's logging module lands in the same log, so you can record what a task did:
import logging
log = logging.getLogger(__name__)
log.info("Loaded %s rows for %s", len(rows), ds)
Messages at INFO and above are kept; DEBUG is hidden by default. Logs are for people. To pass a value to another task, return it.
The log also shows retries: "Starting attempt 2 of 3" means the first try failed and the task is allowed three in total.
The last line names the exception; the line above it is the code that raised it.