Hello krish sir i have done all the code and execute that but the response is not working for me. I got correct Sql query but on streamlit it did not display anything can you help me
Hi Krish! Lately I've been watching your videos on GenAi and I'm so glad that someone is putting up content on actually using these openly available models for real world use cases! However I would like to see more and more videos on domain specific fine tuning! Ive practically seen domain specifically fine tuned models with around 200M, 300M parameters generating results far better than generic models like Gemini, GPT3.5 turbo etc which are huge! I'm looking forward to a full length video from you on actually fine tuning smaller LLMs like T5 (base/small openly available) for domain specific tasks like text2sql and benchmark those scores with the results produced in this video!! Lighter models and more accurate results are always exciting to watch!
Nice one, sir. I am from Nigeria and got convinced in one of your videos to join Pwskills FSDSP batch. Please, I am still waiting for you. I need you in this industry. Thanks for all you do
@pdevender If I have an opportunity to work as a data analyst or a junior data scientist, I don't see anything that will deprive me of coming down to India.
Thank you Krish, this video was great! Now I have a question, I am an app developer and I use database services such as Firefox or Parse Sever, do you have any idea how to approach the same with those databases?
thank you for the useful informations you provide in all of your videos, i have a question regarding this video , can we add a performance metric to make sur the query is correct
I have already mysql database with 20 schemas and each schema has multiple tables. In this case how to fine tune my mysql database with llm? Can you please explain. Thank you
I'm a programmer and I love using all kinds of tools, especially those related to artificial intelligence. If you have a project, we can work together to make it a reality
Hi Krish, thanks for the amazing video. Can you please help to create a similar solution using llama2 models . How can we fine tune the open source llm model to work like text to sql solution
damn this is crazy, what a great video. How would one go about scaling this application for a larger dataset and maybe for different kinds of data like geospatial etc?
Hi Krish, thanks for the amazing video. Can you please help to create a similar solution using open source llm models like codellama. How can we fine tune the open source llm model to work like text to sql solution
Great Video Dear Krish Naik Sir :") Can I use this approach for larger projects ??? Like i have HRMS project which has so many tables and data , can you please answer to my question wether this approach is suitable or I have to use different approach ????
Hey Krish, amazing work. I have been trying to run this on an AWS Linux instance and it throws me (argument of type 'Part' is not iterable) error. It works fine on Windows local PC. Can you help me fix this issue please.
Hi krish, we have this already but the query is taking 1 - 2 mins, i am an AI product manager, can you share techniques to reduce that time to 5-10 seconds ?
Sir how can we add another table in db and join them and on the basis of that joined table how will our model respond. Like in the given table there are name, class, subject and marks. In second table there is name and their roll number. So how can we join these two tables and make our model train over it please help
Sir is there anything like we can upload pdf then the text in pdf should translate in another lang and the translated text should replace the text in pdf with same format of pdf and generate translated pdf if possible then sir please let me know.
This is not reliable.. llm should be used to correct the SQL code if at all an error exists.. But this questionnaire is unreliable for complex data models..
@@mithunshet5922 Honestly, what he should do is simply try his .db and see if it retrieve the right results with his queries. its not hard as long as the code is ran from his on-prem/local environment, the results should output a plausible answer. The hardest part should be to update the Prompt to the right kind of questions the model is going to be enquiry.
Krish Sir I am from sales background but wanted to switch started learning but not sure how to proceed and land a job in the end. Please make a session for which we can increase our chance to get interview calls. Is there any mock preparation or Hr connect available in ineuron
Could not create `Blob`, expected `Blob`, `dict` or an `Image` type(`PIL.Image.Image` or `IPython.display.Image`). Got a: Value: ['You are an expert in converting English questions to SQL query!The SQL database has the name STUDENTS and has the following columns NAME, CLASS, SECTION and MARKS
For example, Example 1 How many entries of records are present?, the SQL command will be something like this SELECT COUNT(*) FROM STUDENTS; Example 2 - Tell me all the students studying in Data Science class?,the SQL command will be something like this SELECT * FROM STUDENTS where CLASS="data science"; also the sql code should not have \'\'\' or any quotes symbol in beginning or end and sql word in the output. '] getting this error someone help
Hi do you know, if Let's say we connect Azure OpenAI to a SQL DB (Oracle) and want to retrieve data using AI Azure Platform, will SQL DB have an impact performance if so do you know how much can be impacted? Let say that we use SqL dB with many integrations
Likes Target 1000 :)
Likes target only 1000 that’s too small value mainly for your valuable content your Videos should get minimum 5k in a day
Krish Bhai 729!
Hello krish sir i have done all the code and execute that but the response is not working for me. I got correct Sql query but on streamlit it did not display anything can you help me
Ho gaye bhaiya 👍👍👍
Hi Krish! Lately I've been watching your videos on GenAi and I'm so glad that someone is putting up content on actually using these openly available models for real world use cases! However I would like to see more and more videos on domain specific fine tuning! Ive practically seen domain specifically fine tuned models with around 200M, 300M parameters generating results far better than generic models like Gemini, GPT3.5 turbo etc which are huge! I'm looking forward to a full length video from you on actually fine tuning smaller LLMs like T5 (base/small openly available) for domain specific tasks like text2sql and benchmark those scores with the results produced in this video!! Lighter models and more accurate results are always exciting to watch!
You are great Sir learning stats and Eda from you. Very smooth explanation. 🎉🎉
Thankyou sir🙏,from past 2 month I following your video.
Nice one, sir. I am from Nigeria and got convinced in one of your videos to join Pwskills FSDSP batch. Please, I am still waiting for you. I need you in this industry.
Thanks for all you do
why dont you come to india
@pdevender If I have an opportunity to work as a data analyst or a junior data scientist, I don't see anything that will deprive me of coming down to India.
Wonderful video Krish. Beautifully explained. Keep posting.
Krish mast banaya hai... I will try this in my ofc sample data
Have you tried.. is it working with organization Tables. ??
@Krish you are a legend.❤
can you please put up a video on fine tuning this with a specific context? lets say i want to delevop this for a cilent. How would we go about then?
Great video boss❤
Thank you Krish, this video was great! Now I have a question, I am an app developer and I use database services such as Firefox or Parse Sever, do you have any idea how to approach the same with those databases?
Interestingly all the data science students got better marks than Devops. Possibly a Krish-AI Bias :)
This video is really helpful for me ,sir I have one doubt can we use ready made data
You are wonderful sir
Just wow 🌟
thank you for the useful informations you provide in all of your videos, i have a question regarding this video , can we add a performance metric to make sur the query is correct
Made my life simple
Crisp and to the point...❤
I have already mysql database with 20 schemas and each schema has multiple tables. In this case how to fine tune my mysql database with llm? Can you please explain. Thank you
One idea is to Give the customize data in form of a er diagram and relational structure schema in form of pdf or something and fine tune the model
hey what did you do?
@@Munnu-hs6rk Absolute Bullshit
Ultimate...thanks krish
I'm a programmer and I love using all kinds of tools, especially those related to artificial intelligence. If you have a project, we can work together to make it a reality
Thank you, Krish.
Hi krish Sir , i wanted to show the Query on the front end so basically Search(Question) -> Sql Query should be the answer
Thank you for your lecture.
Krishna, great content! Can we use this for generating pictorial output representation.
Hi Krish, thanks for the amazing video.
Can you please help to create a similar solution using llama2 models . How can we fine tune the open source llm model to work like text to sql solution
Best video.
I think the information posted in the "JOIN" button is quite old. Please re-explain what are the benefits we get in different subscription option.
all newly fresh videos on ML and DL are getting uplaoded. Check the below playlist
ruclips.net/video/ip4WxEZwEPc/видео.html
damn this is crazy, what a great video. How would one go about scaling this application for a larger dataset and maybe for different kinds of data like geospatial etc?
Hi Krish, thanks for the amazing video.
Can you please help to create a similar solution using open source llm models like codellama. How can we fine tune the open source llm model to work like text to sql solution
Great Video Dear Krish Naik Sir :")
Can I use this approach for larger projects ???
Like i have HRMS project which has so many tables and data ,
can you please answer to my question wether this approach is suitable or I have to use different approach ????
Have tested with one table and it works all good. But struggling with multiple tables
Can you provide a sample with multiple table in one database ?
Great😊
would be nice to see this working with llama and not gemini only. Please show us how to use llama
What is the best way to have an offline LLM interacting with sqlite db?
Krish the king bhai
Hey Krish, amazing work. I have been trying to run this on an AWS Linux instance and it throws me (argument of type 'Part' is not iterable) error. It works fine on Windows local PC. Can you help me fix this issue please.
Excellent video!
Sir could you post a video on your time management.
Hi krish, we have this already but the query is taking 1 - 2 mins, i am an AI product manager, can you share techniques to reduce that time to 5-10 seconds ?
Hello Krish, how do I fix a 'DefaultCredentialsError'? I can't seem to get the app answering questions despite inputing my Api key. Thanks
sir ap aik application bna de jesse apne q/a based bnai thi streamlit or gemini api key k sath. vhi cheez fastapi k through bnani ha
Is there a way to use Data Dictionary to train LLM model to generate SQL queries later on?
Sir how can we add another table in db and join them and on the basis of that joined table how will our model respond. Like in the given table there are name, class, subject and marks. In second table there is name and their roll number. So how can we join these two tables and make our model train over it please help
In the same way. It doesn't matter how many tables you have in the database. Just adjust the prompt a little.
Sir is there anything like we can upload pdf then the text in pdf should translate in another lang and the translated text should replace the text in pdf with same format of pdf and generate translated pdf if possible then sir please let me know.
Nice idea bro...😊
AttributeError: module 'google.generativeai' has no attribute 'GenerativeModel' how to resolve this?
How can we get only query out of this chain ?
How can we scale it for real world data with 100s of tables/columns? Any refernces?
even i had the same query ? can we have multiple tables ? as in this video he has used a single table
try rag
Thank you , was very informative . How should I go about implementing if the data model is complex with 10 tables and has star schema ?
This is not reliable.. llm should be used to correct the SQL code if at all an error exists.. But this questionnaire is unreliable for complex data models..
@@mithunshet5922 Honestly, what he should do is simply try his .db and see if it retrieve the right results with his queries. its not hard as long as the code is ran from his on-prem/local environment, the results should output a plausible answer. The hardest part should be to update the Prompt to the right kind of questions the model is going to be enquiry.
Have you found a way? Multiple agent?
If I want to read and ask questions from multiple csv files at a time, then how can I implement?
great,,,
Can this connect to Oracle Database?
im interested in this too.
Hi, do you have videos for chatbot? thanks
I tried it with one database table with timeseries data in postgresql, It is giving entire records no matter what question I ask?
Did you resolved it
Can you please train more data to the SQL server
I have a doubt. Will this send my Database contents/schema along with API request to LLMs for queries I ask ?
Do I have to change thw peopt language? I mean, may I wrote it in Portuguese, for example?
Wow..
Can I have a llm for Tex to BDD test cases for java applications
Can it also run on any warehouse SAP BW, Synapse etc
is it possible that we modify it and then the user can enter his schema on which he would like to run his queries
sir my API Key is not generating
Would it be possible to have it sql to txt instead ?
in out put i am getting paranthesis and single quotes so how to remove it
I had made one using Hugging face .
could you please share your hugging face space link
could you please share that link
which model u have used in Hugging face for text to sql ..?
Google AI Studio not available here in canada
Any other way out ??
@@anirudhgrack7560leave canada
Is it possible to retrieve table name from where ever it in any schema with respect to column name
actually last query was wrong, it would return all marks less except from largest. The question was to find student with second mark.
Krish Sir I am from sales background but wanted to switch started learning but not sure how to proceed and land a job in the end.
Please make a session for which we can increase our chance to get interview calls.
Is there any mock preparation or Hr connect available in ineuron
I am also from Marketing background I moved to Data science in 2022 if you understand the basics and statistics ML,DL,CV and NLP is nothing
@@raghavendranarayana1009 which domain have you chosen for your career
@@raghavendranarayana1009 right now are you in ML domain. How did learn this things. Did interviewer concerned about your background
@@pdevender interviewer asked on why did you transit from marketing domain to Data science domain
@@raghavendranarayana1009 ok what was your answer then ?
Sir NLP with deep learning one shot please
plz make video on how to deploy it
Sir when enter Streamlit run app.py mine display comes empty. Why? I am very confuse.
Hello sir please tell me? Why this happens
can you amke a video how to use that in angular?
Hi krish , I tried to push it to github and deploy the app on streamlit community, the data base stopp working, how can i fix that
Did you complete this project?
Could not create `Blob`, expected `Blob`, `dict` or an `Image` type(`PIL.Image.Image` or `IPython.display.Image`). Got a: Value: ['You are an expert in converting English questions to SQL query!The SQL database has the name STUDENTS and has the following columns NAME, CLASS, SECTION and MARKS
For example,
Example 1 How many entries of records are present?, the SQL command will be something like this SELECT COUNT(*) FROM STUDENTS;
Example 2 - Tell me all the students studying in Data Science class?,the SQL command will be something like this SELECT * FROM STUDENTS where CLASS="data science";
also the sql code should not have \'\'\' or any quotes symbol in beginning or end and sql word in the output.
'] getting this error someone help
Did you resolved this one buddy?
@@programmerpro-hs8ro join all the prompts in single string using " ".join
pass a string in the method instead of list like "model.generate_content(prompt[0] + question)" this will resolve the above error
Can you pls make video like same for NoSQL db by using Mongo
@krishnaik can we use my SQL instead of SQL lite ?
Yes you can
Sir new video to store data into vector database free tier….
how we can use Gemini in EU? Anyone got the Idea?
Second ❤
First❤
Hi do you know, if Let's say we connect Azure OpenAI to a SQL DB (Oracle) and want to retrieve data using AI Azure Platform, will SQL DB have an impact performance if so do you know how much can be impacted? Let say that we use SqL dB with many integrations
Like number 674
Anyone did this one?
whatsApp bot with gemini pro is this possible ............?
I will tell your AI bot to delete all data from xyz table...👿