Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,614 questions
1 answer
Materialized views using Delta ?
In Azure Synapse, will I be able to create materialized views on top of Delta Files?
asked 2020-06-23T13:24:35.057+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 46%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFA%3C/text%3E%3C/svg%3E)
Felipe Andrade
1
Reputation point Microsoft Employee
answered 2020-06-25T23:17:03.973+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft
19,386
Reputation points Microsoft Employee
3 answers
How to replicate data from different backends that are using SQL Servers (all hosted on Azure) to do Reports. What Azure Products do I need?
Suppose I have hosted on the same Resource on Azure 4 Web APIS on .NET Core with SQL Server. Each system has their own SQL Server Database on Azure. The systems are communicated using Azure Service Bus. My objetive is to use Power BI or a similar…
asked 2020-06-04T16:27:01.447+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 25%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
Pablo De Luca
1
Reputation point
answered 2020-06-21T12:59:49.127+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 72%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Ra Gus
1
Reputation point
1 answer
Rendering output of included Python viz libraries
Synapse by default includes a collection of various Python libraries (Anaconda dist.) among which are Seaborn and Altair, but their output is not rendered automatically in the Synapse notebooks. Are any additional configuration steps required to enable…
asked 2020-06-06T09:50:15.283+00:00
Dimitri B
66
Reputation points
commented 2020-06-20T05:10:25.897+00:00
Euan Garden
136
Reputation points
1 answer
One of the answers was accepted by the question author.
Is there a way to install Python / Scala libraries from within notebooks?
In Databricks it is possible to install Python (but not Scala) libraries from within notebook, into notebook's local scope, e.g.: !pip install 'library-name' or dbutils.library.installPyPI("library-name") Is something similar possible…
2 answers
One of the answers was accepted by the question author.
Not able to use dimension tables from Azure Synapse Analystice Service sample data
I created the azure sql pool in synapse service and tried to use the sample data. I tried to connect the sample data with SQL pro for MSSQL but could not access the dimensions tables from sample data. example: I used this query- SELECT…
asked 2020-06-09T21:50:36.01+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 55.00000000000001%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
Tarun Chawla
21
Reputation points
answered 2020-06-11T11:21:29.543+00:00
Tarun Chawla
21
Reputation points
2 answers
One of the answers was accepted by the question author.
Accessing dataframe created in Scala from Python command
Is there a way to create a Spark dataframe in Scala command, and then access it in Python, without explicitly writing it to disk and re-reading? In Databricks I can do in Scala dfFoo.createOrReplaceTempView("temp_df_foo") and it then in…
1 answer
How to join the current Azure DW database to Synapse Database Pool ?
As captioned title, How to join the current Azure DW database to Synapse Database Pool ? I found in synapse studio , you can only create a new DW pool , instead of add.
asked 2020-06-06T04:03:10.637+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 1%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Michael
6
Reputation points
commented 2020-06-10T01:59:14.067+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 21%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Robert Barat (WOW)
26
Reputation points
3 answers
Editing GUI for Synapse SQLPool DDL statements
Have to ask this newbie question after reading the Synapse documentation... I just installed Visual Studio with the DB addons, and connect to Synapse SQL Pool. All working fine so far. However, I am looking for a convenient way to manager relational…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 4%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
5 answers
Let SSAS connect to Synapse without enabling 'Allow Azure services'
Hi all, I want to enable my Azure Analysis Services Cube to process with data from Synapse. But I want to disable the 'Allow all Azure Services' option on the firewall. So now I'm thinking about adding an action to my Data Factory Pipeline (self…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 63%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
2 answers
Azure synapse tablock
Dear All expert. In Azure sql datawarehouse. are there any way to do tablock ? I have a table with a column having an id int column . I want to insert a record in this table with increment of 1 . how can I do that ?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Code formatting
It looks like currently Synapse workspace doesn't have a code formatting feature, so it has to be done manually. Are there plans to add it?
2 answers
Spark SQL DML statements with Delta tables
I am getting an unspecified error when running UPDATE, DELETE and MERGE sql statements on Delta tables when using Spark SQL APIs. I can use Scala APIs fine, I’m wondering if anyone else is having the same issue?
asked 2020-05-27T21:21:35.157+00:00
Serverless SQL
216
Reputation points MVP
commented 2020-06-04T20:14:47.443+00:00
Euan Garden
136
Reputation points
1 answer
Synapse Workspaces SQL Pool Storage - New vs Existing
Hi All, Would a SQL Pool created as part of a Synapse Workspace perform any differently to an exiting SQL Pool from a different region? Documentation states that the SQL Pool uses Azure Storage but does not specifically state if that's server specific…
asked 2020-05-23T00:16:31.147+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 40%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
Grant Campbell
1
Reputation point
commented 2020-05-31T22:07:31.587+00:00
Grant Campbell
1
Reputation point
1 answer
One of the answers was accepted by the question author.
What is Azure Synapse Analytics
Hello All, What is Azure Synapse Analytics? [Note: As we migrate from MSDN, this question has been posted by an Azure Cloud Engineer as a frequently asked question] Sourced from Azure Synapse FAQ
asked 2020-05-14T07:18:50.82+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 57.99999999999999%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Ramya Harinarthini_MSFT
5,311
Reputation points Microsoft Employee
accepted 2020-05-14T07:36:56.617+00:00
Ramya Harinarthini_MSFT
5,311
Reputation points Microsoft Employee