SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
412 questions
1 answer
One of the answers was accepted by the question author.
Ingesting data from Azure Synapse Analytics to Azure SQl VM database
Hi I am about to get some data in the Azure Synapse Analytics from dataverse ( via Azure Synapse link) Azure Syanpse Link can only write to Datalake or Syanpse . I have a question,. ****How data can be brought to another SQL from Azure Synapse Analytics…
SQL Server on Azure Virtual Machines
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,361 questions
Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
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.
5,385 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,662 questions
asked 2022-06-14T01:35:29.097+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 72%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
John K
186
Reputation points
commented 2022-06-14T06:03:06.407+00:00
Ronen Ariely
15,206
Reputation points
2 answers
One of the answers was accepted by the question author.
Schema specific Admin permission for Azure Synapse
Hi, Is this possible for a Schema specific Admin permission for Azure Synapse sqlpool. Say we have 3 schemas in sqlpool. We want to add specific AD group to be the admin of a particular schema. Thanks, Anirban
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,385 questions
asked 2022-06-10T18:31:27.837+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 12%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
Maitra-v, Anirban
141
Reputation points
accepted 2022-06-13T17:08:53.543+00:00
Maitra-v, Anirban
141
Reputation points
3 answers
One of the answers was accepted by the question author.
Polybase - Load CSV file that contains text column with commas surrounded by quotes
I'm trying to load a CSV file using Polybase into Synapse. Here is a sample file product_id,product_name,aisle_id,department_id 1,Chocolate Sandwich Cookies,61,19 2,All-Seasons Salt,104,13 3,Robust Golden Unsweetened Oolong Tea,94,7 4,Smart Ones…
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,385 questions
asked 2020-10-06T13:29:07.16+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 40%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESU%3C/text%3E%3C/svg%3E)
satish umapathy
26
Reputation points
commented 2022-06-13T16:25:38.193+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 42%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sakthivel R
1
Reputation point
1 answer
Syanpse Pipeline Call stored procedure using SQL Pool
I'm capturing audit log for success / failure activities when moving data from parquet to sql pool db. Activities are running in parallel but few cases, there are no audit getting written to table. Pipeline shows success but still no entry in db. 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.
5,385 questions
asked 2022-06-10T12:25:01.087+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPJ%3C/text%3E%3C/svg%3E)
Puran Joshi
1
Reputation point
commented 2022-06-13T12:05:45.937+00:00
AnnuKumari-MSFT
34,561
Reputation points Microsoft Employee
Moderator
4 answers
Synapse SQL Serverless: How can I create a function that returns a single text value
Hi, I am using Synapse SQL Serverless and all I want to do is create a function that splits a string into rows using the STRING_SPLIT function and substitute those values into another string that has placeholders for those values. However, functions do…
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,385 questions
asked 2021-11-25T13:03:06.693+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 57.00000000000001%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESW%3C/text%3E%3C/svg%3E)
Sheed, Wayne
1
Reputation point
answered 2022-06-13T11:21:17.757+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
1 answer
Dedicated SQL pool
How to Load Data from ADLSGen2 to DedicatedSQlPool?
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,385 questions
asked 2022-05-31T13:12:30.883+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 28.999999999999996%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Rachit Pandya
21
Reputation points
commented 2022-06-13T05:23:24.737+00:00
PRADEEPCHEEKATLA
90,661
Reputation points
Moderator
2 answers
One of the answers was accepted by the question author.
Azure Synapse Spark pool pricing
When creating a Spark pool in Azure Synapse, the pricing is per hour. Is it real time hour (include idling hours) or just computing hour (when the cores actually run)?
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,385 questions
asked 2020-12-01T17:15:32.097+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 75%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
Minh NGUYEN
126
Reputation points
commented 2022-06-13T05:07:30.527+00:00
PRADEEPCHEEKATLA
90,661
Reputation points
Moderator
1 answer
SynapseML Computer Vision results as Failed to download image from input URL
Hello Team, I was following the tutorial - https://learn.microsoft.com/en-us/azure/synapse-analytics/machine-learning/tutorial-computer-vision-use-mmlspark I have my own file and below is the code %%pyspark import synapse.ml from…
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,385 questions
asked 2022-06-09T13:49:42.117+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 87%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Marri, Ananda Krishna
1
Reputation point
commented 2022-06-13T05:05:39.86+00:00
PRADEEPCHEEKATLA
90,661
Reputation points
Moderator
2 answers
Transaction can't be executed
I'm running a statement in Synapse and want to create a new table from a old table, rename both tables, and drop the old table in a transaction block, but it shows me the "111212;Operation cannot be performed within a transaction" error. Could…
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,385 questions
Developer technologies | Transact-SQL
4,707 questions
asked 2021-11-18T13:45:54.32+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 26%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYZ%3C/text%3E%3C/svg%3E)
Yumeng Zhang
1
Reputation point Microsoft Employee
commented 2022-06-10T15:47:37.12+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 90%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Antony Taylor
1
Reputation point
2 answers
Pros/ Cons having multiple Azure SQL Data bases in same Synapse SQL pool or single SQL database for same client?
Hi All, I am going to create a new project for one of my client. Idea is to create 3 different databases like, STAGING,ENTERPRAISE and PRESENTATION DB's. Could you please assist me to go ahead with creation of these 3 diff DB's or can I create…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,361 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,385 questions
asked 2022-06-10T11:36:06.113+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 28.999999999999996%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKY%3C/text%3E%3C/svg%3E)
Kalidas Yerravarapu
26
Reputation points
answered 2022-06-10T15:26:05.76+00:00
Kalidas Yerravarapu
26
Reputation points
3 answers
how to know the size of sql dedicated pool in synapse
I am using DW200C in my SQL dedicated pool. In my reporting side, getting data very slow and performance also not that much great. I need to know the size of Azure Synapse SQL dedicated Pool and need to check the performance imrpovement based on the…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,361 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,385 questions
asked 2022-05-24T20:20:19.177+00:00
Kalidas Yerravarapu
26
Reputation points
answered 2022-06-10T11:07:42.99+00:00
Kalidas Yerravarapu
26
Reputation points
1 answer
Synapse Pipeline Script activty Fails after 30 mins.
Hi, I have a couple of Synapse pipelines with different Script activity to execute scripts against Synapse dedicated pool. Whenever the script runs for more than 30 mins, the activity is failing with the following error: The error message is misleading…
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,385 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,662 questions
asked 2022-05-26T21:23:38.057+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 31%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Kalidass Murugesan
101
Reputation points
commented 2022-06-10T10:38:11.397+00:00
AnnuKumari-MSFT
34,561
Reputation points Microsoft Employee
Moderator
1 answer
One of the answers was accepted by the question author.
drop table as parameters in synapse dedicated sql pool with pre-copy script using sink side of copy data activity.
I am loading data into a synapse database with the help of copy data activity, but here on the Sink side, I am auto creating tables every time. For that, I need to drop the existing table and recreate the table. For this purpose, I am using a pre-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.
5,385 questions
asked 2022-06-08T19:07:29.387+00:00
Vaibhav B
31
Reputation points
commented 2022-06-10T10:34:31.397+00:00
AnnuKumari-MSFT
34,561
Reputation points Microsoft Employee
Moderator
1 answer
Spark Synapse could not create a session
When i try to attach and run my notebook on spark cluster, it returns the error message "LivyHttpRequestFailure: Something went wrong while processing your request. Please try again later. HTTP status code: 500. Trace ID:…
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,385 questions
asked 2022-06-01T12:27:08.543+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 57.99999999999999%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Projjetta
1
Reputation point
commented 2022-06-10T10:18:51.307+00:00
AnnuKumari-MSFT
34,561
Reputation points Microsoft Employee
Moderator
1 answer
Not able to view tables of dedicated SQL Pool in SSMS
I am able to see my tables in Azure synapse studio but its not visible in SQL server management studio. Though I can see data by executing queries but tables of dedicated SQL Pools not visible
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,385 questions
asked 2022-06-04T16:16:07.227+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 72%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vikash Kumar
1
Reputation point
commented 2022-06-09T15:01:05.443+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 12%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Subashri Vasudevan
11,231
Reputation points
1 answer
How to sync multiple table in bulk copy
Hi, I use bulk copy to copy entire table from SQL database into Synapse database using pipeline. Now I want to make a sync of all table so auto upsert will execute on pipeline. Thanks, Ranjeet
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,385 questions
asked 2022-06-01T10:55:24.51+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 73%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Ranjeet Mendhekar
1
Reputation point
commented 2022-06-09T13:25:32.287+00:00
AnnuKumari-MSFT
34,561
Reputation points Microsoft Employee
Moderator
1 answer
Notebook fails in pipeline due to error 6002 , user error
Notebooks run fine with normal run, but when used in pipeline it fails. The reason for fail is unknown but causes of error is data write in csv. Data write is working fine normally but breaks in pipelne. all access control in security assigned to self…
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,563 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,385 questions
asked 2022-06-03T13:40:54.59+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 45%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Jha, Ayush
16
Reputation points
commented 2022-06-08T20:35:18.777+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT
46,647
Reputation points Microsoft Employee
Moderator
1 answer
Not able to create ingestion pipeline.
I am learning Azure Data Fundamentals and following the instructions given in the exercise https://learn.microsoft.com/en-us/learn/modules/examine-components-of-modern-data-warehouse/5-exercise-azure-synapse but stuck at data ingestion pipeline part. …
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,385 questions
asked 2022-06-08T07:56:23.807+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 49%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETB%3C/text%3E%3C/svg%3E)
Tarun Bali
1
Reputation point
commented 2022-06-08T17:09:38.773+00:00
ShaikMaheer-MSFT
38,551
Reputation points Microsoft Employee
Moderator
1 answer
One of the answers was accepted by the question author.
Synapse pipeline lookup activity - Select statement with where condition which compares string with '-'
In synapse pipeline I am using look up activity which reads data from Azure SQL Database. SELECT statement has WHERE condition which compares PipelineRunId. PipelineRunId Example: a3de6326-8af4-43e9-a90e-d2e123f7e6fe Below is the SELECT…
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,385 questions
asked 2022-06-08T16:16:14.18+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 52%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHD%3C/text%3E%3C/svg%3E)
Heta Desai
357
Reputation points
commented 2022-06-08T16:42:59.24+00:00
Heta Desai
357
Reputation points
0 answers
What is the best way to read DBF Files from Data Lake gen 2 into Synapse Analytics Notbook with Pyspark?
Hello community, we have many DBF-Files (FoxBase+/dBase III DBF) in our Data Lake gen2, that has been loaded through Synapse Pipelines. We are currently trying to find the best way to load these files with Pyspark to our Synapse Notebook and…
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,563 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,385 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 9%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZK%3C/text%3E%3C/svg%3E)