What is the most optimal way to insert variant/object data into a snowflake table?

App Building
, ,
1

Hello, I have a snowflake table where a column is an array of objects.

How do I best set up a way for users to add/remove/edit objects into that column?

Is there some component that is best used to managing this kind of data?

2

Hey Jose! I'd probably recommend using a separate component for this. You can:

  1. Add a modal component to your app
  2. Inside the modal, add a JSON editor component and set the value to {{ table1.selectedRow.your_json_column }}
  3. Set the modal's "Hidden" property to true
  4. Add an event handler to your JSON column in your table to open the modal
  5. Let me know if you have any questions about this :slight_smile:


Screen Recording 2023-05-10 at 4.34.01 PM.mov