GitHub user dosubot[bot] added a comment to the discussion: Does superset supports S3 tables feature in AWS ?
<!-- Greeting --> Hello @omkenge! I'm [Dosu](https://dosu.dev), here to assist you with bugs, questions, and contributing. I'm ready to help while you wait for a human maintainer. How can I assist you today? <!-- Answer --> Yes, Superset supports handling S3 tables in AWS Athena. To ensure proper configuration, you need to set specific environment variables and feature flags: Environment Variables: - `SUPERSET_REGION`: Set this to your AWS region, e.g., `eu-west-1`. - `SUPERSET_WORKGROUP`: Set this to your Athena workgroup, e.g., `superset-etl`. - `SUPERSET_ATHENA_DB`: Set this to your Athena database name, e.g., `my_superset_db`. Feature Flags: - `DownloadCSVFromS3`: Enable this feature flag (`DOWNLOAD_CSV_FROM_S3`). - `ShowDefaultCSVOptions`: Enable this feature flag (`SHOW_DEFAULT_CSV_OPTIONS`) <sup>[[1]](https://github.com/apache/superset/issues/31482)</sup>. Additionally, ensure that your connection string is correctly formatted and includes all necessary parameters. The format should be: ``` awsathena+rest://{aws_access_key_id}:{aws_secret_access_key}@athena.{region_name}.amazonaws.com/{schema_name}?s3_staging_dir={s3_staging_dir}&... ``` If you are experiencing schema visibility issues, common causes include incorrect schema names or insufficient permissions. Verify that the schema exists and that your user account has the necessary permissions <sup>[[2]](https://github.com/apache/superset/blob/master/docs/docs/using-superset/issue-codes.mdx)</sup><sup>[[3]](https://github.com/apache/superset/blob/master/superset/errors.py)</sup>. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/4e2740ff-6666-4bff-99c4-490d6ceb5d93?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/4e2740ff-6666-4bff-99c4-490d6ceb5d93?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/4e2740ff-6666-4bff-99c4-490d6ceb5d93?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/4e2740ff-6666-4bff-99c4-490d6ceb5d93?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/4e2740ff-6666-4bff-99c4-490d6ceb5d93?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/4e2740ff-6666-4bff-99c4-490d6ceb5d93?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/4e2740ff-6666-4bff-99c4-490d6ceb5d93?feedback_type=other)</sup> GitHub link: https://github.com/apache/superset/discussions/33375#discussioncomment-13048722 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
