SmartQuery: Automated SQL for Data Lakes in Microsoft Fabric

An user friendly environment to populate the required data from the Data Model without having the SQL knowledge and generate reports

Comment

Inspiration

Inspired to use the AI skills in Fabric and get the benefit of that

What it does

This is will help the uses to get the required output or results without knowing the SQL, the simple English will be converted to SQL and get the required data from the existing Lake house. Also provide the SQL query generated automatically

How we built it

With the help of data in the existing Lakehouse, using the inbuild Fabric AI Skill

Challenges we ran into

connecting the Fabric AI skill from the workspace and export the model and use the URL in another notebook in other workspace was a challenge

Accomplishments that we're proud of

Successful integration of Fabric AI skill and get the required output

What we learned

The usage of Fabric AI Skill

What's next for Smart Query: Automated SQL for Data Lakes in Microsoft Fabric

Make use of this application in the other project and train the users to use it with out knowing what is SQL and how to use the SQL query to get the data from a Lake House

Built With

Share this project:

Updates