Skip to main content

Key:value objects


1 comment

  • Sam

    Hi Steve,

    Short answer: You’re welcome to contact Support, but you can also solve this one yourself if you’d like.

    To provide some concrete context for other users, assume we have a sounds.playcount object with a key:value structure, like the following example:

    "playcount" {

    This kind of structure adds a new column for each key, which will very quickly cause the table to reach the 1600 column limit (in Redshift).

    To solve this, you need to:

    1. Add the column to the parent table.
    2. Change the Nested level configuration by setting Key:Value to true.

    In our example case, (1) Add the playcount column to the parent table. Let’s call it flowkey_users_songs for our example. The column type is varchar. We could use syntax like this:

    ALTER TABLE flowkey_users_songs ADD COLUMN playcount VARCHAR(256);

    After the column is created, (2) define it as a key:value column in the Panoply platform.


Please sign in to leave a comment.

Powered by Zendesk