XLS files are also supported.
Prerequisite
Appropriate permission:nx1_ingest
Add the public URL to the portal
- Log in to NexusOne.
- On the NexusOne homepage, navigate to Ingest > File.
- In the File Details section, click Public File URL.
- In File URL, enter the following URL to a XLSX file:
File URL box.
There are no file options to customize the xlsx file when you ingest a file using a public URL.
Add ingest details
Add the following information to the fields:- Name:
xlsx_url - Schema:
xlsx_url_schema - Table:
xlsx_url_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.