SQL-Based Loads from External Storage ​

This section covers commands that support SQL-based data loads from source files stored outside the database in object stores. These SQL commands provide "data movement" functionality that is accessible directly from database applications. Users can connect to object storage via SQL objects and load tables from data that is stored and updated externally.

Important: For efficient data loading from object storage, your target tables must be regular user tables, as defined with standard CREATE TABLE statements.

For details about loading tables with the ybload client, see Bulk Loading Tables.