StarRocks Data Loading

Load data into StarRocks tables via the four loading methods, with column mapping, status checks, and failure troubleshooting.

When to Use

• Ingesting data from applications, object storage, or Kafka
• Choosing a loading method (Stream / Broker / Routine Load / INSERT)
• Mapping or transforming columns during load
• Checking load job status or canceling loads
• Diagnosing data load failures

Method selection:

• Stream Load — real-time, small/medium batches (<10GB), direct from applications
• Broker Load — large batch (>10GB) from S3/HDFS, scheduled ETL
• Routine Load — continuous streaming from Kafka
• INSERT INTO — small loads and ETL transformations within StarRocks

Related skills: [starrocks-table-design] for the target schema; [starrocks-etl-and-tasks] for ETL pipelines and async/scheduled execution.