Create Databases in Teradata VantageCloud Lake with SQL - Creating Databases with SQL - Teradata VantageCloud Lake

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.

GRANT SELECT ON Tables_Database TO Views_Database WITH GRANT OPTION;

Use the editor to create databases in VantageCloud Lake.

1. Log on as SYSDBA, and select the editor .
2. Enter the CREATE DATABASE syntax as in the following example:

   CREATE DATABASE name [ FROM database_name ] AS
   
     { PERMANENT | PERM } = { n | constant_expression } [ BYTES ]
       [ SKEW = { constant_expression | DEFAULT } [ PERCENT ] ]
   
     [ database_attribute [[,]...] [;]

3. Select Run.