Headwater streams are critical control points for carbon dioxide (CO2) emissions to the atmosphere, traditionally assumed to originate primarily from terrestrial sources. However, in-stream metabolic activity can become a substantial CO2 source, particularly in water-scarce regions characterized by net heterotrophic streams and low groundwater inputs. To explore this idea, we analyzed patterns of CO2 and oxygen (O2) concentrations at high-temporal resolution alongside stream aerobic metabolic rates to identify CO2 sources under contrasting hydrological conditions in an intermittent, oligotrophic Mediterranean stream. During high-discharge periods, there was no correlation between O2 and CO2 concentrations, and O2-CO2 patterns indicated CO2 oversaturation. These results indicate that despite ecosystem respiration (ER) predominated over gross primary production (GPP) during high-discharge periods, lateral groundwater inputs were likely the dominant source of CO2 emissions within the stream. Under low-flow conditions, GPP was still low in this net heterotrophic stream. Yet. a negative relationship between O2 and CO2 concentrations emerged, suggesting a major role of in-stream metabolic activity in driving O2-CO2 dynamics. These findings reinforce the concept of headwater streams as key CO2 emitters, while emphasizing the influence of hydrological conditions on their dual role: acting as chimneys for terrestrially-derived CO2 during high-flow periods and as active carbon biogeochemical reactors during low-flow periods.