Open In Colab

Rockset Vector Store#

As a real-time search and analytics database, Rockset uses indexing to deliver scalable and performant personalization, product search, semantic search, chatbot applications, and more. Since Rockset is purpose-built for real-time, you can build these responsive applications on constantly updating, streaming data. By integrating Rockset with LlamaIndex, you can easily use LLMs on your own real-time data for production-ready vector search applications.

We’ll walk through a demonstration of how to use Rockset as a vector store in LlamaIndex.


In this example, we’ll use OpenAI’s text-embedding-ada-002 model to generate embeddings and Rockset as vector store to store embeddings. We’ll ingest text from a file and ask questions about the content.

Setting Up Your Environment#

  1. Create a collection from the Rockset console with the Write API as your source. Name your collection llamaindex_demo. Configure the following ingest transformation with VECTOR_ENFORCE to define your embeddings field and take advantage of performance and storage optimizations:

    _input.* EXCEPT(_meta), 
    ) as embedding
FROM _input
  1. Create an API key from the Rockset console and set the ROCKSET_API_KEY environment variable. Find your API server here and set the ROCKSET_API_SERVER environment variable. Set the OPENAI_API_KEY environment variable.

  2. Install the dependencies.

pip3 install llama_index rockset 
  1. LlamaIndex allows you to ingest data from a variety of sources. For this example, we’ll read from a text file named constitution.txt, which is a transcript of the American Constitution, found here.

Data ingestion#

Use LlamaIndex’s SimpleDirectoryReader class to convert the text file to a list of Document objects.

%pip install llama-index-llms-openai
%pip install llama-index-vector-stores-rocksetdb
from llama_index.core import SimpleDirectoryReader

docs = SimpleDirectoryReader(
    input_files=["{path to}/consitution.txt"]

Instantiate the LLM and service context.

from llama_index.core import Settings
from llama_index.llms.openai import OpenAI

Settings.llm = OpenAI(temperature=0.8, model="gpt-3.5-turbo")

Instantiate the vector store and storage context.

from llama_index.core import StorageContext
from llama_index.vector_stores.rocksetdb import RocksetVectorStore

vector_store = RocksetVectorStore(collection="llamaindex_demo")
storage_context = StorageContext.from_defaults(vector_store=vector_store)

Add documents to the llamaindex_demo collection and create an index.

from llama_index.core import VectorStoreIndex

index = VectorStoreIndex.from_documents(


Ask a question about your document and generate a response.

response = index.as_query_engine().query("What is the duty of the president?")


Run the program.

$ python3
The duty of the president is to faithfully execute the Office of President of the United States, preserve, protect and defend the Constitution of the United States, serve as the Commander in Chief of the Army and Navy, grant reprieves and pardons for offenses against the United States (except in cases of impeachment), make treaties and appoint ambassadors and other public ministers, take care that the laws be faithfully executed, and commission all the officers of the United States.

Metadata Filtering#

Metadata filtering allows you to retrieve relevant documents that match specific filters.

  1. Add nodes to your vector store and create an index.

from llama_index.vector_stores.rocksetdb import RocksetVectorStore
from llama_index.core import VectorStoreIndex, StorageContext
from llama_index.core.vector_stores.types import NodeWithEmbedding
from llama_index.core.schema import TextNode

nodes = [
            text="Apples are blue",
            metadata={"type": "fruit"},
index = VectorStoreIndex(
  1. Define metadata filters.

from llama_index.core.vector_stores import ExactMatchFilter, MetadataFilters

filters = MetadataFilters(
    filters=[ExactMatchFilter(key="type", value="fruit")]
  1. Retrieve relevant documents that satisfy the filters.

retriever = index.as_retriever(filters=filters)
retriever.retrieve("What colors are apples?")

Creating an Index from an Existing Collection#

You can create indices with data from existing collections.

from llama_index.core import VectorStoreIndex
from llama_index.vector_stores.rocksetdb import RocksetVectorStore

vector_store = RocksetVectorStore(collection="llamaindex_demo")

index = VectorStoreIndex.from_vector_store(vector_store)

Creating an Index from a New Collection#

You can also create a new Rockset collection to use as a vector store.

from llama_index.vector_stores.rocksetdb import RocksetVectorStore

vector_store = RocksetVectorStore.with_new_collection(
    collection="llamaindex_demo",  # name of new collection
    dimensions=1536,  # specifies length of vectors in ingest tranformation (optional)
    # other RocksetVectorStore args

index = VectorStoreIndex(


  • collection: Name of the collection to query (required).

  • workspace: Name of the workspace containing the collection. Defaults to "commons".

  • api_key: The API key to use to authenticate Rockset requests. Ignored if client is passed in. Defaults to the ROCKSET_API_KEY environment variable.

RocksetVectorStore(api_key="<my key>")
  • api_server: The API server to use for Rockset requests. Ignored if client is passed in. Defaults to the ROCKSET_API_KEY environment variable or "" if the ROCKSET_API_SERVER is not set.

from rockset import Regions
  • client: Rockset client object to use to execute Rockset requests. If not specified, a client object is internally constructed with the api_key parameter (or ROCKSET_API_SERVER environment variable) and the api_server parameter (or ROCKSET_API_SERVER environment variable).

from rockset import RocksetClient
RocksetVectorStore(client=RocksetClient(api_key="<my key>"))
  • embedding_col: The name of the database field containing embeddings. Defaults to "embedding".

  • metadata_col: The name of the database field containing node data. Defaults to "metadata".

  • distance_func: The metric to measure vector relationship. Defaults to cosine similarity.