GitHub user dosubot[bot] added a comment to the discussion: superset log
<!-- Answer --> You can visualize the Superset Security Action log by adding the logs table (named logs) from the metadata database as a dataset. Here’s how: 1. Make sure the Superset metadata database (where the logs table lives) is added as a database in Superset. This is usually a SQLite, Postgres, or MySQL database configured as your Superset backend. 2. In Superset, go to Data > Datasets and click “+ Dataset”. 3. Select the metadata database, then pick the logs table. 4. Save the dataset. Now you can explore and create charts from it. The logs table includes columns like id, action, user_id, dashboard_id, slice_id, json, dttm, duration_ms, and referrer, which you can use for your visualizations. Be aware: exposing the metadata database as a data source gives access to all Superset metadata tables, so only do this in secure/admin-only environments. There’s no built-in dashboard for logs yet, but you can build custom charts once the dataset is created. [Reference: logs table schema and usage](https://github.com/apache/superset/blob/master/superset/models/core.py#L1208-L1225) [Reference: event logging and dataset creation](https://github.com/apache/superset/blob/master/docs/docs/configuration/event-logging.mdx#L11-L37) <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/b7394451-9267-41b5-9430-b677eb82de4d?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/b7394451-9267-41b5-9430-b677eb82de4d?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/b7394451-9267-41b5-9430-b677eb82de4d?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/b7394451-9267-41b5-9430-b677eb82de4d?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/b7394451-9267-41b5-9430-b677eb82de4d?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/b7394451-9267-41b5-9430-b677eb82de4d?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/b7394451-9267-41b5-9430-b677eb82de4d?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github)& nbsp;[](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/36044) GitHub link: https://github.com/apache/superset/discussions/36044#discussioncomment-14905806 ---- 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]
