ngram_token_size is a read-only variable, whose value can be set either in the start-up string:
mysqld --ngram_token_size=1
or in the MySQL configuration file. Neither of these 2 options are available in CloudSQL, as accessing local file systems is not allowed, and there is no super privilege.