4,653 questions with Azure Synapse Analytics tags

Sort by: Updated
Updated Created Answers
2 answers

How to make manual failover to Azure Gen2 namespace enabled for disaster recovery plan

As a disaster recovery drill test for Azure adls namespace enabled accounts . I could see failover option for blob storage and but for adls namespace enabled accounts the failover option is disabled. Can anyone help in know how to do failover for Azure…

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
asked 2024-07-14T14:41:54.67+00:00
Krishna 0 Reputation points
commented 2024-07-14T15:36:06.8166667+00:00
Krishna 0 Reputation points
2 answers One of the answers was accepted by the question author.

synapse dedicated pool database size

What is the right way to find the database size, table's size, and other objects, the db size that is being billed by azure? Also where can be find the space occupied by the external tables(meta data)?

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-01-19T06:31:06.9466667+00:00
Vinodh247 12,831 Reputation points
commented 2024-07-14T14:25:01.9066667+00:00
Sharma, Rahul 80 Reputation points
2 answers

Getting Azure Synapse Analitics Tables Size - Query on documentation does not return correct data

Hello, I've a Synapase Workspace with a Sql Pool that has a SQL Server version 12.0.2000 . My requirement is to get the phisical space storage for each table in my database. Many peoples pointed me at…

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
asked 2023-03-20T14:37:18.55+00:00
F N 20 Reputation points
commented 2024-07-14T13:03:04.0166667+00:00
Sharma, Rahul 80 Reputation points
1 answer One of the answers was accepted by the question author.

Import A website data as a table in ms fabric

i have a website i want to import as table and store in the datalake . its possible in power bi we can see as a table view, please give me a solution 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
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,077 questions
Microsoft Fabric Training
Microsoft Fabric Training
Microsoft Fabric: A Microsoft unified data platform.Training: Instruction to develop new skills.
28 questions
asked 2024-07-14T08:58:30.28+00:00
shafeeq pk 0 Reputation points
accepted 2024-07-14T12:32:14.35+00:00
shafeeq pk 0 Reputation points
1 answer

How to copy the files from private github repo to a Azure blob storage

We have incoming files in the GitHub repo and the task is to ingest these files to Azure blob using Synapse. The file ingested to Blob in a container supposes that if we have the same file of the 2 different versions, the final version should only be…

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,599 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-13T16:47:49.3266667+00:00
Mahantha MV 0 Reputation points
edited an answer 2024-07-14T01:59:46.4133333+00:00
Vinodh247 12,831 Reputation points
1 answer

Restore KekIdentity in Synapse Workspace

Hi, We deleted the managed identity for our synapse workspace that was the KekIdentity And now, when we open the workspace, none of the resources will load. I don't see any documentation on how to restore the KekIdentity for the Azure…

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-12T22:43:20.23+00:00
Dance, Cody R. (ALT) 20 Reputation points
answered 2024-07-13T12:15:23.1266667+00:00
Amira Bedhiafi 19,221 Reputation points
1 answer

PySpark in Azure Synapse notebooks is very slow to do API requests

I am doing api requests in a PySpark notebook in Azure Synapse Analytics. On my local env, in a Python3 kernel, the script is going lightning fast. But in Synapse, the pyspark notebook is very very slow in doing request (like 1 in 20 seconds when i…

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-12T16:07:22.09+00:00
Grégoire Mansio 0 Reputation points
answered 2024-07-13T09:04:51.3233333+00:00
Amira Bedhiafi 19,221 Reputation points
1 answer

Built in SQL server in synapse is unavailable

Hi, Even after changing the firewall settings, the built in SQL server status is unavailable. Someone please assist. Step-by-step solution would be really helpful. Thanks in advance.

Azure SQL Database
Azure Firewall
Azure Firewall
An Azure network security service that is used to protect Azure Virtual Network resources.
604 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
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,268 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,077 questions
asked 2024-07-13T05:40:54.8066667+00:00
shailaja Azure 0 Reputation points
edited an answer 2024-07-13T05:55:15.6433333+00:00
Andreas Baumgarten 103.2K Reputation points MVP
1 answer

How to assign a private IP address to Synapse Analytics studio?

I am facing an issue connecting to a private SFTP server through Synapse Notebook. So, I was thinking of assigning a private IP address to synapse studio and get that IP whitelisted on SFTP server so that I can connect to it from notebook as well as…

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-12T15:31:48.35+00:00
Piyush Vijayrao Magarde 0 Reputation points
answered 2024-07-12T15:59:22.7466667+00:00
akinbade abiola 8,215 Reputation points
2 answers One of the answers was accepted by the question author.

Want to migrate from one Synapse workspace to another Synapse workspace

Hi team, Want to migrate from one Synapse workspace to another Synapse workspace. One being Dev environment, another one test environment. Please provide leads. Regards, NagaSri

Azure Database Migration service
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 Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,059 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,077 questions
asked 2021-10-18T15:17:49.867+00:00
Naga 66 Reputation points
answered 2024-07-12T15:07:38.5833333+00:00
Mehdi Belkhiria 0 Reputation points Microsoft Employee
1 answer

How to Interpret Dataflow costs

How to interpret 'Azure Synapse Analytics - Dataflow' consumed quantity from monthly usage report? Any scenario based examples to estimate the pricing of Azure Synapse Analytics Dataflow?

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-12T10:40:36.92+00:00
AzureUser-9588 151 Reputation points
edited an answer 2024-07-12T11:33:02.1666667+00:00
Chandra Boorla 155 Reputation points Microsoft Vendor
5 answers One of the answers was accepted by the question author.

Synapse Analytics Event Trigger Activation Error

Storage event trigger activation fails with following error: Forbidden. Role based access check failed for resource <storage-account> Please help.

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-08-18T16:33:47.047+00:00
Chavi Gupta 36 Reputation points
edited a comment 2024-07-12T07:17:57.1466667+00:00
Venki Bimma 0 Reputation points
1 answer

Logic for consolidation of incremental DynamicsF&O Records in Azure Storage

We are using Power Apps with Azure Synapse Jobs to extract data from Dynamics 365 and incrementally push it into Azure Storage. The data syncing works well, but we are encountering issues with data consolidation. We have an Azure Function App set on a…

Azure Storage Explorer
Azure Storage Explorer
An Azure tool that is used to manage cloud storage resources on Windows, macOS, and Linux.
241 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
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-07-10T07:43:36.5166667+00:00
Haris Aqeel 0 Reputation points
edited the question 2024-07-12T06:49:59.5466667+00:00
JananiRamesh-MSFT 23,486 Reputation points
1 answer

Data is missing from management API using service principle. ex:resources

I have a requirement to load datasets from management.Azure.com (Management API), for example: Resources, Assessments, Tasks, and Secure Score. I have created a service principal in app registration and have been able to obtain the access token. However,…

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
Active Directory
Active Directory
A set of directory-based technologies included in Windows Server.
6,182 questions
asked 2024-07-11T22:11:50.9166667+00:00
Mahesh Reddy 0 Reputation points
answered 2024-07-12T06:04:27.1566667+00:00
Smaran Thoomu 12,355 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

Missing ODBC drivers on spark 3.3 & 3.4 version

Hi Team - We are upgrading our Spark version from 3.2 to 3.4 and using the pyodbc module for SQL operations. However, we are encountering the following error when attempting to connect to the Azure SQL Database. Could someone please assist…

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:55:19.18+00:00
Abhiram Duvvuru 231 Reputation points Microsoft Employee
accepted 2024-07-11T23:22:57.3733333+00:00
Abhiram Duvvuru 231 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

check a field value is not null in derived transformation in dataflow

I am checking if a field(column) has data that is not NULL. How do i use NOT ISNULL(field1) in derived transformation ? I want to convert following code in derived transformation example: iif( not isNULL(field1), field1, iif( not isnull(field2), field2,…

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,077 questions
asked 2024-07-09T17:16:30.26+00:00
Peruka, Sikander reddy 90 Reputation points
accepted 2024-07-11T15:49:02.5133333+00:00
Peruka, Sikander reddy 90 Reputation points
1 answer

Unable to connect Fivetran with public IP to ADLS Gen2 in Vnet with Private end point

Hi, I'm encountering an issue while trying to connect Fivetran to ADLS Gen2 in the UK South region. Here are the details: I have configured ADLS Gen2 as a destination in Fivetran and completed the prerequisites, including creating an SPN with appropriate…

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 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 Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,280 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 Network Watcher
Azure Network Watcher
An Azure service that is used to monitor, diagnose, and gain insights into network performance and health.
162 questions
asked 2024-07-01T13:39:20.48+00:00
Sriram M 20 Reputation points
commented 2024-07-11T14:03:23.3133333+00:00
Nehruji R 4,376 Reputation points Microsoft Vendor
0 answers

Unable to connect serverless sql from Arcgis Pro client (SQL Server Authentication)

It was stated in https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/get-started-ssms, SSMS is partially supported starting from version 18.5, you can use it to connect and query only. I able to use SSMS to connect to serverless sql. But,…

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-11T10:39:00.0366667+00:00
Yap Chun Hing 5 Reputation points
commented 2024-07-11T13:30:58.73+00:00
Harishga 5,825 Reputation points Microsoft Vendor
1 answer

How to upsert records from Azure Synapse dedicated SQL Pool table Dataverse table in Azure Data Factory?

I want to move data regularly from Synapse SQL pool to dynamics 365 dataverse, Everytime I do that I need to truncate the table in dataverse and run the pipeline in ADF, instead of truncating everytime I found we can do upsert to the dataverse…

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,077 questions
asked 2023-12-26T12:11:16.4066667+00:00
Anirudh Mounasamy 101 Reputation points
answered 2024-07-11T13:30:37.42+00:00
Burak Kaan Ozalp 0 Reputation points
1 answer One of the answers was accepted by the question author.

Reached the maximum number of Synapse workspaces for Azure Students

Reached the maximum number of Synapse workspaces allowed for this subscription. Please contact Microsoft support to request an exception. Subscription: ededc91b-601b-4aa9-bae1-df7da64b1d65. Subscription offer type: AzureForStudents_2018-01-01. Current…

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-01-11T17:21:45.0633333+00:00
Nori 35 Reputation points
commented 2024-07-11T11:19:00.5733333+00:00
Scott Tarvan 0 Reputation points