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
2
votes
1 answer

Mac SQL Operations Studio Import

I've widely searched for this feature, but cannot find any info. Is it possible to import csv in SQL Operations Studio (Mac)?
dana
  • 31
  • 1
  • 5
1
vote
1 answer

Retrieving the connection string for a Mssql database running inside a container

I'm writing a local python script that queries an MSSQL database that runs locally and having difficulties connecting to the database. The database runs inside a docker container since I'm using a mac (i5). I'm not sure what is the correct format…
דרור דה-הרטוך
  • 11
  • 1
1
vote
3 answers

SQL DB migration to Azure SQL using Azure Data Studio

I am not able to migrate on-premise SQL Server database to an Azure SQL database. I am using Azure Data Studio while doing the migration. I am not able to "Select the tables" at the end, due to which I am not able to proceed next.
Baxy
  • 139
  • 1
  • 13
1
vote
1 answer

Using SQL Profiler on an Azure Dedicated SQL Pool using Azure Data Studio

I am attempting to monitor direct query from power bi on a synapse dedicated sql pool. From SSMS I was unable to log into profiler (it offered only windows and sql authentication, i am using AAD with MFA) I then read that I need to use Azure Data…
Vanessa van gelder
  • 13
  • 2
1
vote
0 answers

VS Code Extension for older version

I want to install an extension on a server without access to the internet, so I downloaded the vsix file and tried to install it on the server. Turns out that the VS code on the server is an old version, 1.59 if I remember correctly. How can I find…
xhr489
  • 1,957
  • 13
  • 39
1
vote
1 answer

attach a database to Azure data studio

I am running Azura data studio on docker on my Mac, and have a server running, in which I need to attach a database to that I have locally in .mdf format. I have tried right clicking to click attach database as you would in sql server express, but…
devdude19289
  • 151
  • 1
  • 10
1
vote
1 answer

Azure Data Studio: _delta_log/*.*' cannot be listed

I'm trying to query my delta tables using Azure Synapse Serverless SQL Pool. Login in Azure Data Studio using the SQL admin credentials. This is a simple query to table that I'm trying trying to make: SELECT TOP 100 * FROM OPENROWSET( …
Dinis Rodrigues
  • 558
  • 6
  • 19
1
vote
1 answer

Getting Index Scan instead Index Seeking if IN clause larger in Azure Sql

This is the Non clustered index we have : ALTER TABLE [Allocation].[allocation_plan_detail] ADD CONSTRAINT [UQ_AP_TENANT_TYPE_STATUS_PLAN_ITEM_CLUB] UNIQUE NONCLUSTERED ( [tenant_id] ASC, [item_type] ASC, [allocation_plan_status] ASC, …
SUVAM ROY
  • 103
  • 1
  • 10
1
vote
0 answers

Can I run Azure Data Studio as another user?

Is there any equivalent to this RUNAS /user:DOMAIN\username "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe" in order for me to run ADS as another user? well, I tried modifying that command and point that to…
John Phillip Abello
  • 183
  • 2
  • 14
1
vote
2 answers

SQL Server Management Studio - Login errors

I have an Azure SQL Server resource for which I'm the Azure AD admin. I have provided the resource access "Contributor" to another user who cannot access the database through SQL Server Management Studio as he is receiving the following error using…
Roopansh Gupta
  • 11
  • 2
1
vote
1 answer

How to query Application Insight data using Azure Data Studio

I have the following connectivity options in my Azure Data Studio setup: How can I connect may Azure Data Studio to an Application Insight instance?
Allan Xu
  • 7,998
  • 11
  • 51
  • 122
1
vote
1 answer

Connection String not found Azure Data Studio to VS2022 - Mac

I am trying to setup my uni work (which is windows based) onto my mac. I have a docker container running with AzureSQLEdge, which I have connected to my Azure Data Studio and can run queries no problem. However in VS2022 trying to set up the…
MrBardoth
  • 13
  • 3
1
vote
2 answers

How to import a .csv file to existing table on sql server on Azure Data Studio?

I am using mac m1 so I can't use SSMS, I can use Azure Data Studio. I want to import an excel file to my existing table on SQL Server. If I use BULK INSERT sql query, it gives an error because Azure Data Studio cannot see local file storage except…
batuhan
  • 19
  • 1
  • 2
1
vote
0 answers

Access Denied When loading python from Windows with Azure Data Studio

I am trying to use a local version of python with Azure Data Studio and I receive this message when I try to use it. WindowsApps\PythonSoftwareFoundation.Python.3.10_3.10.1520.0_x64__qbz5n2kfra8p0\python.exe" -c "import…
Robert Edwardes
  • 77
  • 7
1
vote
3 answers

How to connect MySQL local database to Azure Data Studio?

I searched the documentation but I could not find out, how can I connect MySQL local database to Azure Data Studio?
user18301379
1 2 3
…
16 17