Is there a way to create column on the fly in Singlestore?

Help JSON
1

I am trying to load the unstructured data into the Singlestore. I am not sure what different kind of key pairs will be there will i will be loading as the column and data. The number of column may keep changing in the future as CRM is allowing client to add custom properties.

Is there a way to create column on the fly in Singlestore? Or I will have to go with the traditional SQL approach of creating column if it doesn’t exist.

2

For regular, structured relational columns, to add them, use ALTER TABLE. You can’t add a column at the time you are doing DDL (like an INSERT or UPSERT).

If you really need that capability, consider using a JSON column for the flexible or dynamic part of your schema, pleas some standard date/string/number etc. columns for the static part of your schema.