XLS files are also supported.
Prerequisite
Appropriate permission:nx1_ingest, nx1_monitor, nx1_s3_admin, airflow_user, superset_user,
spark_sql, and trino_admin
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:
Run Once - Mode:
append - Tags: Don’t add any tags
Monitor job
When you ingest the file, this creates an Airflow job. To monitor the status of the job, use the following steps:- Click View Jobs or navigate to the NexusOne homepage and click Monitor.
- Find your job name,
xlsx, in the list, and watch its current status. - Wait for a few minutes and refresh your browser until the status changes to
Completed.
Visualize your dataset
Use the following steps to visualize your dataset:- On the NexusOne homepage, click Discover to launch Superset.
- Hover your mouse over SQL, and then select SQL Lab.
- Enter the following command in the query box:
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.