186 questions
Score of 0
0 answers
108 views
SQL Server Polybase importing parquet: Operand type clash: bigint is incompatible with datetime
We have a parquet file on S3 and are importing it into SQL Server 2022.
The issue is that mydatetimefield is a timestamp dtype (internally stored as bigint) in parquet file and the dtype on import ...
Score of 0
1 answer
705 views
Load data from Delta table and write to Synapse dedicated SQL pool
I'm working on a project where we are trying to load multiple tables from Delta table into Synapse dedicated pool. The reason why we need the data in SQL is because the apps that read it are using ....
Score of -1
1 answer
691 views
SQL Server PolyBase service fails to start
I'm running SQL Server 2022 Developer edition and want to use PolyBase to connect to some MongoDB database. However after installation I cannot seem to start the PolyBase Data Movement service.
It ...
Score of 0
1 answer
476 views
Polybase external table on Parquet file stored in Azure StorageV2
My goal is to create a Polybase external table from a Parquet file located in an Azure storage container.
SQL Server 2019 (RTM-CU22-GDR) (KB5029378) - 15.0.4326.1 (X64)
StorageV2 (general purpose v2) (...
Score of 0
1 answer
280 views
Unable to load data from on prem to Synapse using polybase/Copy Method
ADF, ADLS and Synapse all are in private end points and we are able to extract data from on prem and load into synapse using Bulk insert method in ADF copy Activity. But when using polybase/Copy ...
Score of 1
1 answer
236 views
CREATE EXTERNAL TABLE AS SELECT failing for Azure Blob Storage
I am attempting to export query results from Azure Synapse to Azure Blob Storage
CREATE EXTERNAL DATA SOURCE MyDataSource WITH (
LOCATION='wasb://[email protected]/',
...
Score of 0
0 answers
337 views
MS SQL external table running very slow
I have one external table that has only 2 columns and 3 rows in it and when i run query to fetch data using external table that take almost 15 mins to get the data. I am not sure why that much slow as ...
Score of 0
0 answers
353 views
Unable to read file in S3 bucket from SQL Server using Polybase
I need to be able to query csv/txt files in an S3 bucket from SQL Server.
I have enabled Polybase and successfully created a master key and scoped credential using an AWS access key and secret for the ...
Score of 0
1 answer
210 views
Can't create external data source for MongoDB in SQL Server 2022
I'm following the instructions in Configure PolyBase to access external data in MongoDB for SQL Server 2022, and get the following error when creating the external data source:
CREATE EXTERNAL DATA ...
Score of 0
1 answer
557 views
Polybase external data source for SQL Server
I'm having issues creating an external table in SQL Server which points to another SQL Server.
These are the steps I've taken:
CREATE EXTERNAL DATA SOURCE Polybase_ServerTest
WITH (
LOCATION = '...
Score of 0
3 answers
1140 views
SQL Server 2019 PolyBase - CREATE EXTERNAL DATA SOURCE returns unsupported URI
I am trying to create an external data source in SQL Server to an Azure Storage account. I have created the database scoped credential, but when I execute the CREATE EXTERNAL DATA SOURCE command, I ...
Score of 0
1 answer
303 views
Azure synapse dedicated SQL pools exports to ADLS storage account via polybase have .parq extensions instead of .parquet
Azure synapse dedicated SQL pools exports to ADLS storage account via polybase have .parq extensions instead of .parquet extensions.
CREATE EXTERNAL DATA SOURCE [SomeExternalDataSourcename]
WITH(TYPE=...
Score of 0
1 answer
236 views
Issue with Polybase-from synapse analytics DW on S3
I am trying to create an external data source from azure synapse DW to S3 compatible bucket/storage. But I am getting an error about the unsupported URI. As per the Microsoft documents, S3 is ...
Score of 0
1 answer
536 views
How to resolve authorization error while writing to synapse dedicated pool table from Azure Databricks using Pyspark using databricks service principl
I am using a databricks service principal which has
Storage Blob Data Contributor access on ADLS
db_datareader, db_datawriter, db_ddladmin permission on synapse dedicated sql pool
I am using below ...
Score of 0
1 answer
197 views
Polybase CETAS to Azure blob storage
I'm trying to write data to azure blob storage from a SQL 2022 VM, using polybase.
I'm using managed identity for authentication with blob storage, as the VM is in a different VNET to the storage, ...