> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://apidocs.polytomic.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://apidocs.polytomic.com/_mcp/server.

# Publish Harbor Saved Query Draft

POST https://app.polytomic.com/api/harbors/{harbor_id}/saved-queries/{saved_query_id}/draft/publish

Validates and publishes the current draft as the next immutable saved-query version.

Only organization administrators can publish. Publication executes and validates
the current draft with the Polytomic-managed Harbor's MotherDuck `read_scaling`
credential. It fails instead of using the Harbor writer credential when the
reader credential is missing or incomplete.

After execution, publication verifies that the draft did not change. A
concurrent edit returns a conflict and remains a draft. Successful publication
creates the next immutable revision, records the observed ordered columns as its
output contract, removes validation inputs from the published definition, and
deletes the mutable draft. The response includes the immutable `revision_id`
that future executions use for exact provenance.

Reference: https://apidocs.polytomic.com/api-reference/harbors/publish-saved-query-draft

## Authentication

- `Authorization` header (bearer token, required) — Bearer user API key
- `Authorization` header (basic auth, required) — Basic organization-scoped API key

## Request

### Path parameters

- `harbor_id` (string, required) — Unique identifier of the Harbor.
- `saved_query_id` (string, required) — Unique stable identifier of the saved query.

## Response

### 200

OK

- `data` (HarborSavedQueryResponse, optional)

## Errors

### 403 Forbidden Error

Forbidden

- `key` (string, optional)
- `message` (string, optional)
- `metadata` (map from string to any, optional)
- `status` (integer, optional)

### 404 Not Found Error

Not Found

- `key` (string, optional)
- `message` (string, optional)
- `metadata` (map from string to any, optional)
- `status` (integer, optional)

### 409 Conflict Error

Conflict

- `key` (string, optional)
- `message` (string, optional)
- `metadata` (map from string to any, optional)
- `status` (integer, optional)

### 422 Unprocessable Entity Error

Unprocessable Entity

- `key` (string, optional)
- `message` (string, optional)
- `metadata` (map from string to any, optional)
- `status` (integer, optional)

### 500 Internal Server Error

Internal Server Error

- `key` (string, optional)
- `message` (string, optional)
- `metadata` (map from string to any, optional)
- `status` (integer, optional)

## Types

### HarborSavedQueryResponse

- `change_note` (string, optional, nullable) — Note supplied when this version was published.
- `description` (string, optional) — Business definition and usage notes.
- `expected_columns` (list of string, optional, nullable) — Expected ordered result-column names.
- `id` (string, optional) — Stable saved-query identifier.
- `name` (string, optional) — Human-readable saved-query name.
- `owner` (string, optional) — Human-readable owner label.
- `parameters` (list of HarborSavedQueryParameter, optional, nullable) — Published typed scalar parameter declarations.
- `published_at` (datetime, optional) — When this version was published.
- `published_by` (string, optional, nullable) — Actor that published this version. Null for the system actor.
- `published_by_type` (string, optional) — Type of actor that published this version.
- `revision_id` (string, optional) — Immutable identifier of this exact published definition.
- `sql_template` (string, optional) — Published SQL template.
- `updated_at` (datetime, optional) — When this version's draft was last updated before publication.
- `version` (integer, optional) — Current published version number.

### HarborSavedQueryParameter

- `name` (string, required) — Template parameter name referenced as \{\{start\_date}}.
- `type` (enum, required) — Scalar parameter type.
  - Allowed values: `string`, `number`, `boolean`, `date`, `timestamp`, `uuid`
- `default_value` (any, optional) — JSON scalar used when the parameter is omitted, matching the declared type. Use default_value, not default. Optional parameters without a default bind SQL NULL.
- `required` (boolean, optional) — When true, rejects explicit null during validation and execution and allows omission only when default_value is present.

## Examples

**Response**

```json
{
  "data": {
    "change_note": "string",
    "description": "string",
    "expected_columns": [
      "string"
    ],
    "id": "248df4b7-aa70-47b8-a036-33ac447e668d",
    "name": "string",
    "owner": "string",
    "parameters": [
      {
        "name": "start_date",
        "type": "string",
        "default_value": null,
        "required": true
      }
    ],
    "published_at": "2024-01-15T09:30:00Z",
    "published_by": "248df4b7-aa70-47b8-a036-33ac447e668d",
    "published_by_type": "string",
    "revision_id": "248df4b7-aa70-47b8-a036-33ac447e668d",
    "sql_template": "string",
    "updated_at": "2024-01-15T09:30:00Z",
    "version": 1
  }
}
```

**SDK Code**

```python
import requests

url = "https://app.polytomic.com/api/harbors/248df4b7-aa70-47b8-a036-33ac447e668d/saved-queries/248df4b7-aa70-47b8-a036-33ac447e668d/draft/publish"

headers = {"Authorization": "Bearer <token>"}

response = requests.post(url, headers=headers)

print(response.json())
```

```javascript
const url = 'https://app.polytomic.com/api/harbors/248df4b7-aa70-47b8-a036-33ac447e668d/saved-queries/248df4b7-aa70-47b8-a036-33ac447e668d/draft/publish';
const options = {method: 'POST', headers: {Authorization: 'Bearer <token>'}};

try {
  const response = await fetch(url, options);
  const data = await response.json();
  console.log(data);
} catch (error) {
  console.error(error);
}
```

```go
package main

import (
	"fmt"
	"net/http"
	"io"
)

func main() {

	url := "https://app.polytomic.com/api/harbors/248df4b7-aa70-47b8-a036-33ac447e668d/saved-queries/248df4b7-aa70-47b8-a036-33ac447e668d/draft/publish"

	req, _ := http.NewRequest("POST", url, nil)

	req.Header.Add("Authorization", "Bearer <token>")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(res)
	fmt.Println(string(body))

}
```

```ruby
require 'uri'
require 'net/http'

url = URI("https://app.polytomic.com/api/harbors/248df4b7-aa70-47b8-a036-33ac447e668d/saved-queries/248df4b7-aa70-47b8-a036-33ac447e668d/draft/publish")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'

response = http.request(request)
puts response.read_body
```

```java
import com.mashape.unirest.http.HttpResponse;
import com.mashape.unirest.http.Unirest;

HttpResponse<String> response = Unirest.post("https://app.polytomic.com/api/harbors/248df4b7-aa70-47b8-a036-33ac447e668d/saved-queries/248df4b7-aa70-47b8-a036-33ac447e668d/draft/publish")
  .header("Authorization", "Bearer <token>")
  .asString();
```

```php
<?php
require_once('vendor/autoload.php');

$client = new \GuzzleHttp\Client();

$response = $client->request('POST', 'https://app.polytomic.com/api/harbors/248df4b7-aa70-47b8-a036-33ac447e668d/saved-queries/248df4b7-aa70-47b8-a036-33ac447e668d/draft/publish', [
  'headers' => [
    'Authorization' => 'Bearer <token>',
  ],
]);

echo $response->getBody();
```

```csharp
using RestSharp;

var client = new RestClient("https://app.polytomic.com/api/harbors/248df4b7-aa70-47b8-a036-33ac447e668d/saved-queries/248df4b7-aa70-47b8-a036-33ac447e668d/draft/publish");
var request = new RestRequest(Method.POST);
request.AddHeader("Authorization", "Bearer <token>");
IRestResponse response = client.Execute(request);
```

```swift
import Foundation

let headers = ["Authorization": "Bearer <token>"]

let request = NSMutableURLRequest(url: NSURL(string: "https://app.polytomic.com/api/harbors/248df4b7-aa70-47b8-a036-33ac447e668d/saved-queries/248df4b7-aa70-47b8-a036-33ac447e668d/draft/publish")! as URL,
                                        cachePolicy: .useProtocolCachePolicy,
                                    timeoutInterval: 10.0)
request.httpMethod = "POST"
request.allHTTPHeaderFields = headers

let session = URLSession.shared
let dataTask = session.dataTask(with: request as URLRequest, completionHandler: { (data, response, error) -> Void in
  if (error != nil) {
    print(error as Any)
  } else {
    let httpResponse = response as? HTTPURLResponse
    print(httpResponse)
  }
})

dataTask.resume()
```