title: Snowflake: create or replace table vs insert overwrite into table
body: <p>I am creating a table in Snowflake that will be used by a SQL Server stored procedure (using <code>Openquery</code>) to return data.</p>
  <p>When the Snowflake task executes to refresh the data in the table, is it better to run a <code>&quot;create or replace table&quot;</code> statement or use an <code>&quot;insert overwrite into table&quot;</code> statement?</p>
  <p>I'm looking to avoid a period of time when there is no data available to the SQL Server stored procedure.</p>
  <p>Is one of these approaches better for keeping existing data available until the task to refresh the table finishes?</p>