Questions tagged [azure-synapse-link]
11 questions
2
votes
2 answers
How to set the dependency between two trigger pipelines in azure synapse Analytics
I have a two trigger synapse pipelines one which is scheduled at 03 am cst , What I'm looking now is the Second pipeline should trigger after the completion of the first pipeline i.e after 03 am cst.
Is there a way i can create this dependency in…
Never_Give_Up
- 126
- 1
- 9
2
votes
0 answers
D365 Azure Synapse Link Slow synchronisation
We are testing out Azure Synapse Link for Dataverse due to data export service being deprecated. We did some initial tests on low volume data, and were able to get the service up and running fairly easily. I've now tried setting it up for a larger…
Kuba
- 21
- 2
1
vote
0 answers
Access choice labels directly from Azure Synapse Link for Dataverse - Unable to implement sample code
I am trying to work 'Choices', formerly known as OptionSets in Azure Dataverse.
I am trying to implement the sample code from the link https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-choice-labels
The code is as…
Patterson
- 1,927
- 1
- 19
- 56
1
vote
2 answers
Why can I connect to a Synapse serverless SQL pool but cannot connect to a dedicated SQL pool in the same Synapse Workspace
Recently, we deployed a dedicated SQL Pool to a Synapse Workspace in production. In development we can access both the serverless SQL pool and the dedicated SQL pool. However, in production we can access the serverless SQL pool, but we cannot reach…
Michael B.
- 11
- 2
1
vote
1 answer
update statistics in synapse for all the table
i am using the below script(which is in the link) to update all the stats in all the tables for synapse database dedicated sql pool however the update if not happening for all the…
hari_agg
- 15
- 4
0
votes
1 answer
Got Error Ingest JSON array data into Azure (via Azure Synapse or Azure Data Factory)
I'm trying to ingest the Json array format from US Census API data into Azure either ASA or ADF is fine... Tried using HTTP or REST and none of them is successful.enter image description here
The error after using HTTP connector is shown as
"Error…
azure rr2
- 1
- 1
0
votes
1 answer
Azure Synapse - Where to find the Managed identity object ID
Hopefully a quick question
I was wondering from within Azure Synapse Studio - where can I find the "Managed identity object ID"?
I tried to click around before and was some what able to find it when creating an integration dataset - But I cant seem…
rodneyc8063
- 113
- 8
0
votes
1 answer
TypeError: function() argument 'code' must be code, not str in Azure Synapse Notebook
I am having below data frame and wanted to save the data frame as a CSV file in the Azure Data lake. My data frame is called 'df'. I am using Azure Synpase Notebook
df.to_csv('abfss://jobsdata@strxxxuei.dfs.core.windows.net/Jobs_newdata/data.csv',…
sthambi
- 197
- 2
- 17
0
votes
3 answers
How to get the KeyVault name in the notebook from the keyvault link in Synapse?
How to get the KeyVault name in the notebook from the keyvault link in Synapse?
I need the KeyVault name to pass to the TokenLibrary.
TokenLibrary.getSecret(keyVaultName,"MyConnectionString", "AzureKeyVaultLink")
Xavier John
- 8,474
- 3
- 37
- 51
0
votes
1 answer
Permission denied error while accessing files under mount point via local file system API in Azure Synapse Notebook
Working from Azure Synapse Notebook, I have mounted the ADLS Gen2 folder using LinkedServiceA as per below command,
mssparkutils.fs.mount(
"abfss://@.dfs.core.windows.net/", #ADLS GEN 2 PATH
"/adlsmount", #Mount Point Name
…
Despicable me
- 548
- 1
- 9
- 24
0
votes
1 answer
Azure Cosmos DB analytical store: How can I view the Well-defined schema representation?
Per the documentation on Analytical store.
What is Azure Cosmos DB Analytical Store?
“The first non-null occurrence defines the column data type. Any document not following the first non-null datatype won't be represented in analytical store.”
I…
Xavier John
- 8,474
- 3
- 37
- 51