PineconeLookup

The PineconeLookup gem identifies content that is similar to a provided vector embedding. The gem calls the Pinecone API and returns a set of IDs with highest similarity to the provided embedding.

Parameters: Configure the parameters needed to call the Pinecone API.
Input: This gem requires an embedding as input. The embedding is provided by a foundational model like OpenAI.
Output: This gem outputs an array of IDs with corresponding similarity scores.

Now let’s understand the gem parameters, input, and output in detail.

Gem Parameters

Verify the (1) input columns contain a column with the embeddings. The structure of this column’s entries must be compatible with the structure of the Pinecone index.

Credentials

Configure the Pinecone API credentials here. Storing the Pinecone API token as a (2) Databricks Secret is highly recommended. For instructions click here. Be sure to use the (3) Fabric connection to the Databricks workspace which contains the Databricks scope and secrets configured in this gem. Hardcoding the Pinecone credential is not recommended. Selecting this option could send credentials to be stored hardcoded in Git; reach out to understand the integrations with other secret managers.

Properties

Pinecone DB uses indexing to map the vectors to a data structure that will enable faster searching. The PineconeLookup gem searches through a Pinecone index to identify embeddings with similarity to the input embedding. Enter the Pinecone (4) Index name which you’d like to use for looking up embeddings. Select one of the gem’s input columns with vector embeddings as the (5) Vector column to send to Pinecone’s API. The column must be compatible with the Pinecone Index. To change the column’s datatype and properties, configure the gem(s) preceding the PineconeLookup gem. Pinecone’s API can return multiple results. Depending on the use case, select the desired (6) Number of results sorted by similarity score. The result with highest similarity to the user’s text question will be listed first.

Input

PineconeLookup requires a model_embedding column as input. Use one of Prophecy’s Machine Learning gems to provide the model_embedding. For example, the OpenAI gem can precede the PineconeLookup gem in the pipeline. The OpenAI gem, configured to Compute a text embedding, will output an openai_embedding column. This is a suitable input for the PineconeLookup gem.

Column	Description	Required
model_embedding	array(float) - The format of this embedding is important. It must be an array of floating point numbers that matches the requirements of the Pinecone index. For example, we used a Pinecone index with `1536` dimensions, `Cosine` metric, and an `s1` pod type. So each record in the model_embedding column must be an array of `1536` floating point numbers, such as `[-0.0018493991, -0.0059955865, ... -0.02498541]`.	True

Output

The output dataset contains the pinecone_matches and pinecone_error columns. For each input content entry, this gem adds an array to the pinecone_matches column. The output array will have Number of Results entries.

Column	Description
pinecone_matches	array - an array of several content IDs and their scores. Example: `[{"id":"web-223","score":0.8437653},{"id":"web-224","score":0.8403446}, ...{"id":"web-237","score":0.82916564}]`
pinecone_error	string - this column is provided to show any error message returned from Pinecone’s API; helpful for troubleshooting errors related to the PineconeLookup gem.

Prophecy converts the visual design into Spark code available on the Prophecy user’s Git repository. Find the Spark code for the PineconeLookup gem below.

def vector_lookup(Spark: SparkSession, in0: DataFrame) -> DataFrame:
 from pySpark.sql.functions import expr, array, struct
 from Spark_ai.dbs.pinecone import PineconeDB, IdVector
 from pySpark.dbutils import DBUtils
 PineconeDB(DBUtils(Spark).secrets.get(scope = "< my_scope >", key = "< my_key >"), "us-east-1-aws")\
 .register_udfs(Spark)

 return in0\
 .withColumn("_vector", col("<model>_embedding"))\
 .withColumn("_response", expr(f"pinecone_query(\<index name>\", _vector, {3})"))\
 .withColumn("pinecone_matches", col("_response.matches"))\
 .withColumn("pinecone_error", col("_response.error"))\
 .drop("_vector", "_response")

[Not yet supported]

FAQ

Troubleshooting

To troubleshoot the gem preceding PineconeLookup, open the data preview output from the previous gem. For example if the embedding structure is incorrect then try adjusting the previous gem, run, and view that gem’s output data preview.

Creating a Pinecone Index

If you don’t have one yet, create a Pinecone index. Click here for pointers on choosing an index type and size. How to populate the index? For example, this guide shows how to ingest and vectorize web content data to store in a Pinecone Database index.

Overview

Sources and targets

Data processing

Advanced

Gem Parameters

Credentials

Properties

Input

Output

FAQ

Troubleshooting

Creating a Pinecone Index

​Gem Parameters

​Credentials

​Properties

​Input

​Output

​FAQ

​Troubleshooting

​Creating a Pinecone Index

Gem Parameters

Credentials

Properties

Input

Output

FAQ

Troubleshooting

Creating a Pinecone Index