Cloud
This section describes the provider-specific properties required to configure Cloud database connections in Kyvos Reporting. The following Cloud providers are supported under this category: Amazon EC2, Snowflake, Google BigQuery, and Amazon Redshift.
Properties that are common across Cloud providers are documented in the Common Properties section.
To create a connection, go to Navigate > Administration > Configure > Connections. Click Add.
In the Provider list, select Cloud and then the required database. You can also search for the required database from the search bar.
Properties
Amazon EC2
Property | Description |
|---|---|
Access Key | Access Key ID that identifies the AWS account making service requests. |
Secret Key | Secret Access Key associated with the Access Key ID, used to sign requests. |
Bucket | Bucket name where objects are organized and accessed. |
Snowflake
Property | Description |
|---|---|
Driver Version | Select the Snowflake JDBC driver version to use for this connection. |
Server | Host name or IP address of the Snowflake server. |
DB | Name of the database to connect to. |
Warehouse | Name of the virtual warehouse that provides compute resources. |
Schema | Schema to be used for the specified user in this connection. |
Google BigQuery
Prerequisite
A GCP Service Account with BigQuery access and a JSON key file available on the server.
Property | Description |
|---|---|
Connection Name | Unique name for the connection (for example, |
Project ID | GCP project ID where the BigQuery datasets are hosted. |
Service Account Email | Email ID of the GCP Service Account used for authentication. |
Private Key Path | Absolute path to the Service Account JSON key file on the server. |
Amazon Redshift
Property | Description |
|---|---|
Connection Name | Unique name for the connection. |
Host | Endpoint of the Amazon Redshift cluster. |
Port | Port on which the Redshift cluster listens. |
Database | Name of the Redshift database to connect to. |
Username | Username with permissions to access the database. |
Password | Password associated with the specified user. |
Schema | Default schema to be used for the connection. |