setting allow_experimental_object_type to migrate JSON type fields to Clickhouse DB

[samanshahroudi]

Your Question

How can I set the allow_experimental_object_type value before creating a table in Clickhouse DB using go-gorm library?

The document you expected this should be explained

I need to have a field of type Json in the Golang structure. According to this document https://clickhouse.com/docs/en/integrations/data-formats/json, I need to set the allow_experimental_object_type value to 1 before creating a table, but I couldn't find a way to set it using the go-gorm library.

Expected answer

I need a code snippet or a small workaround to set allow_experimental_object_type to 1 using go-gorm library, so I can automatically migrate the Golang struct to the Clickhouse table with the JSON field.

[mr-tron]

err = conn.Exec("set allow_experimental_object_type = 1").AutoMigrate(objects...)

[xuchen81]

having the same question, anyone can help?

[xuchen81]

err = conn.Exec("set allow_experimental_object_type = 1").AutoMigrate(objects...)

it does not work.

[movy]

Same happening on Clickhouse Cloud:

Very frustrating, but also hilarious since Clickhouse Cloud AI offered this query and failed to fix the error. So much for fancy blog posts....