Query Profile

The Query Profile page allows you to import a tar file containing query profile data into tables. After importing, the Job Status page displays the target schema and key ID. You can then use this schema and key ID in the LLM to analyze your queries.

Import query profile data

1. Navigate to the Query Profile page.
2. Click Browse to select the tar file you want to import.
3. Enter a Target Schema name where the query profile data will be imported.
4. (Optional) Enter a Key ID to identify the profile data.

   Note

   A Key ID is a unique string that helps you keep record of your stored profiles. If you do not provide a key ID, a unique ID will be automatically generated. In the backend, copies of the stored internal tables are created using the naming format: <target_schema>.qprof_<table_name>_<key_id>. The combination of target schema and key ID can be used by the LLM to locate your saved profiles.
5. (Optional) Enter a Sandbox Name for the import job.

   Note

   If you do not provide a sandbox name, the profiles will be imported to the main cluster.
6. Click Import to begin uploading the data. The import job is created and you are directed to the Job Status page.

Monitor import job status

1. On the Job Status page, in the Query Profile tab, locate your import job in the list.
2. Once the job completes, note the Target Schema, Key ID, and Sandbox Name (if provided) displayed in the job details.
3. Use the target schema, key ID, and sandbox name (if applicable) with the MCP Server Query Profiling tools to leverage the LLM to analyze your imported query profiles.