Data Query overview
- Print
- PDF
Data Query overview
- Print
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Available in VPC
Overview
When you subscribe to Data Query, a Data Catalog data source is automatically created, and you can perform queries based on the Data Schema managed by Data Catalog. From the Query Editor menu, you can run queries, view query execution result details, and manage data source additions and deletions.
Common attributes
API URL
https://kr.dataquery.naverncp.com/api/v2/
Request headers
| Header name | Description |
|---|---|
| Content-Type | Specify the request body content type as application/json (POST) |
| x-ncp-apigw-timestamp | This is the number of milliseconds that have elapsed since January 1, 1970 00:00:00 UTC Request is considered invalid if the timestamp differs from the current time by more than 5 minutes |
| x-ncp-iam-access-key | API key issued by NAVER Cloud Platform or access key issued by IAM |
| x-ncp-apigw-signature-v2 | Signature signed by the secret key that matches the access key in the sample body above HmacSHA256 is used as the HMAC encryption algorithm |
Note
For more information, see NAVER Cloud Platform API Guide.
Operation
Query
| APIuser(s) | Description |
|---|---|
| queries | Run user query |
Error response format
If a wrong API request is sent, or an error occurs during its processing, then the success/failure result is returned as an HTTP status code. The detailed message is then returned in the form of JSON.
Response example
{
"type":"http://kr.dataquery.naverncp.com/api/v2/queries",
"title":"query.error.BAD_REQUEST",
"status":400,
"detail":"[query] must not be null",
"instance":"/api/v2/queries",
"errorCode":400
}
Error response
| HTTP status | Error code | Message | Description | Solutions |
|---|---|---|---|---|
| 400 | 400 | Catalog 'public_data1' does not exist Schema 'public_schema' does not exist | Error in query | Double-check the user's query and table information |
| 403 | 10001 | Change/executeSelectQuery | No Sub Account action permissions | Double-check Sub Account action permissions |
| 401 | 10002 | Authentication Failed - This account is not allowed | Authentication failed | Double-check header value authentication information |
| 400 | 10010 | Query Project Not Found | Invalid projectId | Double-check user's Data Query projectId Subscribe to Data Query for query execution APIs |
| 400 | 10090 | mismatched input 'table'. Expecting: <identifier> | Query syntax error | Double-check the user's query syntax |
| 400 | 10091 | 'DropCatalog' command is blocked. | Unavailable query statement used | Change the query because the query statement is unusable |
Was this article helpful?