Create Databases in VantageCloud Lake | VantageCloud Lake - Creating Databases - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Teradata recommends that you create top-level databases to separate tables and views. You can create additional lower-level databases within the top-level databases as required by site security policy and user access needs. For example, lower-level databases can be based on organizations.

Database Description
Tables_Database
  • Owns perm space.
  • Contains all tables and data.
  • Normally accessible only to privileged administrative and batch users for creating and modifying database objects or performing data loads and updates.
Views_Database
  • Requires minimal perm space because it does not contain data.
  • Contains views of the tables in the Tables_Database.
  • Exists primarily to provide SELECT access to the data for all users.
Where security policy requires it, you can designate a layer of views for load and update operations so that even batch users do not need to directly access data tables.
You must grant table access privileges to each views database to allow the views within each database to access tables in the Tables database. The following is an example of the command:
GRANT SELECT ON Tables_Database TO Views_Database WITH GRANT OPTION;

You use Editor to create databases in VantageCloud Lake.

  1. Log on as SYSDBA, and select Editor.
  2. Enter the CREATE DATABASE syntax. The following is an example of the syntax:
    CREATE DATABASE name [ FROM database_name ] AS

  { PERMANENT | PERM } = { n | constant_expression } [ BYTES ]
    [ SKEW = { constant_expression | DEFAULT } [ PERCENT ] ]

  [ database_attribute [[,]...] [;]
  3. Select Run.