Skip to main content
This tutorial walks you through how you can add a public URL to a CSV file into the NexusOne platform.

​
Prerequisite

Appropriate permission: nx1_ingest, nx1_monitor, nx1_s3_admin, airflow_user, superset_user, spark_sql, and trino_admin

​
Add the public URL to the portal

  1. Log in to NexusOne.
  2. On the NexusOne homepage, navigate to Ingest > File.
  3. In the File Details section, click Public File URL.
  4. In the File URL field, enter the following URL to a CSV file:
https://rapid-file-tutorial.s3.us-east-1.amazonaws.com/customers.csv
There are no file options to customize the CSV file when you ingest a file using a public URL.

​
Add ingest details

Add the following information to the fields:
  • Name: csv_url
  • Schema: csv_url_schema
  • Table: csv_url_table
  • Schedule: Run Once
  • Mode: append
  • Tags: Don’t add any tags
After adding these details, click Ingest. Wait for a few minutes until you see a success message appear.

​
Monitor job

When you ingest the file, this creates an Airflow job. To monitor the status of the job, use the following steps:
  1. Click View Jobs or navigate to the NexusOne homepage and click Monitor.
  2. Find your job name, csv, in the list, and watch its current status.
  3. 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:
  1. On the NexusOne homepage, click Discover to launch Superset.
  2. Hover your mouse over SQL, and then select SQL Lab.
  3. Enter the following command in the query box:
SELECT * FROM csv_url_schema.csv_url_table
visualize-csv-url-dataset-v4-1-2

Visualize your dataset

​
Additional resources