Run Database Actions

Blink supports multiple types of SQL servers and database providers: All Run Database Actions enable you to 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.

​

Run MySQL Query

Runs a MySQL query on a database.

​

Run Oracle Database Query

Run a query on an Oracle database.