How to Integrate Retool with Codecademy

Codecademy for Teams provides data export capabilities through the admin dashboard. Log into your Codecademy for Teams admin account and navigate to the Admin section. Look for Reports or Data Export options — the exact location depends on your plan and Codecademy's current interface, which has been updated periodically. Download the available progress reports as CSV. Typical export data includes: employee email, employee name, course name, course category, enrollment date, completion date (if completed), completion percentage, and total time spent. Some Codecademy plans may offer more detailed exports including individual lesson completions, assessment scores, and learning path progress. If Codecademy has updated their admin interface since this was written, look for 'Reports', 'Analytics', 'Data Export', or 'Team Progress' in the admin navigation. Enterprise plan customers may have access to automated reporting or direct data feeds — contact your Codecademy account manager to explore these options. Once you have the CSV export, prepare to import it into your database. The import process establishes the data foundation that Retool will query — subsequent exports can update the data on a weekly or monthly basis depending on how frequently you need fresh progress data in your Retool dashboard.

Import your Codecademy CSV data into a database that Retool can query. If you're using Retool Database (the built-in managed PostgreSQL), navigate to Retool Database in your Retool account and create a new table. Create a table named codecademy_progress with the following columns: - id: SERIAL PRIMARY KEY - employee_email: VARCHAR(255) - employee_name: VARCHAR(255) - department: VARCHAR(255) (join from your employee directory if available) - course_name: VARCHAR(500) - course_category: VARCHAR(255) (Python, JavaScript, SQL, Data Science, etc.) - enrollment_date: DATE - completion_date: DATE (nullable) - completion_percentage: INTEGER - time_spent_minutes: INTEGER - last_activity_date: DATE - imported_at: TIMESTAMP DEFAULT NOW() Import your CSV data into this table using Retool Database's import feature, your database management tool (pgAdmin, DBeaver), or a SQL INSERT statement. Create a database Resource in Retool pointing to this database: Resources tab → Add Resource → PostgreSQL (or your database type) → configure connection details. This database becomes the query layer for your Retool dashboard — all subsequent steps build SQL queries against this table.

1-- Create table for Codecademy progress data
2CREATE TABLE IF NOT EXISTS codecademy_progress (
3  id SERIAL PRIMARY KEY,
4  employee_email VARCHAR(255) NOT NULL,
5  employee_name VARCHAR(255),
6  department VARCHAR(255),
7  course_name VARCHAR(500),
8  course_category VARCHAR(255),
9  enrollment_date DATE,
10  completion_date DATE,
11  completion_percentage INTEGER DEFAULT 0,
12  time_spent_minutes INTEGER DEFAULT 0,
13  last_activity_date DATE,
14  imported_at TIMESTAMP DEFAULT NOW()
15);
16
17-- Index for common query patterns
18CREATE INDEX idx_employee_email ON codecademy_progress(employee_email);
19CREATE INDEX idx_course_category ON codecademy_progress(course_category);
20CREATE INDEX idx_completion ON codecademy_progress(completion_percentage);

Create the foundational SQL queries for your Retool dashboard. In Retool's query editor, create queries against your database Resource. getTeamProgress: Fetches all employees and their course completion status. getCategoryCompletion: Aggregates completion by course category for the Chart component. getDepartmentStats: Groups completion data by department for the management overview. getRecentActivity: Shows employees with the most recent Codecademy activity — useful for identifying engaged learners and those who haven't logged in recently. Bind these queries to Table and Chart components in your Retool dashboard. Use Retool's Select components for filtering by department, course category, and date range. The date range filter should apply to last_activity_date to show recent learners.

1-- Query: Team progress overview with completion stats
2SELECT
3  employee_name,
4  employee_email,
5  department,
6  COUNT(*) as total_courses_enrolled,
7  COUNT(CASE WHEN completion_percentage = 100 THEN 1 END) as courses_completed,
8  AVG(completion_percentage) as avg_completion_pct,
9  SUM(time_spent_minutes) / 60.0 as total_hours_spent,
10  MAX(last_activity_date) as last_active
11FROM codecademy_progress
12WHERE
13  ({{ select_department.value === 'All' || select_department.value === '' }}
14    OR department = {{ select_department.value }})
15GROUP BY employee_name, employee_email, department
16ORDER BY avg_completion_pct DESC;

Add visual analytics to the dashboard using Retool's Chart component (Plotly.js-powered). Create a getCategoryStats query that groups completion data by course category: Bind this to a Bar Chart showing average completion percentage by category (Python, JavaScript, SQL, etc.). For skills coverage analysis, create a getSkillsCoverage query that calculates what percentage of the team has achieved at least 80% completion in each course category — this is your skills coverage metric. Build a Stat panel at the top of the dashboard with key metrics: - Total active learners (employees with last_activity_date in the last 30 days) - Organization-wide completion rate (AVG of completion_percentage) - Total learning hours (SUM of time_spent_minutes / 60) - Courses completed this month For the individual employee detail view, create a getEmployeeCourses query that filters to a specific employee selected from the Table and shows all their enrolled courses with per-course completion status. Bind the Table's selectedRow to drive this query. For complex integrations that combine Codecademy progress data with HRIS systems, performance review data, or recruiting pipeline data, RapidDev's team can help build the multi-source data architecture in Retool.

1-- Query: Course category completion rates
2SELECT
3  course_category,
4  COUNT(DISTINCT employee_email) as learners_enrolled,
5  COUNT(DISTINCT CASE WHEN completion_percentage = 100 THEN employee_email END) as learners_completed,
6  ROUND(AVG(completion_percentage), 1) as avg_completion_pct,
7  ROUND(SUM(time_spent_minutes) / 60.0, 1) as total_hours_spent,
8  ROUND(
9    100.0 * COUNT(DISTINCT CASE WHEN completion_percentage >= 80 THEN employee_email END)
10    / NULLIF(COUNT(DISTINCT employee_email), 0),
11    1
12  ) as pct_learners_proficient
13FROM codecademy_progress
14GROUP BY course_category
15ORDER BY avg_completion_pct DESC;

Since Codecademy doesn't offer a real-time API, set up a process to keep your database data current. The approach depends on how frequently Codecademy allows data exports and your organization's reporting cadence. For manual refresh: Create a Retool app with an Import CSV button that allows an L&D admin to upload a fresh Codecademy export CSV. Use Retool's file upload component and a JavaScript query to parse the CSV and run INSERT OR UPDATE statements against your database table. For automated refresh: Use a Retool Workflow with a scheduled trigger (weekly, every Monday at 6 AM) that reminds or notifies the L&D admin to download and import the latest Codecademy export. The workflow can send a Slack or email notification with instructions. If your Codecademy enterprise account provides any API access or scheduled data pushes, configure a Retool Workflow with a webhook trigger to receive new data when Codecademy sends it. Add a data_freshness indicator to your Retool dashboard showing the last import date: SELECT MAX(imported_at) as last_imported FROM codecademy_progress. Display this prominently so users know how current the data is.

1-- Upsert Codecademy data (update existing, insert new)
2INSERT INTO codecademy_progress (
3  employee_email, employee_name, department, course_name,
4  course_category, enrollment_date, completion_date,
5  completion_percentage, time_spent_minutes, last_activity_date, imported_at
6)
7VALUES {{ formatDataAsArray(importedData) }}
8ON CONFLICT (employee_email, course_name)
9DO UPDATE SET
10  completion_percentage = EXCLUDED.completion_percentage,
11  time_spent_minutes = EXCLUDED.time_spent_minutes,
12  last_activity_date = EXCLUDED.last_activity_date,
13  completion_date = EXCLUDED.completion_date,
14  imported_at = NOW();