Collectives™ on Stack Overflow
Find centralized, trusted content and collaborate around the technologies you use most.
Learn more about Collectives 0votes
0answers
42views
How to set up cross tenant authentication using Service Principal without secret in ADF Linked service
I need to transfer data from an Azure SQL database in Tenant A to another Azure SQL database in Tenant B using Azure Data Factory. I want to use Service Principal authentication without relying on ...
Advice
0votes
0replies
26views
Exporting Azure synapse workspace artifacts
Just came across a task and had to do some digging to find the answer:How to export Azure Synapse artifacts, more specifically pipelines, conserving their folder hierarchy, when Git integration is ...
0votes
0answers
44views
PySpark 3.5.5 CharType in read.csv schema definition
I'm using a PySpark notebook inside of Azure Synapse.This is my schema definitionqcew_schema = StructType([ StructField( 'area_fips', dataType = CharType(5), ...
0votes
0answers
25views
Cross-subscription Synapse Spark query to a dedicated SQL Pool how to?
I want to query a different subscription SQL Pool using SPark can I just use the same syntax or is additional configuration neccesary and if so how to?df = spark.read.option(Constants.SERVER, "&...
- 287
1vote
0answers
34views
run single notebook with different objects lists dict parallel on spark, when called from master notebook in synapse
Anyone know how to call single notebook with different parameters parallel, and all notebooks should appear on spark UI to make the trouble shooting easier? I have one child notebook, calling from ...
- 11
0votes
0answers
99views
Content of directory on path 'https://xxx.dfs.core.windows.net/xxx/deltalake/stocks_partitioned/_delta_log/*.*' cannot be listed
When I try to access tables from a serverless SQL pool from my application I get the error.Msg 13807, Level 16, State 1, Line 1Content of directory on path 'https://xxx.dfs.core.windows.net/xxx/...
- 1,099
0votes
0answers
28views
Azure Synapse Delta Lake view can't be accessed in synapse for some user
I have a delta lake in azure blob storage.I want to read the data using serverless sql pool.My team mate already defined the views and he is able to access them without a problem.When I try to ...
0votes
0answers
27views
Azure Synapse Notebook - read parquet from Google Cloud
I have a Azure Synapse Notebook and want to read parquest files from google cloud. I created a linked service to the google cloud. This works fine: I can test the connection with success.But how can ...
0votes
0answers
89views
Using Service Principal authentication with vendor API in ADF
I need to extract data from a vendor API in Azure Data Factory using Service Principal authentication.In Web activity, I’m not sure what the correct resource value should be for external (non-...
0votes
0answers
68views
Query to get counts of data
I have SQL query that I'm trying to make work on Azure Synapse where the project is being built. But everything I try doesn't get the correct record count. The tables I have ingested onto Azure ...
- 45
0votes
0answers
76views
OData $expand keyword not working in Synapse Copy Activity with Azure Devops Analytics OData source
I'm working on a Synapse pipeline that pulls data from the Azure Devops OData feed. The base query works fine in both the browser and Synapse, but it seems to ignore the $expand portion of the query ...
- 1,070
1vote
1answer
99views
How to flatten multidimensional array in Azure Data Factory/Synapse
I want to extract "email" from JSON using ADF/Synapse.Below is the JSON that I want to flatten and extract all "email" which is in an object in a multidimensional array:{ "...
0votes
0answers
30views
Azure Data Flow - parse transformation of XML element with both attribute and value
Given XML with element that has both attribute and value, e.g.<root><elem attr="world">hello</elem></root>how can I parse both the attribute and the value in ...
- 181
0votes
1answer
66views
Why OPENROWSET with CosmosDB returns 'Incorrect secret value'?
I am trying to connect Synapse Analytics to an existing CosmosDB container. In official tutorials the code is simple,SELECT TOP 10 *FROM OPENROWSET( 'CosmosDB', 'Account=your-cosmosdb;...
- 116
0votes
0answers
52views
Execute long running job in synapse
I want to create a Synapse pipeline in which one of the activities is a lightweight, long-running job. Once it succeeds, the flow should proceed to the next activity. However, I don't see any activity ...
- 221
This tag is in a collective: a subcommunity defined by tags with relevant content and experts.
- The Overflow Blog
- Featured on Meta
Hot Network Questions
- What damages are recoverable for late delivery of a package?
- Why does LaTeX put the PDF tags for floats at the end of the document?
- What does "origin of the world" vulgo "Big Bang" mean?
- Why do I get so many applications from Mekelle university students?
- When exactly does the game clock start during an American football kickoff?
- Does the intersection of a variety with rational singularities with a smooth variety have rational singularities?
- Detect if any ping succeeds
- Fool a program it has a pty of specific size
- To pretwist or not between two solids and one stranded?
- Blind Spot Regarding the Correlation Coefficient
- What is the point of All In?
- Was the spittle and mud in John 9:6-7, symbolic, a catalyst to faith, or a required act of obedience?
- Why do my Raspberry Pi 5 SD cards have unwritable partition tables?
- Visualizing Different Coordinate Representations of Complex Numbers
- Why is the verb "to sic" conjugated with a double c rather than the more typical ck?
- Making a case for a defensive infantry wedge formation
- Can missed approach procedures be used for a PT?
- About \def parameter list
- Not Benny but close
- What physical changes to the mouth would cause problems with articulation?
- When doing a CASSCF calculation, why do we rotate by 90 degrees rather than by a different amount?
- Creating a spiral
- MinMaxStack - tracks minimum and maximum values
- Can a chocolate bar contain alcohol naturally?