External tables provide access to data stored in data sources outside of Greenplum Database as if the data were stored in regular database tables. Data can be read from or written to external tables.
An external table is a Greenplum database table backed with data that resides outside of the database. An external table is either readable or writable. It can be used like a regular database table in SQL commands such as
INSERT and joined with other tables. External tables are most often used to load and unload database data.
Web-based external tables provide access to data served by an HTTP server or an operating system process. See Creating and Using External Web Tables for more about web-based tables.
CREATE EXTERNAL TABLESQL command to access external data served by the Greenplum Database
gpfdistfile server utility. When external data is served by gpfdist, all segments in the Greenplum Database system can read or write external table data in parallel.
Parent topic: Greenplum Database Administrator Guide