capabilities.work

Resolve Connection and Run SQL Query

A 3-step recipe with Dataiku. We can help you get access.

Recipe · 3 steps

Resolve Connection and Run SQL Query

with Dataiku

Confirm a connection and execute a SQL query against it.

  1. List the DSS connections available on the instance.
  2. Fetch the target connection's details to confirm it exists and is usable.
  3. Execute the SQL query against the confirmed connection.
What you'll need to have ready
  • apiKey: DSS API key passed as a Bearer token in the Authorization header.
  • connectionName: Name of the DSS connection to query.
  • query: SQL query to execute.
For your developer

Arazzo workflow dataiku:run-sql-query, 3 operations: listConnections → getConnection → executeSqlQuery. Specs on APIs.io.

More recipes with Dataiku

Audit Recipe and Project JobsBootstrap Project with First DatasetBrowse Managed Folder ContentsBuild Dataset and Poll JobCreate Dataset, Set Schema, and BuildCreate Govern Artifact with Custom FieldsCreate Govern Blueprint and VersionExport Project BundleImport and Preload API Node GenerationInspect and Read a Dataset