Generating Advanced SQL with LangChain & Redis Knowledge Bases

In this tutorial, we'll explore how to build knowledge bases for advanced SQL generation using LangChain. We'll leverage LangChain chains to extract insights from BigQuery by generating and executing SQL queries. Redis will store the SQL query examples needed for few-shot-prompting.

Code used in the video:

https://www.rabbitmetrics.com/building-llm-knowledge-base-for-advanced-sql-chains

LangChain SQL Chain documentation

https://python.langchain.com/docs/use_cases/sql/quickstart/

This tutorial contains a video demo of generating a service account key to connect to BigQuery.

https://www.rabbitmetrics.com/operationalizing-shopify-data-for-ai-bigquery-tutorial/

advanced bigquery build code documentation examples explore extract few-shot insights knowledge langchain prompting queries query redis sql sql generation sql queries sql query store tutorial video will