Uncategorized – SQL Smarts

Azure Databricks Spark Uncategorized

Associative Grouping using Spark (Part 3)

This is part of series of posts about associative grouping: Part 1 – Associative Grouping using tSQL Recursive CTE’s Part 2 – Associative Grouping using tSQL Graph In the first two parts of this series we looked at how we could use recursive CTE’s and SQL Server’s graph functionality to Read more…

By Niall, 1 yearSeptember 30, 2021 ago

Azure Data Factory Uncategorized

Azure Data Factory: Making Non-Dynamic Linked Services Dynamic

One of my clients has been adding data from multiple Salesforce instances to their data platform this week. One of their developers asked me if the Salesforce linked service could be made dynamic, as there is no place in the GUI to add parameters, or a dynamic values for the URL, user name or credentials. Here’s how we can do that.

By Niall, 2 yearsMay 12, 2021 ago