Data connections

You can configure data connections to external databases either through vianctl command line interface (CLI) or the hila monitoring app (UI).

CLI

The quick way to configure a data connection is to run the following vianctl command, giving your connection parameters. Be sure to replace the placeholders with your actual values.

vianctl externalconnections create --name <NAME_OF_CONNECTION> --description "<DESCRIPTION_OF_CONNECTION>" --type <DB_TYPE> --url "<YOUR_URL>"

Examples for popular databases:

vianctl externalconnections create --name my_snowflake_connection --description "Snowflake connection" --type snowflake --url "snowflake:<CREDENTIAL_STRING>"
vianctl externalconnections create --name my_bigquery_connection --description "BigQuery connection" --type bigquery --url "bigquery:<CREDENTIAL_STRING>"
vianctl externalconnections create --name my_oracle_connection --description "Oracle connection" --type oracle --url "oracle:<CREDENTIAL_STRING>"
vianctl externalconnections create --name my_azuresql_connection --description "Azure SQL connection" --type azuresql --url "mssql+pyodbc:<CREDENTIAL_STRING>"
vianctl externalconnections create --name my_databricks_connection --description "Databricks connection" --type databricks --url "databricks:<CREDENTIAL_STRING>"

UI

In the hila monitoring app, create a new data connection in the Data Source Connections window by clicking the User button menu at the bottom of the hila left nav bar, followed by clicking Settings and then Data Source Connections.

1. Click Add New Connection to open the Add New Data Source Connection pane.

2. Enter a name, description, URL, and select a connection type.

3. The Test Connection button becomes active. Click the button to test. If the connection is successful, hila shows a menu for you to view the tables in the database you’ve connected to.

4. Delete, test, or edit the connection by clicking the relevant action under the ACTIONS column.