Creating Foreign Table

Foreign tables created using query execution in SQL Terminal or any other tool can be viewed in the Object browser after refresh.

1. To view the newly created foreign table, right-click and select Refresh either at database, schema and foreign table group level.
   

   • GDS Foreign table is denoted with icon before the table name.
   • HDFS Foreign table is denoted with icon before the table name.
   • HDFS Foreign table with partition is denoted with icon before the table name.