Hi @mdideles ,
To answer your query, yes, this is expected behavior.
Instead of attempting to control the exact number of files during export, consider using a wildcard to export data into multiple files. You can export up to 1 GB of table data to a single file; for larger datasets, using a wildcard will allow you to export data across multiple files, which may vary in size and can even exceed 1 GB.
Here are some documentation that might be helpful to you:
I hope the above information is helpful.