Example of Migration to create a table with cached results: Materialised view table

materilize_view_migration.rb

class MaterialisedView < ActiveRecord::Migration[5.2]
  def change
    execute <<-SQL
      CREATE TABLE mv_complex_query
          COMMENT 'Updated every 5m by the mv_complex_query event'
          SELECT * FROM big_table
    SQL

    execute <<-SQL
      CREATE EVENT dump_mv_complex_query
      ON SCHEDULE EVERY 5 MINUTE
      DO BEGIN
          CREATE TABLE mv_complex_query_new
              COMMENT 'Updated every 5m by the dump_mv_complex_query event'
              SELECT * FROM big_table;
          RENAME TABLE
              mv_complex_query TO mv_complex_query_old,
              mv_complex_query_new TO mv_complex_query;
          DROP TABLE IF EXISTS mv_complex_query_old;
      END
    SQL
  end
end

big_table could be any complex query or views