# AWS S3 + Spice AI Tutorial

An implementation of _[Architecting high-performance AI-driven data applications with Spice AI and AWS](https://aws.amazon.com/blogs/storage/architecting-high-performance-ai-driven-data-applications-with-spice-ai-and-aws/)_ running on [Spice Cloud](/content/site-root.html), instead of an EC2 instance.

## SQL Queries

```
SELECT title, tags, type FROM questions WHERE body ILIKE '%Java%' LIMIT 5;
```

```
SELECT title, tags, type FROM questions WHERE body ILIKE '%Java%' LIMIT 5;
```

```
SELECT title, creation_date, score FROM vector_search (questions,'Java issues',5) ORDER BY score DESC;
```

```
SELECT title, creation_date, score FROM vector_search (questions,'Java issues',5) ORDER BY score DESC;
```

```
SELECT title, creation_date, score FROM vector_search (questions,'JVM issues',5) ORDER BY score DESC;
```

```
SELECT title, creation_date, score FROM vector_search (questions,'JVM issues',5) ORDER BY score DESC;
```

```
-- Expected zero results.

SELECT title, tags, type FROM questions WHERE body ILIKE '%JVM Issues%' LIMIT 5;
```

```
-- Expected zero results.

SELECT title, tags, type FROM questions WHERE body ILIKE '%JVM Issues%' LIMIT 5;
```

```
select question_id, fused_score, title, tags

from rrf(

text_search(questions, 'Java'),

vector_search(questions, 'Java issues')) order by fused_score desc
limit 5
```

```
select question_id, fused_score, title, tags

from rrf(

text_search(questions, 'Java'),

vector_search(questions, 'Java issues')) order by fused_score desc
limit 5
```

Description

AWS Storage Blog: Architecting high performance AI-driven data applications with Spice AI and AWS

Contributors Jeadie](https://github.com/Jeadie)  
spiceai/aws-s3-tutorial \| Spice Cloud Platform