Intro to Input Tables
Input tables are dynamic workbook elements that support structured data entry. They allow you to integrate new data points into your analysis and augment existing data from Snowflake to facilitate rapid prototyping, advanced modeling, forecasting, what-if analysis, and more—without overwriting source data.
You can use input tables as sources for other elements (e.g., grouping tables, pivot tables, and visualizations) or incorporate the data using lookups and joins. And when you create warehouse views for input tables, you can reuse the manually entered data across your broader data ecosystem.
This document introduces empty and linked input tables, which support a variety of use cases for ad hoc data entry. For information about creating and interacting with input tables, see Create and Manage Input Tables and Edit Input Table Data.
Contents
Input Table Overview
Input tables give you the ability to do the following:
- Add rows (empty input tables only)
- Add columns (text, number, date, and logical)
- Input values through keyboard entry
- Paste values in up to 12,500 cells at once
- Configure data entry permissions
- Configure data validation
- Protect columns to prevent edits
- Add row edit history
For information about using this functionality, see Create and Manage Input Tables.
Empty Input Tables
Empty input tables support data entry in standalone tables independent of existing data. All cells in an empty input table are editable, and you can add rows and columns to construct your table as you see fit.
Linked Input Tables
Linked input tables support data entry alongside data from Snowflake or other data elements in the same workbook.
As a child element, a linked input table includes one or more columns that reference source columns in the parent element. This includes a primary key column, which provides row identifiers that define the input table's granularity and link manually entered data to existing data in the parent element.
Maintaining the data relationship between the input table and parent element requires the primary key column to reference static data in the parent element. All other linked columns can reference variable data, which is continually updated in the input table to reflect live data from the root source.
