📈

Apache Superset

Tlhahlobo

Sethala sa tlhahlobo ea data sa sejoale-joale le pono bakeng sa tlhahlobo ea likhoebo

Lintlha tsa ho kenya

Ho romelloa ha basebetsi: 2-5 min
sehlopha: Tlhahlobo
RAM e tlase: 2048MB
Tšehetso: Litekete le imeile

Tseba lengolo lena

Tlhaloso

Apache Superset ke sebopeho sa sejoale-joale, se loketseng mekhatlo, sa business intelligence le ho hlahloba data, se etsang hore motho e mong le e mong ea nang le boemo bofe kapa bofe ba tsebo a hlahlobe le ho bonts'a data ea hae ka bonolo. E qalile ho Airbnb 'me joale ke projeke ea Apache Software Foundation ea boemo bo holimo, Superset e fana ka sebopeho se matla le se bonolo sa ho haha li-dashboard, li-chart le lits'ebetso tsa analytics ntle le ho hloka SQL e ngata kapa tsebo ea lenaneo.

Ka bo eona, Superset e hahiloe holim'a semantic layer e matla e hokelang ho database efe kapa efe ea SQL kapa data warehouse. Tšehetso e kenyelletsa PostgreSQL, MySQL, SQLite, Oracle, Microsoft SQL Server, Amazon Redshift, Google BigQuery, Snowflake, Apache Drill, Apache Druid, Apache Hive, Presto, ClickHouse le tse ling tse ngata ka li-connector tsa SQLAlchemy. Bokhoni bona ba ho kopanya bo lumella mekhatlo ho kopanya analytics ho tsoa mehloling e fapaneng ea data ka sebopeho se le seng.

Sistimi e na le laeborari e pharalletseng ea ponts'o e nang le mefuta e fetang 40 ea li-chart tse entsoeng pele, ho kenyeletsoa li-chart tsa nako tsa time-series, li-bar chart, li-pie chart, mape ea libaka, li-heatmap, li-pivot table, le ponts'o e tsoetseng pele joalo ka Sankey diagrams le sunburst charts. Mofuta o mong le o mong oa ponts'o o ka lokisoa haholo ka UI e bonolo, e lumellang bahlahlobi ho lokisetsa lipontšo ho ipapisitsoe le litlhoko tsa khoebo ntle le ho ngola khoutu.

SQL Lab ea Superset e fana ka IDE e matla bakeng sa ho hlahloba data, e nang le likarolo tse kenyelletsang nalane ea lipotso, lipotso tse bolokiloeng, ho beha lipotso ka nako, li-tab tse ngata, le lipontšo tsa data tse kopantsoeng. Tšehetso ea Jinja templating lipotsong e nolofalletsa ho hlahisa SQL ka mokhoa o fetohang ho ipapisitsoe le li-filter tsa dashboard, e etsa liphetoho tsa analytics tse sebelisanang. Liphetho tsa lipotso li ka romelloa ho CSV bakeng sa tlhahlobo e ngoe kapa ho arolelanoa.

Bakeng sa tikoloho ea VPS hosting, Superset e sebetsa e le khetho ea ho itšoarela e nkang sebaka sa lipalangoang tsa BI tsa khoebo tse kang Tableau, Looker kapa Power BI, e fana ka mosebetsi o lekanang ntle le litefiso tsa lichelete ka mosebelisi kapa ho ikopanya le mofani. Sebopeho sa platform se tšehetsa ho atoloha ka mokhoa o otlolohileng ka load balancing, 'me se ka sebetsana le mojaro oa boemo ba khoebo ka basebelisi ba makete a mangata ba sebelisang hammoho le limilione tsa mela ea data.

Likarolo tsa polokeho le taolo li kenyelletsa taolo ea phihlello e thehiloeng karolong (RBAC), polokeho ea mokhoa oa dataset le mola oa data (row-level), kopanyo le li-provider tsa OAuth (Google, GitHub, Okta), netefatso ea LDAP, le logging e felletseng ea tlhahlobo. Tšehetso ea bo-tenant ba bangata e nolofalletsa libaka tse arohaneng tsa mosebetsi bakeng sa lihlopha tse fapaneng kapa bareki ka har'a installation e le 'ngoe ea Superset.

Ho atolosoa ha sistimi ka moralo o matla oa plugin ho lumella bahlahisi ho theha li-visualization tse ikhethileng, li-database connector le likarolo tsa dashboard. Sehlopha sa bahlahisi se ntse se hola se romella li-plugin le li-extension, se ntse se atolosa bokhoni ba Superset le tikoloho ea kopanyo.

Likarolo tsa bohlokoa

Ho Kopanya Database ka Mokhoa o Fapaneng

Tšehetso ea 'nete bakeng sa li-database tse fetang 40 ka SQLAlchemy, ho kenyeletsoa PostgreSQL, MySQL, BigQuery, Snowflake, Redshift, Druid, ClickHouse le Presto, bakeng sa analytics e kopaneng.

Laeborari e Pharalletseng ea Ponts'o

Li-chart tse fetang 40 tse entsoeng pele, ho kenyeletsoa time-series, mape ea geospatial, li-pivot table, Sankey diagrams le ponts'o e tsoetseng pele e nang le likhetho tse ngata tsa ho ikhetha.

SQL Lab IDE

Mohlophisi oa SQL o matla o nang le nalane ea lipotso, lipotso tse bolokiloeng, sebopeho sa li-tab tse ngata, Jinja templating, ho beha lipotso ka nako, le lipontšo tsa data tse kopantsoeng bakeng sa ho hlahloba.

Polokeho ea Enterprise le Taolo

Taolo ea phihlello e thehiloeng karolong, row-level security, tumello ea dataset, kopanyo ea OAuth/LDAP, lilog tse felletseng tsa tlhahlobo, le tšehetso ea bo-tenant ba bangata.

Li-Dashboard tse Sebelisanang

Moaki oa dashboard ka drag-and-drop o nang le cross-filtering, likarolo tsa drill-down, moralo o arabelang, le nchafatso ea data ea nako ea sebele bakeng sa analytics e fetohang.

Moaho o Atolohang

Moralo o atolohang ka bophahamo o tšehetsang load balancing, mekhahlelo ea cache (Redis), ts'ebetso ea lipotso tse sa sebetseng ka nako e le 'ngoe (Celery), le basebelisi ba bangata ba khoebo ba sebetsang hammoho.

Mehlala ea ho sebelisa

- Business Intelligence Dashboards: Theha li-dashboard tsa bolaoli, ts'ebetso ea KPI, analytics ea thekiso le litlaleho tsa ts'ebetso bakeng sa ho etsa liqeto ho ipapisitsoe le data
- Data Exploration and Analysis: Lumella bahlahlobi ho hlahloba li-dataset, ho haha lipotso tse potlakileng le ho theha lipontšo ntle le tšehetso ea boenjiniere
- Customer Analytics Portals: Haha analytics e kenngoeng lits'ebetsong tsa SaaS, ho fa bareki tlhaiso-leseling mabapi le tšebeliso ea bona, ts'ebetso le mekhoa
- Real-Time Monitoring: Lekola metrics ea lits'ebetso, ts'ebetso ea sistimi, data ea lisensara tsa IoT le liketsahalo tsa khoebo ka li-dashboard tse nchafatsoang ka boyona
- Self-Service BI Platform: Matlafatsa basebelisi ba khoebo lihlopheng tsohle ho theha litlaleho tsa bona le lipontšo tse tsoang ho li-dataset tse laoloang
- Multi-Tenant Analytics: Fana ka tikoloho e arohaneng ea analytics bakeng sa bareki, lihlopha kapa mekhahlelo ea khoebo e fapaneng ka polokeho ea mola oa data

Litaelo tsa ho kenya

Kenya Apache Superset ho Ubuntu VPS ka pip ka tikoloho ea Python e ikhethileng. Theha database e ikhethileng (PostgreSQL e khothalelitsoe) bakeng sa polokelo ea metadata ea Superset. Kenya Redis bakeng sa caching le tšehetso ea lipotso tse sa sebetseng ka nako e le 'ngoe.

Theha tikoloho ea virtual ka python3 -m venv venv, e sebetse, 'me u kenye phutheho ea superset ka pip install apache-superset. Qalisa database ka superset db upgrade 'me u theha mosebelisi oa admin ka superset fab create-admin.

Kenya data ea mohlala 'me u qalise Superset ka taelo ea superset init. Hlophisa superset_config.py ka SECRET_KEY, mehala ea likhokahano tsa database le litlhophiso tsa cache ea Redis. Beha Celery workers bakeng sa ts'ebetso ea lipotso tse sa sebetseng ka nako e le 'ngoe lidatasetong tse kholo.

Hlophisa web server (Gunicorn) le reverse proxy (Nginx) bakeng sa romello ea production. Nolofalletsa HTTPS ka lingoliloeng tsa Let's Encrypt. Beha litšebeletso tsa systemd bakeng sa web server ea Superset le Celery workers bakeng sa ho qala ka boyona le ho sheba.

Bakeng sa romello e nang le ho fumaneha ho phahameng, sebelisa mehlala e mengata ea web server ea Superset ka mor'a load balancer, hlophisa database e arolelanoang ea metadata le cache ea Redis, 'me u romelle sehlopha se arohaneng sa Celery workers bakeng sa ts'ebetso ea lipotso. Lekola ts'ebetso 'me u atolose li-worker ho ipapisitsoe le mojaro oa lipotso.

Litlhahiso tsa ho kenya

Litlhophiso tsa Superset li laoloa ka faele ea superset_config.py ho PYTHONPATH. Hlophisa SECRET_KEY bakeng sa enkripshene ea seboka (e hlahisoe ka openssl rand -base64 42), SQLALCHEMY_DATABASE_URI bakeng sa polokelo ea metadata, le CACHE_CONFIG bakeng sa cache ea Redis.

Beha likhokahano tsa database ka UI kapa ka taelo ea superset set_database_uri. Hlophisa row-level security (RLS) ka ho hlalosa li-filter tsa SQL tse sebelisoang li-dataset ho ipapisitsoe le litšoanelo tsa basebelisi. Nolofalletsa li-dashboard tsa sechaba ka PUBLIC_ROLE_LIKE = "Gamma" bakeng sa ho arolelana ka ntle.

Lokisa netefatso ka ho hlophisa AUTH_TYPE (DATABASE, OAUTH, LDAP kapa REMOTE_USER) le litlhophiso tse tsamaellanang tsa AUTH_CONFIG. Kopanya le li-provider tsa OAuth (Google, GitHub, Okta) kapa enterprise LDAP/Active Directory bakeng sa SSO.

Mekhoa e molemo ka ho fetisisa e kenyelletsa ho nolofalletsa tšireletso ea CSRF, ho hlophisa CORS bakeng sa li-dashboard tse kenyelelitsoeng, ho beha linako tsa ho emela lipotso ho thibela lipotso tse telele, ho nolofalletsa tlhahlobo ea litšenyehelo tsa lipotso bakeng sa taolo ea lisebelisoa, ho hlophisa litsebiso tsa lengolo-hokeletsoa bakeng sa litlaleho tse hlophisitsoeng, le ho kenya maano a backup bakeng sa database ea metadata. Sebelisa litlhophiso tsa tikoloho bakeng sa lintlha tse sirelelitsoeng ho e-na le ho li ngola ka thata lifaeleng tsa litlhophiso.

Likopo tsa theknoloji

Litaelo tsa sistimi

  • Khopolo: 2048MB RAM

Lekanya Sengoloa sena

★★★★★
-
Ho kenya...

Na o se o loketse ho kenya kopo ya hao? Apache Superset?

Qala ka metsotsoana ka ts'ebetso ea rona e bonolo ea ho kenya VPS

Ho kenya ka ho ka bang 2 metsotso • Full root ho kena • Thuto ka terene le lengolo tsoibila