Skip to main content

Run Database Actions

Run Database Actions allow you to perform SQL statements against remote databases.

Blink supports multiple types of SQL servers and database providers:

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.