Data loading
Loading Overview
Overview of the options for loading data into StarRocks, with guidance on choosing one.
Batch load data from Amazon S3
Batch load data from Amazon S3 into PhoenixAI Cloud with INSERT and FILES() or with Broker Load.
Batch load data from Azure cloud storage
Batch load data from Azure Blob Storage or Azure Data Lake Storage Gen2 into PhoenixAI Cloud with INSERT and FILES() or with Broker Load.
Load data from a local file system
How to load CSV and JSON data from a local file system into StarRocks by running Stream Load with the curl command.
Load from Confluent Cloud
2 items
Load data from Amazon MSK
Continuously load CSV or JSON messages from an Amazon MSK topic into PhoenixAI Cloud with a Routine Load job.
Load data using INSERT
How to load data into StarRocks using INSERT statements: INSERT VALUES, INSERT INTO SELECT, INSERT OVERWRITE, Dynamic Overwrite, and loading from files...
Load data using Stream Load transaction interface
How to use the Stream Load transaction interface (two-phase commit) in StarRocks for highly concurrent stream loads from Flink or Kafka with multi-table...
Realtime synchronization from MySQL
How to use Flink CDC to capture MySQL change data in real time and synchronize it into StarRocks tables using the StarRocks Flink connector.
Realtime synchronization from PostgreSQL
How to use a Flink CDC pipeline to capture PostgreSQL changes and stream them into StarRocks Primary Key tables in real time.
Continuously load data from Apache Flink®
How to use the StarRocks Flink connector to continuously load data from Apache Flink into StarRocks, supporting DataStream API, Table API & SQL, and Python API.
Change data through loading
How to perform INSERT, UPDATE, DELETE, partial update, and conditional update on Primary Key tables in StarRocks using Stream Load, Broker Load, or Routine...
Strict mode
How strict mode affects data loading in StarRocks: what it controls, how to enable it, and when to use it to reject rows with invalid column type conversions.