Data Mesh architecture implementation on Azure data lake
Hi friends, Data mesh architecture is a decentralized approach that organizes data based on business domains (e.g., marketing, sales, HR), I have the following questions Is it required to build a separate data lake for each department? When data…
Automatic updates on source systems
Hi friends, I have a requirement that the business has 12 different upstream sources SAP, CRM, Oracle HCM, SqlServer, PostgreSQL, and multiple other open-source databases and custom applications, etc. and every system has its master record, and just…
Cannot register microsoft.Synapse
Hi, I am encountering a problem. No matter how many times I click 'register' on Microsoft Synapse, it always shows as 'NotRegistered'.
error when module is publish in power bi
I am getting this error when module is publish in power bi Data source credentials missing The data source sandpit is missing credentials. Ask the dataset owner to update the credentials.
How to parse nested json array of document in ADF data flow
Hi all I am trying to fitch the values from a nested josh array of document , I have used aggregate to convert into objects but not able to fitch the values of all child nodes like as below itOffer.item itOffer.item.SplOfr itOffer.item.buy …
Error when using pandas to write data to ADLS in Azure Synapse Analytics
Hi Mr/Mrs, I want to use pandas to write dataframe to .csv file into ADLS, but I got this issue although I put the access key, it didn't work. How can I fix this issue? Thanks!
Synapse workspace deployment node-js supported versions
Hi, I would like to know the list of node.js versions supported for Synapse workspace deployment (Synapse Workspace Deployment@2 task). I can't seem to find any documentation describing the same.
In ADF, I am not able to merge data from multiple streams with different columns with different data types
Hello, I am not able to merge data from multiple streams in ADF DATAFLOWS. Stream 1) flow let - only 1 column. Stream 2) flow let - only 1 column. Stream 3) source columns (54 columns) Stream 4) regular…
Querying 1 serverless sql server db from another serverless sql server db
Hello - I would like to check if this scenario is possible in azure synpase analytics. Query data of serverless SQL in azure synapse analytics from another serverless sql server. We have a requirement , where we want to create views in the second…
Cannot view data lake gen 2 containers using analytics synapse linked service view (even with the contributor permission granted)
Each time i try to view the contents of a data lake gen 2 container using the portal 'Data' tab. I get the following error; 'Storage Explorer Error Uncaught ReferenceError: O is not defined.' I have already given the resource and myself, the storage…
How can we connect Blackboard DDA (a SaaS using PostgreSQL to store data ) via Azure Synapse analytics using SSL certificate for authentication in SHIR for Private Vnet enabled networks.
Blackboard DDA is a SaaS application which uses PostgreSQL as DB to store data. The DB uses a SSL certificate key to authenticate and we have private Vnet enabled. How to create a linked service for this DB and where do we store certificate in SHIR. Are…
Linked services and Key Vault
Hello, Just a question regarding link services, basically, our orgnisation has linked services with one datasbases from different business area, now we need to ingest data from different source, ideally from sharepoint with all the csv files for other…
Azure Synapse alert for Dedicated SQL Pool
How can I properly set up an alert for a Dedicated SQL Pool in Azure Synapse for CPU Utilization? I want the alert to trigger if the CPU Utilization is more than 90% for an hour continuously. I have set the "check every" to 1 hour and…
How to upgrade the Azure Synapse Runtime for Apache Spark 3.1 to version 3.3
We received an email regarding the retirement of Apache Spark 3.1 as of January 26, 2024. There is a notice saying to upgrade to Apache Spark 3.3 when clicking on [Azure Synapse Link for Dataverse] from Power Apps, but I am not seeing the Update option…
InvalidHttpRequestToLivy: Your Spark job requested 12 vcores. However, the workspace has a 0 core limit.
it gives me this error and when i tried to increase core size limit i could not find that option so how to solve this error?
How to translate database content with Azure Translator by ADF or Synapse notebook?
There is an Azure Database table. Some of columns need to be translated from one language to another into additional columns. Such as from English to Spanish, or Portuguese to English, etc. I am exploring how I can use ADF or Synapse notebook to…
Azure Synapse Analytics Workspace And its Dedicated SQL Pool Migration From one subscription to another subscription during Cross Subscription Migration
I just Want to know that how can I migrate synapse workspace and its dedicated SQL pool from one subscription to another subscription during cross subscription migration
Backup/Restore and collation update in Azure Synapse
We have one requirement that to change the collation of Azure SQL serverless database in Azure Synapse Analytics to default collation. So I have 2 questions, 1. How to take backup and restore Azure SQL serverless database in synapse. 2. How to update…
No MediaTypeFormatter is available to read an object of type 'ClusterInfo' from content with media type 'text/html'.
Hi, in azure data factory I wanted to test the connection of our new Databricks Workspace URL and ClusterID. I parameterized the linked service (LS) to global parameters databricksURL and databricksClusterID. When I want to test the connection…
Cross-db query in Synapse
Hi, I am pretty new to Azure Synapse This post mentions that it is possible to have only one database per SQL pool. However, this post was from 2 years ago. Is this still the case? Assuming that only one database can be created within a SQL pool, is…