We are currently using Azure Blob as our file source and syncing data to BigQuery using Fivetran. Our use case involves:

• Ingesting multiple files from a container

• Each file having its own distinct schema

• Needing each file to map to a separate BigQuery table

• Automatically handling new file additions and name changes without manual connector duplication or reconfiguration

This functionality is currently available for S3 and GCS connectors through directory-to-table mapping, and it would greatly help our team if similar support could be enabled for Azure Blob as well.

If not available, are there recommended workarounds for dynamic file-to-table ingestion at scale on Azure Blob?