Fundamentals: Uploads
samtSQL enables users to upload multimodal data, either via its REST interface or via the web interface.
Supported formats
samtSQL supports two upload container formats:
- CSV files
- ZIP files
ZIP files may contain multimodal data in the file formats supported by samtSQL. Currently, samtSQL supports the following file types inside ZIP archives.
Image file types
- JPG
- PNG
- GIF
- WEBP
Audio file types
- MP3
- WAV
Data representation
After upload, samtSQL automatically transforms the uploaded data into a single table in the PostgreSQL database. The table name is derived from the input CSV or ZIP file name.
Warning: Existing tables with the same name will be overwritten by the upload. Before overwriting data, samtSQL shows a confirmation warning in the web interface. In the REST interface, overwriting must be explicitly enabled via the associated request parameter.
CSV uploads
For CSV uploads, the table created after the upload has the same columns and rows as the input CSV file.
ZIP uploads
For ZIP uploads, the resulting table has two columns:
filename: the file path of each file in the ZIP archivecontent: the text-encoded content used for evaluating AI operators
The table contains one row for each supported file found in the input ZIP archive.