Replies: 5 comments 1 reply
-
@cmp-nct Thank you for your feedback! 🚀 |
Beta Was this translation helpful? Give feedback.
-
I definitely second this! I'm using this tool daily as a data engineer. Its very helpful, but could be 100x more helpful if it knew my data model/schema |
Beta Was this translation helpful? Give feedback.
-
I tried scripting my entire database to a file out of SSMS then I opened that file in a separate tab in Azure Data Studio but it didn't seem to help Copilot know the PK-FK joins. I even tried Copilot in that same tab, but it didn't seem any smarter. What am I doing wrong? |
Beta Was this translation helpful? Give feedback.
-
is there any specific command of comment to point the copilot to my local database schema to use table schemas when suggesting query only from those files. I mean i have table generation script which has structure of all the tables and want to point copilot to suggest queries according to that schema, any way to do that ? Also are there any similar commands on which i can train co pilot to do special stuffs on per project basis ? |
Beta Was this translation helpful? Give feedback.
-
This would also be enormously helpful to me - to be able to teach Copilot the structure of my database tables and provide it human-descriptive text about the meaning of the fields and their relationships, so it could lean on that information when I - and hundreds of other users - ask it to generate queries to get the exact information they are looking for. |
Beta Was this translation helpful? Give feedback.
-
Copilot know how to use SQL but he can't do it without knowing the structure.
Now suddenly copilot not only knows the syntax, it even chooses the right enum when writing an INSERT statement that actually uses my own implementation routines correctly.
Copilot can really be a very intuitive and powerful tool but it needs to have a relevant scope of data available.
The structure of the database is one of those things it requires to work with database related codes.
Beta Was this translation helpful? Give feedback.
All reactions