Thanks for the explanations. I would like to explore more possibilities with LOAD DATA. From a data lake perspective, information generally remains as pure data and is often stored in different places. How could LOAD DATA act in situations like this?

Example 1: I have thousands of CSV files on different disks that are accessible via the network. What would be the syntax to perform the load with LOAD DATA?

Example 2: log files available on cloud storage (S3, Google Storage, etc.)
Would the routine to load these files also be through LOAD DATA?

thanks