Enable CTAS and DROP table

1

Hi all, i am unable to find the option to enable CTAS and DROP table option.

image
image1216×790 41.1 KB

Dremio local installation running on docker on my laptop and am trying to write back to an S3 bucket.

2

It should be enabled by default if you’re on version >16.0 and on Community Edition. Try writing a table and see if it works (make sure the account that is connecting to S3 Source has Write permissions from an AWS perspective).

If you’re on version >16.0 and on Enterprise, then an Admin user may have to enable “CREATE TABLE” in the privileges section of the S3 Source.

image
image1872×624 40.7 KB

3

Thanks @lenoyjacob, you are right - the check box option doesn’t show as it is enabled by default on the community edition and am able to write back to my s3 bucket successfully.