MotherDuck

1. Create a MotherDuck service token

What: Create a token Querio can use to connect.

How:

1. Log in to MotherDuck
2. Go to Settings > Service Tokens
3. Click Create Service Token
4. Give it a descriptive name
5. Copy the token and store it securely

2. Grant read-only access

What: Limit Querio to the databases and schemas it should query.

GRANT SELECT ON ALL TABLES IN DATABASE my_database TO querio_service_token;
GRANT SELECT ON ALL TABLES IN SCHEMA my_database.my_schema TO querio_service_token;

Adjust the database and schema names for your setup.

3. Share connection details

For MotherDuck, provide the service token and database name.

Connection string format:

md:<database>?motherduck_token=<service_token>