migro

migro

Data Warehouse migrations for dbt.

Setup

• Install migro in a dbt project.

   pip install migro
  

• Create a migration. For example:

   mkdir migrations
   migro make create_bobby_tables_user
  

• Open the sql file in the migrations folder and add this statement.

   create user bobby_tables password='{{ password }}';
   -- Redshift syntax:
   -- create user bobby_tables with password '{{ password }}';
  

• Pretend to run the migration. Notice the password generated by the {{ password }} jinja template.

   migro up --pretend --limit=1
  

• Now run the migration.

   migro up
  

• Query the new migrations table to see the migration history.

   select * from public.migrations order by id;
  

Data Warehouse Support

• Redshift
• Snowflake