Specifies table options for the foreign table. Can be any table_option allowed in CREATE TABLE (see table_option), except as noted:
The following table options are not supported for foreign tables:
- BLOCKCOMPRESSIONLEVEL
- BLOCKCOMPRESSIONALGORITHM
- BLOCKCOMPRESSION
- MERGEBLOCKRATIO
- CHECKSUM
- DATABLOCKSIZE
- FREESPACE
- Journal table
The following table options are not supported for external data formatted as Parquet:
- Row partitioning
- Subrow partitioning
- Multicolumn partitions
- Autocompression
- MAP
- You can specify an existing contiguous or sparse map for the table.
- map_name
- Name of an existing contiguous or sparse map.
- COLOCATE USING colocation_name
- Optionally, you can specify a colocation name so that the tables reside on the same AMPs to avoid a redistribution of the rows when the tables are joined on a primary index or primary AMP index. For example, you can colocate two tables, then join the tables on the primary index or primary AMP index columns.