Skip to content

Supported Platforms

This page provides an overview of the platforms you can use to execute SQL-based tests and the necessary configuration values required for the setup.

Supported

  1. PostgreSQL PostgreSQL ✅
  2. Snowflake Snowflake ✅
  3. Databricks Databricks ✅

In Planning

  1. Firebolt ❌
  2. AWS Redshift ❌
  3. Azure Synapse ❌
  4. Google BigQuery ❌
  5. MS SQL Server ❌

PostgreSQL PostgreSQL

PostgreSQL is a powerful, open-source relational database system.:

Configuration Values: - host: The hostname or IP address of your PostgreSQL server. - port: The port on which PostgreSQL is running (default is 5432). - dbname: The name of the database to connect to. - user: The username for authentication. - password: The password for the user. - schema: The schema to set in the current connection session. - sslmode (optional): The SSL mode for the connection (e.g., disable, allow, prefer, require).

Example Configuration File:

[DEFAULT]
host = your-postgresql-host
port = 5432
dbname = your-database-name
user = your-username
password = your-password
schema = your-schema-name
sslmode = disable

Snowflake Snowflake

Snowflake is a fully managed cloud data platform that supports scalable storage and high-performance analytics. Here is how to configure Snowflake for executing your SQL-based tests.

Configuration Values: - account: Your Snowflake account identifier - user: The username for Snowflake authentication. - password: The password for your Snowflake account. - warehouse: The name of the virtual warehouse to use for computations. - database: The name of the database to connect to. - schema: The schema to use within the specified database. - role (optional): The role to assume for the session (default is the user's default role).

Example Configuration File:

[DEFAULT]
account = your-snowflake-account
user = your-snowflake-user
password = your-snowflake-password
warehouse = your-virtual-warehouse
database = your-database
schema = your-schema-name
role = your-role-name

Databricks Databricks

Databricks provides a cloud-based data analytics platform and SQL-based querying engine.:

Configuration Values: - server_hostname: The Databricks server's hostname. - http_path: The HTTP Path of the Databricks SQL endpoint. - access_token: Your personal access token for authentication.

Example Configuration File:

[DEFAULT]
server_hostname = your-databricks-hostname
http_path = your-databricks-http-path
access_token = your-access-token