Recommend DDL

Retrieves DDL recommendations from Firebolt.

GET

Query

Arguments

stringrequired

Firebolt user engine host, for example account-1-mindcloud.api.us-east-1.app.firebolt.io.

stringrequired

Name of the user engine, for example mc_fb_act_20260422_engine.

stringrequired

Database to use for the statement.

stringrequired

Table name to optimize.

stringrequired

SELECT statement that returns exactly one TEXT column containing workload SQL.

Field selectionChoose which fields should be included in the response. Learn more

string

Comma-separated response fields to include.

Try this request

Request

curl --request GET \
  --url "https://connect.mindcloud.co/v1/universal/firebolt/0.0.5/actions/recommend-ddl" \
  --header "Authorization: Bearer $MINDCLOUD_API_TOKEN" \
  --get \
  --data-urlencode 'connectionId=$CONNECTION_ID' \
  --data-urlencode 'engineUrl=' \
  --data-urlencode 'engineName=' \
  --data-urlencode 'database=' \
  --data-urlencode 'tableName=' \
  --data-urlencode 'workloadQuery='

{
  "success": true,
  "data": [],
  "meta": {}
}

Every app you connect,one REST pattern

Call any app with one REST pattern. MindCloud handles each provider's auth, request shape, and responses for you.

Learn what the Universal API is

One REST patternUse the same request structure across apps like Slack, HubSpot, Salesforce, and thousands more.

Managed connectionsSend a MindCloud connection ID instead of handling provider tokens, refresh logic, and credential storage yourself.

Action-level docsEach action page shows the exact endpoint, required arguments, optional controls, and response behavior for that app version.