Shouldn't be a problem. I use a lot of Python in cases like these. As the splitting needs to happen on a smaller dimension file, it shouldn't be an issue outside of Azure to address it. The issue, is I really don't want to split the file outside because the delimiters are dynamic depending on business unit and can be multiple positions that may or may not be to split. This is why I liked using functions because it allowed me to apply functions to columns to split on a SELECT statement as needed. This was one of the very cool options that Azure seems to lack at the moment. Hopefully in time.