Upload a CSV file
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
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
.csvextension - Can have a maximum of 500,000 rows. Files will be truncated if this limit is exceeded.
Authorizations
Can be either an Organization API Key or Personal Access Token (PAT).
Include in the Authorization header as: Bearer YOUR_TOKEN
Body
The CSV file to upload, which must have a .csv extension
UUID of the model to create the view in
"880e8400-e29b-41d4-a716-446655440003"
UUID of the branch to create the view in. Mutually exclusive with branchName.
"990e8400-e29b-41d4-a716-446655440004"
Name of the branch to create the view in. Mutually exclusive with branchId.
"my-branch"
Override the view name. Defaults to sanitized file name.
"custom_view_name"
Response
CSV file uploaded successfully and view created.
Unique identifier for the upload
Original file name
Name of the view created
ID of the model the view was created in
Database table name in the scratch schema
Number of rows in the uploaded file
Whether the file was truncated due to row limit (500,000 rows)
Whether a view was created in the model