Skip to content

Delete a Dataset or Internal View

You can only delete a dataset or internal view using DDL statements on the Workspace page or in another SQL editor.

Note: When you delete a dataset, the permissions set for that dataset in an Okera policy are not deleted.

To delete a dataset:

On the Workspace page, issue the following DDL statement DROP TABLE <database-name>.<dataset-name>, where <database-name> is the database in which the dataset is stored and <dataset-name> is the dataset name you want to drop from the database.

For example: DROP TABLE mydb.mydataset

To delete an internal view:

On the Workspace page, issue the following DDL statement DROP VIEW <database-name>.<view-name>, where <database-name> is the database in which the view is stored and <view-name> is the name of the internal view you want to drop from the database.

For example: DROP VIEW mydb.myview