0 votes
in Apache Superset by
What types of data sources can be connected to Apache Superset for visualizations and analytics? How would you go about connecting a new data source?

1 Answer

0 votes
by
Apache Superset supports various data sources, including relational databases (e.g., MySQL, PostgreSQL), columnar stores (e.g., Apache Druid), and cloud-based warehouses (e.g., Amazon Redshift, Snowflake). To connect a new data source:

1. Install the appropriate database driver.

2. Navigate to “Sources” > “Databases” in Superset’s UI.

3. Click “+ Database” to open the configuration form.

4. Provide required information: database name, SQLAlchemy URI (format varies per database type).

5. Configure optional settings: expose sensitive info, allow multi-schema metadata fetch, impersonate logged-in user, etc.

6. Test connection using “Test Connection” button.

7. Save the configuration.
...