Uploading Files
Types of files that you can upload to Fabi.ai and how to do it.
Uploading a file
Working with files is common to all ad hoc and exploratory data analysis. To get started, simply click “Uploads Files”, select as many files as you want and click “Open”.
Fabi.ai will create a SQL cell for the first file in the series to show you how to query files.
File formats
Currently, we support the following formats:
- CSV
- Excel
- Parquet
- JSON
A note on JSON: The file must be somewhat structured and we attempt to make a best effort to parse the file, but in the event that it does not work, check out the DuckDB documentation on JSON uploads to see what options you have at your disposal.
We’re continuously adding new formats and functionality, so please feel free to reach out to support@fabi.ai if you have any particular requests!
Advanced file upload functionality
Under the hood, we’re using DuckDB to manages your uploaded files. This also means that you have access to DuckDB SQL functionality.
For example, if you want to change the delimiter used after you’ve uploaded the file, you can use the delim
function:
select *
from read_csv('flights.csv', delim = '|')
For more information on advanced functionality available to you by file type, check out the DuckDB import documentation (or simply ask the AI).