📈

Iqela le Apache

Uhlalutyo

Ukuhlola idatha yanamhlanje kunye neqonga lokubona izinto ngendlela yokuhlaziya amashishini

Ulwazi Lonikezelo

Ukusasazwa: 2- 5 min
udidi: Uhlalutyo
Ubungakanani be RAM: 2048MB
Inkxaso: IiTikiti ne-imeyili

Yabelana ngalo mqondiso

Iinkcukacha

I-Apache Superset yiplatifomu yobukrelekrele beshishini kunye nokuphanda idatha eyanamhlanje, enokulungela iinkampani, eyenza kube lula kubasebenzisi bazo zonke iinkqubela ukuphanda nokubona idatha yabo. Eyaqalwa e-Airbnb kwaye ngoku ngumsebenzi ophezulu we-Apache Software Foundation, i-Superset ibonelela ngomphambili ocacileyo wokwakha iideshibhodi, iichati, kunye nezicelo zohlalutyo lwedatha ngaphandle kokuba kufuneka ulwazi olukhulu lwe-SQL okanye izakhono zokuprogramisha.

Ngokusisiseko, i-Superset yakhiwe kwisakhiwo esomeleleyo se-semantic layer esidibanisa nayiphi na i-SQL database okanye i-data warehouse. Ixhasa 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, nezinye ezininzi ngee-SQLAlchemy connectors. Olu udibaniso lwendawo yonke luvumela imibutho ukudibanisa uhlalutyo kwimithombo yedatha eyahlukeneyo ngesixokelelo esinye.

Iplatifomu ineencwadi zemifanekiso ezinkulu ezineechati ezilungiselelwe ezingaphezu kwe-40 ezibandakanya iichati zexesha, iichati zekholomu, iichati zepayi, iimephu zejografi, iimephu zobushushu, iitheyibhile ze-pivot, kunye nemifanekiso ephambili efana ne-Sankey diagrams kunye ne-sunburst charts. Uhlobo ngalunye lomfanekiso lunokulungiswa ngokukhululekileyo nge-UI elula, ivumela iinkcukacha zokuboniswa ukuba zilungelelaniswe neemfuno zeshishini ngaphandle kokubhala ikhowudi.

I-SQL Lab ye-Superset ibonelela ngomhleli onamandla wokuphanda idatha ene-query history, imibuzo egciniweyo, ukucwangcisa imibuzo, amathebhu amaninzi, kunye nokubonwa kwedatha okudibeneyo. Inkxaso ye-Jinja templating kwimibuzo ivumela ukwakhiwa kwe-SQL ngokuguquguqukayo ngokusekelwe kwizihluzi zedeshibhodi, ibumba amava ahlanganayo ohlalutyo. Iziphumo zemibuzo zinokuthunyelwa kwi-CSV ukuze zihlalutywe okanye zabelwe ngakumbi.

Kwiindawo zokusingatha ze-VPS, i-Superset yenza umsebenzi wengqikelelo yezixhobo ezizisebenzisela ukugcina zodwa kwiiplatifomu zentengiso ze-BI ezifana ne-Tableau, Looker, okanye i-Power BI, ibonelela ngomsebenzi ofanayo ngaphandle kweendleko zelayisensi ngomsebenzisi okanye ukuxhomekeka kumthengisi. Isakhiwo seplatifomu sixhasa ukwanda ngokuthe nkqi ngokulinganisa umthwalo kwaye sinokuphatha imisebenzi yobungakanani beshishini ngabasebenzisi abaliwaka ngaxeshanye kunye neemilione zemigca yedatha.

Iimpawu zokhuseleko nolawulo zibandakanya ulawulo lokufikelela olusekelwe kwidima (RBAC), ukhuseleko lwezinga ledatasethi kunye nomgca, udibaniso nabanikezeli be-OAuth (Google, GitHub, Okta), ukuqinisekiswa nge-LDAP, kunye nokugcina irekhodi lolawulo lokuphanda. Ukusebenza ngabaninzi kuvumela izithuba ezizimeleyo zeenkqubo zesebe okanye zabathengi ngaphakathi kwesiseko se-Superset esinye.

Ukwandiswa kwesakhelo se-Superset ngesakhiwo se-plugin esomeleleyo kuvumela abaphuhlisi ukwenza imifanekiso yokwenza ngokwabo, abadibanisi bedatabase, kunye nezinto zedeshibhodi. Uluntu olukhulayo luthatha inxaxheba ngee-plugins nezandiso, lukhulisa ngokuqhubekayo amandla kunye nendalo yodibaniso yeSuperset.

Iimpawu eziphambili

Ukudibanisa Kwedatabase Kwihlabathi Liphela

Inkxaso yomthonyama ye-40+ yedatabase ngeSQLAlchemy kubandakanya i-PostgreSQL, i-MySQL, i-BigQuery, i-Snowflake, i-Redshift, i-Druid, i-ClickHouse, kunye ne-Presto yohlalutyo oludibeneyo.

Ithala Elikhulu Lemifanekiso

Iichati ezingaphezu kwe-40 zohlobo olulungiselelwe kwangaphambili ezibandakanya ixesha, iimephu zejografi, iitheyibhile ze-pivot, i-Sankey diagrams, kunye nemifanekiso ephambili ene-customization ebanzi.

I-SQL Lab IDE

Umhleli onamandla we-SQL onembali yemibuzo, imibuzo egciniweyo, indlela yamathebhu amaninzi, i-Jinja templating, ukucwangciswa kwemibuzo, kunye nokubonwa kwedatha okudibeneyo ukuze kuphandwe.

Ukhuseleko Olukhulu Nolawulo Lwasemthethweni Kwiinkampani

Ulawulo lokufikelela ngokwendima, ukhuseleko lomgca wezinga ledatha, iimvume zedathasethi, udibaniso lwe-OAuth/LDAP, irekhodi lolawulo lwezenzo ezipheleleyo, kunye nenkxaso yabasebenzisi abaninzi.

Iideshibhodi Ezisebenzisanayo

Isakhi sedeshibhodi esitsala-ukuya-kubeka ne-cross-filtering, i-drill-down, ii-layout ezihambelana nesikrini, kunye nokuhlaziywa kwedatha ngexesha lokwenyani ukuze kuhlalutywe ngokuguquguqukayo.

Isakhiwo Esinokwanda

Uyilo olunokwandiswa ngokuthe nkqi oxhasa ukulinganisa umthwalo, izakhiwo zegcino (Redis), ukusebenza kwemibuzo engakhaliyo (Celery), kunye nabasebenzisi abaninzi ngaxeshanye kwinqanaba lebhizinisi.

Sebenzisa iziganeko

- Iideshibhodi Zobukrelekrele Beshishini: Yenza iideshibhodi zolawulo, ukuqapha i-KPI, uhlalutyo lwentengiso, kunye nokuxela ngokwenkqubo ukuze kwenziwe izigqibo ezisekelwe kwidatha
- Ukuphanda Idatha Kunye Nohlalutyo: Vumela oohlalutyi ukuba bophonononge iidathasethi, bakhe imibuzo engacwangciswanga, kwaye bayile imifanekiso ngaphandle kokuxhaswa ngumhlaziyi
- Iiportali Zohlalutyo Lwabathengi: Yakha uhlalutyo olugqunyelwe kwizicelo ze-SaaS ukubonelela abathengi ngemiboniso yokusetyenziswa kwabo, ukusebenza, kunye neendlela
- Ukuqapha Ngexesha Lokwenyani: Qapha iimetriki zesicelo, ukusebenza kwesistim, idatha yezinzwa ze-IoT, kunye neziganeko zeshishini ngeedeshibhodi ezihlaziya ngokuzenzekelayo
- Iqonga Lobukrelekrele Obuzimeleyo: Nika amandla abasebenzisi beshishini kuwo wonke amasebe ukuba benze iingxelo zabo kunye nemifanekiso ngokusekelwe kwidathasethi elawulwayo
- Uhlalutyo Lwabaninzi Ngaxeshanye: Bonelela ngendawo yohlalutyo ezimeleyo kubathengi abahlukeneyo, amasebe, okanye iiyunithi zeshishini ngokhuseleko lomgca wezinga ledatha

Incwadi yofako

Faka i-Apache Superset kwi-Ubuntu VPS usebenzisa i-pip kwindawo yokusebenzela ye-Python. Yenza idatabase ezinikelweyo (i-PostgreSQL icetyiswa) ukugcina idatha ye-metadata ye-Superset. Faka i-Redis ngegcino lekhasha kunye nenkxaso yemibuzo engakhaliyo.

Yenza indawo yokusebenzela enye ngomyalelo python3 -m venv venv, uyisebenzise, kwaye ufake iphakheji ye-superset usebenzisa pip install apache-superset. Qalisa idatabase ngo superset db upgrade kwaye wenze umsebenzisi womlawuli ngo superset fab create-admin.

Layisha idatha yomzekelo kwaye uqalise i-Superset ngomyalelo superset init. Lungelelanisa i-superset_config.py ngeSECRET_KEY, iintambo zoqhagamshelwano lwedatabase, kunye nezicwangciso ze-Redis cache. Seta abasebenzi be-Celery ukuze kucutshungulwe imibuzo ngokungaqhubi kwidatha enkulu.

Lungelelanisa iseva yewebhu (Gunicorn) kunye ne-reverse proxy (Nginx) ukuze kusasazwe kwimveliso. Vula i-HTTPS usebenzisa iiziqinisekiso zeLet's Encrypt. Seta iinkonzo ze-systemd zeseva yewebhu ye-Superset kunye nabasebenzi be-Celery ukuze baqale ngokuzenzekelayo kwaye baqapheke.

Kwiinkqubo zokufumaneka okuphezulu, qhuba iinkqubo ezininzi zeseva yewebhu ye-Superset ngaphambili kwe-load balancer, lungelelanisa idatabase ye-metadata eyabelwanayo kunye negcino le-Redis, kwaye usasaze iqela elahlukileyo labasebenzi be-Celery ukuze kucutshungulwe imibuzo. Qapha ukusebenza kwaye ulinganise abasebenzi ngokuxhomekeke komthwalo wombuzo.

Iingcebiso Zoqwalaselo

Ulawulo lwecwangciso ye-Superset lwenziwa yifayile ye-superset_config.py kwi-PYTHONPATH. Lungelelanisa i-SECRET_KEY yokubethelela iseshoni (yenziwe ngomyalelo openssl rand -base64 42), i-SQLALCHEMY_DATABASE_URI yokugcinwa kwe-metadata, kunye ne-CACHE_CONFIG ye-Redis caching.

Seta uqhagamshelwano lwedatabase ngolwakhiwo lwe-UI okanye ngomyalelo superset set_database_uri. Lungelelanisa i-row-level security (RLS) ngokuchaza izihluzi ze-SQL ezisetyenziswa kwiidathasethi ngokusekelwe kwiindima zabasebenzisi. Vula iideshibhodi zoluntu ngo PUBLIC_ROLE_LIKE = "Gamma" ukwabelana ngaphandle.

Lungelelanisa ukuqinisekiswa ngokuseta i-AUTH_TYPE (DATABASE, OAUTH, LDAP, okanye REMOTE_USER) kunye neezicwangciso ezihambelanayo ze-AUTH_CONFIG. Dibanisa nabanikezeli be-OAuth (Google, GitHub, Okta) okanye ne-LDAP/Active Directory yemibutho ukuze kufumaneke i-SSO.

Iindlela ezilungileyo zibandakanya ukuvula ukhuseleko lwe-CSRF, ukulungelelanisa i-CORS kwiideshibhodi ezifakiweyo, ukuseta izithintelo zexesha zemibuzo ukuthintela imibuzo ethatha ixesha elide, ukuvula ukuqikelelwa kwendleko yemibuzo ukulawula izixhobo, ukulungelelanisa izilumkiso ze-imeyile zeengxelo ezicwangciswayo, kunye nokuphumeza isicwangciso sokugcina ngokuthe ngcembe se-metadata database. Sebenzisa iinguqu zendawo ngeemvume ezibalulekileyo endaweni yokuzibhala kwifayile yocwangciso.

Iimfuno zobuchule

Iimfuno zenkqubo

  • Inkumbulo: 2048MB RAM

Linganisa eli nqaku

★★★★★
-
Ifaka...

Ukulungele ukungenisa isicelo sakho? Iqela le Apache?

Qala kwimizuzu ngenkqubo yethu elula yokufaka i-VPS

Deploy in about 2 minutes • Full root access • Support by ticket and email