Using your own SQL tables for interviews
If you want to collaborate on a SQL challenge with your candidate and you want to use real data, you can upload a custom SQL table in addition to your template. To do this, go to the interview templates section, and click the "Upload SQL table" button.
You'll then be able to upload a .sql file which can be queried on during an interview. Tables you upload will be prefixed with your organization name and the table limit is 2MB.
Example SQL file
Here is an example file for the format we accept for custom tables.
Executing on the table
During the interview, you'll be able to use any custom SQL tables you uploaded.