[GitHub] [incubator-superset] bkyryliuk commented on pull request #12188: fix: CTAS on multiple statements

[GitBox <gi...@apache.org>]

bkyryliuk commented on pull request #12188:
URL: https://github.com/apache/incubator-superset/pull/12188#issuecomment-754139289


   +1 to this comment, we are actively leveraging it
   > > What would be an example use case for using CTAS ?
   > 
   > If you mean "why materialize a dataset?", the main reason is to create a summary and/or richer dataset to speed subsequent queries against this snapshot
   > 
   > If you mean "why using the Superset CTAS feature over simply writing your own `CREATE TABLE {} AS`" statement, it has to do with administrator/policy control. It's possible in Superset to NOT give DML access, but allow people to effectively do this in a controlled way, and even force a target location/naming scheme for the CTAS-generated table
   
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org