Stack Overflow
Stack Overflow

Questions tagged [azure-data-studio]

Use this tag for issues related to Azure Data Studio and try tagging the platform as well. Ask the question on superuser.com if you are facing issues with installation

Azure Data Studio is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. This is similar to Sql Server Management Studio, but works on all platforms.

Github: https://github.com/Microsoft/azuredatastudio

253 questions
3
votes
1 answer

How to communicate with SQL Server 2019 container hosted inside Docker from Azure Data Studio

I am trying to create a login web application in visual studio (.NET core web app). I am using Azure Data Studio(ADS) to connect to the local database for the application. But when I run the application using docker, the web app loaded successfully…
sk5991
  • 45
  • 6
3
votes
1 answer

How do you disable autocommit in azure data studio

We use Azure Data Studio for our SQL Server queries. However, it automatically commits everything and I cannot find an option to disable this. I found this page…
Martijn Van Loocke
  • 433
  • 2
  • 6
  • 17
3
votes
1 answer

Dataset production using SQL Server Management Studio, Visual Studio Code, Azure Data Studio, Visual Studio

I regularly use SSMS to query data and build datasets, my IT department handle the database administration. Recently I found out about Azure Data Studio and I liked: intellisense source code control (e.g. with Git) extensions from the community SQL…
sassora
  • 53
  • 5
3
votes
3 answers

proper Roles and permission to use Azure Data Studio

I am using Azure Data Studio. Which roles should I add to the user? There is an error when I use the Start New Profiler session: The user does not have permission to perform this action.
Fatemeh Ramezani
  • 83
  • 8
3
votes
2 answers

Import table from same Notebook

How could one read a markdown table from a text block and import in into a variable in a code block in the same PowerShell notebook? Attempted to import with PowerShell $b=Import-Csv -Path <> -Delimiter '|' Couldn't figure out how to point the…
Ayan Mullick
  • 67
  • 2
  • 11
  • 38
3
votes
2 answers

Azure Data Studio - how to access Activity Monitor

I've recently installed ADS but I can't find how to view the activity monitor. In SSMS, you can easily access the activity monitor and view which queries are blocked, Active expensive queries, recent expensive queries etc. Is this available in…
user3298593
  • 115
  • 1
  • 13
3
votes
2 answers

Connecting to Amazon Redshift in Azure Data Studio via the Postgresql Connector

I've recently joined a company with a mixed set of databases that include a Redshift cluster and some SQL databases. I'd like to use a single IDE to access both for analytical reporting, so I don't have to switch between tools. I'm currently using…
EILNP
  • 33
  • 1
  • 3
3
votes
2 answers

Group tables by schema in ADS

In Visual Studio's Server Explorer window there's a very nice feature that lets you see the DB objects grouped by schema: It turns this object tree: Data Connections -> MyServer -> MySchema.MyTable Into this one: Data Connections -> MyServer ->…
RaG
  • 317
  • 7
  • 19
3
votes
0 answers

In Azure data studio I am unable to find add foreign key or any other constraint option

I'm using ubuntu and to Azure Data Studio tool for DB connection. I'm able to apply key constraint using Sequelize ORM but for sample test table I want to create key constraints manually without running query, Is there any GUI option azure data…
Vipul Patil
  • 1,250
  • 15
  • 27
3
votes
0 answers

Can we change the `New Query` name template?

Currently, AzureDataStudio creates New Query like so: The above picture shows two tabs but each are for different servers named dev and qa. It would be nice to name the New Query with more useful information like SQLQuery_1 - dev and SQLQuery_2 -…
Jan Paolo Go
  • 5,842
  • 4
  • 22
  • 50
3
votes
0 answers

How to restore from a .bak file in Azure Data Studio for Mac

I'm trying to use Azure Data Studio for Mac, I need to restore a databse using a .bak file, I have that file in finder, but when I click restore I click on "Restore from" choose Backup file, then "Backup File path" click on "..." but it never open…
diego muñoz
  • 43
  • 1
  • 5
3
votes
2 answers

Azure Data Studio: Save As CSV

In Azure Data Studio, after getting my results I'm clicking on the "Save as CSV" icon and nothing appears to be happening. How do I name the file and where will it be placed? I'm expecting to see a Save As.. dialog.
Del Lee
  • 442
  • 1
  • 6
  • 20
2
votes
1 answer

Missing Table Designer in Azure Datastudio

I only see 'Refresh' when I make right click on Table.How to get 'New Table' to manage table with designer in Azure Data Studio.Is there any extension to get.
Wai_Lynn
  • 35
  • 4
2
votes
1 answer

ODBC Driver Error Querying External Table

I've set up an external table in Azure SQL in order to execute an elastic query according to the docs here https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-overview?view=azuresql I can see the external table in Azure Data…
Patrick Goode
  • 1,412
  • 5
  • 20
  • 35
2
votes
1 answer

Problem with using "Database Administration Tool Extensions for Windows" in Azure Data Studio

I want to Generate Script in Azure Data Studio by using Database Administration Tool Extensions for Windows as it is mentioned in these a,b questions. However, after installing the Database Administration Tool Extensions for Windows, when I…
amin
  • 93
  • 8
1 2
3
…
16 17