Configuration


Configuring your project is done with a simple YAML file, named quary.yaml and placed at the root of a project. The file defines which database to use and how to connect to it. The following are the different options for configuring the database.

SQLite

SQLite is a database type that runs locally, it is a file-based database. It is a good choice for small projects and for testing. It can be operated in two manners

In Memory

The database is created in memory and is lost when the application is closed. It is faster than the file-based version and is good for rapid testing.

sqliteInMemory: {}

File Based

The other option is to use a file based database, where the database is stored in a file on the disk and is persisted between runs. In this case the path to the file is specified, and each run creates the file if it does not exist. It is useful for testing, for small projects and when you want to use the database in different applications.

sqlite:
  path: db.sqlite

BigQuery

BigQuery is a cloud based database, it is a good choice for large projects and for production. It is operated by Google and is part of the Google Cloud Platform. To use BigQuery you need to create a project in the Google Cloud Platform and enable BigQuery for the project. You can configure the connection to BigQuery with the following configuration.

bigQuery:
  projectId: my-project-id
  datasetId: my-dataset-id

Snowflake

Snowflake is a cloud-based data warehousing platform that offers scalable, on-demand storage and computing power and that separates storage and compute, enabling users to independently scale and pay for each.

snowflake:
  accountUrl: account-url
  clientId: client-id
  clientSecret: client-secret
  role: your-quary-role
  database: database-name
  schema: schema-name
  warehouse: warehouse-name