Blink supports multiple types of SQL servers and database providers:

PostgresSQL

MySQL

ClickHouse

Oracle Database

Microsoft SQL Server

Snowflake

Vertica

All Run Database Actions enable you to the view results in the following output formats:
  • Table
  • Comma Separated Values (CSV)
  • JSON
Note: There is a max limit on the amount of data returned. Use SELECT, WHERE, and LIMIT clauses to reduce the result size.

​
Creating a connection

For Snowflake and Vertica, refer to their corresponding documentation pages. For the other database types, you can connect in two ways:

​
Connecting via password

  1. Access your database server.
  2. Choose which account and database you wish to connect with.
  3. In the Blink platform, choose the type of server (Postgres, MySQL, etc.).
  4. Insert your username and password.
  5. Insert the hostname (IP or domain) of the server along with the port number to connect with.
  6. Insert the name of the database to use to connect.

​
Connecting via Database Source Name

You can connect directly via a Database Source Name (DSN) to pass any unique connection or authentication parameters. Refer to the Postgres, MySQL, and ClickHouse documentation on how to format their respective DSN strings.

​
Actions

​
Run Postgres Query

Runs a PostgreSQL query on a database.
ParameterDescription
SQL QuerySQL statement to execute.
Output formatRepresentation of the output result.

​
Run MySQL Query

Runs a MySQL query on a database.
ParameterDescription
SQL QuerySQL statement(s) to execute.
Output formatRepresentation of the output result. When executing multiple statements, only the first statement’s results will be displayed.

​
Run Oracle Database Query

Run a query on an Oracle database.
ParameterDescription
QuerySQL or PL/SQL statement(s) to execute.

For SQL queries, use standard SQL syntax without a semicolon at the end. For PL/SQL blocks, include semicolons within the block and end with a semicolon, for example -

<br/>begin DBMS_LOCK.sleep(7); end;<br/>
Output FormatRepresentation of the output result. Only the first statement’s results will be displayed.