Ask HN: Web-based platform for testing job candidates

2 points

2 years ago

Hi HN, I am hiring for a junior data analyst role and trying to prepare an assignment as a way to examine candidate skills. Does anyone know of a web-based GUI that resembles something like MS SQL Management Studio or Teradata SQL Assistant or Cloudera HUE that allows me to import a few sample datasets and then allow job candidates to write their SQL to solve the assignment? I have identified CSV Fiddle [1] and Simon Willison's Datasette Lite [2] as potential options but the GUI doesn't really accommodate easy development of long multi-step SQL queries. I also need the tables to be locked down.

Thanks

[1] https://csvfiddle.io/

[2] https://simonwillison.net/2022/Jun/20/datasette-lite-csvs/