A Table node corresponds to either 1. A table in Resources, or 2. A tab in Projects. Resources and Projects could be stored in Cloud in an unordered, parallel way to optimize the ability to process big data. However, an application need clean neat and tabular data. That is where the concept of table node comes out. Table node allows you to directly access the data in resources and project and turn into Table, Charts and even Data science application, ensuring a hassle-free experience during app development.
You can find a list of Table Nodes at Left Tool Bar - Data Node - Table Node. For resources and projects that have multiple tables, click on them to expand. Hover on table nodes, you'll see a Preview button and a more button provides some quick operations including:
- Default Page Size: Set the default page size per page for this table node. This setting determines how many rows will be requested from the database.
- Get Table DataRetrieve table node data with certain page, search and order.
- Page Size: The number of results to display per page. A higher page size will show more results on a single page, while a lower value will show fewer.
- Page Number: The specific page (starting from 1) of results to display based on the defined Page Size. For example, if there are 400 rows and the Page Size is set to 100, selecting Page Number 3 will show results 201-300.
- Search Fields: Specifies the database columns or attributes that should be searched. This helps in narrowing down the search to specific fields rather than searching across all columns.
- Search Value: The actual text or value to search for within the chosen Search Fields. The database will return results that match or contain this value in the specified fields.
- Sorting Field: Determines the database column or attribute by which the results should be sorted. For example, if you choose a 'Date' field, the results will be sorted based on dates.
- Sorting Order: Determines the direction of the sort for the selected Sorting Field. Common values include 'Ascending' (A-Z, smallest to largest, or oldest to newest) and 'Descending' (Z-A, largest to smallest, or newest to oldest).
- Insert Table Rows Insert rows into table node data source. Specifically:
- Resource Table Node: Insert rows directly into the table in the resource that the current Table Node corresponds to.
- Data Prep Table Node: Inserting rows into Data Prep Table Nodes is not recommended. The table will be overwritten once the Data Prep is synced, and any rows you insert will be lost.
- Data Update: Triggered when the data node runs.
- Data Update Error: Triggered when errors occur as the data node runs.