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.

    Note

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

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

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