analystsqltool READMEAs analysts, we often only have read access to most databases. However, the requests we received are too often so complicated that version control and cross reference are so important for better efficiency. That's why we start to pick up code editors like vscode. Bad news is taht most SQL tools here are for developers, requiring full access and all details of the database connection. But analysts also need autocompletions! That's why I develop this plugin. FeaturesPrepare a version of offline schema json file and you will have the autocompletion when you are writing SQL queries in VScode. RequirementsThe name of your schema file doesn't matter. But keep in mind that it MUST BE a json file following the below format.
Extension SettingsDesignate your schema file by either using "Analyst SQL Tool: Set Schema Path" in the command palette or change "analystsqltool.schemaPath" in settings.json. Known IssuesRelease NotesUsers appreciate release notes as you update your extension. 0.1.12024-08-26 Lower the vscode engine requirement 0.1.02024-08-25 Release the first version. |