Skip to main content
POST
/
datalakes
/
{id}
/
query
Query datalake
curl --request POST \
  --url https://api.prequel.co/import/datalakes/{id}/query \
  --header 'Content-Type: application/json' \
  --header 'X-API-KEY: <api-key>' \
  --data '
{
  "query": "SELECT * FROM provider_abc.users LIMIT 10"
}
'
{
  "schema": [
    {
      "name": "<string>",
      "type": "<string>"
    }
  ],
  "records": [
    {}
  ]
}

Authorizations

​
X-API-KEY
string
header
required

Path Parameters

​
id
string
required

Body

application/json
​
query
string
required

SQL query to execute against the datalake.

Example:

"SELECT * FROM provider_abc.users LIMIT 10"

Response

Success

​
schema
object[]
required

Column names and types for the returned records.

​
records
object[]
required