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
0
votes
0 answers

Create nice formatting in Python

Im trying to write a python script that helps me with formatting sql. Goal is to have the data format and the NULL's line out neatly. It looks like this: CREATE TABLE [dbo].[?????????????????????????]( , [timestamp] TIMESTAMP NULL , [??????] INT…
Koen H
  • 1
  • 1
0
votes
1 answer

Different behavior when executing an SQL query in Azure Data Studio and SSMS or SSRS

I have a query that behaves differently depending on the client executing it. I got instantaneous result (163 rows) with Azure Data Studio. More than 7 minutes for SQL Management Studio, Report Builder, SSRS Web Portal. What is even better is that I…
nicolasL
  • 136
  • 1
  • 7
0
votes
1 answer

Azure Data Studio Machine Learning - Python and R Packages not being recognized

I'm setting up Azure Data Studio ( ADS ) 1.29 running the Machine Learning extension , to manage SQL 2019 Machine Learning Services in Win2016. The reason for running ADS is so I can install Python and R packages into SQL MLS via ADS. Ultimately we…
steve
  • 395
  • 2
  • 11
0
votes
1 answer

Select conditional column but getting subquery returned more than 1 value

I have a database with sales information. There is the CustomerID, FirstName, LastName and State column. In State there are only California and Texas. I need those who live in California to show their FirstName, while those who live in Texas show…
warafaiswar
  • 3
  • 1
0
votes
1 answer

Make a property bag from a list of keys and values

I have a list containing the keys and another list containing values (obtained from splitting a log line). How can I combine the two to make a proeprty-bag in Kusto? let headers = pack_array("A", "B", "C"); datatable(RawData:string) [ "1,2,3", …
Jenny
  • 2,041
  • 13
  • 15
0
votes
1 answer

Azure Data Studio failing to authenticate to github

How can I get Azure Data Studio (ADS) to log into github? Last year it was connected, after I somehow input a "Personal access token". But, that recently got messed up, and now I can't recreate the steps from last year. Now, after opening my local…
cnelson
  • 1
0
votes
1 answer

Unable to open pandas python package from Azure Data Studio, while configuring SQL Server 2019 Big Data Cluster

I'm working on setting up SQL Server 2019 Big Data Cluster. One of the initial steps is installing python package: panda. Post installation, when I try to import the package, I get the following exception in Azure Data Studio. import…
RaviLobo
  • 447
  • 2
  • 10
  • 29
0
votes
1 answer

Insights-Widget "When" Condition Value Options

I am trying to add a "When" condition to a custom insights widget so that the widget is only visible on a dashboard for a specific database. The problem is that the documentation for this doesn't cover the possible conditions and values…
Joe
  • 616
  • 2
  • 12
  • 27
0
votes
1 answer

Offline install of Powershell kernel in Azure Data Studio Notebook

I would like to create a Notebook in Azure Data Studio, using the Powershell kernel. To do this on my personal laptop, I did selected the Powershell kernel in ADS and followed the next few steps. From what I can tell, these steps first downloaded…
Andy
  • 399
  • 1
  • 2
  • 10
0
votes
1 answer

Restore .bak file with docker MSSQL server in MAC OS

I am using the docker MS-SQL server latest version and trying to restore the database (.bak) file using Azure data studio. But not able to find the physical location in MAC As per the Azure data studio it points the data to the /var/opt/mssql/data…
San Jaisy
  • 15,327
  • 34
  • 171
  • 290
0
votes
1 answer

Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] Java Error

I have been facing problem connecting Hibernate to Azure Data Studiowhere I want to read the data from the database. Here are the files: Testing Class public class AbtCANMapperTest { StandardServiceRegistry ssr = new…
TechGeek49
  • 476
  • 1
  • 7
  • 24
0
votes
1 answer

Error using Polybase to load Parquet file: class java.lang.Integer cannot be cast to class parquet.io.api.Binary

I have a snappy.parquet file with a schema like this: { "type": "struct", "fields": [{ "name": "MyTinyInt", "type": "byte", "nullable": true, "metadata": {} } ... …
Tino
  • 63
  • 4
  • 13
0
votes
2 answers

Why do I need to declare variables twice: within and without the dynamic query?

I'm reworking an existing static query to be dynamic. Why am I needing to declare the variables twice? Once at the top of the file (for a subsequent, unchanging query) and again within the dynamic SQL statement. Is this something to do with how…
Ed HP
  • 124
  • 2
  • 9
0
votes
2 answers

Adding local image in Jupyter SQL notebook

Started using Azure data studio and creating documentation for some SQL processes in our system. As part of that I need to include a flow diagram in the document. Currently I have uploaded an image to a URL and am able to embed the image in document…
vignesh
  • 1,414
  • 5
  • 19
  • 38
0
votes
1 answer

SQL Server Connection Failed with Linux Mint + SQL Server 2008 R2 using AzureDataStudio

I am trying to connect to my SQL Server 2008 R2 with SP4 database, however, I got this error and I have tried some solutions that I found here, but none works for me. PS. I do not know exactly how to understand this…
José Luiz
  • 334
  • 1
  • 5
  • 18
1 2 3
…
16 17