Faʻasoa lenei faʻamatalaga
Faʻamatalaga
O le Apache Superset o se faiga faʻapisinisi fou mo faʻatinoga faʻa-pisinisi ma suʻesuʻega faamatalaga, e faigofie ai mo tagata faʻaaogaina o ituaiga eseese o poloaiga ona suʻesuʻe ma vaʻaia a latou faamatalaga. Na atinaʻe muamua i Airbnb ma o le taimi nei o se galuega autu a le Apache Software Foundation, ofoina e Superset se faʻasologa vaaiga malosi ma faigofie mo le fausiaina o dashboards, graphs, ma polokalame suʻesuʻega faamatalaga e aunoa ma le manaʻomia o le SQL atoatoa poʻo poloaiga faʻagaioi.
I lona mea autu, o Superset o loo fausia i luga o se semantic layer malosi e fesoʻotaʻi ai ma so o se database poʻo data warehouse e faʻaaoga ai SQL. O lagolago e aofia ai PostgreSQL, MySQL, SQLite, Oracle, Microsoft SQL Server, Amazon Redshift, Google BigQuery, Snowflake, Apache Drill, Apache Druid, Apache Hive, Presto, ClickHouse, ma le tele o isi e ala i SQLAlchemy connectors. O lenei fesoʻotaʻiga lautele e mafai ai i faalapotopotoga ona tuʻufaʻatasia suʻesuʻega i faʻamatalaga eseese i le tasi faʻasologa ulufale.
O le faiga e ofoina se faletusi vaaiga tele e silia ma le 40 ituaiga o graphs muamua e aofia ai graphs o taimi, graphs pa, graphs pai, mapa o nofoaga, heatmaps, pivot tables, ma vaaiga maualuga e pei o Sankey diagrams ma sunburst charts. O ituaiga vaaiga taʻitasi e mafai ona faʻatulagaina i le UI faigofie, e faʻatagaina ai tagata suʻesuʻe e faʻafetaiʻi faʻaaliga i manaʻoga faʻapitoa o pisinisi e aunoa ma le tusitusi code.
O le SQL Lab a Superset e ofoina se IDE malosi mo suʻesuʻega o faamatalaga e aofia ai talaaga o fesili, fesili teuina, faʻatonuga fesili, pepa e tele, ma faʻamatalaga faʻaaliga o faamatalaga. E lagolagoina le templating Jinja i fesili e mafai ai ona gaosia SQL faʻaoga e faʻatatau i filifiliga dashboard, e faia ai aafiaga suʻesuʻega fesoʻotaʻi. O taunuuga o fesili e mafai ona faʻaaveina i CSV mo suʻesuʻega fesoʻotaʻi poʻo faʻasoasoaina.
Mo siosiomaga VPS hosting, o Superset e avea ma nofoaga suitulaga faʻatumauina mo faiga BI faʻapisinisi e pei o Tableau, Looker, poʻo Power BI, e ofoina ai malosiaga tutusa e aunoa ma tupe laisene mo tagata taʻitasi poʻo faalagolago i se tagata ofoina. O fausaga o le faiga e lagolagoina le faʻalautelega lautele e ala i le load balancing ma e mafai ona faʻatautai uta faʻapisinisi ma tagata faʻaaogaina e afe i le taimi tutusa ma miliona o laina o faamatalaga.
O vaega o le puipuiga ma pulega e aofia ai role-based access control (RBAC), puipuiga i le tulaga o seti faamatalaga ma laina, fesoʻotaʻiga ma OAuth providers (Google, GitHub, Okta), LDAP authentication, ma faʻamaumauga suʻesuʻega atoatoa. O le lagolago multi-tenancy e mafai ai ona faʻavavevaeina avanoa galuega mo matagaluega poʻo tagata ogaoga eseese i totonu o le Superset e tasi.
O le faʻalauteleina o le faiga e ala i le fausaga plugin malosi e mafai ai tagata atinaʻe ona fausia vaaiga faʻapitoa, connectors o database, ma vaega dashboard. O se faʻalapotopotoga tele o tagata e fausia plugins ma faʻalauteleina, ma faʻalauteleina faifaipea galuega ma faiga fesoʻotaʻiga a Superset.
Faʻamatalaga autu
Fesoʻotaʻiga Database Lautele
Lagolago tuʻufua mo database 40+ e ala i SQLAlchemy e aofia ai PostgreSQL, MySQL, BigQuery, Snowflake, Redshift, Druid, ClickHouse, ma Presto mo suʻesuʻega tasi.
Faletusi Vaaiga Tele
Ituaiga graphs muamua 40+ e aofia ai o taimi, mapa o nofoaga, pivot tables, Sankey diagrams, ma vaaiga maualuga ma filifiliga faʻatulagaina tele.
SQL Lab IDE
Faʻaliliu SQL malosi ma talaaga fesili, fesili teuina, faʻatonuga multi-tab, templating Jinja, faʻatonuga fesili, ma faʻamatalaga faʻaaliga o faamatalaga mo suʻesuʻega.
Puipuiga Faʻapisinisi ma Pulega
Role-based access control, row-level security, faʻatagaga seti faamatalaga, tuʻufaʻatasiga OAuth/LDAP, talaaga suʻesuʻega atoatoa, ma lagolago multi-tenancy.
Dashboards Feʻaveaʻi
Fausia dashboard e ala i le drag-and-drop ma cross-filtering, galuega drill-down, fausaga faʻafetaiʻi, ma faʻafouga o faamatalaga o le taimi moni mo suʻesuʻega faʻaleleia.
Fausaga Faʻalautele
Mamanu faʻalautele e lagolagoina tuʻufaʻatasiga o uta, faiga teuina vave (Redis), faʻatinoga fesili async (Celery), ma tagata faʻaaogaina faʻatasi i le tele o tagata faʻapisinisi.
Faʻaaoga mataupu
- Dashboards Suʻesuʻega Pisinisi: Fausia dashboards pule, mataituina KPI, suʻesuʻega faʻatauga, ma lipoti galuega mo faʻaiuga e faʻavae i faamatalaga
- Suʻesuʻega ma Suʻeina o Faamatalaga: Faʻatagaina tagata suʻesuʻe e suʻe seti faamatalaga, fausia fesili faʻapitoa, ma fausia vaaiga e aunoa ma le lagolago a tagata tusi polokalame
- Portala Suʻesuʻega mo Tagata Faʻatau: Fausia suʻesuʻega faʻafesoʻotaʻi i polokalame SaaS e foaʻi atu ai i tagata faʻatau vaʻaiga i le faʻaaogaina, malosi, ma tulaga
- Mataituina o le Taimi Moni: Mataituina metrics o polokalame, malosi o faiga, faamatalaga sensor IoT, ma mea o loo tupu i pisinisi ma dashboards e faafouina otometi
- Faiga BI Faʻaaogaina e Tagata Lava Ia: Faʻamalosia tagata pisinisi i matagaluega uma e fausia a latou lipoti ma vaaiga mai seti faamatalaga o loo pulea
- Suʻesuʻega Multi-Tenant: Ofo siosiomaga suʻesuʻega tumaoti mo tagata faʻatau, matagaluega, poʻo vaega pisinisi eseese ma puipuiga i le tulaga o laina
Fautuaga mo le Faʻapipiʻiina
Faʻapipiʻi le Apache Superset i le Ubuntu VPS e faaaoga ai pip i totonu o se siosiomaga virtual Python. Fausia se database faʻapitoa (PostgreSQL e fautuaina) mo teuina metadata o Superset. Faʻapipiʻi Redis mo caching ma lagolago fesili async.
Fausia siosiomaga virtual ma python3 -m venv venv, faagaioia ai, ma faʻapipiʻi le package superset ma pip install apache-superset. Faaulu le database ma superset db upgrade ma fausia tagata pule ma superset fab create-admin.
Faʻaulu faamatalaga faʻataʻitaʻiga ma faʻaulu Superset ma le poloaiga superset init. Faatulaga superset_config.py ma SECRET_KEY, fesoʻotaʻiga database, ma faatulagaga Redis cache. Seti Celery workers mo faʻagaioiga fesili async i seti faamatalaga tetele.
Faatulaga le web server (Gunicorn) ma reverse proxy (Nginx) mo faʻatinoga o le gaosiga. Faagaioia HTTPS ma faʻamaoti Let's Encrypt. Seti systemd services mo le Superset web server ma Celery workers mo le amataina otometi ma le mataituina.
Mo faʻatinoga o le maaʻa maualuga, tamoe ai instances e tele o le Superset web server i lalo o load balancer, faatulaga metadata database ma Redis cache fesoʻotaʻi, ma faʻatuʻu se pool Celery workers ese mo fesili. Mataituina le malosi ma faʻalautele workers e tusa ma le uta o fesili.
Fautuaga Faʻatonu
O faatulagaga Superset e pulea e ala i le faila superset_config.py i PYTHONPATH. Faatulaga SECRET_KEY mo le faʻaleaogaina o session (fausia ma openssl rand -base64 42), SQLALCHEMY_DATABASE_URI mo teuina metadata, ma CACHE_CONFIG mo Redis caching.
Seti fesoʻotaʻiga database e ala i le UI poʻo le superset set_database_uri command. Faatulaga row-level security (RLS) e ala i le faʻamalamalamaina o filtara SQL e faʻaaogaina i seti faamatalaga e tusa ma matafaioi o tagata faʻaaogaina. Faagaioia dashboards lautele ma PUBLIC_ROLE_LIKE = "Gamma" mo faʻasoasoaina i fafo.
Faʻafetaiʻi authentication e ala i le faʻatulagaina o AUTH_TYPE (DATABASE, OAUTH, LDAP, poʻo REMOTE_USER) ma faatulagaga AUTH_CONFIG e tusa ai. Tuʻufaʻatasi ma OAuth providers (Google, GitHub, Okta) poʻo enterprise LDAP/Active Directory mo SSO.
O faiga sili ona lelei e aofia ai le faagaioiaina o CSRF protection, faatulaga CORS mo dashboards faʻapipiʻi, seti taimi faʻaiuga o fesili e puipuiʻi ai fesili umi, faʻagaioia le tofiga o tau fesili mo le pulea o punaoa, faʻatulaga faʻailoga imeli mo lipoti faʻatonu, ma faʻatinoina faiga o teuina mo database metadata. Faaaoga environment variables mo faʻamaoti lilolilo nai lo le tusia i totonu o le config file.