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:
Note: There is a max limit on the amount of data returned.
Use SELECT
, WHERE
, and LIMIT
clauses to reduce the result size.
For Snowflake and Vertica, refer to their corresponding documentation pages.
For the other database types, you can connect in two ways:
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.
Runs a PostgreSQL query on a database.
Parameter | Description |
---|---|
SQL Query | SQL statement to execute. |
Output format | Representation of the output result. |
Runs a MySQL query on a database.
Parameter | Description |
---|---|
SQL Query | SQL statement(s) to execute. |
Output format | Representation of the output result. When executing multiple statements, only the first statement’s results will be displayed. |
Run a query on an Oracle database.
Parameter | Description |
---|---|
Query | SQL 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 Format | Representation of the output result. Only the first statement’s results will be displayed. |
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:
Note: There is a max limit on the amount of data returned.
Use SELECT
, WHERE
, and LIMIT
clauses to reduce the result size.
For Snowflake and Vertica, refer to their corresponding documentation pages.
For the other database types, you can connect in two ways:
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.
Runs a PostgreSQL query on a database.
Parameter | Description |
---|---|
SQL Query | SQL statement to execute. |
Output format | Representation of the output result. |
Runs a MySQL query on a database.
Parameter | Description |
---|---|
SQL Query | SQL statement(s) to execute. |
Output format | Representation of the output result. When executing multiple statements, only the first statement’s results will be displayed. |
Run a query on an Oracle database.
Parameter | Description |
---|---|
Query | SQL 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 Format | Representation of the output result. Only the first statement’s results will be displayed. |