Looking to install DBT on an EC2 instance. The environment dictates it get installed on its own instance in our VPC using Terraform. Upon reviewing the install / environment docs, I wasn’t able to find anything that pointed to pre-req’s, sizing, etc. Any guidance is hugely appreciated.
I’d take a look at the terraform docs:
- A t2.micro will be plenty enough.
- ubuntu or and AWS ami will work
- if you can’t ssh into the ec2 instances for security reasons, look into setting up a bootstrap script that will inject your DB credentials into ~/.dbt/profiles from secrets manager and also setup a cronjob on it to run the work on the schedule you require.
Hope that helps.