Create a separate secondary database for refresh

refresh_secondary_database.sql

-- A separate new database
CREATE DATABASE refresh_secondary_database;

-- Create a new schema
CREATE SCHEMA refresh_secondary_database.amadeus_dynamic_pricing;

-- Task that refreshes the secondary database on a schedule
CREATE OR REPLACE TASK refresh_secondary_database.amadeus_dynamic_pricing.dynamic_pricing_data_refresh_task
  WAREHOUSE = WH01_XS
  SCHEDULE = 'USING CRON 0 3 * * * UTC'
AS
  ALTER DATABASE AMADEUS_DYNAMIC_PRICING REFRESH
;