Nhazi
Apache Superset bụ platform business intelligence na nyocha data dị ọgbara ọhụrụ, nwere ike ịga nke ọma na nke a na-ahụ ma nwee ike ịga nke ọma, nke na-eme ka ọ dị mfe maka ndị ọrụ niile nwere ọkwa nkà dị iche iche ịchọpụta ma hụ data ha. Airbnb mere mbụ, ma ugbu a bụ ọrụ Apache Software Foundation dị elu, Superset na-enye interface dị ọcha na nwayọọ maka iwu dashboards, chati, na ngwa nyocha data na-enweghị ihe mmụta SQL zuru ezu ma ọ bụ nkà programming.
N'isi ya, Superset ejiri ọkwa semantic dị ike wuo ya nke na-ejikọta na database ma ọ bụ data warehouse ọ bụla na-asụ SQL. Nkwado gụnyere PostgreSQL, MySQL, SQLite, Oracle, Microsoft SQL Server, Amazon Redshift, Google BigQuery, Snowflake, Apache Drill, Apache Druid, Apache Hive, Presto, ClickHouse, na ndị ọzọ n'ọnụọgụ ọtụtụ site na SQLAlchemy connectors. Njikọ ụwa a na-enye ohere ka ndị otu jikọta nyocha n'ofe isi data dị iche iche site na otu interface.
Platform a nwere ọtụtụ ngwa ngwa nhụta gụnyere karịa ụdị chati 40 e mere tupu ya, gụnyere chati oge series, chati bar, chati pie, maapụ ọdịnala, heatmaps, pivot tables, na nhụta dị elu dị ka Sankey diagrams na sunburst charts. Ụdị nhụta ọ bụla dị ka ọ ga-esi kpebie n'ụzọ ọ chọrọ site na UI dị mfe, na-enye ohere ka ndị nyocha hazie nkwupụta dabara na ihe azụmahịa chọrọ n'enweghị ide koodu.
SQL Lab nke Superset na-enye IDE dị ike maka nchọpụta data gụnyere akụkọ ajụjụ, ajụjụ echekwabara, ntinye ajụjụ ọzọ, tabs ọtụtụ, na ihe nhụta data dị n'ime. Nkwado maka Jinja templating n'ime ajụjụ na-enye ohere maka mmepụta SQL dị ike dabere na filtọ dashboard, na-eme ka ahụmịhe nyocha mmekọrịta dị. Nsonaazụ ajụjụ nwere ike ịpụpụ na CSV maka nyocha ọzọ ma ọ bụ nkekọrịta.
Maka gburugburu hosting VPS, Superset na-eje ozi dị ka ihe nnọchi anya ọ na-ejikwa onwe ya na nke platform BI azụmahịa dị ka Tableau, Looker, ma ọ bụ Power BI, na-enye ọrụ yiri nke ahụ na-enweghị ụgwọ ikike kwa onye ọrụ ma ọ bụ ịdabere na onye na-ere. Usoro ụlọ ọrụ ahụ na-akwado mgbasa n'akụkụ site na nkesa ibu, ma nwee ike ijikwa ọrụ nke oke ụlọ ọrụ nwere ndị ọrụ ndị na-arụ ọrụ ọnụ ruo puku ma ọ bụ ọtụtụ nde row data.
Njirimara nchekwa na ọchịchị gụnyere ikike dabere na ọrụ (RBAC), nchekwa dataset na row, njikọ na ndị na-enye OAuth (Google, GitHub, Okta), nkwenye LDAP, na ndekọ nyocha zuru ezu. Nkwado multi-tenancy na-enye ohere maka oghere ọrụ kewara maka ngalaba ma ọ bụ ndị ahịa dị iche iche n'ime otu Superset.
Mgbasa ya site na usoro plugin dị ike na-enye ndị mmepe ohere ịmepụta nhụta ọdịnala, ndị njikọ database, na akụkụ dashboard. Otu ndị na-enye aka na-enyekwa plugins na mgbasa, na-agbasawanye ikike Superset na gburugburu njikọ mgbe niile.
Nkarachọ
Njikọ Database Ụwa
Nkwado ụlọ maka karịa database 40 site na SQLAlchemy gụnyere PostgreSQL, MySQL, BigQuery, Snowflake, Redshift, Druid, ClickHouse, na Presto maka nyocha a jikọtara ọnụ.
Ụlọ Nhụta Bara Ụba
Karịa ụdị chati 40 e mere tupu ya gụnyere oge series, maapụ ọdịnala, pivot tables, Sankey diagrams, na nhụta dị elu nwere nhọrọ mgbanwe zuru ezu.
SQL Lab IDE
Onye edemede SQL dị ike nwere akụkọ ajụjụ, ajụjụ echekwabara, interface tabs ọtụtụ, Jinja templating, ntinye ajụjụ, na ihe nhụta data dị n'ime maka nchọpụta.
Nchedo Dị Elu Na Ọchịchị
Nchịkwa ikike dabere na ọrụ, nchedo row-level, ikike dataset, njikọ OAuth/LDAP, ndekọ nyocha zuru ezu, na nkwado multi-tenancy.
Dashboards Nwere Mmekọrịta
Ihe ngwa iwu dashboard drag-and-drop nwere cross-filtering, drill-down, nhazi responsive, na ịgbanwe data oge ozugbo maka nyocha dị ndụ.
Nhazi Ịgbasa
Nhazi nke a ga-esi gbasaa n'akụkụ na-akwado load balancing, oke cache (Redis), ịgba ajụjụ asynchronous (Celery), na ndị ọrụ ndị na-arụ ọrụ ọnụ n'oke ụlọ ọrụ.
Oge ojiji
- Dashboard Business Intelligence: Mepụta dashboard ndị isi nchịkwa, nlele KPI, nyocha ire ere, na akụkọ arụ ọrụ maka mkpebi dabere na data
- Nchọpụta Data Na Nyocha: Kwe ndị nyocha ka ha chọpụta datasets, wuo ajụjụ ngwa ngwa, ma mepụta nhụta na-enweghị nkwado ndị injinia
- Portal Nyocha Ndị Ahịa: Wuo nyocha e tinyere na ngwa SaaS na-enye ndị ahịa nghọta banyere ojiji ha, arụmọrụ, na ụkpụrụ
- Nlele Oge Ozugbo: Lelee metrics ngwa, arụmọrụ sistemu, data sensọ IoT, na ihe omume azụmahịa site na dashboard na-agbanwe n'onwe ya
- Platform BI Nkwụnye Onwe Ya: Kwe ndị ọrụ azụmahịa n'ngalaba niile ka ha mepụta akụkọ na nhụta nke ha site na datasets a na-achịkwa
- Nyocha Multi-Tenant: Nye gburugburu nyocha kewara maka ndị ahịa, ngalaba, ma ọ bụ ngalaba azụmahịa dị iche iche nwere nchekwa row-level
Ndụmọdụ ịwụnye
Wụnye Apache Superset na Ubuntu VPS site na pip n'ime gburugburu Python virtual. Mepụta database kpọmkwem (PostgreSQL a na-atụ aro) maka nchekwa metadata Superset. Wụnye Redis maka caching na nkwado ajụjụ asynchronous.
Mepụta gburugburu virtual site na python3 -m venv venv, mee ya ka ọ rụọ ọrụ, wee wụnye ngwugwu superset site na pip install apache-superset. Malite database site na superset db upgrade ma mepụta onye njikwa site na superset fab create-admin.
Bulata data ihe atụ wee malite Superset site na iwu superset init. Hazie superset_config.py nwere SECRET_KEY, eriri njikọ database, na ntọala cache Redis. Tọọ ndị ọrụ Celery maka ịgba ajụjụ asynchronous na datasets buru ibu.
Hazie web server (Gunicorn) na reverse proxy (Nginx) maka mgbasa mmepụta. Gbanye HTTPS site na Let's Encrypt certificates. Hazie ọrụ systemd maka web server Superset na ndị ọrụ Celery maka mbido akpaka na nlele.
Maka mgbasa high-availability, gbaa ọtụtụ ihe nkesa web server Superset n'azụ load balancer, hazie database metadata e kesara na cache Redis, ma tinye pool ndị ọrụ Celery dị iche maka ịgba ajụjụ. Lelee arụmọrụ ma tọọ ndị ọrụ dabere na ibu ajụjụ.
Ndụmọdụ ntọala
A na-achịkwa nhazi Superset site na faịlụ superset_config.py n'ime PYTHONPATH. Tọọ SECRET_KEY maka nzuzo session (mepụta site na openssl rand -base64 42), SQLALCHEMY_DATABASE_URI maka nchekwa metadata, na CACHE_CONFIG maka caching Redis.
Hazie njikọ database site na UI ma ọ bụ iwu superset set_database_uri. Hazie row-level security (RLS) site n'ịkọwa filtọ SQL a na-etinye na datasets dabere na ọrụ ndị ọrụ. Gbanye dashboards ọha na eze site na PUBLIC_ROLE_LIKE = "Gamma" maka nkekọrịta mpụga.
Hazie nkwenye site na ịhazi AUTH_TYPE (DATABASE, OAUTH, LDAP, ma ọ bụ REMOTE_USER) na AUTH_CONFIG kwekọrọ ya. Jikọọ ya na ndị na-enye OAuth (Google, GitHub, Okta) ma ọ bụ LDAP/Active Directory nke ụlọ ọrụ maka SSO.
Ụzọ kacha mma gụnyere ịgbanye nchedo CSRF, ịhazi CORS maka dashboards e tinyere, itọ oge ọnwụ ajụjụ iji gbochie ajụjụ ogologo oge, ịgbanye atụ ọnụ ahịa ajụjụ maka njikwa akụrụngwa, ịtọ akwụkwọ ozi maka akụkọ ndị e kesara, na itinye atụmatụ backup maka database metadata. Jiri gburugburu ihe gbanwere maka akara nzuzo kama ịkpọ ya n'ime faịlụ nhazi.