Databases, data import, and SQL Editor¶
After opening the MatrixOne database management console through Connect > Connect via Cloud Platform on an instance, you can browse databases and manage cross-instance data sharing, import sample or object-storage datasets, run queries and visualize results in the SQL Editor, and inspect query history, CU usage, and execution plans.
Load data¶
Open Load Data to bring sample datasets or external object-storage files into tables:
Explore with sample data: Load the built-in TPC-H sample dataset (such as
mo_sample_data_tpch_sf1) into your instance and query it directly in the SQL Editor. Keep the browser tab open until sample loading completes.Import CSV / JSON from object storage: Choose CSV File or Json File, enter the object-storage bucket URL, configure credentials (IAM Role ARN or Alibaba Cloud AccessKey / AWS Access Key), and choose or enter the target Database and Table. If another query is actively running in the SQL Editor, wait for it to finish as prompted before starting an import.
For unstructured documents, REST APIs, Kafka streams, or workflow orchestration pipelines, use AI Studio Data Sources and Processing.
Use the SQL Editor¶
Open SQL Editor to run interactive queries and save scripts in workbooks:
Select a database from the left tree and open or create a workbook (workbooks can be searched, renamed, or deleted; each workbook has a 1 MB content limit—create a new workbook when approaching the limit).
Write SQL in the editor and execute it; collapse, minimize, maximize, or reset the results pane as needed.
Switch to the Chart tab after receiving query results to choose a chart type (Bar, Pie, or Line) and configure columns, axes, and aggregations.
For SQL syntax, data types, and built-in functions, see Reference: SQL.
Query history and execution profile¶
Open Queries History to audit executed statements and analyze query performance:
Filter by status (ALL, Running, Success, Failed) or expand Filters to search by SQL text, database, user, query ID, session ID, transaction ID, minimum duration, or time range, and download filtered results locally.
Review SQL text, status, query type, duration, timestamps, rows read, bytes scanned, result count, and CU consumption in the table.
Open Query Details for any record to inspect full query metadata, Query Result, and Query Profile (interactive execution plan tree showing operator nodes, SQL slices, CPU, and memory overview).
Completion check and next steps¶
Confirm newly imported or subscribed tables appear under Database, a test
SELECTsucceeds in SQL Editor, and the correspondingSuccessrecord is visible in Queries History.To inspect instance resource metrics or manage instance users and IP allowlists, continue with Monitoring and Access control and permissions.