Skip to content
Staircase

Data-lake assistant

Data

Answers questions over the accumulated loan and partner data in plain language, and draws the chart where a chart is the answer.

Used when
When someone needs a figure out of the warehouse and does not want to write the query.
Collects
  • The question, and which body of data it should be answered from.
Returns
  • The answer, the query behind it, and a chart where one was asked for.
Evidence
  • prompt-graphql-data

Operations

ChatMTG

POST /handle_query

Handle US Data ChatMTG querying via SQL query

handleUSDataQueryingViaSQL

Endpoint function serves as an interface for users to interact with a US Data database by accepting a SQL query as an input and executing the query.

Request
application/json
{
  "sql": "select count(*) from \"sc-us-data-consumer-data\""
}
Response
application/json

Success

Total Number of People - 258,617,916
Request bodyapplication/json
1 fields
FieldTypeDescription
sqlrequiredstringSQL statement
Response 400application/json
1 fields

Request data invalid

FieldTypeDescription
messagestringError message
Response 403application/json
1 fields

Forbidden

FieldTypeDescription
messagestringError message
Other responses

200

Others in Data

Type to search.