Currently we can only set Type/Bucket page size with Java API. It would be great If we can do the same with SQL. Here is the relevant discussions on Discord https://discord.com/channels/883057780553052180/883057780553052184/1178065425439920168