Joining Queries in Azure Data Factory on Cosmos DB Sources
This article shows how you can use two Cosmos DB dataets in Azure Data Factory and join them on a common column.
2024-04-08
1,269 reads
This article shows how you can use two Cosmos DB dataets in Azure Data Factory and join them on a common column.
2024-04-08
1,269 reads
Learn how to get started with a Microsoft Fabric pipeline.
2023-08-02
4,331 reads
Learn how you can use CI/CD with your ADF Pipelines and Azure DevOps using ARM templates.
2023-03-10
12,675 reads
This article will show how you can use Azure Data Factory to check your data quality with an assertion.
2022-11-02 (first published: 2022-10-24)
3,809 reads
This article discusses the data flow formatters, Flatten, Parse, and Stringify, which can be useful when dealing with JSON data.
2022-08-12
13,778 reads
This article covers how you can give access with a shared key to Azure Storage Accounts and apply a policy for how users can access the files.
2022-06-15
8,108 reads
Get a few common questions and possible answers about Azure Data Factory that you may encounter in an interview.
2022-06-03
4,269 reads
Learn about using the Script activity in Azure Data Factory to run DDL or DML statements.
2022-05-13
17,648 reads
Learn about using Mapping Data Flows in Azure Data Factory.
2022-04-25
7,551 reads
Learn how you can re-use parts of your pipeline in Azure Data Factory. Save off some tasks as a flowlet for use in multiple pipelines.
2024-02-19 (first published: 2022-04-15)
7,236 reads
By Kevin3NF
Common Reasons for Emergency SQL calls If you are a production DBA (or Accidental...
By Steve Jones
I grabbed this book over the 2024 holiday season as it was on sale...
By Steve Jones
Investing small amounts of money over a long time works miracles, but no one...
When running clone sql is changing one specific table to History table and its...
Comments posted to this topic are about the item What is time?
Hello experts, The following SQL update is failing to install on some of our...
Consider the following script for a Sql Server database with Compatibility Level at least 130 (Sql Server 2016):
create table tjson ( id int primary key, j1 varchar(max), j2 varchar(max), j3 varchar(max)); insert into tjson (id, j1, j2, j3) values (1, '[{"c11":"value11A", "c12":"value12A"},{"c11":"value11B", "c12":"value12B"}]', '[{"c21":"value21A", "c22":"value22A"},{"c21":"value21B", "c22":"value22B"}]', '[{"c31":"value31A", "c32":"value32A"},{"c31":"value31B", "c32":"value32B"}]');How many rows does the Query Optimizer estimate for the following query?
select id, c1.c11, c2.c21, c2.c22, c3.c31, c3.c32 from tjson cross apply openjson(j1) with( c11 varchar(50) '$.c11', c12 varchar(50) '$.c12') c1 cross apply openjson(j2) with( c21 varchar(50) '$.c21', c22 varchar(50) '$.c22') c2 cross apply openjson(j3) with( c31 varchar(50) '$.c31', c32 varchar(50) '$.c32') c3;See possible answers