Stack Overflow
Stack Overflow

Questions tagged [azure-synapse]

Questions about Azure Synapse Analytics, bringing together enterprise data warehousing and big data analytics.

Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on your terms, using either serverless or provisioned resources—at scale. Azure Synapse brings these two worlds together with a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.

2525 questions
0
votes
1 answer

Can we create pipelines to run DAX queries on Azure Analysis Service Tabular Models from ADF or Synapse Analytics?

How can we create ADF pipeline to run DAX query from ADF(or Synapse Analytics) to AAS Tabular Models and get the data stored into tables in Azure Data Warehouse Tables or in a .csv file? I've read about creating a .Net library for connecting to…
tmmwj
  • 1
0
votes
1 answer

Merge multiple Azure databases into one Azure SQL database and sync them weekly

I have 100-150 Azure databases with same table schema. There are 300-400 tables in each database. Separate reports are enabled on all these databases. Now I want to merge these database into a centralized database and generate some different Power…
Joshi
  • 51
  • 6
0
votes
1 answer

How to run python scripts in Synapse in production environments

How can we run python scripts in Synapse in production environments? I want to know the best practices.
utopianpallu
  • 21
  • 2
0
votes
1 answer

How to Remove All Views from Azure Synapse SQL Serverless Inbuilt

Can let me know how to remove views/tables from Azure Synapse Inbuilt SQL Serverless Pool. Its easy enough to remove individual tables/views using following: use [DatabaseName] GO drop EXTERNAL table schemaname.tablename But I would to remove all…
Patterson
  • 1,927
  • 1
  • 19
  • 56
0
votes
1 answer

Azure Synapse Private Endpoints TrustFailure SSL/TLS secure channel

I am trying to connect from a client in vnet A to a Synapse Workspace and storage account in vnet b using private endpoints. All traffic between the two vnets is routed via a third party firewall. The firewall allows all traffic: If I try to open…
Bakkie103
  • 47
  • 6
0
votes
1 answer

Retrieve password from Azure key vault in Azure Synapse T sql

I have created certificate in synapse with below code. I want to retrieve password from azure key vault and use the password in the below statement. CREATE CERTIFICATE ZZZZ_Certificate ENCRYPTION BY PASSWORD = 'pGFD4bb925DGvbd2439587y' WITH…
Rajib
  • 19
  • 1
  • 7
0
votes
1 answer

How do I retrieve certificate definition in Azure Synapse dedicated pool?

I have created certificate with following definition. The certificate is created .Is there any option to retrieve certificate definition from system objects ?If we can retrieve definition ,what is the best way to restrict user to view create…
Rajib
  • 19
  • 1
  • 7
0
votes
1 answer

Is it possible to retrieve file path/url information when querying BULK OPENROWSET in Azure Synapse?

I am able to retrieve all the keys and values from json files stored in a Azure Data Lake Storage Gen 2 directory through an Azure Synapse Serverless SQL query like the one below: SELECT TOP 100 someColumn1, someColumn2 FROM OPENROWSET( …
Allen Rufolo
  • 1,173
  • 1
  • 11
  • 14
0
votes
0 answers

Power BI refreshes failing if Synapse is updated by Dynamics - is this to be expected?

We have recently implemented Azure Synapse Workspace into our reporting landscape. The purpose of this Synapse Workspace is to store Dynamics data to be reported on by Power BI. We were using the Data Export Services mechanism to move data from…
Dave100
  • 1
  • 1
0
votes
1 answer

Synapse Pipeline : DF-Executor-OutOfMemoryError

I am having nested json as source in gzip format. In Synapse pipeline I am using the dataflow activity where I have mentioned the compression type as gzip in the source dataset. The pipeline was executing fine for small size files under 10MB. When I…
Ritesh S
  • 1
  • 1
0
votes
0 answers

Azure Managed Private Endpoint in Continuous Refresh Mode

We have configured a number of Azure Managed Endpoints. However, the endpoints appear to be stuck in a state of Refresh mode, see image. Can someone let me know what might be causing this?
Patterson
  • 1,927
  • 1
  • 19
  • 56
0
votes
1 answer

Connection string for parameterized Linked Services - Azure SQL / Azure Synapse

I have a requirement where in I need to parameterize my Azure SQL/Azure Synapse linked service using 2 parameters 'DBServer' and 'DBName'. I configured my collaboration branch as below and everything works as expected in my Synapse workspace. Even…
Alok Thampi
  • 161
  • 1
  • 1
  • 7
0
votes
1 answer

Azure Synapse and Jira Rest Api Error 21155

I am trying to call the Rest Api from Jira via the REST Connector of Synapse. I always get the error 21155. Error occured when deserializing source JSON file. Check if data is in valid JSON. Unexpected character encountered while parsing value…
Felix111
  • 1
0
votes
0 answers

Azure Synapse Dedicated SQL Pool Connector for Apache Spark

0 I am trying to write data into Azure Synapse dedicated pool using python from spark…
Sam
  • 281
  • 5
  • 15
0
votes
1 answer

Get data from Azure Synpase to Azure Machine Learning

I am trying to load the data (tabular data in tables, in a schema named 'x' from a spark pool in Azure Synapse. I can't seem to find how to do that. Until now i have only linked synapse and my pool to the ML studio. How can I do that?
vertigo
  • 125
  • 8
1 2 3
…
99 100