Skip to main content

Pinecone

Samples Overview

Qarbine provides a wide variety of sample templates, and queries. Some are application oriented examples, while others are database administrator (DBA) oriented.

Below are a few of the component samples to consider. Review the Qarbine Catalog for the latest components. See the latest set of components for Pinecone in the folder depicted below.

  

  

Indexes

This template is at “example/Pinecone/DBA/Indexes”. It provides the basic index name information within the associated Pinecone environment. Below is a sample snippet from running the template.

  

etc. for each index.

The associated data source uses the following Qarbine virtual query

list tables

Indexes with Details

This template is at “example/Pinecone/DBA/Index @index with detail”. It provides detailed information on a chosen index within the associated Pinecone environment. Below is a sample snippet from running the template.

  

etc. for each index.

The associated data source uses the following Qarbine virtual query

describe tables

Index @index details

This template is at “example/Pinecone/DBA/Index @index with detail”. It provides detailed information on a single chosen index within the associated Pinecone environment. When run the following Qarbine prompt is presented to choose an index.

  

Below is a sample snippet from running the template.

  

The associated data source uses the following Qarbine virtual query

describe table @index

Index Statistics

This template is at “example/Pinecone/DBA/Index stats”. It provides detailed statistics on all indexes within the associated Pinecone environment.

Below is a sample snippet from running the template.

  

The associated data source uses the following Qarbine virtual query

describe indexStats

Index @index Statistics

This template is at “example/Pinecone/DBA/Index @index stats”. It provides detailed statistics on a single chosen index within the associated Pinecone environment. When run the following Qarbine prompt is presented to choose an index.

  

Below is a sample snippet from running the template.

  

The associated data source uses the following Qarbine virtual query

describe indexStats @index

General Schema

This general purpose template is at “Qarbine_admin/Cached schemas for prompted data service”. It displays information on all of the cached schemas. These schemas are saved as users interact with the data tools such as the Data Source Designer, Query by Example, and Report by Example. If a particular collection is not shown in the output, simply open up one of these tools and select it from the collection drop down to create it. Then rerun the template.

Running the template prompts for a data service.

  

Below is a sample snippet from running the template.