Workspace name as dynamic content

Question: What does ETL always need in production?

Answer: Messaging on failures

Q: What is the best channel today?

A: Teams (and Email because you can make email rules easier)

Q: Can you do this in Fabric as of 2024/07?

A: Yes, messaging to Teams is in preview state.

What doesn't work:

• Data pipelines always use AND when combining several inputs. This means that you must use OR box to combine failures together before you report the failure. As Data Pipeline doesn't have an OR box, you must create failure reporting for every action separately.
• You can't copy-paste Teams-messaging or their content, so you have to make all of them manually one by one.
• I am not sure if can even copy paste functions, the UI is difficult.
• You can't tell what environment you are running the Data Pipeline: Dev, Test or Prod

Now this idea suggesting is on the last one:

• You can now drag Workspace ID to the Teams Message. This gets renamed as DataFactory for some reason, but don't get confused with that.
• Problem is that this ID is a cryptic key such as 8466c1bc-e477-415e-8b77-a714cd012345, so you need to add separately a decrypt table so people will know what environment was this run on.

So Data Pipeline should have "Workspace" or "Workspace name" dynamic content to choose from.