View as Markdown
Incorta (OAuth) icon

Incorta (OAuth) ACTION

Execute SQL Query

Executes a custom Spark SQL query against an Incorta tenant via the Advanced SQL Interface (Advanced SQLi), which exposes the tenant's physical schemas and verified business views as Spark SQL tables. Use this for ad hoc reporting or data exploration. Queries that resolve workflow references to bound parameters are not supported; inline literal values in the SQL text instead. It is a read/query interface (not a general-purpose transactional database) — expect SELECT statements with Spark SQL syntax: joins, aggregates, GROUP BY, window functions, and CTEs all work. Use List Schemas, List Tables, and List Columns first if you don't already know the available schema/table/column names, and reference tables as schema.table, e.g. pipedream_store.customer. Always include a LIMIT (and select only the columns you need) for exploratory queries: results are capped at Max Rows (default 500), and the response reports truncated: true when more rows existed than were returned, so a truncated result is partial (the total row count is not known; run a COUNT(*) if you need it). Narrow the query with LIMIT, filters, or aggregates rather than relying on the cap. To read the next page of a large result, either use LIMIT n OFFSET m with a stable ORDER BY, or keyset paging (ORDER BY <unique column> and WHERE <column> > <last value seen> with LIMIT), e.g. SELECT * FROM sales.orders WHERE order_id > 1000 ORDER BY order_id LIMIT 100; keyset paging is faster on large tables. Example: SELECT region, SUM(amount) AS total_sales FROM sales.sales_fact GROUP BY region ORDER BY total_sales DESC LIMIT 50 returns {rows: [{region, total_sales}, ...], rowCount, truncated: false}, one row per region. Authenticates with the connected Incorta account's OAuth access token, so no separate SQL password is needed, and discovers the cluster's Advanced SQLi connection settings automatically from the account's base URL; the tenant must have Advanced SQLi enabled (not available on Azure deployments). The first query after a quiet period can take several seconds while the connection initializes. See the documentation
  • Action
  • Writes data
  • OAuth
  • SDK
  • MCP

IMPLEMENTATION

Call this tool

Connect a user's Incorta (OAuth) account once, then configure and run Execute SQL Query from your backend or agent.

import { PipedreamClient } from "@pipedream/sdk"

const pd = new PipedreamClient({
  projectId: process.env.PIPEDREAM_PROJECT_ID!,
  clientId: process.env.PIPEDREAM_CLIENT_ID!,
  clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
  projectEnvironment: "production",
})

const result = await pd.actions.run({
  id: "incorta_oauth-execute-sql-query",
  externalUserId: "{external_user_id}", // any stable ID for this user in your system
  configuredProps: {
    incorta_oauth: { authProvisionId: "apn_xxxxxxx" },
    sql: "SQL Query",
    maxRows: 10,
  },
})

console.log(result)

SCHEMA

Inputs

Pipedream supplies the connected account. Your application provides the operation-specific values below. Dynamic inputs are resolved against that user's account.

Execute SQL Query inputs
Property Type Description
sql SQL Query sql
The Spark SQL query to execute against Incorta via Advanced SQLi, e.g. SELECT * FROM sales.sales_fact LIMIT 50. See our docs to learn more about working with SQL in Pipedream
Required
maxRows Max Rows integer
Maximum number of rows to return, e.g. 100. The action stops reading once more rows than this have arrived and reports truncated. It does not change or limit the query itself, so add a LIMIT to the SQL as well.
Optional

REFERENCE

Tool details

Behavior hints are published with the component in the Pipedream registry and surface as MCP tool annotations, so an agent can reason about a tool before it calls it.

Registry key
incorta_oauth-execute-sql-query
Version
0.0.1
App
Incorta (OAuth)
Authentication
OAuth
Read-only
No
Destructive
No
Open world
Yes