XLS files are also supported.
Prerequisite
Appropriate permission:nx1_ingest
Download an XLSX file
Use a Sales dataset from Kaggle.Upload it to the portal
- Log in to NexusOne.
- On the NexusOne homepage, navigate to Ingest > File.
- In the File Details section, click Upload File > Choose file.
- Header: Use the first row as the column name. Defaults to
True. - Sheet Name: Enter the sheet name to read. Defaults to
0, the first sheet.
Add ingest details
Add the following information to the fields:- Name:
xlsx - Schema:
xlsx_schema - Table:
xlsx_table - Schedule:
None - Mode:
append - Tags: Don’t add any tags
None specifies that the DAG on Apache Airflow won’t rerun.
After adding these details, click Ingest. Wait for a few minutes until you see a success message appear.
Monitor job
After the success message from the previous instruction appears, click View Jobs or navigate to the NexusOne homepage and click Monitor. You should see your job name,xlsx, in the list, and its current status.
Visualize your dataset
On the NexusOne homepage, navigate to Discover > New > SQL query. Then execute the following command:
Visualize your dataset
Additional resources
- To get an overview of what file ingestion is, refer to Data ingestion overview.
- For general instructions about how to ingest a file in NexusOne, refer to How to ingest a file.
- For more information about roles or permissions, refer to Govern Overview.