4,653 questions with Azure Synapse Analytics tags

Sort by: Updated
Updated Created Answers
1 answer

Azure synapse and reserved pricing discount

From looking at the link here https://azureaggregator.wordpress.com/2021/02/09/data-flows-in-adf-and-synapse-now-support-reserved-instance-pricing/ and …

Azure Synapse Analytics
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,653 questions
asked 2024-07-02T14:58:46.54+00:00
MrFlinstone 501 Reputation points
commented 2024-07-06T16:00:24.4533333+00:00
ShaikMaheer-MSFT 38,326 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

I cannot access synapse workspace in Azure. error code

Failed to load Failed to load role assignments due to forbidden issue, error code 403. Refresh or troubleshoot the issue. Please can someone help. I am the owner of the subscription.

Azure Synapse Analytics
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,653 questions
asked 2024-05-09T15:19:23.46+00:00
Xhevahir Mehalla 140 Reputation points
commented 2024-07-06T08:22:11.9033333+00:00
Xhevahir Mehalla 140 Reputation points
1 answer One of the answers was accepted by the question author.

multiple join in adf pipeline

Hi, and how to to handle select statement with multiple join in adf pipeline

Azure Synapse Analytics
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,653 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,078 questions
asked 2024-07-06T02:28:47.5633333+00:00
Vineet S 325 Reputation points
accepted 2024-07-06T06:01:53.1166667+00:00
Vineet S 325 Reputation points
1 answer

Is there a way to collect Synapse's Spark UI logs through an API?

Is there a way to automate the process to send get request to receive bearer token for this API:…

Azure API Management
Azure API Management
An Azure service that provides a hybrid, multi-cloud management platform for APIs.
1,930 questions
Azure Synapse Analytics
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,653 questions
asked 2024-07-05T20:25:12.74+00:00
S 0 Reputation points Microsoft Intern
answered 2024-07-05T21:46:24.11+00:00
Sina Salam 6,966 Reputation points
1 answer

How to Handle Errors and Row Counts in Synapse Stored Procedures

I'm migrating a stored procedure from a Data Warehouse to Azure Synapse Dedicated SQL pool. The procedure uses @@error and @@rowcount variables, which are not supported in Synapse. Are there alternative ways to achieve the same functionality without…

Azure Synapse Analytics
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,653 questions
asked 2024-07-02T13:05:32.38+00:00
vikranth-0706 200 Reputation points
edited a comment 2024-07-05T16:03:12.93+00:00
BhargavaGunnam-MSFT 28,931 Reputation points Microsoft Employee
1 answer

Error while creating linked service from Synapse to Dyanamics 365

I am trying to create Linked Service from Microsoft Synapse to Dynamics 365. While testing connect I am getting error ClientIpAddressNotAuthorized. We have licensed Microsft Synapse and trial version of Dynamics 365.

Azure Synapse Analytics
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,653 questions
asked 2024-07-03T06:15:50.9666667+00:00
Rakesh Gupta 0 Reputation points
commented 2024-07-05T08:55:55.94+00:00
Harishga 5,825 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Unable to use Synapse workspace features in Synapse Link for Dataverse when Synapse network is in private mode

Hi Team, We are using Synapse Link for Dataverse for syncing data from d365 to ADLS Gen2, which can be used for analytics in ADLS Gen2. As our Synapse analytics environment network is publically disabled and using…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,418 questions
Azure Synapse Analytics
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,653 questions
Dynamics 365 Training
Dynamics 365 Training
Dynamics 365: A Microsoft cloud-based business platform that provides customer relationship management and enterprise resource planning solutions.Training: Instruction to develop new skills.
73 questions
Microsoft Power Platform Training
Microsoft Power Platform Training
Microsoft Power Platform: An integrated set of Microsoft business intelligence services.Training: Instruction to develop new skills.
211 questions
Microsoft Dataverse Training
Microsoft Dataverse Training
Microsoft Dataverse: A Microsoft service that enables secure storage and management of data used by business apps. Previously known as Common Data Service.Training: Instruction to develop new skills.
15 questions
asked 2024-06-25T06:40:07.63+00:00
Sriram M 20 Reputation points
accepted 2024-07-04T19:02:13.46+00:00
Sriram M 20 Reputation points
2 answers One of the answers was accepted by the question author.

Share a self-hosted integration runtime with Azure Synapse

Hi, I want to use the same Integration Runtime in Azure Synapse as I am currently using in existing Data Factory pipelines. I managed to grant permission to Synapse by using the "Enter Manually" option and pasting the Managed Identty Object…

Azure Synapse Analytics
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,653 questions
asked 2020-07-20T11:15:58.977+00:00
Hans Olav Vogt Myklebust / Intility AS 31 Reputation points
edited a comment 2024-07-04T13:29:50.29+00:00
Militaru, Petrica 0 Reputation points
1 answer

Error publishing notebook.

I am trying to publish my notebook. I get the following error : CreateOrUpdateNotebook failed: BadRequest. The operation failed because the entity “notebookA” is being renamed to “notebookB”. A retry of rename from exact source to target may work”. It…

Azure Synapse Analytics
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,653 questions
asked 2024-05-30T17:31:34.6033333+00:00
Candy T 0 Reputation points
answered 2024-07-04T10:20:34.9733333+00:00
Jay Chandel 0 Reputation points
1 answer

What is the mechanism to implement SSL when connecting from a third party application or IPaas platforms to Azure Synapse database either in serverless sql pool or ded

How can we implement SSL between any IPass platform and Azure Synapse. Is it different when connecting to a serverless sql pool db vs dedicated sql pool db.

Azure Synapse Analytics
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,653 questions
asked 2024-07-04T05:05:33.12+00:00
Amit Chakraborty 0 Reputation points
answered 2024-07-04T07:45:52.1233333+00:00
Harishga 5,825 Reputation points Microsoft Vendor
0 answers

After some time, viewing pipeline log links lead to wrong page

This is something I consistently experience if I use the same Synapse Analytics Workspace for a decent amount of time: My workflow is: Monitor Pipeline Runs Click on a run of interest This shows me the pipeline that ran and all the individual steps…

Azure Synapse Analytics
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,653 questions
asked 2024-06-27T14:13:06.36+00:00
Andrew Chung 40 Reputation points Microsoft Employee
commented 2024-07-04T06:34:42.9133333+00:00
phemanth 8,480 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Do Apache Spark Pools have a Service Tag?

Our company is rolling out more restrictive network security groups and I wanted to see if we could have our Apache Spark Pools' traffic be allowed via a service tag. When I tried to trace the IP address of the pools, the IPs varied widely so a static IP…

Azure Synapse Analytics
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,653 questions
asked 2024-06-28T15:07:17.05+00:00
Andrew Chung 40 Reputation points Microsoft Employee
accepted 2024-07-03T11:11:32.6466667+00:00
Andrew Chung 40 Reputation points Microsoft Employee
2 answers

unable to connect synapse db

Hi, Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'tcp:ag-syn-bi-group-d.sql.azuresynapse.net,1433', Database: 'bronze', User: ''. Check the linked service configuration is correct, and make sure the SQL…

Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,897 questions
Azure Synapse Analytics
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,653 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,078 questions
asked 2024-07-02T14:07:35.56+00:00
Vineet S 325 Reputation points
commented 2024-07-03T11:08:57.7566667+00:00
Smaran Thoomu 12,355 Reputation points Microsoft Vendor
2 answers

CopyData in ForEach

Dear all, I want to use the copydata activity in my pipeline. I have a csv file in my storage account, which has the list of the data i want to pass into the copy activity. I create a lookup activity first and then I try to use ForEach and put the copy…

Azure Synapse Analytics
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,653 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,078 questions
asked 2024-06-27T09:48:48.74+00:00
Zhuoqiong Mo 40 Reputation points
edited a comment 2024-07-03T09:19:41.35+00:00
phemanth 8,480 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

How to send data into displayHTML function in Azure Synapse Analytics

Hi, As mentioned in this link https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-data-visualization I want to use D3.js to visualize my data. How do I send data from my pyspark dataframe into displayHTML() to visualize it?

Azure Synapse Analytics
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,653 questions
asked 2024-06-28T06:28:54.47+00:00
Raghul Kannan 146 Reputation points
accepted 2024-07-03T08:40:26.0066667+00:00
Raghul Kannan 146 Reputation points
0 answers

azure synapse

hey i try to get sdk call that return me the info about the Azure Active Directory i cant find the sdk call for this

Azure Synapse Analytics
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,653 questions
asked 2024-06-26T08:13:52.66+00:00
Tommy Mordehay 0 Reputation points
commented 2024-07-03T08:29:53.3366667+00:00
PRADEEPCHEEKATLA-MSFT 84,936 Reputation points Microsoft Employee
1 answer

ALTER TABLE ADD COLUMN changes made to Synapse Delta tables in a Notebook do not reflect in Lake Database

Running the following spark.sql("ALTER TABLE example_table ADD COLUMN example_column STRING") Successfully adds the column to the Delta table and this can be verified by running %%sql SELECT example_column FROM example_table However when…

Azure Synapse Analytics
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,653 questions
asked 2024-06-30T20:51:36.6366667+00:00
Francesca Lightbown 0 Reputation points
commented 2024-07-03T08:09:55.2433333+00:00
Smaran Thoomu 12,355 Reputation points Microsoft Vendor
1 answer

How can I enable Synapse Link on a source azure serverless sql db to connect to dedicated sql pool..

Context Our team is planning to regularly refresh our external valuations dedicated pool using staging data from our serverless sql database. To implement this I have created the dedicated sql pool and the azure sql db is ready with plenty of data. The…

Azure Synapse Analytics
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,653 questions
asked 2024-07-01T06:11:32.8433333+00:00
Michael Minto 25 Reputation points
edited a comment 2024-07-03T06:09:33.88+00:00
Harishga 5,825 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

CDM and synapse datawarehouse

Hi friends, I have some questions on CDM common data model and what use cases it best suited for ? Since CDM has attributes , entities and relationships does it fair to assume that we don't need to do data model such as star schema and snowflake schema?…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,418 questions
Azure Synapse Analytics
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,653 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,078 questions
asked 2024-07-02T18:13:42.5333333+00:00
Anshal 2,166 Reputation points
accepted 2024-07-03T04:55:11.18+00:00
Anshal 2,166 Reputation points
1 answer

how to fix an issue where records are not syncing from Dataverse to Azure Database intermittently?

Successfully generated a summary I am experiencing an issue where records are not syncing from Dataverse to Azure Database intermittently, specifically for the Payment (evx_payment) entity. The affected records only sync when the customer manually…

Azure SQL Database
Azure Synapse Analytics
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,653 questions
Microsoft Dataverse Training
Microsoft Dataverse Training
Microsoft Dataverse: A Microsoft service that enables secure storage and management of data used by business apps. Previously known as Common Data Service.Training: Instruction to develop new skills.
15 questions
asked 2024-07-02T21:16:35.34+00:00
Gustavo Mercado (LTIMINDTREE LIMITED) 20 Reputation points Microsoft Vendor
answered 2024-07-02T23:33:25.1+00:00
Gustavo Mercado (LTIMINDTREE LIMITED) 20 Reputation points Microsoft Vendor