Manage query result data

This guide explains how to configure the query result storage location.

Set query result location

To execute a query, you must configure the Object Storage bucket and subpath where the result data will be stored. Only one query result location can be configured.

info

• Only one query result location can be configured.
• For details on bucket creation and permission settings, refer to Prepare query result storage.

1. Go to KakaoCloud console > Analytics > Data Query menu.

2. In the query editor, go to the Settings tab.

3. Select the [Manage] button to configure the query result location.

4. In the Set query result location pop-up, enter the required information and select [Save].

   Field	Required	Description
   Bucket	Required	Select the Object Storage bucket to store query results ⚠️ The bucket must be created in Object Storage beforehand.
   Subpath	Optional	Set a detailed subpath - You can create a new path or use an existing one.

5. Confirm the saved Object Storage path.
   Clicking the path redirects to the corresponding bucket in Object Storage.

Query result data

Once the bucket and subpath are configured, final query result data is stored as follows:

info

• A date-based folder structure {YYYY}/{MM}/{DD}/ is automatically created under the user-specified path.
• Query result files are saved in .csv and .metadata formats.
  • For non-structured queries such as EXPLAIN, results are saved in .txt format.
• Large query results are split into ~500MB chunks.
  • In such cases, filenames are suffixed with a number, e.g., query_id_0.csv, query_id_1.csv.

Item	Description
Final result path	{bucket name}/{subpath}/{YYYY}/{MM}/{DD}/{query ID}.csv {bucket name}/{subpath}/{YYYY}/{MM}/{DD}/{query ID}.metadata Example output files bucket_name/query_result/2024/11/19/20241119-161648-65kIHujbh7_0.csv bucket_name/query_result/2024/11/19/20241119-161648-65kIHujbh7.metadata