title: Creating a table in a database of a connection and retrieving data from another connection
body: <p>So I came up with a situation where I need to create a table on a database (Connection 1) and need to fill it up with data from another connection (Connection 2).</p>
  <p>Right now I am creating these tables and filling them up with a select query in the same server using this example: <code>CREATE TABLE table 1 as SELECT * FROM database.dataTable</code>, However I am stuck to Create <code>table1</code> in a database in (Connection 1) and filling it up from (Connection 2).</p>
  <p>To explain my self better I need to do something like this <code>CREAT TABLE table1(Connection 1) as SELECT * FROM database.dataTable(Connection 2)</code>. I am using python.</p>