To connect to a Database, click the (+)New-button to the top right of the app and choose Database connection or browse to the data tab and click on New Database.

Choose the Database type you want to connect to.

Please make sure to whitelist the following IP address so pushmetrics.io can connect to your database:

18.156.113.81/32

Connection credentials are always stored encrypted and we always use SSL/TLS encryption in transit if your database supports it.

Query timeout

Each database connection has an optional Query timeout (seconds). When a query run by a report, notebook, or SQL block takes longer than this limit, PushMetrics stops it — and, on the databases that support it, the query is cancelled on the database itself so it stops consuming resources on your warehouse.

  • Where to set it: on the database connection form when you add or edit a connection.
  • Range: 30 to 1800 seconds (30 minutes). Leave it blank to use the platform default of 3600 seconds (1 hour).
  • Why it exists: it prevents a single long-running query from tying up shared processing capacity, so reports across your workspace keep running smoothly. Setting a value below the default protects your own warehouse from runaway queries too.

Where the timeout is enforced on the database

On these databases the timeout is applied directly on the connection, so the query is cancelled at the source:

  • PostgreSQL
  • Amazon Redshift
  • MySQL
  • Snowflake
  • Databricks
  • Clickhouse
  • Vertica
  • Exasol

On the following, the per-database timeout is not enforced — these databases have no session-level statement-timeout mechanism, so a long query is only stopped by PushMetrics' overall run limit, not at your configured value:

  • BigQuery
  • Amazon Athena
  • Amazon DynamoDB
  • Google Sheets
  • IBM DB2
  • Microsoft SQL Server
  • Mongo BI
  • Oracle

MariaDB note: MariaDB connects using the MySQL driver, and the MySQL statement-timeout syntax does not apply on MariaDB. So on MariaDB the per-database timeout is not enforced at your configured value — the query runs until PushMetrics' overall run limit.

Supported Databases

PushMetrics supports the following databases and data sources:

Additional databases available via the generic connection form:

  • Apache Impala
  • Apache Kylin
  • Firebird

If your database is missing, get in touch to request support for it.