You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "bhavishya123 (via GitHub)" <gi...@apache.org> on 2025/07/15 09:41:37 UTC
[D] Export "ALLOW_FULL_CSV_EXPORT" not working in superset 4.1.3 [superset]
GitHub user bhavishya123 created a discussion: Export "ALLOW_FULL_CSV_EXPORT" not working in superset 4.1.3
Export "ALLOW_FULL_CSV_EXPORT" not working in superset 4.1.3
I am not able to view FULL_CSV_EXPORT view option .
I am using Helm based deployment
Additionally Row Limit for Table not increasing beyond default 50k
i am also sharing my values.yaml
image:
repository: apache/superset
tag: "4.1.3-dev"
pullPolicy: IfNotPresent
service:
type: LoadBalancer
port: 8088
annotations:
cloud.google.com/load-balancer-type: "Internal"
nodePort:
http: null
postgresql:
enabled: true
auth:
password: superset
redis:
enabled: true
init:
enabled: true
loadExamples: true
adminUser:
username: admin
password: admin
email: admin@example.com
supersetWorker:
enabled: true
replicas:
enabled: true
replicaCount: 1
# Enable Celery beat for scheduling
supersetCeleryBeat:
enabled: true
ingress:
enabled: false
bootstrapScript: |
#!/bin/bash
# Install required Python packages
pip install apache-superset[databricks]
configOverrides:
superset_config.py: |
import os
from celery.schedules import crontab
SECRET_KEY = 'brzq6qmA+aGBmgCu/ccccccccccccccccccccccc+jM1u'
# Enable alerts and reports
FEATURE_FLAGS = {
"DASHBOARD_NATIVE_FILTERS": True,
"ENABLE_TEMPLATE_PROCESSING": True,
"ALERT_REPORTS": True,
"ALERTS_ATTACH_REPORTS": True,
"SCHEDULED_QUERIES": True,
"ALLOW_FULL_CSV_EXPORT": True,
}
SQLALCHEMY_DATABASE_URI = 'postgresql+psycopg2://postgres:superset@superset-postgresql:5432/superset'
DEFAULT_TIME_FILTER = 'Last day'
ROW_LIMIT = 9000000
SAMPLES_ROW_LIMIT = 9000000
NATIVE_FILTER_DEFAULT_ROW_LIMIT = 9000000
FILTER_SELECT_ROW_LIMIT = 9000000
SQL_MAX_ROW = 9000000
DEFAULT_SQLLAB_LIMIT = 9000000
DISPLAY_MAX_ROW = 9000000
TABLE_VIZ_MAX_ROW_SERVER = 9000000
SQLLAB_CTAS_NO_LIMIT = True
# SendGrid email configuration
SMTP_HOST = 'smtp.sendgrid.net'
SMTP_PORT = 587
SMTP_USER = 'apikey'
SMTP_PASSWORD = 'SECRET_KEY'
SMTP_MAIL_FROM = 'test@gmail.com'
SMTP_STARTTLS = True
SMTP_SSL = False
# Enable email notifications and alerts
EMAIL_NOTIFICATIONS = True
ENABLE_ALERTS = True
# Configure Redis for caching
CACHE_CONFIG = {
'CACHE_TYPE': 'RedisCache',
'CACHE_DEFAULT_TIMEOUT': 300,
'CACHE_KEY_PREFIX': 'superset_',
'CACHE_REDIS_HOST': 'superset-redis-master',
'CACHE_REDIS_PORT': 6379,
'CACHE_REDIS_DB': 1,
}
# Email report configuration
EMAIL_REPORT_FROM_ADDRESS = 'test@gmail.com'
# Celery configuration for Redis
class CeleryConfig:
broker_url = 'redis://superset-redis-master:6379/0'
result_backend = 'redis://superset-redis-master:6379/0'
worker_prefetch_multiplier = 1
task_acks_late = False
task_annotations = {
'sql_lab.get_sql_results': {
'rate_limit': '100/s',
},
'email_reports.send': {
'rate_limit': '1/s',
'time_limit': 120,
'soft_time_limit': 150,
'bind': True,
},
}
beat_schedule = {
"reports.scheduler": {
"task": "reports.scheduler",
"schedule": crontab(minute="*", hour="*"),
},
"reports.prune_log": {
"task": "reports.prune_log",
"schedule": crontab(minute=0, hour=0),
},
}
CELERY_CONFIG = CeleryConfig
FILTER_STATE_CACHE_CONFIG = {
'CACHE_TYPE': 'RedisCache',
'CACHE_DEFAULT_TIMEOUT': 86400,
'CACHE_KEY_PREFIX': 'superset_filter_',
'CACHE_REDIS_HOST': 'superset-redis-master',
'CACHE_REDIS_PORT': 6379,
'CACHE_REDIS_DB': 2,
}
EXPLORE_FORM_DATA_CACHE_CONFIG = {
'CACHE_TYPE': 'RedisCache',
'CACHE_DEFAULT_TIMEOUT': 86400,
'CACHE_KEY_PREFIX': 'superset_explore_',
'CACHE_REDIS_HOST': 'superset-redis-master',
'CACHE_REDIS_PORT': 6379,
'CACHE_REDIS_DB': 3,
}
# WebDriver configuration for screenshots in email reports
WEBDRIVER_BASEURL = "http://superset:8088/"
WEBDRIVER_BASEURL_USER_FRIENDLY = "http://localhost:8088/"
# Screenshot configuration
SCREENSHOT_LOCATE_WAIT = 10
SCREENSHOT_LOAD_WAIT = 60
SCREENSHOT_SELENIUM_HEADLESS = True
CONTENT_SECURITY_POLICY_WARNING = False
# Reports configuration
ALERT_REPORTS_NOTIFICATION_DRY_RUN = False
WEBDRIVER_WINDOW = {"dashboard": (1600, 2000), "slice": (3000, 1200)}
<img width="513" height="652" alt="Screenshot 2025-07-15 at 3 06 52 PM" src="https://github.com/user-attachments/assets/0ef45a89-5aa3-445b-a930-bf2b6c994fa6" />
GitHub link: https://github.com/apache/superset/discussions/34169
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Export "ALLOW_FULL_CSV_EXPORT" not working in superset 4.1.3 [superset]
Posted by "bhavishya123 (via GitHub)" <gi...@apache.org>.
GitHub user bhavishya123 edited a discussion: Export "ALLOW_FULL_CSV_EXPORT" not working in superset 4.1.3
Export "ALLOW_FULL_CSV_EXPORT" not working in superset 4.1.3
I am not able to view FULL_CSV_EXPORT view option .
I am using Helm based deployment
Additionally Row Limit for Table not increasing beyond default 50k
i am also sharing my values.yaml
image:
repository: apache/superset
tag: "4.1.3-dev"
pullPolicy: IfNotPresent
service:
type: LoadBalancer
port: 8088
annotations:
cloud.google.com/load-balancer-type: "Internal"
nodePort:
http: null
postgresql:
enabled: true
auth:
password: superset
redis:
enabled: true
init:
enabled: true
loadExamples: true
adminUser:
username: admin
password: admin
email: admin@example.com
supersetWorker:
enabled: true
replicas:
enabled: true
replicaCount: 1
# Enable Celery beat for scheduling
supersetCeleryBeat:
enabled: true
ingress:
enabled: false
bootstrapScript: |
#!/bin/bash
# Install required Python packages
pip install apache-superset[databricks]
configOverrides:
superset_config.py: |
import os
from celery.schedules import crontab
SECRET_KEY = 'brzq6qmA+aGBmgCu/ccccccccccccccccccccccc+jM1u'
# Enable alerts and reports
FEATURE_FLAGS = {
"DASHBOARD_NATIVE_FILTERS": True,
"ENABLE_TEMPLATE_PROCESSING": True,
"ALERT_REPORTS": True,
"ALERTS_ATTACH_REPORTS": True,
"SCHEDULED_QUERIES": True,
"ALLOW_FULL_CSV_EXPORT": True,
}
SQLALCHEMY_DATABASE_URI = 'postgresql+psycopg2://postgres:superset@superset-postgresql:5432/superset'
DEFAULT_TIME_FILTER = 'Last day'
ROW_LIMIT = 9000000
SAMPLES_ROW_LIMIT = 9000000
NATIVE_FILTER_DEFAULT_ROW_LIMIT = 9000000
FILTER_SELECT_ROW_LIMIT = 9000000
SQL_MAX_ROW = 9000000
DEFAULT_SQLLAB_LIMIT = 9000000
DISPLAY_MAX_ROW = 9000000
TABLE_VIZ_MAX_ROW_SERVER = 9000000
SQLLAB_CTAS_NO_LIMIT = True
# SendGrid email configuration
SMTP_HOST = 'smtp.sendgrid.net'
SMTP_PORT = 587
SMTP_USER = 'apikey'
SMTP_PASSWORD = 'SECRET_KEY'
SMTP_MAIL_FROM = 'test@gmail.com'
SMTP_STARTTLS = True
SMTP_SSL = False
# Enable email notifications and alerts
EMAIL_NOTIFICATIONS = True
ENABLE_ALERTS = True
# Configure Redis for caching
CACHE_CONFIG = {
'CACHE_TYPE': 'RedisCache',
'CACHE_DEFAULT_TIMEOUT': 300,
'CACHE_KEY_PREFIX': 'superset_',
'CACHE_REDIS_HOST': 'superset-redis-master',
'CACHE_REDIS_PORT': 6379,
'CACHE_REDIS_DB': 1,
}
# Email report configuration
EMAIL_REPORT_FROM_ADDRESS = 'test@gmail.com'
# Celery configuration for Redis
class CeleryConfig:
broker_url = 'redis://superset-redis-master:6379/0'
result_backend = 'redis://superset-redis-master:6379/0'
worker_prefetch_multiplier = 1
task_acks_late = False
task_annotations = {
'sql_lab.get_sql_results': {
'rate_limit': '100/s',
},
'email_reports.send': {
'rate_limit': '1/s',
'time_limit': 120,
'soft_time_limit': 150,
'bind': True,
},
}
beat_schedule = {
"reports.scheduler": {
"task": "reports.scheduler",
"schedule": crontab(minute="*", hour="*"),
},
"reports.prune_log": {
"task": "reports.prune_log",
"schedule": crontab(minute=0, hour=0),
},
}
CELERY_CONFIG = CeleryConfig
FILTER_STATE_CACHE_CONFIG = {
'CACHE_TYPE': 'RedisCache',
'CACHE_DEFAULT_TIMEOUT': 86400,
'CACHE_KEY_PREFIX': 'superset_filter_',
'CACHE_REDIS_HOST': 'superset-redis-master',
'CACHE_REDIS_PORT': 6379,
'CACHE_REDIS_DB': 2,
}
EXPLORE_FORM_DATA_CACHE_CONFIG = {
'CACHE_TYPE': 'RedisCache',
'CACHE_DEFAULT_TIMEOUT': 86400,
'CACHE_KEY_PREFIX': 'superset_explore_',
'CACHE_REDIS_HOST': 'superset-redis-master',
'CACHE_REDIS_PORT': 6379,
'CACHE_REDIS_DB': 3,
}
# WebDriver configuration for screenshots in email reports
WEBDRIVER_BASEURL = "http://superset:8088/"
WEBDRIVER_BASEURL_USER_FRIENDLY = "http://localhost:8088/"
# Screenshot configuration
SCREENSHOT_LOCATE_WAIT = 10
SCREENSHOT_LOAD_WAIT = 60
SCREENSHOT_SELENIUM_HEADLESS = True
CONTENT_SECURITY_POLICY_WARNING = False
# Reports configuration
ALERT_REPORTS_NOTIFICATION_DRY_RUN = False
WEBDRIVER_WINDOW = {"dashboard": (1600, 2000), "slice": (3000, 1200)}
<img width="513" height="652" alt="Screenshot 2025-07-15 at 3 06 52 PM" src="https://github.com/user-attachments/assets/0ef45a89-5aa3-445b-a930-bf2b6c994fa6" />
GitHub link: https://github.com/apache/superset/discussions/34169
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [D] Export "ALLOW_FULL_CSV_EXPORT" not working in superset 4.1.3 [superset]
Posted by "bhavishya123 (via GitHub)" <gi...@apache.org>.
GitHub user bhavishya123 added a comment to the discussion: Export "ALLOW_FULL_CSV_EXPORT" not working in superset 4.1.3
@dosu
GitHub link: https://github.com/apache/superset/discussions/34169#discussioncomment-13762978
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org