Using DDL statements
Unified Analytics supports DDL statements to create a database schema and to define the type and structure of the data added to a database.
The following list contains the DDL statements that are currently supported through the Unified Analytics engine.
- Create/Drop/Alter/Use Database
- Create/Drop/Truncate Table
- Alter Table/Partition/Column
- Create/Drop/Alter View
- Create/Drop/Alter Materialized View
- Create/Drop/Alter Scheduled Query
- Create/Drop/Grant/Revoke Roles and Privileges
- Analyze Compute / Drop Statistics
- Refresh Table