Download OpenAPI specification:Download
Create a new tenant.
This endpoint is protected and requires a valid JWT token. Only users with appropriate permissions can create tenants.
| name required | string (Name) |
{- "name": "string"
}{- "name": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}List all tenants.
This endpoint is protected and requires a valid JWT token.
| skip | integer (Skip) Default: 0 |
| limit | integer (Limit) Default: 100 |
{- "tenants": [
- {
- "name": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}
]
}Get a tenant by ID.
This endpoint is protected and requires a valid JWT token.
| tenant_id required | string <uuid> (Tenant Id) |
{- "name": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}Update a tenant.
This endpoint is protected and requires a valid JWT token. Only users with appropriate permissions can update tenants.
| tenant_id required | string <uuid> (Tenant Id) |
Name (string) or Name (null) (Name) | |
Any of string (Name) | |
{- "name": "string"
}{- "name": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}Delete a tenant (soft delete).
This endpoint is protected and requires a valid JWT token. Only users with appropriate permissions can delete tenants.
| tenant_id required | string <uuid> (Tenant Id) |
{- "detail": [
- {
- "loc": [
- "string"
], - "msg": "string",
- "type": "string"
}
]
}{- "users": [
- {
- "email": "string",
- "name": "string",
- "role": "Dataset user",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "identity_provider_id": "string",
- "created_at": "2019-08-24T14:15:22Z"
}
]
}Create a new user
| email required | string (Email) |
| name required | string (Name) |
| role | string (Role) Default: "Dataset user" Enum: "Dataset user" "Dataset editor" "Org admin" |
{- "email": "string",
- "name": "string",
- "role": "Dataset user"
}{- "email": "string",
- "name": "string",
- "role": "Dataset user",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "identity_provider_id": "string",
- "created_at": "2019-08-24T14:15:22Z"
}Get user by ID
| user_id required | string (User Id) |
{- "email": "string",
- "name": "string",
- "role": "Dataset user",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "identity_provider_id": "string",
- "created_at": "2019-08-24T14:15:22Z"
}Update user by ID
| user_id required | string (User Id) |
| email required | string (Email) |
| name required | string (Name) |
| role | string (Role) Default: "Dataset user" Enum: "Dataset user" "Dataset editor" "Org admin" |
{- "email": "string",
- "name": "string",
- "role": "Dataset user"
}{- "email": "string",
- "name": "string",
- "role": "Dataset user",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "identity_provider_id": "string",
- "created_at": "2019-08-24T14:15:22Z"
}Soft delete a user
This endpoint is protected and requires a valid JWT token. The user making the request must have the 'Org admin' role.
| user_id required | string (User Id) |
{- "property1": "string",
- "property2": "string"
}Invite a new user to the system
This endpoint is protected and requires a valid JWT token. The user sending the invitation must have the 'Org admin' role.
| email required | string (Email) |
| name required | string (Name) |
| role | string (Role) Default: "Dataset user" Enum: "Dataset user" "Dataset editor" "Org admin" |
{- "email": "string",
- "name": "string",
- "role": "Dataset user"
}{- "email": "string",
- "name": "string",
- "role": "Dataset user",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "identity_provider_id": "string",
- "created_at": "2019-08-24T14:15:22Z"
}{- "email": "string",
- "name": "string",
- "role": "Dataset user",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "identity_provider_id": "string",
- "created_at": "2019-08-24T14:15:22Z"
}Update a user's role
This endpoint is protected and requires a valid JWT token. The user making the request must have the 'Org admin' role.
| user_id required | string (User Id) |
| role required | string (Role) Enum: "Dataset user" "Dataset editor" "Org admin" |
{- "role": "Dataset user"
}{- "email": "string",
- "name": "string",
- "role": "Dataset user",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "identity_provider_id": "string",
- "created_at": "2019-08-24T14:15:22Z"
}Create a new project.
This endpoint is protected and requires a valid JWT token. Projects are created within the current user's tenant.
| name required | string (Name) |
Description (string) or Description (null) (Description) |
{- "name": "string",
- "description": "string"
}{- "name": "string",
- "description": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}List all projects in the current tenant.
This endpoint is protected and requires a valid JWT token.
| skip | integer (Skip) Default: 0 |
| limit | integer (Limit) Default: 100 |
{- "projects": [
- {
- "name": "string",
- "description": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}
]
}Get a project by ID.
This endpoint is protected and requires a valid JWT token. Only projects within the current user's tenant are accessible.
| project_id required | string <uuid> (Project Id) |
{- "name": "string",
- "description": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}Update a project.
This endpoint is protected and requires a valid JWT token. Only projects within the current user's tenant can be updated.
| project_id required | string <uuid> (Project Id) |
Name (string) or Name (null) (Name) | |
Description (string) or Description (null) (Description) |
{- "name": "string",
- "description": "string"
}{- "name": "string",
- "description": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}Delete a project (soft delete).
This endpoint is protected and requires a valid JWT token. Only projects within the current user's tenant can be deleted.
| project_id required | string <uuid> (Project Id) |
{- "detail": [
- {
- "loc": [
- "string"
], - "msg": "string",
- "type": "string"
}
]
}Create a new dataset.
This endpoint is protected and requires a valid JWT token. Datasets are created within the current user's tenant. A corresponding BigQuery dataset will be created synchronously.
| name required | string (Name) |
Description (string) or Description (null) (Description) | |
| project_id required | string <uuid> (Project Id) |
{- "name": "string",
- "description": "string",
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9"
}{- "name": "string",
- "description": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}List all datasets in the current tenant.
This endpoint is protected and requires a valid JWT token.
| skip | integer (Skip) Default: 0 |
| limit | integer (Limit) Default: 100 |
{- "datasets": [
- {
- "name": "string",
- "description": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}
]
}Get a dataset by ID.
This endpoint is protected and requires a valid JWT token. Only datasets within the current user's tenant are accessible.
| dataset_id required | string <uuid> (Dataset Id) |
{- "name": "string",
- "description": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}Update a dataset.
This endpoint is protected and requires a valid JWT token. Only datasets within the current user's tenant can be updated. The corresponding BigQuery dataset will be updated synchronously.
| dataset_id required | string <uuid> (Dataset Id) |
Name (string) or Name (null) (Name) | |
Description (string) or Description (null) (Description) | |
Project Id (string) or Project Id (null) (Project Id) |
{- "name": "string",
- "description": "string",
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9"
}{- "name": "string",
- "description": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}Delete a dataset (soft delete).
This endpoint is protected and requires a valid JWT token. Only datasets within the current user's tenant can be deleted. The corresponding BigQuery dataset will be deleted synchronously.
| dataset_id required | string <uuid> (Dataset Id) |
{- "detail": [
- {
- "loc": [
- "string"
], - "msg": "string",
- "type": "string"
}
]
}List all datasets in a specific project.
This endpoint is protected and requires a valid JWT token. Only datasets within the current user's tenant are accessible.
| project_id required | string <uuid> (Project Id) |
{- "datasets": [
- {
- "name": "string",
- "description": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}
]
}Create a new table.
This endpoint is protected and requires a valid JWT token. Tables are created within the current user's tenant. A corresponding BigQuery table will be created synchronously.
| name required | string (Name) |
| schema required | any (Schema) |
| dataset_id required | string <uuid> (Dataset Id) |
{- "name": "string",
- "schema": null,
- "dataset_id": "8c4c51f1-f6f3-43bc-b65d-7415e8ef22c0"
}{- "name": "string",
- "schema": null,
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "dataset_id": "8c4c51f1-f6f3-43bc-b65d-7415e8ef22c0",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}List all tables in the current tenant.
This endpoint is protected and requires a valid JWT token.
| skip | integer (Skip) Default: 0 |
| limit | integer (Limit) Default: 100 |
{- "tables": [
- {
- "name": "string",
- "schema": null,
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "dataset_id": "8c4c51f1-f6f3-43bc-b65d-7415e8ef22c0",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}
]
}Get a table by ID.
This endpoint is protected and requires a valid JWT token. Only tables within the current user's tenant are accessible.
| table_id required | string <uuid> (Table Id) |
{- "name": "string",
- "schema": null,
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "dataset_id": "8c4c51f1-f6f3-43bc-b65d-7415e8ef22c0",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}Update a table.
This endpoint is protected and requires a valid JWT token. Only tables within the current user's tenant can be updated. The corresponding BigQuery table will be updated synchronously.
| table_id required | string <uuid> (Table Id) |
Name (string) or Name (null) (Name) | |
Schema (any) or Schema (null) (Schema) | |
Dataset Id (string) or Dataset Id (null) (Dataset Id) |
{- "name": "string",
- "schema": { },
- "dataset_id": "8c4c51f1-f6f3-43bc-b65d-7415e8ef22c0"
}{- "name": "string",
- "schema": null,
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "dataset_id": "8c4c51f1-f6f3-43bc-b65d-7415e8ef22c0",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}Delete a table (soft delete).
This endpoint is protected and requires a valid JWT token. Only tables within the current user's tenant can be deleted. The corresponding BigQuery table will be deleted synchronously.
| table_id required | string <uuid> (Table Id) |
{- "detail": [
- {
- "loc": [
- "string"
], - "msg": "string",
- "type": "string"
}
]
}List all tables in a specific dataset.
This endpoint is protected and requires a valid JWT token. Only tables within the current user's tenant are accessible.
| dataset_id required | string <uuid> (Dataset Id) |
{- "tables": [
- {
- "name": "string",
- "schema": null,
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "dataset_id": "8c4c51f1-f6f3-43bc-b65d-7415e8ef22c0",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}
]
}Create a new import job.
This endpoint is protected and requires a valid JWT token. Import jobs are created within the current user's tenant.
| status required | string (Status) |
| table_id required | string <uuid> (Table Id) |
{- "status": "string",
- "table_id": "ac92386a-00cc-4818-bf43-1a666d5a5e67"
}{- "status": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "table_id": "ac92386a-00cc-4818-bf43-1a666d5a5e67",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}List all import jobs in the current tenant.
This endpoint is protected and requires a valid JWT token.
| skip | integer (Skip) Default: 0 |
| limit | integer (Limit) Default: 100 |
{- "import_jobs": [
- {
- "status": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "table_id": "ac92386a-00cc-4818-bf43-1a666d5a5e67",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}
]
}Get an import job by ID.
This endpoint is protected and requires a valid JWT token. Only import jobs within the current user's tenant are accessible.
| job_id required | string <uuid> (Job Id) |
{- "status": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "table_id": "ac92386a-00cc-4818-bf43-1a666d5a5e67",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}List all import jobs for a specific table.
This endpoint is protected and requires a valid JWT token. Only import jobs within the current user's tenant are accessible.
| table_id required | string <uuid> (Table Id) |
{- "import_jobs": [
- {
- "status": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "table_id": "ac92386a-00cc-4818-bf43-1a666d5a5e67",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}
]
}Create a new export job.
This endpoint is protected and requires a valid JWT token. Export jobs are created within the current user's tenant.
| status required | string (Status) |
| table_id required | string <uuid> (Table Id) |
{- "status": "string",
- "table_id": "ac92386a-00cc-4818-bf43-1a666d5a5e67"
}{- "status": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "table_id": "ac92386a-00cc-4818-bf43-1a666d5a5e67",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}List all export jobs in the current tenant.
This endpoint is protected and requires a valid JWT token.
| skip | integer (Skip) Default: 0 |
| limit | integer (Limit) Default: 100 |
{- "export_jobs": [
- {
- "status": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "table_id": "ac92386a-00cc-4818-bf43-1a666d5a5e67",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}
]
}Get an export job by ID.
This endpoint is protected and requires a valid JWT token. Only export jobs within the current user's tenant are accessible.
| job_id required | string <uuid> (Job Id) |
{- "status": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "table_id": "ac92386a-00cc-4818-bf43-1a666d5a5e67",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}List all export jobs for a specific table.
This endpoint is protected and requires a valid JWT token. Only export jobs within the current user's tenant are accessible.
| table_id required | string <uuid> (Table Id) |
{- "export_jobs": [
- {
- "status": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "table_id": "ac92386a-00cc-4818-bf43-1a666d5a5e67",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}
]
}Get paginated query results for a completed query job.
This endpoint is protected and requires a valid JWT token. Only query jobs within the current user's tenant are accessible.
| job_id required | string <uuid> (Job Id) |
| page | integer (Page) >= 1 Default: 1 Page number (1-indexed) |
| page_size | integer (Page Size) [ 1 .. 200 ] Default: 50 Number of rows per page |
{- "rows": [
- {
- "data": { }
}
], - "columns": [
- "string"
], - "column_privacy": { },
- "total_rows": 0,
- "page": 0,
- "page_size": 0,
- "total_pages": 0
}Get a query job by ID.
This endpoint is protected and requires a valid JWT token. Only query jobs within the current user's tenant are accessible.
| job_id required | string <uuid> (Job Id) |
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "query_id": "6fa29c22-6bab-424a-859e-a13a5c607e72",
- "running_job_id": "string",
- "status": "string",
- "error_result": { },
- "error_details": { },
- "created": "2019-08-24T14:15:22Z",
- "started": "2019-08-24T14:15:22Z",
- "ended": "2019-08-24T14:15:22Z",
- "total_rows": 0,
- "total_bytes_processed": 0,
- "total_slot_ms": 0,
- "cache_hit": true,
- "dml_stats": { },
- "query_plan": { },
- "timeline": { },
- "destination_table": { },
- "num_dml_affected_rows": 0,
- "script_statistics": { },
- "session_info": { },
- "transaction_info": { },
- "reservation_usage": { },
- "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "private_row_count": 0,
- "exports": [
- { }
]
}List all query jobs in the current tenant.
This endpoint is protected and requires a valid JWT token.
| skip | integer (Skip) Default: 0 |
| limit | integer (Limit) Default: 100 |
{- "query_jobs": [
- {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "query_id": "6fa29c22-6bab-424a-859e-a13a5c607e72",
- "running_job_id": "string",
- "status": "string",
- "error_result": { },
- "error_details": { },
- "created": "2019-08-24T14:15:22Z",
- "started": "2019-08-24T14:15:22Z",
- "ended": "2019-08-24T14:15:22Z",
- "total_rows": 0,
- "total_bytes_processed": 0,
- "total_slot_ms": 0,
- "cache_hit": true,
- "dml_stats": { },
- "query_plan": { },
- "timeline": { },
- "destination_table": { },
- "num_dml_affected_rows": 0,
- "script_statistics": { },
- "session_info": { },
- "transaction_info": { },
- "reservation_usage": { },
- "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "private_row_count": 0,
- "exports": [
- { }
]
}
]
}List all query jobs for a specific query.
This endpoint is protected and requires a valid JWT token. Only query jobs within the current user's tenant are accessible.
| query_id required | string <uuid> (Query Id) |
{- "query_jobs": [
- {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "query_id": "6fa29c22-6bab-424a-859e-a13a5c607e72",
- "running_job_id": "string",
- "status": "string",
- "error_result": { },
- "error_details": { },
- "created": "2019-08-24T14:15:22Z",
- "started": "2019-08-24T14:15:22Z",
- "ended": "2019-08-24T14:15:22Z",
- "total_rows": 0,
- "total_bytes_processed": 0,
- "total_slot_ms": 0,
- "cache_hit": true,
- "dml_stats": { },
- "query_plan": { },
- "timeline": { },
- "destination_table": { },
- "num_dml_affected_rows": 0,
- "script_statistics": { },
- "session_info": { },
- "transaction_info": { },
- "reservation_usage": { },
- "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z",
- "private_row_count": 0,
- "exports": [
- { }
]
}
]
}Create a new export job for query results.
This endpoint is protected and requires a valid JWT token. Only users from the same tenant as the query job can create exports. Export jobs are created within the current user's tenant.
| job_id required | string <uuid> (Job Id) |
| format | string (ExportFormat) Default: "CSV" Enum: "CSV" "JSON" "AVRO" "PARQUET" |
| compression | string (ExportCompression) Default: "GZIP" Enum: "GZIP" "DEFLATE" "NONE" |
{- "format": "CSV",
- "compression": "GZIP"
}{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "query_job_id": "9bdb210e-7f90-412b-9a10-f1b506f822ee",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "status": "string",
- "format": "string",
- "compression": "string",
- "gcs_path": "string",
- "signed_url": "string",
- "error_message": "string",
- "created_at": "2019-08-24T14:15:22Z",
- "completed_at": "2019-08-24T14:15:22Z",
- "expires_at": "2019-08-24T14:15:22Z"
}List all export jobs for a query job.
This endpoint is protected and requires a valid JWT token. Only exports within the current user's tenant are accessible.
| job_id required | string <uuid> (Job Id) |
{- "exports": [
- {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "query_job_id": "9bdb210e-7f90-412b-9a10-f1b506f822ee",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "status": "string",
- "format": "string",
- "compression": "string",
- "gcs_path": "string",
- "signed_url": "string",
- "error_message": "string",
- "created_at": "2019-08-24T14:15:22Z",
- "completed_at": "2019-08-24T14:15:22Z",
- "expires_at": "2019-08-24T14:15:22Z"
}
]
}Get export job details by ID.
This endpoint is protected and requires a valid JWT token. Only exports within the current user's tenant are accessible.
| export_id required | string <uuid> (Export Id) |
{- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "query_job_id": "9bdb210e-7f90-412b-9a10-f1b506f822ee",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "status": "string",
- "format": "string",
- "compression": "string",
- "gcs_path": "string",
- "signed_url": "string",
- "error_message": "string",
- "created_at": "2019-08-24T14:15:22Z",
- "completed_at": "2019-08-24T14:15:22Z",
- "expires_at": "2019-08-24T14:15:22Z"
}Get download URL for an export.
This endpoint is protected and requires a valid JWT token. Only users from the same tenant as the export can download. Generates a new signed URL if needed.
| export_id required | string <uuid> (Export Id) |
nullCreate a new query.
This endpoint is protected and requires a valid JWT token. Queries are created within the current user's tenant.
| query_text required | string (Query Text) |
| project_id required | string <uuid> (Project Id) |
{- "query_text": "string",
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9"
}{- "query_text": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}List all queries in the current tenant, optionally filtered by project.
This endpoint is protected and requires a valid JWT token.
| skip | integer (Skip) Default: 0 |
| limit | integer (Limit) Default: 100 |
| project_id | string <uuid> (Project Id) |
{- "queries": [
- {
- "query_text": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}
]
}Get a query by ID.
This endpoint is protected and requires a valid JWT token. Only queries within the current user's tenant are accessible.
| query_id required | string <uuid> (Query Id) |
{- "query_text": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}Update a query.
This endpoint is protected and requires a valid JWT token. Only queries within the current user's tenant can be updated.
| query_id required | string <uuid> (Query Id) |
Query Text (string) or Query Text (null) (Query Text) | |
Project Id (string) or Project Id (null) (Project Id) |
{- "query_text": "string",
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9"
}{- "query_text": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}Delete a query (soft delete).
This endpoint is protected and requires a valid JWT token. Only queries within the current user's tenant can be deleted.
| query_id required | string <uuid> (Query Id) |
{- "detail": [
- {
- "loc": [
- "string"
], - "msg": "string",
- "type": "string"
}
]
}Run a query. Returns a job_id (query_job_id) immediately after starting the job. Job completion is handled asynchronously in the background. Errors will be returned as HTTP exceptions with detailed error messages.
| query_id required | string (Query Id) |
| query_text required | string (Query Text) |
{- "query_id": "string",
- "query_text": "string"
}{- "job_id": "string"
}Get query quota summary for current tenant (read-only, Org admin only)
Returns current quota limits, usage, and remaining amounts. Only accessible by users with 'Org admin' role.
{- "quota": {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "monthly_quota_usd": "string",
- "daily_quota_usd": "string",
- "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z"
}, - "usage": {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "daily_cost_usd": "string",
- "monthly_cost_usd": "string",
- "last_reset_daily": "2019-08-24T14:15:22Z",
- "last_reset_monthly": "2019-08-24T14:15:22Z",
- "created_at": "2019-08-24T14:15:22Z",
- "updated_at": "2019-08-24T14:15:22Z"
}, - "daily_remaining_usd": "string",
- "monthly_remaining_usd": "string",
- "daily_percentage_used": 0,
- "monthly_percentage_used": 0,
- "is_daily_quota_exceeded": true,
- "is_monthly_quota_exceeded": true
}Get query execution cost history with pagination (read-only, Org admin only)
Args: page: Page number (1-indexed) page_size: Number of records per page (max 100)
Returns: Paginated query cost history
Note: Only accessible by users with 'Org admin' role.
| page | integer (Page) Default: 1 |
| page_size | integer (Page Size) Default: 20 |
{- "items": [
- {
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "query_id": "6fa29c22-6bab-424a-859e-a13a5c607e72",
- "bytes_processed": 0,
- "cost_usd": "string",
- "created_at": "2019-08-24T14:15:22Z"
}
], - "total": 0,
- "page": 0,
- "page_size": 0
}Create a project-tenant approval request.
This endpoint allows users to request that a tenant be invited to join a project. The request will be sent to all Org admins of the tenant being invited.
| project_id required | string <uuid> (Project Id) ID of the project requesting tenant association |
| tenant_id required | string <uuid> (Tenant Id) ID of the tenant being invited |
{- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0"
}{- "status": "string",
- "requested_by": "cda0f200-65cd-4343-aedd-9c936b908826",
- "reviewed_by": "92ab4dbc-1b27-40ce-b24b-7dde8f4709be",
- "created_at": "2019-08-24T14:15:22Z",
- "expires_at": "2019-08-24T14:15:22Z",
- "reviewed_at": "2019-08-24T14:15:22Z",
- "rejection_reason": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "project_name": "string",
- "tenant_name": "string",
- "requester_name": "string",
- "requester_email": "string"
}Create a project-dataset approval request.
This endpoint allows users to request that a dataset be added to a project. The request will be sent to all Org admins of the dataset's owning tenant.
| project_id required | string <uuid> (Project Id) ID of the project requesting dataset access |
| dataset_id required | string <uuid> (Dataset Id) ID of the dataset being requested |
{- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
- "dataset_id": "8c4c51f1-f6f3-43bc-b65d-7415e8ef22c0"
}{- "status": "string",
- "requested_by": "cda0f200-65cd-4343-aedd-9c936b908826",
- "reviewed_by": "92ab4dbc-1b27-40ce-b24b-7dde8f4709be",
- "created_at": "2019-08-24T14:15:22Z",
- "expires_at": "2019-08-24T14:15:22Z",
- "reviewed_at": "2019-08-24T14:15:22Z",
- "rejection_reason": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
- "dataset_id": "8c4c51f1-f6f3-43bc-b65d-7415e8ef22c0",
- "project_name": "string",
- "dataset_name": "string",
- "requester_name": "string",
- "requester_email": "string"
}List all pending approval requests for the current user's tenant.
This endpoint is only accessible to Org admins and returns all pending approval requests that require their attention.
{- "project_tenant_approvals": [
- {
- "status": "string",
- "requested_by": "cda0f200-65cd-4343-aedd-9c936b908826",
- "reviewed_by": "92ab4dbc-1b27-40ce-b24b-7dde8f4709be",
- "created_at": "2019-08-24T14:15:22Z",
- "expires_at": "2019-08-24T14:15:22Z",
- "reviewed_at": "2019-08-24T14:15:22Z",
- "rejection_reason": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "project_name": "string",
- "tenant_name": "string",
- "requester_name": "string",
- "requester_email": "string"
}
], - "project_dataset_approvals": [
- {
- "status": "string",
- "requested_by": "cda0f200-65cd-4343-aedd-9c936b908826",
- "reviewed_by": "92ab4dbc-1b27-40ce-b24b-7dde8f4709be",
- "created_at": "2019-08-24T14:15:22Z",
- "expires_at": "2019-08-24T14:15:22Z",
- "reviewed_at": "2019-08-24T14:15:22Z",
- "rejection_reason": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
- "dataset_id": "8c4c51f1-f6f3-43bc-b65d-7415e8ef22c0",
- "project_name": "string",
- "dataset_name": "string",
- "requester_name": "string",
- "requester_email": "string"
}
]
}Get detailed information about a specific approval request.
This endpoint is only accessible to Org admins and returns detailed information about the approval request including all related entities.
| approval_id required | string <uuid> (Approval Id) |
{- "approval": {
- "status": "string",
- "requested_by": "cda0f200-65cd-4343-aedd-9c936b908826",
- "reviewed_by": "92ab4dbc-1b27-40ce-b24b-7dde8f4709be",
- "created_at": "2019-08-24T14:15:22Z",
- "expires_at": "2019-08-24T14:15:22Z",
- "reviewed_at": "2019-08-24T14:15:22Z",
- "rejection_reason": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08"
}, - "project_tenant_details": {
- "status": "string",
- "requested_by": "cda0f200-65cd-4343-aedd-9c936b908826",
- "reviewed_by": "92ab4dbc-1b27-40ce-b24b-7dde8f4709be",
- "created_at": "2019-08-24T14:15:22Z",
- "expires_at": "2019-08-24T14:15:22Z",
- "reviewed_at": "2019-08-24T14:15:22Z",
- "rejection_reason": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "project_name": "string",
- "tenant_name": "string",
- "requester_name": "string",
- "requester_email": "string"
}, - "project_dataset_details": {
- "status": "string",
- "requested_by": "cda0f200-65cd-4343-aedd-9c936b908826",
- "reviewed_by": "92ab4dbc-1b27-40ce-b24b-7dde8f4709be",
- "created_at": "2019-08-24T14:15:22Z",
- "expires_at": "2019-08-24T14:15:22Z",
- "reviewed_at": "2019-08-24T14:15:22Z",
- "rejection_reason": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
- "dataset_id": "8c4c51f1-f6f3-43bc-b65d-7415e8ef22c0",
- "project_name": "string",
- "dataset_name": "string",
- "requester_name": "string",
- "requester_email": "string"
}
}Approve an approval request.
This endpoint is only accessible to Org admins and allows them to approve pending approval requests. The actual association will be created upon approval.
| approval_id required | string <uuid> (Approval Id) |
{ }Reject an approval request.
This endpoint is only accessible to Org admins and allows them to reject pending approval requests with an optional reason.
| approval_id required | string <uuid> (Approval Id) |
Rejection Reason (string) or Rejection Reason (null) (Rejection Reason) Reason for rejection if applicable | |
Any of string (Rejection Reason) Reason for rejection if applicable | |
{- "rejection_reason": "string"
}{ }Internal endpoint for expiring old approval requests.
This endpoint is called by the Cloud Scheduler to automatically expire approval requests that are older than 15 days.
| internal_token | string (Internal Token) |
{ }Create a new agent.
This endpoint is protected and requires a valid JWT token. Only users with 'Org admin' role can create agents. Agents are created within the current user's tenant.
IMPORTANT: Agents must have at least one project assignment. The project_id and optional role must be provided in the request body.
| name required | string (Name) |
Description (string) or Description (null) (Description) | |
| protocol required | string (Protocol) Protocol type: 'A2A' or 'MCP' |
| endpoint_url required | string (Endpoint Url) Agent endpoint URL |
Capabilities (object) or Capabilities (null) (Capabilities) | |
Agent Metadata (object) or Agent Metadata (null) (Agent Metadata) | |
| project_id required | string <uuid> (Project Id) Project ID to assign the agent to. Agents must have at least one project assignment. |
Role (string) or Role (null) (Role) Optional role for the agent in the project |
{- "name": "string",
- "description": "string",
- "protocol": "string",
- "endpoint_url": "string",
- "capabilities": { },
- "agent_metadata": { },
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
- "role": "string"
}{- "name": "string",
- "description": "string",
- "protocol": "string",
- "endpoint_url": "string",
- "capabilities": { },
- "agent_metadata": { },
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "status": "string",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z",
- "gateway_url": "string"
}List all agents in the current tenant.
This endpoint is protected and requires a valid JWT token.
| skip | integer (Skip) Default: 0 |
| limit | integer (Limit) Default: 100 |
{- "agents": [
- {
- "name": "string",
- "description": "string",
- "protocol": "string",
- "endpoint_url": "string",
- "capabilities": { },
- "agent_metadata": { },
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "status": "string",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z",
- "gateway_url": "string"
}
]
}Get an agent by ID.
This endpoint is protected and requires a valid JWT token. Only agents within the current user's tenant are accessible.
| agent_id required | string <uuid> (Agent Id) |
{- "name": "string",
- "description": "string",
- "protocol": "string",
- "endpoint_url": "string",
- "capabilities": { },
- "agent_metadata": { },
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "status": "string",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z",
- "gateway_url": "string"
}Update an agent.
This endpoint is protected and requires a valid JWT token. Only agents within the current user's tenant can be updated.
| agent_id required | string <uuid> (Agent Id) |
Name (string) or Name (null) (Name) | |
Description (string) or Description (null) (Description) | |
Protocol (string) or Protocol (null) (Protocol) | |
Endpoint Url (string) or Endpoint Url (null) (Endpoint Url) | |
Capabilities (object) or Capabilities (null) (Capabilities) | |
Agent Metadata (object) or Agent Metadata (null) (Agent Metadata) | |
Status (string) or Status (null) (Status) |
{- "name": "string",
- "description": "string",
- "protocol": "string",
- "endpoint_url": "string",
- "capabilities": { },
- "agent_metadata": { },
- "status": "string"
}{- "name": "string",
- "description": "string",
- "protocol": "string",
- "endpoint_url": "string",
- "capabilities": { },
- "agent_metadata": { },
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "tenant_id": "34f5c98e-f430-457b-a812-92637d0c6fd0",
- "status": "string",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z",
- "gateway_url": "string"
}Delete an agent (soft delete).
This endpoint is protected and requires a valid JWT token. Only agents within the current user's tenant can be deleted.
| agent_id required | string <uuid> (Agent Id) |
{- "detail": [
- {
- "loc": [
- "string"
], - "msg": "string",
- "type": "string"
}
]
}Get rate limit configuration for an agent
| agent_id required | string <uuid> (Agent Id) |
{- "max_requests_per_second": "string",
- "max_requests_per_minute": "string",
- "max_requests_per_hour": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "agent_id": "2b1e3b65-2c04-4fa2-a2d7-467901e98978"
}Update rate limit configuration for an agent
| agent_id required | string <uuid> (Agent Id) |
required | Max Requests Per Second (number) or Max Requests Per Second (string) (Max Requests Per Second) Maximum requests per second |
required | Max Requests Per Minute (number) or Max Requests Per Minute (string) (Max Requests Per Minute) Maximum requests per minute |
required | Max Requests Per Hour (number) or Max Requests Per Hour (string) (Max Requests Per Hour) Maximum requests per hour |
{- "max_requests_per_second": 0,
- "max_requests_per_minute": 0,
- "max_requests_per_hour": 0
}{- "max_requests_per_second": "string",
- "max_requests_per_minute": "string",
- "max_requests_per_hour": "string",
- "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
- "agent_id": "2b1e3b65-2c04-4fa2-a2d7-467901e98978"
}Assign an agent to a project.
This endpoint is protected and requires a valid JWT token. Only users with 'Org admin' role can assign agents to projects.
| project_id required | string <uuid> (Project Id) |
| agent_id required | string <uuid> (Agent Id) |
Role (string) or Role (null) (Role) |
{- "agent_id": "2b1e3b65-2c04-4fa2-a2d7-467901e98978",
- "role": "string"
}{- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
- "agent_id": "2b1e3b65-2c04-4fa2-a2d7-467901e98978",
- "role": "string",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}List all agents assigned to a project.
This endpoint is protected and requires a valid JWT token.
| project_id required | string <uuid> (Project Id) |
{- "agents": [
- {
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
- "agent_id": "2b1e3b65-2c04-4fa2-a2d7-467901e98978",
- "role": "string",
- "created_at": "2019-08-24T14:15:22Z",
- "archived_at": "2019-08-24T14:15:22Z"
}
]
}Remove an agent from a project.
This endpoint is protected and requires a valid JWT token. Only users with 'Org admin' role can remove agents from projects.
| project_id required | string <uuid> (Project Id) |
| agent_id required | string <uuid> (Agent Id) |
{- "detail": [
- {
- "loc": [
- "string"
], - "msg": "string",
- "type": "string"
}
]
}Route a message to a specific agent.
This endpoint is protected and requires a valid JWT token.
| agent_id required | string <uuid> (Agent Id) |
| message required | object (Message) |
Project Id (string) or Project Id (null) (Project Id) |
{- "agent_id": "2b1e3b65-2c04-4fa2-a2d7-467901e98978",
- "message": { },
- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9"
}{- "result": { },
- "error": { },
- "id": "string"
}Route a message to all agents assigned to a project.
This endpoint is protected and requires a valid JWT token.
| project_id required | string <uuid> (Project Id) |
| message required | object (Message) |
{- "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",
- "message": { }
}[- {
- "result": { },
- "error": { },
- "id": "string"
}
]