1. Click Add New Connection from the Data Sources tab in Settings. 

1. • Rename the Connection, if desired.
2. Choose MySQL from the Connection Type drop-down.
3. Enter the Database Name.
4. Enter the Port Number. (3306 is the default)
5. Enter the Database URI.
6. Enter your MySQL Username.
7. Enter your MySQL Password.
8. Click the Test Connection button.

When your connection is successfully set up, you will see it listed as an option in the drop-down menu when loading data as a query data source.

Connecting directly to a Snowflake instance allows users to push down queries and transformations into Snowflake where the data resides, eliminating the need to extract data. This leverages the in-database data processing capabilities while maintaining compliance, security, and governance.

To add a Snowflake connection:

1. Click Add New Connection from the Data Sources tab in Settings. 

1. • Rename the Connection, if desired.

2. Select Snowflake from the Connection Type drop-down.

3. Enter a Role.

4. Enter a Warehouse, if desired.

5. Enter a Database Name.

6. Enter a Port Number. (443 is the default)

7. Enter a Database URI.

8. Enter your Snowflake Username

9. Enter your Snowflake Password.

10. Click the Test Connection button.

When your connection is successfully set up, you will see it listed as an option in the drop-down menu when loading data as a query data source.

Connecting directly to a Databricks instance allows users to push down queries and transformations into Databricks where the data resides, eliminating the need to extract data. This leverages the in-database data processing capabilities, including Spark, while maintaining compliance, security, and governance.

To add a Databricks connection:

1. Click Add New Connection from the Data Sources tab in Settings. 

1. • Rename the Connection, if desired.

2. Select Databricks from the Connection Type drop-down.

3. Enter a Schema.
4. Enter a Unity Catalog, if desired and in use in your Databricks instance.
5. Enter a Port Number. (443 is the default)
6. Enter a Database URI.
7. Enter a HTTP Path.

8. Enter your Databricks Username

9. Enter your Databricks Password.

   Note: If desired, you can use a Personal Access Token (PAT) in place of username and password. In this case, enter "token" as the Username and your PAT as the password. This may be required if Single Sign On (SSO) is configured in your Databricks instance.

10. Click the Test Connection button.

When your connection is successfully set up, you will see it listed as an option in the drop-down menu when loading data as a query data source.

Open Database Connectivity (ODBC) Drivers allow applications to access data in database management systems (DBMS) using SQL as a standard for accessing the data.

Supported drivers in Virtualitics Explore include:

• Databricks (Simba Spark)

• Snowflake

• MySQL

• PostgreSQL

• Hive

• Impala

• Amazon Redshift

• Microsoft SQL Server
  

1. Select one of the above drivers to use in the Driver drop-down.
2. In the JSON field, enter any valid ODBC connection options. At a minimum, it must contain the “DSN” option, referencing a configured ODBC Data Source.
3. Enter a username/password as applicable.