title: What is the correct way of updating a table without having dashboards without data that depend on those tables?
body: <p>I have a dashboard with charts that uses <code>table_a</code> information. Every 2 hours I drop the <code>table_a</code> and rewrite the new data to it so that my dashboard would have 2-hour uptime. Every these 2 hours there is a 15-minute gap where the data is not available for the dashboard because it is being calculated.</p>
  
  <p>I was wondering what is the correct approach to avoid this 15-minute gap. I am thinking of these steps:</p>
  
  <ol>
  <li>Copy the existing table_a to table_a_temp</li>
  <li>Write the new data to table_a_temp</li>
  <li>Drop table_a</li>
  <li>Rename table_a_temp to table_a</li>
  </ol>
  
  <p>Are there any other solutions that are more efficient? </p>