Results for “lightning-datatable”

Documents MariaDB-specific ALTER TABLE syntax and behavior, including online DDL algorithms, lock modes, lock timeouts, idempotent subclauses, system versioning, and partition operations, for writing and reviewing schema migrations.

Manages biological datasets and models with LaminDB, covering setup, artifact registration, querying, lineage tracking, validation, ontology annotation, collections, branches, storage, and workflow integrations.

Write and run analytical SQL queries against Redpanda SQL (Oxla), a distributed PostgreSQL-wire-compatible columnar database, including data loading, external sources, and type handling.

Manage biological datasets and models with LaminDB, an open-source lineage-native lakehouse. Covers setup, artifact registration, query/search, lineage tracking, validation, ontology-backed annotation, collections, branches, storage, and workflow integrations.

Explains MariaDB-specific TRUNCATE TABLE semantics: DROP privilege, implicit commit, AUTO_INCREMENT reset, trigger and FK behavior, and restrictions on system-versioned tables and sequences.

Automate Snowflake data warehouse operations: list databases, schemas, and tables, execute SQL statements, and manage data workflows via the Composio MCP integration.

Documents MariaDB-specific UPDATE syntax and behavior, including single-table vs multi-table forms, assignment evaluation order, RETURNING with OLD_VALUE(), temporal tables, and common pitfalls. Use when writing, generating, or reviewing UPDATE statements targeting MariaDB.

Generates and reviews MariaDB CREATE SEQUENCE statements with version-specific syntax, defaults, and gotchas.

Documents MariaDB-specific transaction control syntax and behavior, including START TRANSACTION, COMMIT, ROLLBACK, SAVEPOINT, implicit commit rules, autocommit defaults, and idle transaction timeouts.

Provision Bigtable instances, design performant schemas, and query data using gcloud, cbt, or client libraries.

Covers MariaDB-specific DELETE syntax and behavior, including RETURNING, multi-table forms, temporal-table deletion, and DELETE vs TRUNCATE differences.

Builds statistical plots with the seaborn Python library and pandas DataFrame integration, on attractive matplotlib-based defaults. Use for quick exploration of distributions, relationships, and categorical comparisons — box plots, violin plots, swarm/strip plots, KDE/histograms, pair plots, joint plots, regression plots, correlation heatmaps, and faceted small multiples (relplot/displot/catplot/lmplot). For interactive/hover/zoom charts defer to alterlab-plotly; for exact journal/manuscript styling (column widths, point fonts, CMYK, vector export) defer to alterlab-scientific-viz; for low-level custom matplotlib figures defer to alterlab-matplotlib (seaborn integrates with it for fine-tuning). Part of the AlterLab Academic Skills suite.

Covers MariaDB-specific SELECT syntax and behavior, including optimizer hints, LIMIT extensions, row locking, temporal queries, and file output.

DataFrame operations with pandas and polars — groupby, joins, reshaping, performance. Use when manipulating tabular data, choosing between pandas and polars, optimizing DataFrame code, or translating between the two libraries.

表格全场景处理：本地 Excel/CSV 与在线表格（飞书、doubao.com 的 /sheets/ 链接）的创建、读写、分析、计算、建模、语义处理、可视化与美化。**只要用户输入包含表格类附件——上传 .xlsx/.xls/.csv 文件，或给出 feishu/doubao.com 的 /sheets/ 链接或 token——必须加载本技能。** 此外，用户口述数据要整理成表，或要求计算/统计/建模/预测/透视/可视化/美化/公式等任何表格操作时，也加载本技能。一切与 Excel/表格相关的任务都必须加载。本技能不负责获取外部信息，如需补充数据须先通过其他途径获得。