If you use a three-part table name and the location is not the current one, a temporary connection to the new location is established.
To define a new column, click +.