Text to SQL chatbot using Langchain's create_sql_query_chain

[Rohannain]

Body

I am trying to build a Natural Language to SQL chatbot, currently I am using Langchain's "create_sql_query_chain" to generate the query as follows:

`chain = create_sql_query_chain(llm, db)'

How do I give custom prompt to the chain to tell the schema of my table.

One way I have seen in the langchain documentation(reference below):
#https://api.python.langchain.com/en/latest/chains/langchain.chains.sql_database.query.create_sql_query_chain.html
Above they have used PromptTemplate from langchain_core.prompts, but I am not sure how to pass it to my chain any help or lead will be greatly appreciated.

Guidelines

• I have read and understood this category's guidelines before making this post.

[balajikrishna1798]

I know but i willnot tell.