create_temp_view() | DataFrames | Teradata Python Package - create_temp_view() - Teradata Package for Python

Teradata® Package for Python User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Package for Python
Release Number
20.00
Published
December 2024
ft:locale
en-US
ft:lastEdition
2025-01-23
dita:mapPath
nvi1706202040305.ditamap
dita:ditavalPath
plt1683835213376.ditaval
dita:id
rkb1531260709148
Product Category
Teradata Vantage

Use create_temp_view() to create a temporary view for session on the DataFrame.

Raises OperationalError (when view already exists).

Required argument:
  • name specifies the name of the temporary view.

    Types: str

Example Setup

Load the data to run the example.

>>> load_example_data("dataframe", "admissions_train")
>>> df = DataFrame("admissions_train")
>>> df
    masters   gpa     stats programming  admitted
id
38     yes  2.65  Advanced    Beginner         1
7      yes  2.33    Novice      Novice         1
26     yes  3.57  Advanced    Advanced         1
17      no  3.83  Advanced    Advanced         1
34     yes  3.85  Advanced    Beginner         0
13      no  4.00  Advanced      Novice         1
32     yes  3.46  Advanced    Beginner         0
11      no  3.13  Advanced    Advanced         1
15     yes  4.00  Advanced    Advanced         1
36      no  3.00  Advanced      Novice         0

Example 1: Create view 'new_admissions'

>>> df.create_temp_view("new_admissions")
>>> new_df = DataFrame("new_admissions")
>>> new_df
    masters   gpa     stats programming  admitted
id
38     yes  2.65  Advanced    Beginner         1
7      yes  2.33    Novice      Novice         1
26     yes  3.57  Advanced    Advanced         1
17      no  3.83  Advanced    Advanced         1
34     yes  3.85  Advanced    Beginner         0
13      no  4.00  Advanced      Novice         1
32     yes  3.46  Advanced    Beginner         0
11      no  3.13  Advanced    Advanced         1
15     yes  4.00  Advanced    Advanced         1
36      no  3.00  Advanced      Novice         0