villebro commented on a change in pull request #8867: Make schema name for the
CTA queries and limit configurable
URL:
https://github.com/apache/incubator-superset/pull/8867#discussion_r374889991
##########
File path: superset/config.py
##########
@@ -517,6 +522,33 @@ class CeleryConfig: # pylint:
disable=too-few-public-methods
# timeout.
SQLLAB_QUERY_COST_ESTIMATE_TIMEOUT = 10 # seconds
+# Flag that controls if limit should be enforced on the CTA (create table as
queries).
+SQLLAB_CTA_NO_LIMIT = False
+
+# This allows you to define custom logic around the "CREATE TABLE AS" or CTAS
feature
+# in SQL Lab that defines where the target schema should be for a given user.
+# Database `CTAS Schema` has a precedence over this setting.
+# Example below returns a username and CTA queries will write tables into the
schema
+# name `username`
+# SQLLAB_CTA_SCHEMA_NAME_FUNC = lambda database, user, schema, sql:
user.username
+# This is move involved example where depending on the database you can
leverage data
+# available to assign schema for the CTA query:
+# def compute_schema_name(database: Database, user: User, schema: str, sql:
str) -> str:
+# if database.name == 'mysql_payments_slave':
+# return 'tmp_superset_schema'
+# if database.name == 'presto_gold':
+# return user.username
+# if database.name == 'analytics':
+# if 'analytics' in [r.name for r in user.roles]:
+# return 'analytics_cta'
+# else:
+# return f'tmp_{schema}'
+# Function accepts database object, user object, schema name and sql that will
be run.
Review comment:
Nice comprehensive example 👍
----------------------------------------------------------------
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:
[email protected]
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
