File Table
Purpose | Explore this guide to discover what is the File Table and how to create one. |
---|
Created | September 29, 2023 |
---|
What is the File Table
In this Table type you have the opportunity to upload various files directly, including formats such as JSON or CSV files, making them instantly accessible for querying purposes. This functionality simplifies the process of accessing and analyzing your data.
File Tables Supporting video
Creating a File Table
Steps to create a File Table
To create a File Table type follow the instructions below:
-
Go to settings and access the table section.
-
Provide a name, and description.
-
Select the "File" Table type and define a schema for your table.
-
Save the table by clicking on the "CREATE TABLE" button.
-
Navigate to the main page of the tables section.
-
Locate your table and click on it.
You can use the searchbar for seamless filtering
-
Select the "ADD" button located at the top right corner.
-
Drop desired files in the pane for future querying.
When adding a CSV file, ensure that you use the correct separators. CSV files typically use semicolons, whereas the Raven Portal requires commas. Verify that your file is in the correct format when using the File Table feature.
The Raven Portal only supports Excel files with a single sheet.
Visualizing the File Table
To visualize the created table, navigate to the Query App. There, users can query the desired table using PostgreSQL, PRQL, or natural language.