Connecting to Pinecone

Authentication

To authenticate to Pinecone, and connect to your own data or to allow other users to connect to their data, you can use API Key authentication.

Using API Key Authentication

To authenticate using an API Key, you need to obtain your API Key from your Pinecone console at https://app.pinecone.io/.

You can then connect by setting the AuthScheme to APIKey and providing your API key:

AuthScheme: Set this to APIKey.
APIKey: Set this to your API key from Pinecone.

Example connection strings:

Standard API Key Configuration:

Profile=C:\profiles\Pinecone.apip;AuthScheme=APIKey;ProfileSettings='APIKey=your_api_key;APIVersion=2025-10';

Available Tables

The Pinecone API Profile provides access to comprehensive vector database management and machine learning operations across 11 specialized tables:

Indexes - Access vector database indexes with their configuration, status, and host information for data operations.
Models - Query available inference models for embedding generation and document reranking with provider details and supported parameters.
Backups - Access comprehensive backup management including backup status, size, and creation details for data protection.
Collections - Query static index snapshots with metadata and vector count for data archival and restoration.
Imports - Access bulk import jobs for loading large datasets into indexes with progress tracking and status monitoring.
Namespaces - Query index namespace information with vector counts and metadata for data organization.
RestoreJobs - Access backup restoration jobs with progress tracking and target index information.
TextSearch - Query hybrid search results combining vector similarity and keyword matching capabilities.
VectorSearch - Query hybrid search results combining vector similarity and keyword matching capabilities.
Vectors - Query vector data with similarity search, filtering, and metadata for machine learning applications.

Usage Examples

Query a specific index:

SELECT * FROM Indexes WHERE Name = 'my-index'

Query embedding models only:

SELECT * FROM Models WHERE Type = 'embed'

Query backups for specific index:

SELECT * FROM Backups WHERE SourceIndexName = 'my-index'

Query import jobs with specific index host:

SELECT * FROM Imports WHERE IndexHost = 'https://my-index-host-url'

Query index namespaces:

SELECT * FROM Namespaces WHERE IndexHost = 'https://my-index-host-url'

Query completed restore jobs:

SELECT * FROM RestoreJobs WHERE RestoreJobId = '1234'

Query vector data with similarity search:

SELECT * FROM Vectors WHERE IndexHost = 'https://my-index-host-url'

Perform text-based search with inputs:

SELECT * FROM TextSearch WHERE IndexHost = 'https://my-index-host-url' AND NameSpace = 'name_space' AND Inputs = '{\"text\": \"machine learning\"}'

Perform vector search with inputs:

SELECT * FROM VectorSearch WHERE IndexHost = 'https://my-index-host-url' AND Id = '12345'

Connection Properties

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider.

Property	Description
APIKey	Your Pinecone API key for authentication.
APIVersion	The version of the Pinecone API to use for requests.
AuthScheme	The scheme used for authentication. Accepted entries are APIKey or None. Allowed values are: BASIC, NONE, NTLM, OAUTH, APIKEY, OAUTH_CLIENT