AWS resources

To get started, you will need an S3 bucket, for instance my-bucket, and an Athena database:

CREATE DATABASE IF NOT EXISTS analytics_dev
COMMENT 'Analytics models generated by dbt (development)'
LOCATION 's3://my-bucket/'
WITH DBPROPERTIES ('creator'='Foo Bar', 'email'='foo@bar.com');

If the database does not exist, then dbt will attempt to create it automatically.

AWS Glue

You can also use AWS Glue to create and manage your Athena databases.