I'm trying to use Snowflake's Go driver to start a Read-Only transaction, but received a 263000 (0A000): no readonly mode is supported. This is returned by: https://github.com/snowflakedb/gosnowflake/blob/e08419dfe80500613bda2f4e9be6ad17f7107881/connection.go#L162-L167.

Just wondering if this a limitation of the Go driver, or the Snowflake system itself?

In Go's database/sql package, you can start a Read-Only transaction by running the following code:

db.BeginTxx(ctx, &sql.TxOptions{ReadOnly: true})

This is useful when you want to guard against accidental writes during your transaction. However, not sure if Snowflake allows this.