Compact radio jet is in action: jet-outflow connection unveiled by the Close AGN Reference Survey (CARS)