5,576 questions

Sort by: Updated
1 answer

Self-hosted IR 5.66.9620.1 multiplies PostgreSQL numeric values by 10,000 (PostgreSQL 17.8 source)

We copy data from a PostgreSQL database to a Synapse dedicated SQL pool using the PostgreSQL V2 connector (linked service type PostgreSqlV2) through a self-hosted integration runtime. Against our new source server (PostgreSQL 17.8 on x86_64-windows,…

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.

5,576 questions
asked 2026-11-18T13:29:52.4566667+00:00
Jun Jie Lin 0 Reputation points
commented 2026-11-20T08:58:37.73+00:00
Jun Jie Lin 0 Reputation points
2 answers

Request for Clarification on Support for SQL Views, Stored Procedures, and Functions in Fabric Mirroring, Dataverse Link to Fabric, and Azure Synapse Link

We are evaluating data access options for Dynamics 365 Finance & Operations, including Direct AxDB Replica Access, Fabric Mirroring, Dataverse Link to Fabric, and Azure Synapse Link. Microsoft documentation clearly describes support for…

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.

5,576 questions
asked 2026-11-19T17:43:34.44+00:00
Asitha Mudiyanselage 0 Reputation points
answered 2026-11-19T18:28:53.07+00:00
Erland Sommarskog 137.7K Reputation points MVP Volunteer Moderator
1 answer

Can we execute a Stored procedure(Azure SQL DB) through synapse Notebook??

I have created stored Procedure which has Merge Statement to perform slowly changing dimension, I would like to execute this Stored procedure from synapse notebook. Is there any way to perform 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.

5,576 questions
Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

12,113 questions
asked 2022-08-23T10:54:48.037+00:00
Heta Desai 337 Reputation points
answered 2026-11-13T10:51:29.5633333+00:00
mouza mohammed 0 Reputation points
3 answers

Can't Create Database Scoped Credentials in Serverless synapse Database

When I run the below script, I am getting an error saying Incorrect syntax near IDENTITY

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.

5,576 questions
asked 2022-08-15T22:57:56.153+00:00
Teja.Gudipati 11 Reputation points
answered 2026-11-13T05:57:17.6+00:00
Vinodh247-1375 44,281 Reputation points Volunteer Moderator
0 answers

How to connect a dedicated sql pool with azure function

I would like to know how to use python in azure function to connect to synapse's dedicated SQL pool.

Azure Functions
Azure Functions

An Azure service that provides an event-driven serverless compute platform.

6,396 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.

5,576 questions
asked 2022-08-24T05:51:22.45+00:00
C-5961 736 Reputation points
1 answer

Synapse resource class for managed identity

Hi, Is there a possibility to assign the resource class to the Synapse managed identity when it manipulates the dedicated SQL pool data through its pipelines? Since the managed identity is a member of the Synapse Administrator role by default 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.

5,576 questions
asked 2022-07-13T19:53:31.6+00:00
Ljubo Jurkovic 26 Reputation points
edited an answer 2026-11-13T05:11:21.27+00:00
Ljubo Jurkovic 26 Reputation points
0 answers

Execute pipeline from pyspark

Hi, In serverless sql pool, I have a pyspark notebook in which I would like to execute the pipeline, pipeline1. How is this possible?

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.

5,576 questions
asked 2022-02-02T20:22:44.013+00:00
arkiboys 9,631 Reputation points
0 answers

Data Modeling in Azure

Hi All, I would really appreciate if someone please help me with Data Modeling books within Azure scope that entails various techniques such as dimensional modeling , data vault. Any good links would be also a great help. Thanks in advance.

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,576 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.

5,576 questions
Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

12,113 questions
asked 2021-12-03T12:23:03.003+00:00
Samy Abdul 3,356 Reputation points
0 answers

MOUNTING ADLS GEN2 ON SYNAPSE SPARK POOL

I want to mount datalake to specific mount point , want to read data from there , so i tried the below code mssparkutils.fs.mount( source = "abfss://******@adls.dfs.core.windows.net/", mountPoint = "/mnt/mdpdevfs", extraConfigs…

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,576 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.

5,576 questions
Azure Databricks
Azure Databricks

An Apache Spark-based analytics platform optimized for Azure.

2,994 questions
Developer technologies | .NET | Other
Developer technologies | .NET | Other

Microsoft Technologies based on the .NET software framework. Miscellaneous topics that do not fit into specific categories.

4,110 questions
asked 2021-10-29T20:11:49.25+00:00
Anonymous
0 answers

Connect Azure Synapse notebook to Azure SQL Database

I am not using SQL pools in Synapse instead I use only Azure SQL Database. My requirement is to read data from Azure SQL DB through Notebook do some transformations and save the output into Blob Storage. The pipeline in synapse studio is working well…

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.

5,576 questions
asked 2021-09-23T18:42:57.97+00:00
KNP 11 Reputation points
0 answers

How to load csv files from Sharepoint portal to data lake in azure synapse

I have a requirement to load csv files form a folder in our organization sharepoint portal into Data lake. Any specific connector or config set up required to create such pipeline?

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,576 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.

5,576 questions
asked 2021-08-25T16:52:36.333+00:00
Bhoopathiraju Deepthi 46 Reputation points
1 answer

External table creation based on table from another server

Hi, I am trying to create an External table in one database server , by accessing some table from another Remote Database server. Creation of External Data source as well as External table was successful. But when I try to query the External…

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.

5,576 questions
asked 2021-08-16T13:20:42.01+00:00
Gowri Shankar 211 Reputation points
edited an answer 2026-11-13T04:34:31.8033333+00:00
Gowri Shankar 211 Reputation points
1 answer

Does Azure Synapse Analytics have support for Python?

What I am trying to do? Glue-Athena-like process. Data in S3 AWS Glue (create metadata tables) Tables can be queried using Athena via boto3 (python library) Problem I am facing in Azure Cloud ~Trying to replicate the above process using…

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.

5,576 questions
asked 2021-06-08T00:26:04.873+00:00
Roohiya Dudekula 1 Reputation point
edited an answer 2026-11-13T04:31:37.6+00:00
Roohiya Dudekula 1 Reputation point
2 answers

Synapse Spark Pool write to Excel workbook on ADLS2 ?

How can I write from Synapse Spark Pool to Excel workbook (multiple sheets) on ADLS2 ? Something like Pandas ExcelWriter()

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.

5,576 questions
asked 2021-05-27T19:48:34.717+00:00
Jason Campbell 31 Reputation points
edited an answer 2026-11-13T04:30:44.4833333+00:00
Jason Campbell 31 Reputation points
0 answers

Azure Synapse data warehouse Connection string

I have a connection string for azure data warehouse synapse provided by a client. Im a total beginner and it would be a great help if someone could please explain the steps I have to take next to use this connection string to get access to the 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.

5,576 questions
Azure Databricks
Azure Databricks

An Apache Spark-based analytics platform optimized for Azure.

2,994 questions
asked 2021-04-06T06:51:39.95+00:00
Shawn Mathew 1 Reputation point
0 answers

Azure Synapse Serverless query error with Access check for 'CREATE/WRITE' operation against blob failed with HRESULT = '0x80070005'.

hi, i am trying to execute the below query and i getting error as HRESULT = '0x80070005'.: I have given "Storage Blob Data Contributor" access to synapse analytics resource. can anyone help me?. CREATE EXTERNAL TABLE…

Azure Blob Storage
Azure Blob Storage

An Azure service that stores unstructured data in the cloud as blobs.

3,350 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.

5,576 questions
asked 2021-03-22T17:15:31.067+00:00
Sangilimurugan S 31 Reputation points
0 answers

SharePoint linked service input is not a valid Base-64

Hello Team, We are trying to connect to a sharePoint list, when testing connection we are getting the below error message: The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal…

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.

5,576 questions
asked 2025-02-28T21:14:26.6466667+00:00
Minor Gómez 0 Reputation points
0 answers

sftp (restricted) from a pyspark notebook

Hello I need to access an sftp site from a pyspark notebook, however, this site is restricted and can be only accessed from a previously identifed IP address (whitelist) Is this posible? Thanks for your 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.

5,576 questions
asked 2024-09-25T07:57:10.07+00:00
Jon Z 125 Reputation points
1 answer

Synapse Workspace Notebooks - Upload files to sparkpools for google api credentials

I am working with Synapse Workspace Notebooks to import information from google API's. I need to upload credential files to the local directories on the synapse spark pools, I have not been able to figure out how to do that Uploading to azure storage…

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.

5,576 questions
asked 2020-11-12T15:09:08.453+00:00
Ana Del Campo 26 Reputation points Microsoft Employee
edited an answer 2026-11-13T04:04:22.22+00:00
Ana Del Campo 26 Reputation points Microsoft Employee
0 answers

synapse pyspark write dataframe to sql azure

I want to use Pyspark datawrite.write method to write dataframe to sql azure database with linked service. How can I achieve it?

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.

5,576 questions
asked 2024-07-26T23:35:52.9533333+00:00
Simon Zhang 6 Reputation points Microsoft Employee