Upload Files
You can upload files to your home space for experimentation. Excel, JSON, Parquet, and CSV files are supported for upload. Once it is uploaded, you can query the file just like a table by specifying the path, "@[home-space-name].[file-name]".
Upload File to Your Home Space
- Navigate to your Home location by clicking on the home icon & your username.
- Click on the + button in the upper right side and click Upload File.
- Click Next once the file has been selected. If your file is large it may take a few moments to upload, depending on your connection speed.
- (Optional) During the upload process, configure the file settings such as how the file is delimited. Click Save.
Once the file has been uploaded, it is displayed in your home space as a table. You can query it by running SELECT * FROM "@username"."table_name"
.
Limits
- Uploaded files are copies of your local file. Updates to your local file are not automatically reflected in Dremio.
- Bulk upload of multiple files is not supported.
- Files uploaded to your home space cannot be shared with other users. To share it with others, upload the file into a shared source or use COPY INTO to create an Iceberg table in your Dremio catalog.