Optimal sweetness is achieved when the berry is fully ripe. Some berries actually may appear ready to pick when black and shiny, but with some varieties it is when they become less shiny that they are the sweetest.
If you decide to grow blackberries, be aware that the different varieties have varying levels of sweetness. Picking the berries later in the season will make them sweeter too.