Azure Data Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.
If you're looking for a tutorial for building an extension, I put together one: https://www.drewsk.tech/2018/10/11/sql-saturday-796-minnesota-2018/
on Windows it should be %appdata%\azuredatastudio\User\settings.json
Visual Studio Code has the option to have preferences not only for the user but for the specific folder you have opened, not quite sure if azure data studio has the same feature
just create a file ./.azuredatastudio/settings.json in your folder
ah great, thanks @SebastianPfliegel ! I didn't realize the Servers would be considered part of the workspace settings (thought that might just be for editor preferences a la VS Code). I see that settings file location in the expected spot from here (I'm on a Mac so slightly different than the above) https://docs.microsoft.com/en-us/sql/azure-data-studio/settings?view=sql-server-2017#settings-file-locations - copied that into my project's .azuredatastudio/settings.json and looks like I'm in business!
@drethegreat1
Which is duck, pond and species
Ducks are confortable given their temp limit in the species table
I need to count how many ducks are happy with their habitat
I have done all joins etc
Just need help with extraction part
i am trying to count a column containing integers
but i am having trouble
select androud_num, cells_info, count (*) AS Num_Devices
from table
where vrs = '71.0.0-rcrq.0.1.4'
and dt >='2018-05-17'
from table
where vrs = '71.0.0-rcrq.0.1.4'
and dt >='2018-05-17'
Hi, I am developing a Azure Data Studio extension. In the extension I am generating some SQLs and currently I just open those scripts in a new file. Is it possible to automatically run the SQL and directly show the table data to the user? Currently once the SQLs are open, the user has to click on Run to execute the SQL
@spoon611 the Server Reports extension already does this, maybe you can check out the code: https://github.com/Microsoft/azuredatastudio/tree/master/samples/serverReports
@spoon611 this is possible, here's the API function I believe you would use: https://github.com/microsoft/azuredatastudio/blob/d74c2d6c8d637d07e251183f50c02d949b497859/src/sql/azdata.proposed.d.ts#L4001
Based on comments here (https://github.com/Jaykul/Jupyter-PowerShell) I think the work for Windows has been abandoned
@konstantinmds I haven't tried this example - but if I was interested in a react UI inside of ADS I would start here: https://github.com/rebornix/vscode-webview-react
Hi @dzsquared , i reproduced the code structure and it seems that something is not valid.
Here is my project structure in the pic above. Error is that in my out folder i don't get the extension.js file. Do you know where the problem might be ?
Here is my project structure in the pic above. Error is that in my out folder i don't get the extension.js file. Do you know where the problem might be ?
Is there a way to install this into the Insider build ?https://github.com/microsoft/azuredatastudio/tree/master/extensions/sql-database-projects
This makes debugging really challenging
Hi anyone know how you would approach adding live share to ADS? I want to help but don't know where to start microsoft/azuredatastudio#869