Enter SQL to extract columns using the Python library
SQLGlot
running in
Pyodide
in the browser.
SELECT ec.event_date, uc.country, COUNT(DISTINCT ec.user_id) AS daily_active_users FROM temp_events_clean ec JOIN main2.brickstream_stg_20240708_1444.user_crm uc ON ec.user_id = uc.user_id GROUP BY ec.event_date, uc.country ORDER BY ec.event_date, daily_active_users DESC;
Extract
Output: