Sign in

v1

latestOpenAPI 3.1.02026-07-2618690613.4 KB
Uploads

Upload a CSV file

<Note> To use this endpoint:
  • The Upload data setting in Settings > Content permissions must enabled by an Organization Admin
  • The authenticating user must have Restricted Querier permissions or higher on the model the file will be uploaded to </Note>

Upload a CSV file to create a new data input table. The file is parsed, converted to Arrow format, uploaded to storage, written to the connection's table upload (scratch) schema, and a view is created in the specified model.

Uploaded files:

  • Must be a CSV file with .csv extension
  • Can have a maximum of 500,000 rows. Files will be truncated if this limit is exceeded.
post/v1/uploads

Response

CSV file uploaded successfully and view created.

idstring uuid

Unique identifier for the upload

fileNamestring

Original file name

viewNamestring

Name of the view created

modelIdstring uuid

ID of the model the view was created in

inDbAsTableNamestring

Database table name in the scratch schema

rowCountinteger

Number of rows in the uploaded file

truncatedboolean

Whether the file was truncated due to row limit (500,000 rows)

viewCreatedboolean

Whether a view was created in the model