> For the complete documentation index, see [llms.txt](https://community-test.logicnets.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://community-test.logicnets.com/release-9/platform-documentation/data-and-data-tables/create-temporary-table.md).

# Create Temporary Table

Within the data table feature set, you can now create a temporary table based on dynamic selection from a static resource table. These are often referred to in SQLite as in-memory tables/views and the system cleans them up after the call to the server is finished.

### Use

You can choose to query and show data from static resource tables, shared data sources at the package or company level, views, and temporary tables. Temporary tables are helpful when multiple users are accessing data stored in multiple base tables. It is possible to set up query joins and have the temporary table dynamically pull relevant records.

### Steps to Create a Temporary Table

1. From within the project/data folder click the 'New table' icon.

   ![](https://2802811211-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdFhfexCjZ5JMhwGzzywq%2Fuploads%2Fgit-blob-7d186406fd041da564eb7b49bda1906f4d1198dd%2F054ffe63-121f-4999-b6cf-a17af2424027.png?alt=media)
2. From the data main panel select ***Create temporary table*** from the *Mode* dropdown menu.
3. In *Source* field select the type/source of data table for which you are creating a temporary table. See [Data Tables in the Designer](/release-9/platform-documentation/data-and-data-tables/data-tables-in-the-designer.md) for more info about table sources.
4. In the *View name* field specify a name for the view.
5. In the *DDL* field enter the query required to create the temporary table view. Simple examples might be
   * SELECT \* from \[SOURCE\_TABLE] where user = $(username) -- text-based selection
   * SELECT \* from \[SOURCE\_TABLE] where id in ($(value\_list)) -- string-based selection where value\_list = "apple", "banana"
   * SELECT \* from \[SOURCE\_TABLE] where age >= $(input\_value) -- number-based selection
     * For numeric selections you can use the default value feature and specify *$(input\_value:0)*
6. Click ***add*** to complete the operation. You can review the SELECT statement but not edit it. If you need to change it, just delete the table and recreate it with the corrected DDL.

![](https://2802811211-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdFhfexCjZ5JMhwGzzywq%2Fuploads%2Fgit-blob-e2e73605f7e47c6cd7f160e47fbd3eacf4280a99%2Fde939ea9-1439-4488-bd87-ffc48ec5ccff.png?alt=media)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://community-test.logicnets.com/release-9/platform-documentation/data-and-data-tables/create-temporary-table.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.