​

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).