Issue when creating teradataml DataFrame from a table in non-default database - Issue while Creating a teradataml DataFrame from a Table in Non-Default Database - 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
March 2024
Language
English (United States)
Last Update
2024-04-09
dita:mapPath
nvi1706202040305.ditamap
dita:ditavalPath
plt1683835213376.ditaval
dita:id
rkb1531260709148
Product Category
Teradata Vantage

Description

teradataml user may encounter an error when the user tries to create a teradataml DataFrame from a table in a non-default database as "[Error 3524] The user does not have CREATE VIEW access to database [user_db]."

Cause

User has revoked CREATE VIEW for each user on the user’s database.

Solution

Grant CREATE VIEW permission to the user who will work with zero PERM space.
 GRANT CREATE VIEW ON userid TO userid
User can use configure command to set the userid:
>>> from teradataml import configure
>>> configure.temp_view_database = "userid"