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
  • Show
  • Describe
  • Analyze Compute / Drop Statistics
  • Refresh Table