Stream data to MotherDuck from Streamkap
*
to read all files in a folder. This will enable MotherDuck to automatically pick up new files as they are written to the S3 bucket.
Here is an example SQL query to read data from your S3 bucket (using a wildcard for streaming):