Viewing Your Table Schema

Once you have created a Table in Decode, you can easily view its defined structure, known as the schema. Understanding the schema is helpful for several reasons:

• Verification: Confirming the columns you expect (Row Identifier, Static, Metadata, Dynamic) are set up correctly.
• Upload Preparation: Knowing the exact column names and structure helps ensure your spreadsheets align with the table's expectations before uploading.
• Troubleshooting: If uploads fail or data looks incorrect, reviewing the schema can help identify potential mismatches.
• Collaboration: Sharing the schema with team members ensures everyone understands how the data is organized.

How to View the Schema

1. Navigate to the Data Page.
2. Find the Table you want to inspect in the list of available tables on the left sidebar.
3. Click on the "Schema" button below the table name.
4. A dialog or panel will open, displaying the schema details.

Understanding the Schema View

The schema view provides a clear breakdown of your table's structure:

Table Schema View

• Row Identifier: The single unique key column for the table is explicitly shown, along with its data type.
• Metadata Columns: Lists all defined metadata columns (tags) associated with this table, including their names and descriptions (if provided).
• Static Columns: Displays all static columns, showing their names, data types, and descriptions.
• Dynamic Columns (if enabled): If you configured dynamic columns, this section shows the template structure for your periodic data.
  • It will visualize the nesting (if any), displaying group names and individual value names.
  • For each dynamic value, it also shows the defined Type (Number, Text, etc.) and Update Behavior (Overwrite, Add, Subtract).

This view gives you a complete snapshot of how Decode expects data to be structured for this specific table, both for unchanging attributes and for data that evolves over time.