Preserve statement boundaries
The HTTP SQL operation request contains one SQL statement. For a script, submit statements as separate operations in the same session and wait for each required predecessor to succeed. Each new statement needs its own operation ID. A retry of one statement keeps that statement’s original ID. The product’s Run all control follows statement execution. Do not assume that posting an entire script creates a transaction across statements.Inspect secret metadata
This read-only example lists secret definitions. It does not return plaintext values:List secret definitions
Lists secret metadata through SQL operations. Plaintext secret values are not returned.
Replace the placeholders in your client. Keep returned IDs for later requests. Paths below use the native API prefix; adjust it for your deployment.
1. Open a session
session_id from /session_id.
Endpoint reference.
2. Submit SQL
3. Follow execution
/status reaches a terminal state: Succeeded, Failed, Cancelled, OutcomeUnknown, Skipped.
Endpoint reference.
4. Read result metadata
5. Fetch rows
6. Close the session
Inspect credential metadata
List credential definitions
Lists credential metadata through SQL operations without exposing underlying secret values.
Replace the placeholders in your client. Keep returned IDs for later requests. Paths below use the native API prefix; adjust it for your deployment.
1. Open a session
session_id from /session_id.
Endpoint reference.
2. Submit SQL
3. Follow execution
/status reaches a terminal state: Succeeded, Failed, Cancelled, OutcomeUnknown, Skipped.
Endpoint reference.
4. Read result metadata
5. Fetch rows
6. Close the session
Inspect streaming pipelines
Inspect streaming pipelines
Requires the native streaming path to be configured. Listing does not create or start pipelines.
Replace the placeholders in your client. Keep returned IDs for later requests. Paths below use the native API prefix; adjust it for your deployment.
1. Open a session
session_id from /session_id.
Endpoint reference.
2. Submit SQL
3. Follow execution
/status reaches a terminal state: Succeeded, Failed, Cancelled, OutcomeUnknown, Skipped.
Endpoint reference.
4. Read result metadata
5. Fetch rows
6. Close the session
default is not proof that an Iceberg catalog exists.
Create and remove a practice secret and credential
The instance needs a configured local secret store. Use unused nameshttp_docs_token and http_docs_bearer, or replace them throughout. The token is a demonstration value and is not valid authentication. Run the explicit cleanup steps only for the objects created by this example.
Create a practice secret and credential
Send each statement separately in one session. Wait for success before its dependent step. Cleanup is explicit.
Replace the placeholders in your client. Keep returned IDs for later requests. Paths below use the native API prefix; adjust it for your deployment.
1. Open a session
session_id from /session_id.
Endpoint reference.
2. Create a demo secret
3. Follow: Create a demo secret
/status reaches a terminal state: Succeeded, Failed, Cancelled, OutcomeUnknown, Skipped.
Endpoint reference.
4. Inspect the secret definition
5. Follow: Inspect the secret definition
/status reaches a terminal state: Succeeded, Failed, Cancelled, OutcomeUnknown, Skipped.
Endpoint reference.
6. Read: Inspect the secret definition
7. Create a bearer credential
8. Follow: Create a bearer credential
/status reaches a terminal state: Succeeded, Failed, Cancelled, OutcomeUnknown, Skipped.
Endpoint reference.
9. Inspect the credential definition
10. Follow: Inspect the credential definition
/status reaches a terminal state: Succeeded, Failed, Cancelled, OutcomeUnknown, Skipped.
Endpoint reference.
11. Read: Inspect the credential definition
12. Remove the practice credential
13. Follow: Remove the practice credential
/status reaches a terminal state: Succeeded, Failed, Cancelled, OutcomeUnknown, Skipped.
Endpoint reference.
14. Remove the practice secret
15. Follow: Remove the practice secret
/status reaches a terminal state: Succeeded, Failed, Cancelled, OutcomeUnknown, Skipped.
Endpoint reference.