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 Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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"