Using and managing custom files and databases in SQL
If you want to collaborate on a SQL challenge with your candidate and you want to use real data, or if you want to upload your own custom SQL challenge for use in assessments, you'll first need to upload a custom SQL table.
Go to the Databases section under Customization, and click the "Upload SQL table" button. You'll then be able to select MySQL or MSSQL and upload a .sql file which can be queried on during an interview or challenge.
Tables you upload will be prefixed with your organization name and the table limit is 10MB.
Example MySQL file
Here is an example file for the format we accept for custom MySQL tables.
Example MSSQL file
Here is an example file for the format we accept for custom Microsoft SQL tables.
Executing on the table in an interview
During the interview, you'll be able to use any custom SQL tables you uploaded.
Uploading custom files
Aside from .sql files, we also allow you to upload arbitrary files that can later be used in your custom challenges, live interviews, or take-home projects.