Screenshot
Description
Tooltip / help text updates to the SQL Lab Settings on the Edit Database modal to be more descriptive
Updates:
Allow in SQL Lab:
Expose this DB in SQL Lab -> Allow this database to be queried in SQL Lab
Allow CTAS:
Allow CREATE TABLE AS option in SQL Lab -> Allow creation of new tables based on queries
Allow CVAS:
Allow CREATE VIEW AS option in SQL Lab -> Allow creation of new views based on queries
Allow DML:
Allow users to run non-SELECT statements (UPDATE, DELETE, CREATE, ...) -> Allow manipulation of the database using non-SELECT statements such as UPDATE, DELETE, CREATE, etc.
Allow Multi Schema Metadata Fetch:
Allow SQL Lab to fetch a list of all tables and all views across all database schemas. For large data warehouse with thousands of tables, this can be expensive and put strain on the system. -> no change
Screenshot
Description
Tooltip / help text updates to the SQL Lab Settings on the Edit Database modal to be more descriptive
Updates:
Allow in SQL Lab:
Expose this DB in SQL Lab -> Allow this database to be queried in SQL Lab
Allow CTAS:
Allow CREATE TABLE AS option in SQL Lab -> Allow creation of new tables based on queries
Allow CVAS:
Allow CREATE VIEW AS option in SQL Lab -> Allow creation of new views based on queries
Allow DML:
Allow users to run non-SELECT statements (UPDATE, DELETE, CREATE, ...) -> Allow manipulation of the database using non-SELECT statements such as UPDATE, DELETE, CREATE, etc.
Allow Multi Schema Metadata Fetch:
Allow SQL Lab to fetch a list of all tables and all views across all database schemas. For large data warehouse with thousands of tables, this can be expensive and put strain on the system. -> no change