Manual Queries in the Pinecone Dashboard

The Pinecone dashboard provides a user-friendly interface for interacting with your vector database. One of its key features is the ability to perform manual queries to explore your data and test your index. In this comprehensive guide, we will explore how to create and execute manual queries in the Pinecone dashboard.

Accessing the Query Builder

1. Log in to the Pinecone Dashboard: Go to the Pinecone website and log in to your account.
2. Select a Collection: Choose the collection you want to query.
3. Open the Query Builder: Click on the “Query Builder” button or a similar option in the dashboard.

Creating a Query

1. Choose a Query Type: Select the appropriate query type based on your needs. Pinecone typically offers options like “Nearest Neighbors” or “Filtered Search.”
2. Enter Query Vector: Input the query vector using the provided interface. You can either enter the vector manually or upload a file containing the vector data.
3. Set Query Parameters: Configure additional query parameters, such as the number of results to return, the distance metric to use, and any filters to apply.

Executing the Query

1. Click the “Execute” Button: Once you have entered the query and set the parameters, click the “Execute” button to run the query.

Viewing Results

The query results will be displayed in a table format, showing the vector ID, distance to the query, and other relevant information. You can explore the results to understand the similarity between the query vector and the vectors in your collection.

Additional Features

The Pinecone dashboard may offer additional features for manual queries, such as:

• Visualization: Visualizing the query results using scatter plots or other visualization techniques.
• Filtering: Applying filters to narrow down the results based on specific criteria.
• Exporting Results: Exporting the query results to a CSV or other format.

The Pinecone dashboard’s manual query feature provides a valuable tool for exploring your data and testing the effectiveness of your vector database. By understanding how to create and execute manual queries, you can gain insights into your data and optimize your vector database applications.