Skip to main content
The Data API lets you query your Catalog tables using SQL over HTTP — ideal for embedding Nekt data in external applications, dashboards, or scripts without a direct database connection.
The Data API is not available on the Free plan.
Available
Nekt ExpressYes
GCPYes (v2 only)
AWSYes

​
Which version to use

There are two versions of the Data API. Use v2 for all new integrations.
Data APIData API v2 (Beta)
StatusStableBeta
Application init requiredYes (~2 min startup)No
PaginationManual (100 rows/page)Automatic
Output formatsParquetParquet (recommended), CSV
AWSYesYes
GCPNoYes
Submit a SQL query and download the results. No initialization or pagination needed.
1

Create an API key

Go to Workspace settings and create an API key.
2

Submit your query

Send a SQL query to the endpoint, specifying your output format (parquet or csv). Parquet is recommended.
SELECT * FROM "nekt_raw"."table_name" LIMIT 200
Standard SQL syntax is supported (filters, joins, WHERE clauses, etc.).
3

Download the results

The API returns a download link. The link is valid for 1 hour.
For the full reference, see Data API v2.

​
Data API v1

The original Data API. Requires application initialization and manual pagination. Use v2 for new work.
1

Create an API key

Go to Workspace settings and create an API key.
2

Initialize the application

Start the Explorer application that processes queries. This takes approximately 2 minutes.
3

Create and submit your query

Submit a Spark SQL query. Results are paginated at 100 records per page — increment page_number to retrieve subsequent pages.
4

Retrieve results

Use the results endpoint to get a presigned URL to a Parquet file. The URL is valid for 1 hour.
For the full reference, see Data API v1.