Turbot Pipes

Developer toolsAPI key

Query cloud and SaaS data with SQL, and manage workspaces, connections, pipelines and snapshots in Turbot Pipes.

12 actions

ActionEffectData handledScope
turbot_pipes_get_actorGets the user the API token belongs to: id, handle, display name and planreadPersonal data
turbot_pipes_list_workspacesLists the workspaces the token's user can reach, their own and their organizations', with each owner's handlereadGeneral
turbot_pipes_get_workspaceGets one workspace: its state, database host, instance type and versionsreadGeneral
turbot_pipes_run_queryRuns a SQL query on a workspace's database, where each connection is a schema of tables such as aws_s3_bucket, and returns the rows as JSONreadPersonal data
turbot_pipes_list_schemasLists the schemas in a workspace's database; each connection and aggregator is a schemareadGeneral
turbot_pipes_list_tablesLists the tables in one schema of a workspace, such as the tables an AWS connection offersreadGeneral
turbot_pipes_get_tableGets one table's columns and their types, so a query can select the right onesreadGeneral
turbot_pipes_list_connectionsLists the connections (plugins with their credentials' names, not the secrets) attached to a workspacereadGeneral
turbot_pipes_list_pipelinesLists the scheduled pipelines of a workspace, such as benchmark runs and snapshot jobs, with their schedule and last runreadGeneral
turbot_pipes_run_pipelineRuns a workspace pipeline now instead of waiting for its schedulewriteGeneral
turbot_pipes_list_snapshotsLists the saved dashboard and benchmark snapshots of a workspacereadGeneral
turbot_pipes_list_processesLists the recent processes of a workspace, such as pipeline runs and updates, with their statereadGeneral