You can create views with the Create View statement. A view is like a named query. The view can refer to any combination of remote and local tables as well as other views.
You can create a local table using the Create Table statement. A local table is maintained by the driver and is local to the machine on which the driver is running. A local table is exposed in the PUBLIC schema.