Remove a Dataset or Internal View

You can only remove a dataset or internal view from a database using SQL commands on the Workspace page or in another SQL editor. When you remove a dataset or view in Okera, you are not deleting the data; you are simply dropping the dataset or view from a database in Okera.

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

To remove a dataset:

On the Workspace page, issue the following SQL command 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 remove an internal view:

On the Workspace page, issue the following SQL command 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