Volatile tables must be created manually, by executing CREATE VOLATILE TABLE statements from the SQL Editor.
Volatile tables exist only during the session in which they are created. When a database session ends, Teradata Database automatically drops all volatile tables that were created during the session. After you have created a volatile table, use the Load Data wizard to import external data into the table.
- In the SQL Editor view, click . The Load Data to Volatile Table dialog opens.
- From the Volatile Table list, select the volatile table to which you want to import data, and click OK. Importing data to volatile tables is the purview of the Data Transfer perspective. The Switch Perspective dialog box may appear and offer to switch you to that perspective during this process. Switching perspectives is optional. The Data Transfer perspective shows the progress of the data import in the Progress Monitor view, and includes the Transfer History view, which may be helpful. After switching perspectives or dismissing the Switch Perspective dialog, the Data Transfer Wizard opens.
- In the Data Transfer Wizard, for Source Type chose External File (FastLoad), and click Launch. The Load Data Wizard opens.
- For File Type specify the format of the file that has the external data.
- For Input File, enter the name of the file, or click Browse to navigate to the file on your system or network. A sample of the data in the file is displayed in a tabular form preview of how the data will import to the table. If the sample data is not laying out correctly, use the controls in the wizard to specify how the data is formatted in the external file, and how you want the data to be parsed as it is imported to the database.
- Click Finish. The external data is imported to the volatile table.