# Data-lake assistant # 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 Copy ``` { "sql": "select count(*) from \"sc-us-data-consumer-data\"" } ``` ##### Response 200400403 application/json Copy Success ``` Total Number of People - 258,617,916 ``` application/json Copy Request data invalid ``` { "message": "Request body is invalid." } ``` application/json Copy Forbidden ``` { "message": "Invalid Api Key" } ``` ##### Request body`application/json` 1 fields | Field | Type | Description | | --- | --- | --- | | `sql`required | `string` | SQL statement | ##### Response `400``application/json` 1 fields Request data invalid | Field | Type | Description | | --- | --- | --- | | `message` | `string` | Error message | ##### Response `403``application/json` 1 fields Forbidden | Field | Type | Description | | --- | --- | --- | | `message` | `string` | Error message | ##### Other responses `200` ## Others in Data - Counterparty document expectations - Dataset fulfilment - Knowledge search - Metric reconciliation - Model curator - Pipeline control panel - Property data exploration - Public record ingestion - Question answering - Report catalog - Search to production