Document toolboxDocument toolbox

Supported environments and connections

Owned by Sarabjeet Kaur
Last updated: Aug 28, 2024
2 min read

Applies to: Kyvos Enterprise Kyvos Cloud (SaaS on AWS)  Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)  

Kyvos SNI supports the following warehouse connections: 

  • BigQuery

  • Teradata

  • Azure SQL Database

  • Oracle RDS

  • Snowflake  

  • Generic

  • Databricks SQL Warehouse

Note

Kyvos SNI does not support Redshift connection. 

Supported Platforms 

Following are the supported platforms.  

Cloud Platform 

Instance

Cloud Platform 

Instance

AWS 

EC2 Instance

GCP 

VM Instance

On Prem

On Prem

Azure 

VM Instance

Supported Operating Systems 

Platform

Supported OS

Platform

Supported OS

On-premise

CentOS 7.x

AWS

Amazon Linux 2

Azure

RHEL 8.x

GCP

CentOS 7.x

BigQuery

Prerequisites

You must create a service account. To know more about creating a service account, refer to Google Cloud documentation. 

  • After creating a service account, assign the following permissions: 

    • To the service account used by Kyvos VMs, add the following roles on the BigQuery Project:

      • BigQuery Data Viewer

      • BigQuery User

    • For accessing BigQuery Views, add the following permissions to the Kyvos custom role (created above). To create a custom role, refer to Google Cloud documentation.

      • bigquery.tables.create

      • bigquery.tables.delete

      • bigquery.tables.update

      • bigquery.tables.updateData

  • Before establishing a BigQuery connection, see the Working with a BigQuery warehouse connection section for more details.

  • For a GCP environment only, you can select either Application Default Credentials Authentication or Google Service Account Authentication. 

Important

  • For using Application Default Credentials authentication on GCP environment, you need to launch an instance using service account.

  • DO NOT use Application Default Credentials for AWS, Azure, and On-Prem. 

  • For AWS, Azure, or on Prem environment, select the Google Service Account authentication type.

Teradata

Prerequisites

The Teradata application must be up and running. 

AzureSqlDB

Prerequisites 

Allow public Internet IP addresses to access your resource at the Azure SQL Server if access to Azure resources is from other platforms.

Generic

Kyvos SNI allows for Generic JDBC connectivity with any source that offers JDBC-based connectivity. To establish this connection, simply upload the compatible driver version jar from Kyvos Manager.

The following connections are certified through Generic JDBC flow.  

  • AWS-Databricks 

  • Azure-Databricks: Databricks connectivity with Kyvos Single Node Installation is certified with Personal Access Token-based authentication.

Oracle RDS

Prerequisites 

  • No prerequisite and permissions are required if the Oracle RDS database is available on the same platform and within the same account. 

  • Oracle RDS should be up and running

Snowflake  

There is no prerequisite for Snowflake. 

Important

Kyvos SNI 2023.2 setup does not support the following: 

  • Windows and Mac Operating System

  • Disaster Recovery in case of node or disk failure.

  • SQL and HCatalog-based files 

  • Redshift connection

  • SQL Engine – Athena and Presto

  • Graviton EC2 instances

  • Semantic models are processed locally on the same node. External process clusters are not supported. 

  • Backup is supported through EBS snapshot

Databricks SQL Warehouse

  • Supported only with premium workspace.

  • Supported only with Personal Access Token authentication.

  • Storage Blob Data Contributor rights are required for the user. 

  • You must have permission to create (and map) Storage credentials and External Locations for the Unity Catalog.

For more information, see the Working with Databricks SQL warehouse for Azure section.

Read more: 

Appendix: Ports required for Kyvos

Copyright Kyvos, Inc. All rights reserved.