My sincere apologies, I mistakenly ran tests on our redshift product.
I have raised an internal ticket to fix our documentation. Ticket reference: EMD-5136
This is a restriction of the Snowflake JDBC driver, it does not allow multiple ddl statements to be run as a Batch.
The only alternative (I found) to run a batch is to use SnowSQL (CLI Client).
If you intend to use it with matillion, SSH to the matillion instance and install SnowSQL. You may then use the bash script component to execute scripts hosted on the ec2-instance or on S3.