capabilities.work

Run Query in a Session

A 4-step recipe with Teradata. We can help you get access.

Recipe · 4 steps

Run Query in a Session

with Teradata

Open a session on a Vantage system, run one SQL query, then close the session.

  1. Retrieve the Vantage systems available for query execution so the caller can confirm the requested system is reachable before opening a session.
  2. Create a new query session against the requested system for the supplied user and default database.
  3. Execute the supplied SQL statement inside the open session and capture the query identifier, status, and returned rows.
  4. Close and delete the query session to release Vantage resources once the query has run.
What you'll need to have ready
  • system: Target Vantage system name (e.g. vantage-prod).
  • username: Database username used to open the session.
  • database: Default database for the session.
  • query: SQL statement to execute.
  • maxRows: Maximum number of rows to return.
For your developer

Arazzo workflow teradata:run-query-session, 4 operations: listQuerySystems → createSession → executeQuery → deleteSession. Specs on APIs.io.

More recipes with Teradata

Auto-Install Node SoftwareBuild a Data FabricCancel a Running QueryImport and Verify a Remote SystemSubmit Query and Poll for ResultsProvision a Cross-System LinkRegister a System in a New Data CenterReview QueryGrid Environment HealthRun a Connectivity DiagnosticSession Lifecycle