Osquery uses basic SQL commands to leverage a relational data-model to describe a device.

osquery

image-20240702-191703.png

Screenshot 2024-07-30 at 10.14.23 AM.png

Hi guys, I'm trying to host fleetdm on AWS with Terraform. I've followed the instructions and set everything up, but there are errors in the log. Any leads on what's going on and how to fix this?

You need to run a command first, did you apply the terraform in the staggered way?

If possible, run an ecs task to
```fleet prepare db```


```aws ecs execute-command --cluster &lt;cluster-name&gt; --task &lt;task-arn&gt; --container &lt;container-name&gt; --command &lt;command&gt;```

You can have migrations run as part of the deployment process by using the migrations module. That's included in the example setup <https://github.com/fleetdm/fleet/blob/56bdfdcda60c9262503fbe616b23a667fe8da99a/terraform/example/main.tf#L118|here>.

Awesome! It's now up and running, thanks guys!