The dbt source freshness command will output a pass/warning/error status for each table selected in the freshness snapshot.
Additionally, dbt will write the freshness results to a file in the target/ directory called sources.json by default. You can also override this destination, use the -o flag to the dbt source freshness command.