Getting Started

Getting ready to use the AWS Integration from Query.Farm is easy, just follow these steps.

Installation Steps

1. Install DuckDB version 1.1.1 or later.

2. Install the Airport extension from Query.Farm via DuckDB.

   INSTALL 'airport' from community;
   LOAD 'airport';

3. Create an account at Query.Farm for AWS to create an access token and setup AWS credentials/roles.

   Create Account

4. Store the access token using the DuckDB secrets manager.

   CREATE PERSISTENT SECRET aws_secret (
    TYPE AIRPORT,
    auth_token '123456789abdef',
    scope 'grpc://aws.flights.query.farm:8080/'
   );

5. Attach the connection.

   ATTACH 'aws' (TYPE AIRPORT, location 'grpc://aws.flights.query.farm:8080/');

6. You’re ready to query!

   SELECT * from aws.sts.get_caller_identity;