DataStax Astra

RAG Pipeline Quickstart with DataStax Astra

Approximate time to complete: 5-10 minutes, excluding prerequisites

This quickstart will walk you through creating and scheduling a pipeline that collects data from an Amazon S3 bucket, creates vector embeddings using an OpenAI embedding model, and writes the vectors to your DataStax Astra vector database.

Before you begin

Before starting, ensure you have access to the credentials, connection parameters, and API keys as appropriate for the following:

• A Vectorize account (Create one free here ↗ )
• Amazon S3 bucket & IAM access keys (Walkthrough documentation)
• An OpenAI API Key (How to article)
• A DataStax Astra account (Create one on DataStax ↗ )

Step 1: Create a Serverless Astra Vector Database

Create and Configure Database

1. Log into the DataStax Astra Portal ↗
2. From the sidebar, click on the Databases option.
3. On the top-right side of the "Serverless" section, click on the Create Serverless Database button.

4. In the pop-up dialog, select Serverless (Vector) as the deployment type.
5. Under "Configuration":
   • Database Name: Enter your desired name (e.g., quickstart-db).
   • Provider: Select Amazon Web Services from the dropdown.
   • Region: Select us-east-2.
6. Click Create Database.

7. After clicking create, your database will begin initializing.
8. The initialization is very slow. Be patient and wait for it to complete.

Generate Token and Copy API Endpoint

1. Once the database is active, click Generate Token from the right-hand side under "Application Tokens".
2. Copy the generated token and save it securely. You will not be able to retrieve this token again after closing the dialog.

3. On the database overview page, copy the API Endpoint.
4. You will use this endpoint when connecting to your database via API.

Step 2: Create a RAG pipeline

Set Up Pipeline and Vector Database

1. Open the Vectorize application console ↗.
2. From the dashboard, click on + New RAG Pipeline under the "RAG Pipelines" section.

3. Enter a name for your pipeline. For example, you can name it quickstart-pipeline.
4. Click on + New Vector DB to create a new vector database.

5. Select DataStax Astra from the list of vector databases.

6. In the DataStax configuration screen:

• Enter a descriptive name for your DataStax integration. It can be the same as the database name in Astra but doesn't need to be.
• Enter your DataStax API Endpoint.
• Enter your DataStax Application Token.

7. In the DataStax Astra section, provide a name for your collection

• This is the name of the collection where Vectorize will write your vector data to.

Configure AI Platform

1. Click on + New AI Platform.

2. Select OpenAI from the AI platform options.

3. In the OpenAI configuration screen:

• Enter a descriptive name for your OpenAI integration.
• Enter your OpenAI API Key.

4. Leave the default values for embedding model, chunk size, and chunk overlap for the quickstart.

Add Source Connector

1. Click + Add source connector to add a source connector to your pipeline.

2. Choose Amazon S3 from the list of source connector options.

3. In the Amazon S3 configuration screen:

• Name your integration. It can be the same as your bucket name, but it doesn't have to be.
• Enter your Bucket Name exactly as it appears in AWS.
• Provide the Access Key and Secret Key for your AWS IAM user.

4. Accept the default values for file extensions and other options.
5. Click Save Configuration.

Finalize Pipeline Creation

1. After configuring the S3 integration, you should see it listed under Source Connectors.
2. Click Next: Schedule Pipeline to continue.

3. Set the schedule type and frequency for the pipeline.
4. Leave the default values for the pipeline schedule for now.
5. Click Create RAG Pipeline.

Monitor Pipeline Creation and Backfilling

1. After clicking Create RAG Pipeline, you will see the pipeline creation progress.
2. The stages include:

• Creating pipeline
• Deploying pipeline
• Starting backfilling process

3. Once the pipeline is created and deployed, it will begin the backfilling process.
4. You can monitor the pipeline status and view the progress of document ingestion and vector creation.
5. If your S3 bucket is empty, the pipeline will show 0 Documents, 0 Chunks, and 0 Vectors.

Step 3: Upload Files to Your S3 Bucket

Prepare Sample Data

1. Download the friends-scripts.zip file from the following location:

Download: Friends Scripts (ZIP file)

This archive contains text files of the TV show Friends, which we can use as a sample data set.

2. After downloading the friends-scripts.zip file, extract it to a location on your local machine.
3. On most operating systems, you can do this by right-clicking the zip file and selecting Extract All or Unzip.

Upload Files to S3

1. Log into your AWS S3 account and navigate to the Buckets section.
2. Filter to find your bucket by typing its name in the search bar.
3. Click on your bucket name to open the detailed bucket view.

4. Click on the Upload button in the top right corner of the bucket's detail view.

5. You can either drag and drop the extracted files from the friends-scripts directory into the upload area, or click on Add files to browse your local machine and select them manually.

6. After adding the files, you should see them listed under the Files and folders section of the upload screen.

7. Once you've confirmed that all the files are listed, click on the Upload button at the bottom of the screen to start the upload process.

Your files will now be uploaded to your S3 bucket.

Verify Pipeline Processing

1. Within a few seconds after the upload is complete, you should see the content of your files start to populate in the RAG pipeline.
2. The backfilling process will show progress as it reads and processes the documents from your S3 bucket.

3. Total Documents and Total Chunks will increase as the documents are embedded and processed.
4. You can track the number of documents being embedded and vectors being written.
5. After a minute or two of processing, you should see the total number of uploaded documents reflected in the pipeline's statistics.
6. If you used the Friends Scripts documents as recommended, you will see 228 documents displayed in the Total Documents field.

Step 4: Play with Your Data in the RAG Sandbox

Access the RAG Sandbox

1. From the main pipeline overview, click on the RAG Pipelines menu item to view your active pipelines.

2. Find your pipeline in the list of pipelines.
3. Click on the magnifying glass icon under the RAG Sandbox column to open the sandbox for your selected pipeline.

Query Your Data

1. In the sandbox, you can ask questions about the data you've ingested.
2. Type a question related to your dataset in the Question field. For example, "What characteristics define the relationship between Ross and Monica?" if you're working with the Friends TV show scripts.
3. Click Submit to send the question.

Review Results

1. After submitting your question, the sandbox will retrieve relevant chunks from your vector database and display them in the Retrieved Context section.
2. The response from the language model (LLM) will be displayed in the LLM Response section.

• The Retrieved Context section shows the chunks that were matched with your question.
• The LLM Response section provides the final output based on the retrieved chunks.

3. You can continue to ask different questions or refine your queries to explore your dataset further.
4. The sandbox allows for dynamic interactions with the data stored in your vector database.

That's it! You're now able to explore your data using the RAG Sandbox.