Understanding Join output anchors and when to add a Union tool: The Join tool anchors are separate subsets of data. You can combine them with a Union tool. The Select functionality of the Join tool applies only to the J anchor, not the R or L anchored data.
When writing to Google BigQuery using the Google BigQuery Bulk data connection from the Data Connection Manager (DCM), you may encounter an error about GoogleCloudWriter having issues with retrieving the database name. This issue can be resolved by verifying the configuration in the DCM connection.
With the release of 2018.3 comes a very exciting new functionality – workflow caching! Caching can save a lot of time during workflow development by saving data at “checkpoints” in the workflow, so that each time you add a new step to your workflow, it does not need to rerun the workflow in its entirety, rather it can pick up from your last Cache point. There are a couple conditions where tools cannot be selected as cache points, including tools with multiple output anchors, and tools in "circles".
The SharePoint connector allows you to use Service Principal for downloading and uploading files, but it requires the Sites.All permission, which gives the user access to all the Sites in the tenant. This article describes how to set it up.