MENU
      Data Query overview
        • PDF

        Data Query overview

        • PDF

        Article summary

        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/
        HTTP

        Request headers

        Header nameDescription
        Content-TypeSpecify the request body content type as application/json (POST)
        x-ncp-apigw-timestampThis 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-keyAPI key issued by NAVER Cloud Platform or access key issued by IAM
        x-ncp-apigw-signature-v2Signature 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
        queriesRun 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
        }
        JSON

        Error response

        HTTP statusError codeMessageDescriptionSolutions
        400400Catalog 'public_data1' does not exist
        Schema 'public_schema' does not exist
        Error in queryDouble-check the user's query and table information
        40310001Change/executeSelectQueryNo Sub Account action permissionsDouble-check Sub Account action permissions
        40110002Authentication Failed - This account is not allowedAuthentication failedDouble-check header value authentication information
        40010010Query Project Not FoundInvalid projectIdDouble-check user's Data Query projectId
        Subscribe to Data Query for query execution APIs
        40010090mismatched input 'table'. Expecting: <identifier>Query syntax errorDouble-check the user's query syntax
        40010091'DropCatalog' command is blocked.Unavailable query statement usedChange the query because the query statement is unusable

        Was this article helpful?

        What's Next
        Changing your password will log you out immediately. Use the new password to log back in.
        First name must have atleast 2 characters. Numbers and special characters are not allowed.
        Last name must have atleast 1 characters. Numbers and special characters are not allowed.
        Enter a valid email
        Enter a valid password
        Your profile has been successfully updated.