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…
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…
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…
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.
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…
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…
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 ?
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?
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?
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…
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