Skip to content

Chatbot: Add notebook for DIS2025 workshop#912

Merged
amotl merged 1 commit intomainfrom
dis2025
Apr 24, 2025
Merged

Chatbot: Add notebook for DIS2025 workshop#912
amotl merged 1 commit intomainfrom
dis2025

Conversation

@wierdvanderhaar
Copy link
Contributor

Summary of the changes / Why this is an improvement

This is the notebook we want to use for DIS2025. In order for participants to be able to use this, it needs to be on a public repo.

Checklist

  • Link to issue this PR refers to (if applicable): Fixes #???

@coderabbitai
Copy link

coderabbitai bot commented Apr 24, 2025

Walkthrough

A new README file was introduced for a workshop titled "Timeseries QA with LLMs: Combine Telemetry Data and Manuals for Smarter Diagnostics." This documentation details a hands-on lab where participants build an AI assistant that utilizes timeseries telemetry data from CrateDB and structured machine manuals, leveraging OpenAI's language models. The README covers the workshop's objectives, required skills, and provides resources for running the associated notebook in Google Colab or viewing it on GitHub.

Changes

File(s) Change Summary
topic/chatbot/table-augmented-generation/workshop/README.md Added a comprehensive README describing a workshop on building an AI assistant using LLMs, CrateDB, and manuals.

Poem

In a warren of data, the rabbits convene,
With tables and manuals, their minds sharp and keen.
CrateDB hums, telemetry flows,
LLMs reason where the knowledge grows.
With prompts and with plots, the answers take flight—
Hopping through queries, from morning till night!
🐇📊✨


📜 Recent review details

Configuration used: CodeRabbit UI
Review profile: CHILL
Plan: Pro

📥 Commits

Reviewing files that changed from the base of the PR and between b924551 and 1f307bd.

📒 Files selected for processing (1)
  • topic/chatbot/table-augmented-generation/workshop/README.md (1 hunks)
✅ Files skipped from review due to trivial changes (1)
  • topic/chatbot/table-augmented-generation/workshop/README.md

🪧 Tips

Chat

There are 3 ways to chat with CodeRabbit:

‼️ IMPORTANT
Auto-reply has been disabled for this repository in the CodeRabbit settings. The CodeRabbit bot will not respond to your replies unless it is explicitly tagged.

  • Files and specific lines of code (under the "Files changed" tab): Tag @coderabbitai in a new review comment at the desired location with your query. Examples:
    • @coderabbitai generate unit testing code for this file.
    • @coderabbitai modularize this function.
  • PR comments: Tag @coderabbitai in a new PR comment to ask questions about the PR branch. For the best results, please provide a very specific query, as very limited context is provided in this mode. Examples:
    • @coderabbitai gather interesting stats about this repository and render them as a table. Additionally, render a pie chart showing the language distribution in the codebase.
    • @coderabbitai read src/utils.ts and generate unit testing code.
    • @coderabbitai read the files in the src/scheduler package and generate a class diagram using mermaid and a README in the markdown format.
    • @coderabbitai help me debug CodeRabbit configuration file.

Note: Be mindful of the bot's finite context window. It's strongly recommended to break down tasks such as reading entire modules into smaller chunks. For a focused discussion, use review comments to chat about specific files and their changes, instead of using the PR comments.

CodeRabbit Commands (Invoked using PR comments)

  • @coderabbitai pause to pause the reviews on a PR.
  • @coderabbitai resume to resume the paused reviews.
  • @coderabbitai review to trigger an incremental review. This is useful when automatic reviews are disabled for the repository.
  • @coderabbitai full review to do a full review from scratch and review all the files again.
  • @coderabbitai summary to regenerate the summary of the PR.
  • @coderabbitai generate docstrings to generate docstrings for this PR.
  • @coderabbitai generate sequence diagram to generate a sequence diagram of the changes in this PR.
  • @coderabbitai resolve resolve all the CodeRabbit review comments.
  • @coderabbitai configuration to show the current CodeRabbit configuration for the repository.
  • @coderabbitai help to get help.

Other keywords and placeholders

  • Add @coderabbitai ignore anywhere in the PR description to prevent this PR from being reviewed.
  • Add @coderabbitai summary to generate the high-level summary at a specific location in the PR description.
  • Add @coderabbitai anywhere in the PR title to generate the title automatically.

CodeRabbit Configuration File (.coderabbit.yaml)

  • You can programmatically configure CodeRabbit by adding a .coderabbit.yaml file to the root of your repository.
  • Please see the configuration documentation for more information.
  • If your editor has YAML language server enabled, you can add the path at the top of this file to enable auto-completion and validation: # yaml-language-server: $schema=https://coderabbit.ai/integrations/schema.v2.json

Documentation and Community

  • Visit our Documentation for detailed information on how to use CodeRabbit.
  • Join our Discord Community to get help, request features, and share feedback.
  • Follow us on X/Twitter for updates and announcements.

Copy link

@coderabbitai coderabbitai bot left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Actionable comments posted: 2

📜 Review details

Configuration used: CodeRabbit UI
Review profile: CHILL
Plan: Pro

📥 Commits

Reviewing files that changed from the base of the PR and between 2c487c2 and 6299a67.

📒 Files selected for processing (1)
  • topic/chatbot/dis2025/workshop/README.md (1 hunks)
🧰 Additional context used
🪛 markdownlint-cli2 (0.17.2)
topic/chatbot/dis2025/workshop/README.md

1-1: Trailing punctuation in heading
Punctuation: ':'

(MD026, no-trailing-punctuation)


2-2: Emphasis used instead of a heading
null

(MD036, no-emphasis-as-heading)

Copy link

@coderabbitai coderabbitai bot left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Actionable comments posted: 1

♻️ Duplicate comments (1)
topic/chatbot/dis2025/workshop/README.md (1)

1-2: Convert title to a proper Markdown heading
This section uses a generic placeholder heading with trailing punctuation and emphasis for the subtitle, violating MD026 (no trailing punctuation in headings) and MD036 (don’t use emphasis instead of headings). Consolidate into a single H1 without trailing punctuation and remove the emphasis.
Apply this diff:

-# Workshop Title:
-**"Timeseries QA with LLMs: Combine Telemetry Data and Manuals for Smarter Diagnostics"**
+# Timeseries QA with LLMs: Combine Telemetry Data and Manuals for Smarter Diagnostics
🧰 Tools
🪛 markdownlint-cli2 (0.17.2)

1-1: Trailing punctuation in heading
Punctuation: ':'

(MD026, no-trailing-punctuation)


2-2: Emphasis used instead of a heading
null

(MD036, no-emphasis-as-heading)

📜 Review details

Configuration used: CodeRabbit UI
Review profile: CHILL
Plan: Pro

📥 Commits

Reviewing files that changed from the base of the PR and between 6299a67 and c87695f.

📒 Files selected for processing (1)
  • topic/chatbot/dis2025/workshop/README.md (1 hunks)
🧰 Additional context used
🪛 markdownlint-cli2 (0.17.2)
topic/chatbot/dis2025/workshop/README.md

1-1: Trailing punctuation in heading
Punctuation: ':'

(MD026, no-trailing-punctuation)


2-2: Emphasis used instead of a heading
null

(MD036, no-emphasis-as-heading)

@wierdvanderhaar wierdvanderhaar self-assigned this Apr 24, 2025
Copy link
Contributor Author

@wierdvanderhaar wierdvanderhaar left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Great

@wierdvanderhaar wierdvanderhaar requested a review from amotl April 24, 2025 12:18
@wierdvanderhaar
Copy link
Contributor Author

@amotl Could you please verify and merge?

Copy link
Member

@amotl amotl left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Thanks. I've just added two nitpick comments.
Enjoy and good luck with the workshop.

Comment on lines +156 to +157
"# Install dependencies\n",
"!pip install pandas matplotlib openai sqlalchemy python-dotenv ipython-sql\n",
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Excellent choice selecting ipython-sql. However, I can't spot any %%sql blocks, are you actually using it? On another occasion, you may want to try JupySQL?

-- See examples with CrateDB here: https://github.com/crate/cratedb-examples/tree/main/notebook/jupyter

Copy link
Member

@amotl amotl Apr 24, 2025

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

About the venerable and nitpicky topic of »naming things«, I would choose a more concise name for this file, not necessarily using a mixture of uppercase vs. lowercase letters, nor underscores. I also think dis2025/workshop/*Workshop bears some redundancy or unnecessary nesting.

As this piece is also apparently about the TAG topic, why not just slot it into the existing folder chatbot/table-augmented-generation, for example using a name like telemetry-timeseries-qa-assistant.ipynb or telemetry-diagnostics-assistant.ipynb, which touches a few key topics about what's inside?

If you are in a hurry to get this merged, please do, but please don't print the URL on paper, because it will change later on a subsequent iteration, in one way or another.

@amotl amotl changed the title Workshop-Notebook-for-DIS2025 Chatbot: Add notebook for DIS2025 workshop Apr 24, 2025
Copy link

@coderabbitai coderabbitai bot left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Actionable comments posted: 0

🧹 Nitpick comments (3)
topic/chatbot/table-augmented-generation/workshop/README.md (3)

1-2: Simplify and normalize the top‐level heading
The current pattern (“# Workshop Title:” + bold text) triggers markdownlint rules (MD026, MD036) and is more verbose than necessary. Combine into a single H1 without trailing punctuation.

- # Workshop Title:
- **"Timeseries QA with LLMs: Combine Telemetry Data and Manuals for Smarter Diagnostics"**
+ # Timeseries QA with LLMs: Combine Telemetry Data and Manuals for Smarter Diagnostics
🧰 Tools
🪛 markdownlint-cli2 (0.17.2)

1-1: Trailing punctuation in heading
Punctuation: ':'

(MD026, no-trailing-punctuation)


2-2: Emphasis used instead of a heading
null

(MD036, no-emphasis-as-heading)


6-16: Unify “timeseries” hyphenation
You use both “timeseries” (one word) and “time-series” elsewhere; pick one style for consistency (e.g., “time-series” as one or two words). Also consider ending list bullets without a period or consistently apply punctuation across all items.

- In this hands-on workshop, participants will build an AI-powered assistant that can answer questions using a combination of **timeseries telemetry data** and **structured machine manuals**. 
+ In this hands-on workshop, participants will build an AI-powered assistant that can answer questions using a combination of **time-series telemetry data** and **structured machine manuals**

57-68: Verify external links point to the correct branch
The Colab and GitHub URLs point to main. Ensure that once merged, the notebook exists at those paths on main; otherwise consider using a dynamic reference like blob/${{ github.ref }} or update post-merge.

📜 Review details

Configuration used: CodeRabbit UI
Review profile: CHILL
Plan: Pro

📥 Commits

Reviewing files that changed from the base of the PR and between 126c6ca and b924551.

📒 Files selected for processing (1)
  • topic/chatbot/table-augmented-generation/workshop/README.md (1 hunks)
🧰 Additional context used
🪛 markdownlint-cli2 (0.17.2)
topic/chatbot/table-augmented-generation/workshop/README.md

1-1: Trailing punctuation in heading
Punctuation: ':'

(MD026, no-trailing-punctuation)


2-2: Emphasis used instead of a heading
null

(MD036, no-emphasis-as-heading)

🔇 Additional comments (5)
topic/chatbot/table-augmented-generation/workshop/README.md (5)

17-20: Approved: Summary paragraph structure
The paragraph cleanly describes TAG and prompt‐design focus. No changes needed.


23-31: Approved: Key Takeaways section
Bullet points are clear and consistent; good high‐level overview.


34-40: Approved: Requirements from Attendees
The prerequisites are well specified. Consider adding a note about network access if needed in your environment, but that’s optional.


43-47: Approved: Maturity Level designation
The maturity level is clear and appropriate for the target audience.


50-54: Approved: Workshop Type declaration
Hands‐On Lab classification is clear and concise.

@amotl amotl merged commit 2ad5786 into main Apr 24, 2025
1 check passed
@amotl amotl deleted the dis2025 branch April 24, 2025 23:40
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants