Umbono
I-Apache Superset iyisixhumanisi sobuhlakani bebhizinisi nokuhlola idatha esimanje, esilungele ibhizinisi, okwenza kube lula kubasebenzisi wonke amazinga amakhono ukuhlola nokubonisa idatha yabo. Yaqala e-Airbnb futhi manje iyiprojekthi ephezulu ye-Apache Software Foundation, i-Superset inikeza isixhumanisi esicebile nesilula sokwakha amadeshibhodi, amashathi, nezinhlelo zokuhlaziya idatha ngaphandle kokudinga ulwazi olukhulu lwe-SQL noma amakhono okuhlela.
Ngokuyinhloko, i-Superset yakhelwe ngesendlalelo esinamandla se-semantic esixhuma nanoma iyiphi indawo yedatha ekhuluma i-SQL noma nendawo yokugcina idatha. Ukusekelwa kufaka i-PostgreSQL, i-MySQL, i-SQLite, i-Oracle, i-Microsoft SQL Server, i-Amazon Redshift, i-Google BigQuery, i-Snowflake, i-Apache Drill, i-Apache Druid, i-Apache Hive, i-Presto, i-ClickHouse, nokunye okuningi ngama-connector e-SQLAlchemy. Lokhu kuxhumana okubanzi kuvumela izinhlangano ukuhlanganisa ukuhlaziya emithonjeni yedatha ehlukene ngesixhumanisi esisodwa.
Ipulatifomu inezinsiza zokubonakalisa ezinkulu ezinezinhlobo ezingaphezu kwe-40 zamashathi ezakhelwe ngaphambili, okuhlanganisa amashathi wesikhathi, amashathi wamakholomu, amashathi wephayi, amamephu wezindawo, amamephu okushisa, amathebula aphambili, nezinhlobo ezithuthukile ezifana namashathi we-Sankey namashathi we-sunburst. Uhlobo ngalunye lokubonakalisa lungalungiswa ngokukhethekile nge-UI elula, okuvumela abahlaziyi ukwenza izethulo zifanele izidingo zebhizinisi ngaphandle kokubhala ikhodi.
I-SQL Lab ka-Superset inikeza i-IDE enamandla yokuhlola idatha enezici ezifaka umlando wemibuzo, imibuzo egcinwe, ukuhlelwa kwemibuzo, amathebu amaningi, kanye nokubukwa kwedatha okuhlanganisiwe. Ukusekelwa kwe-Jinja templating emibuzweni kuvumela ukwakhiwa kwe-SQL okuguquguqukayo ngokusekelwe kwizihlungi zedeshibhodi, okwakha izinkambo zokuhlaziya ezisebenzisanayo. Imiphumela yemibuzo ingathunyelwa ku-CSV ukuze kuhlaziywe kabusha noma kwabelwane ngayo.
Ngokusingatha kwe-VPS, i-Superset isebenza njengenye yokuzisingathela yamapulatifomu e-BI anamandla afana ne-Tableau, i-Looker, noma i-Power BI, inikeza ukusebenza okufanayo ngaphandle kwezindleko zelayisensi yomsebenzisi ngamunye kanye nokuncika komkhiqizi. Ukwakheka kwayo kusekela ukukala okuthe xaxa ngokusabalalisa umthwalo kanye nokuphatha imisebenzi yezinga lebhizinisi enezinkulungwane zabasebenzisi abasebenzayo nezigidi zemigqa yedatha.
Izici zokuphepha nokubusa zifaka ukulawula okusekelwe ezindimeni (RBAC), ukuphepha kwesethi yedatha nokuphepha ezingeni lomugqa, ukuhlanganiswa nabahlinzeki be-OAuth (Google, GitHub, Okta), ukugunyazwa nge-LDAP, kanye nokurekhoda okubanzi kokuhlola. Ukusekelwa kokusebenza kwabasebenzisi abaningi kuvumela izindawo zokusebenza ezizimele zamasebe noma amakhasimende ngaphakathi kokufakwa kwe-Superset eyodwa.
Ukwelulwa kwe-Superset ngesakhiwo se-plugin esiqinile kuvumela abathuthukisi ukudala ukubonakaliswa okwenziwe ngokwezifiso, izixhumanisi zezinkomba zedatha, nezingxenye zedeshibhodi. Umphakathi okhulayo unikela ngama-plugin nezandiso, uthuthukisa ngokuqhubekayo amakhono nohlelo lokuhlanganisa lwe-Superset.
Izici ezibalulekile
Ukuxhumana Kwedathabhesi Ngokubanzi
Ukusekelwa okwakhelwe ngaphakathi kwedathabhesi ezingaphezu kwe-40 nge-SQLAlchemy, okuhlanganisa i-PostgreSQL, i-MySQL, i-BigQuery, i-Snowflake, i-Redshift, i-Druid, i-ClickHouse, ne-Presto ukuze kuhlanganiswe ukuhlaziya.
Ilabhulali Ecebile Yokubonakalisa
Amashathi ezinhlobo ezingaphezu kwe-40 ezakhelwe ngaphambili okuhlanganisa isikhathi somugqa, amamephu wejografi, amathebula aphambili, amashathi we-Sankey, nokubonakaliswa okuthuthukile nezinketho ezinkulu zokwenza ngokwezifiso.
I-IDE ye-SQL Lab
Umhleli we-SQL onamandla onomlando wemibuzo, imibuzo egcinwe, isixhumanisi esinamathebu amaningi, i-Jinja templating, ukuhlelwa kwemibuzo, kanye nokubukwa kwedatha okuhlanganisiwe ukuze kuhlolwe.
Ukuphepha Nokubusa Okuthuthukile Kwebhizinisi
Ukulawula ukufinyelela ngokusekelwe ezindimeni, ukuvikelwa kwemigqa, izimvume zesethi yedatha, ukuhlanganiswa kwe-OAuth/LDAP, amalogi okuhlola aphelele, nokusekelwa kwezinhlangano eziningi.
Amadeshibhodi Asebenzisanayo
Umklamo wedeshibhodi okhokha ngokuhlola ngokuqondile, ukubhoda ngokujulile, izakhiwo ezisabela ngokuguquguquka, kanye nokuvuselelwa kwedatha ngesikhathi sangempela ukuze kube nokuhlaziya okuguquguqukayo.
Isakhiwo Esikalekayo
Ukwakheka okukwazi ukukala ngokuthe xaxa okusekela ukulinganisa umthwalo, izendlalelo ze-cache (Redis), ukusebenza kwemibuzo engaqhubeki (Celery), kanye nabasebenzisi abaningi besikhathi esifanayo ezingeni lebhizinisi.
Sebenzisa izimo
- Amadeshibhodi Obuhlakani Bebhizinisi: Dala amadeshibhodi wabaphathi, ukuqapha ama-KPI, ukuhlaziya ukuthengisa, kanye nokubika kokusebenza ukuze kwenziwe izinqumo ezisekelwe kudatha
- Ukuhlola Nokuhlaziya Kwedatha: Vumela abahlaziyi ukuthi bahlole amasethi edatha, bakhe imibuzo ye-ad-hoc, futhi bakhe ukubonakaliswa ngaphandle kosekelo lobunjiniyela
- Amapotali Wokuhlaziya Amakhasimende: Akha ukuhlaziya okufakiwe ezinhlelweni ze-SaaS ukuze kunikezwe amakhasimende ulwazi mayelana nokusetshenziswa kwawo, ukusebenza, nemikhuba
- Ukuqapha Ngesikhathi Sangempela: Qapha izimethrikhi zohlelo lokusebenza, ukusebenza kwesistimu, idatha yamasensa e-IoT, nezenzakalo zebhizinisi ngamadeshibhodi azivuselelayo ngokuzenzakalelayo
- Ipulatifomu Ye-Self-Service BI: Nika amandla abasebenzisi bebhizinisi kuwo wonke amasebe ukuthi bakhe imibiko nokubonakaliswa kwabo kusuka emasethini edatha alawulwayo
- Ukuhlaziywa Kwabasebenzisi Abaningi: Hlinzeka izindawo zokuhlaziya ezizimele zamakhasimende, amasebe, noma amayunithi ebhizinisi ahlukene ngokuphepha ezingeni lomugqa
Isikhombisi Sokufaka
Faka i-Apache Superset ku-Ubuntu VPS usebenzisa i-pip endaweni yesifunda ye-Python enendawo ezizimele. Dala idathabhesi ezinikelwe (i-PostgreSQL inconywa) yokugcina idatha ye-metadata ye-Superset. Faka i-Redis yokugcina ngokufihlwa nokusekela imibuzo engenabo ukuhlanganisa.
Dala indawo yesifunda ye-virtual nge-python3 -m venv venv, uyisebenzise, bese ufaka ipakethe ye-superset nge-pip install apache-superset. Qalisa idathabhesi nge-superset db upgrade bese udala umsebenzisi womphathi nge-superset fab create-admin.
Layisha idatha yesibonelo bese uqalisa i-Superset nge-superset init command. Lungisa i-superset_config.py nge-SECRET_KEY, izintambo zokuxhumana kwedathabhesi, kanye nezilungiselelo ze-Redis cache. Setha abasebenzi be-Celery ukuze kwenziwe imibuzo ngokungaqhubeki kumadathasethi amakhulu.
Lungisa iseva yewebhu (Gunicorn) nerevesi proxy (Nginx) ukuze kukhiqizwe. Nika amandla i-HTTPS ngezitifiketi ze-Let's Encrypt. Setha amasevisi we-systemd weseva yewebhu ye-Superset nabasebenzi be-Celery ukuze kuqalwe ngokuzenzakalelayo nokuqashelwa.
Ezinhlelweni zokutholakala okuphezulu, qhuba izibonelo eziningi zeseva yewebhu ye-Superset ngemuva kwe-load balancer, lungisa idathabhesi yemetadata eyabelwana nokugcinwa kwe-Redis, bese usabalalisa iqembu elihlukile labasebenzi be-Celery lokwenza imibuzo. Qapha ukusebenza bese ukala abasebenzi ngokuya komthwalo wemibuzo.
Izincomo zokuhlela
Ukulungiswa kwe-Superset kuphathwa ngefayela superset_config.py elisePYTHONPATH. Lungisa i-SECRET_KEY yokubethela isikhathi sokusebenza (yakhe nge-openssl rand -base64 42), i-SQLALCHEMY_DATABASE_URI yokugcinwa kwemetadata, kanye ne-CACHE_CONFIG ye-Redis caching.
Setha uxhumano lwedathabhesi nge-UI noma nge-superset set_database_uri command. Lungisa i-row-level security (RLS) ngokuchaza izihlungi ze-SQL ezisetshenziswa emasethini edatha ngokusekelwe kumadlelo abasebenzisi. Nika amandla amadeshibhodi womphakathi nge-PUBLIC_ROLE_LIKE = "Gamma" ukwabelana ngaphandle.
Lungisa ukugunyazwa ngokulungisa i-AUTH_TYPE (DATABASE, OAUTH, LDAP, noma REMOTE_USER) kanye nezilungiselelo ezifanele ze-AUTH_CONFIG. Hlanganisa nabahlinzeki be-OAuth (Google, GitHub, Okta) noma ne-LDAP/Active Directory yenhlangano ukuze kube ne-SSO.
Izinqubo ezinhle kakhulu zifaka ukunika amandla ukuvikelwa kwe-CSRF, ukulungisa i-CORS yamadeshibhodi afakiwe, ukusetha izikhathi zokuphela zemibuzo ukuvimbela imibuzo ethatha isikhathi eside, ukunika amandla ukulinganisa izindleko zemibuzo ukuphatha izinsiza, ukulungisa izexwayiso ze-imeyili yemibiko ehlelelwe, kanye nokusebenzisa isu lokusekela idathabhesi yemetadata. Sebenzisa okuguquguqukayo kwemvelo ngezimfihlo zezinto ezibucayi esikhundleni sokuzifaka kahle kufayela lokulungisa.
Izidingo zezobuchwepheshe