When you have write access to Lake Formation, you can write data to Lake Formation using Amazon S3 V2 Connector. You can read from multiple data sources, apply transformations, and write to Lake Formation.

After you write to Lake Formation, use a crawler to populate the AWS Glue data catalog with external tables. The crawler crawls multiple data stores in a single run and creates or updates one or more external tables in the Glue data catalog. For more information, see the AWS documentation.

The following image shows the Joiner transformation that you can use to combine data from Marketo and Amazon S3 sources and create a Lake Formation target: