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

How to change Azure Data Studio result pane default rows limit (for Extenstion Postgres)

When I run a query in Azure Data Studio, instead of writing limit keyword everytime in the query. Is it possible to set the default value to some number , so that Results windows shows only that number of rows from the top. As of now it is…
rohan
  • 43
  • 4
0
votes
1 answer

Stuck at step 4 in migration from SQL Server to Azure

I'm new to Azure service and I just tried migrating my SQL Server database to Azure. I follow this tutorial: https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-database-offline-ads The tutorial's step 4 is shown…
chris_techno25
  • 2,401
  • 5
  • 20
  • 32
0
votes
0 answers

Can I use the Azure Data Studio SQL kernel with the jupyter nbconvert command to execute and convert a notebook to HTML?

I am working with Azure Data Studio and I have a notebook (notebook.ipynb) that uses the SQL kernel in Azure Data Studio. I want to programmatically execute the notebook and convert it to HTML using the jupyter nbconvert command. However, I am…
0
votes
1 answer

Azure Data Studio Does not import CSV

Please would you help me out with this error. I am trying to Import trough wizzard a csv file, downloaded here https://ourworldindata.org/covid-deaths But unfortunately it is not converting all floats.enter image description here Thank you in…
0
votes
1 answer

Azure Data Studio, Error: Failed to Expand Node

Connecting to Postgres server is successful, but by clicking on Databases to expand database folder, the Error: Failed to expand node will be raised. Extension version: 0.2.7 Azure Data Studio version: azuredatastudio 1.43.0 I'm using PostgreSQL…
0
votes
1 answer

How to retrieve unsaved tabs on Azure Data Studio?

How to retrieve unsaved tabs on Azure Data Studio? I was writing a long Azure SQL script that contained a cursor and while loop. And while I was dry-run ning it it crashed! I had not saved my work on this tab. I would like to retrieve the script so…
StackRover
  • 557
  • 5
  • 10
0
votes
1 answer

How do I add a new database to Azure Data Studio on Mac using SQL Docker?

How can I add a database to Azure Data Studio on Mac ? I've created a SQL Image in Docker and I've connected Azure Data Studio to it. I'm trying to add an additional database. On Windows you would typically right clock on 'Database' and have the…
0
votes
1 answer

Server connection and current connection are different on Azure Data Studio?

The orange rectangles indicate two different databases within the current instances. Why are they different - what do both of them indicate? "ddexdev" on the right seems to be the active connection Is the "test_db" on the leftnav just misleading -…
WestCoastProjects
  • 58,982
  • 91
  • 316
  • 560
0
votes
0 answers

"Error: No connection info returned" when attempting to connect to SQL Server from Azure Data Studio

I am trying to understand what is wrong with connection parameters but there is no useful information provided. The connection string is: DRIVER={ODBC Driver 17 for SQL…
WestCoastProjects
  • 58,982
  • 91
  • 316
  • 560
0
votes
0 answers

There's no place for entering basic username and password on Azure Data Studio?

When creating a new connection in Azure Data Studio the only options are sql login - which authenticates through my O/S logged in user not username/password Windows auth (i'm on mac..) Azure AD So how do i connect using username/password? This is…
WestCoastProjects
  • 58,982
  • 91
  • 316
  • 560
0
votes
1 answer

Cannot connect to Local Cosmos DB NoSql using Azure Data Studio

I can connect to my local Azure Cosmos DB Emulator using default Browser data explorer or VS code Azure Databases extension. "Azure Data Studio" with following connection Settings: Connection type: Cosmos DB No Sql Connection String:…
MedEzz
  • 1
0
votes
1 answer

How to add the folder of design diagrams in Azure Data Studio?

I installed Azure Data Studio recently, but I can not find the diagram folder in the dashboard - how do I add it? How can I make relationship between entities in Azure Data Studio?
0
votes
0 answers

Azure Data Studio, Database Project, Postdeployment scripts

I am trying to get multiple files into a post-deployment using project Azure Data Studio I have a main deployment file Script.PostDeployment_Main.sql Contents are -- This file contains SQL statements that will be executed after the build…
user1730289
  • 273
  • 4
  • 15
0
votes
0 answers

Connecting Azure Database Migration Service to self-hosted Integration Runtime in Azure Data Studio

I'm trying to migrate an on-premise SQL Server Database to an Azure SQL database using Azure Data Studio, using this tutorial…
dev1610
  • 23
  • 5
0
votes
2 answers

Column reference

I am querying a database of fuel imports and exports. This is the relevant code: --Find the top 3 regions with the highest fuel exports SELECT exp.Country_Name AS Region, exp.Year, exp.Fuel_exports_as_precentage_of_total_exports AS…
Asaf H
  • 1
  • 1