Open the configuration file in a text editor and manually add views to the [SOURCE_INDIRECT_TABLES] section. Use the following syntax:

TABLE
id=
view_name

To unload specific columns from a view, add a statement for each view on a separate row in the [SOURCE_INDIRECT_TABLES_COLUMNS_LIST] section. In each view statement, list the columns to unload, using a comma (,) as the separator. Use the following format:

TABLE
id_COLUMN_LIST=
column_name_1,
column_name_2,...

For example, the following statements unload data from three columns of the DEMO_VIEW view:

[SOURCE_INDIRECT_TABLES]
TABLE1=DEMO_VIEW

[SOURCE_INDIRECT_TABLES_COLUMNS_LIST]
TABLE1_COLUMN_LIST=COLUMN1,COLUMN2,COLUMN3

Define an SQL query that selects data from the view. In the query statement, use the full view name, including the schema name. You can define an SQL query for a configuration file in the Fast Clone Console.