Split Dataset Into Files of n Records Each, Deliver via SFTP

It may not be pretty, and I'm currently going to a non-SFTP managed folder, but here is the code I've got working! Feedback is most definitely welcome!

%pylab inline

# -*- coding: utf-8 -*-
import dataiku
from dataiku import pandasutils as pdu
import pandas as pd

# Import the class that allows us to execute SQL on the Studio connections
from dataiku.core.sql import SQLExecutor2

# Get a handle on the input dataset
groupeddata = dataiku.Dataset("MY_DATASET")

# Write recipe outputs
outfolder = dataiku.Folder("FOLDER_ID")

# We create an executor. We pass to it the dataset instance. This way, the
# executor knows which SQL database should be targeted
executor = SQLExecutor2(dataset=groupeddata)

# Find the max value of the column to find out how many files we're working with
max_files = executor.query_to_df("""
SELECT MAX(GROUP_COLUMN) AS MaxGroupNumber
FROM MY_TABLE
""")

for index, maxGroup in max_files.itertuples():
maxGroups = maxGroup

for group in range (1, maxGroups + 1):

outData_df = executor.query_to_df(f"""
SELECT MY_COLUMNS_TO_SEND
FROM MY_TABLE
WHERE GROUP_COLUMN = {group}
""")

filename = f"Test_{group}.txt"

outfolder.upload_data(filename, outData_df.to_csv(index=False).encode("utf-8"))