Prerequisites for deploying Kyvos in GCP using Deployment Manager

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

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

You must fulfill the following prerequisites to deploy Kyvos in a GCP environment.

• Prerequisites to deploy Kyvos using Dataproc

• Prerequisites to deploy Kyvos using Kubernetes

Prerequisites to deploy Kyvos using Dataproc

1. Automated resource creation using the script

   1. Permissions required by Google Console users:  

      1. Logged-in users should have the privilege to launch deployment in GCP Deployment Manager.

      2. Logged-in users must have the Viewer predefined role attached.

      3. You must create a custom role. To do this, click Roles > Create new role .
         Provide a name like Kyvos-deployment-role; assign the following permissions, and then attach to the logged-in user service account.

         • deploymentmanager.deployments.create  

         • deploymentmanager.deployments.delete  

         • deploymentmanager.deployments.get  

         • deploymentmanager.deployments.list  

         • deploymentmanager.deployments.update  

         • deploymentmanager.manifests.get  

         • deploymentmanager.operations.get  

         • storage.objects.get

         • compute.subnetworks.use

           NOTE: The above permissions are only required to launch deployment. To view the resources after deployment, the user must have permission on the relevant resources.

   2. The GCP Deployment Manager template is deployed through the logged-in user, and the resources inside the template are created through the default service account of GCP Deployment Manager.
      To create other Google Cloud resources, Deployment Manager uses the credentials of the Google APIs Service Agent to authenticate to other APIs. The Google APIs Service Agent is designed specifically to run internal Google processes on your behalf. This service account is identifiable using the email: [PROJECT_NUMBER]@cloudservices.gserviceaccount.com  

      1. The service account must have the Editor predefined role attached.

      2. You must create a custom role. To do this, click Roles > Create new role . 
         Provide a name like Kyvos-deployment-role; assign the following permissions, and then attach to the service account:

         • cloudfunctions.functions.setIamPolicy  

         • storage.buckets.get  

      3. Compute Network User: If using a Shared Network, grant the above service account the 'Compute Network User' predefined role to the project where the network originally resides. 

      4. If a service account is created from the template, the following permissions must be assigned to the custom role (Kyvos-deployment-role).

         • iam.roles.create  

         • iam.serviceAccounts.setIamPolicy  

         • resourcemanager.projects.setIamPolicy  

2. Manual resource creation: Google Console users should have the privilege to launch Google resources like Instances, Dataproc cluster, Google Storage, and Disks in the Project.  

3. Dataproc Service Agent service account: Dataproc creates this service account with the Dataproc Service Agent role in a Dataproc user's Google Cloud project. This service account cannot be replaced by a user-specified service account when you create a cluster. This service agent account is used to perform Dataproc control plane operations, such as creating, updating, and deleting cluster VMs. Please refer to Dataproc Service Agent (Control Plane identity) for details.
   By default, Dataproc uses the service-[project-number]@dataproc-accounts.iam.gserviceaccount.com as the service agent account. If that service account doesn't exist, Dataproc uses the Google APIs service agent account, [project-number]@cloudservices.gserviceaccount.com, for control plane operations.   

   Permission required :    

   • The above service account must have the Dataproc Service Agent predefined role attached

   • Compute Network User: If using a Shared Network, grant the above service account the 'Compute Network User' predefined role to the project where the network originally resides.

4. Kyvos needs a service account to launch the Kyvos instance. Refer to the steps given in the Service Account section to create it.

5. The logged-in user will need access to VPN, Subnet, Network Interface/Security Group, and Service Account, which will be used by Kyvos to launch compute engines, Dataproc, and Instance Group.

6. Ensure that the following ports are opened/allowed in the Firewall inbound rules for all internal communication between Kyvos instances.
   2121, 2181, 2888, 3888, 4000, 6602, 6903, 6703, 45450, 45460, 45461, 45462, 45463, 45464, 45465, 6603, 6702, 6803, 7003, 45440, 6605, 45421, 45564, 4000, 8080, 8081, 8005, 8009, 8443, 8444, 9443, 22 and 9444.

7. Ensure that the following ports are opened/allowed in the Firewall inbound rules for all internal communication between the Dataproc cluster and Kyvos.
   3306, 8030, 8031, 8032, 8033, 8042, 8088, 9083, 8188, 18080, 8050, 8051, 8020, 10020, 19888, 10033, 8188, 9870, 10200, 10000, 10002, 22, 45460, 9866, 8998, and 9867
   NOTE: The port 8998 is required for Livy.

8. Ports 22, 8080, and 8081 should be accessible from outside of the cluster from where you want to access the Web application.

9. Create a firewall rule with all ports open between Dataproc master and worker nodes using network tags as targets, which will be attached to the Dataproc.
   For more information about the required ports between the Dataproc master nodes and the worker nodes, refer to GCP documentation at: Dataproc Cluster Network Configuration

10. If the Kyvos instances and Dataproc clusters are launched in a different VPN/Subnet, then Network Peering should be created between both networks.

11. There should be a private and public key for creating the Kyvos instances and the Dataproc cluster.

12. Kyvos will need the Storage Legacy Bucket Owner role on the storage bucket to store data (semantic models).

13. To access the storage bucket from the Kyvos instances, a NAT Gateway in VPC or Endpoint between storage and VPC should be available.  

14. To send requests to your VPC network and receive the corresponding responses without using the public internet, you must use the Serverless VPC Access connector.
    Serverless VPC Access uses the   Serverless VPC Access Service Agent   service account. This service account's email address has the following form:

    ^{service-PROJECT_NUMBER@gcp-sa-vpcaccess.iam.gserviceaccount.com}

    Permissions required:

    • By default, the above service account has the Serverless VPC Access Service Agent role (roles/vpcaccess.serviceAgent). Serverless VPC Access operations may fail if you change this account's permissions.

    • If using a Shared Network, grant the above service account the Serverless VPC Access Service Agent predefined role to the project where the network originally resides.

      NOTE: You can refer to the GCP documentation to create a Serverless VPC Access connector. 

15. Create an Autoscaling policy using Kyvos recommended configuration for Dataproc.

16. Private Google Access must be enabled for the subnet that you will use for deploying Kyvos and Dataproc clusters.

17. To enable external Hive metastore, the role attached to the Kyvos Manager node must have the following permissions:

    • resourcemanager.projects.list

    • dataproc.clusters.get

    • compute.instances.get

18. If your bucket is in another project, then for cross-project bucket access, you must provide the following permissions on your bucket.

    • storage.object.list

    • storage.object.get

19. For cross-project metastore and Dataproc, assign the following roles on the project having metastore. Refer to the GCP documentation for details.

    • Dataproc Service Agent

    • Dataproc Metastore Service Agent

20. Ensure that the Kyvos deployment and the Dataproc cluster for use with Kyvos run in the same Project and Region.

21. Kyvos recommend instance configuration:

    1. Machine type for Kyvos Manager, Query Engine, and BI Server: 
       Kyvos Manager: n2-standard-4
       Query Engine: n2-highmem-4
       BI Server: n2-standard-8

    2. Master and worker nodes of Dataproc cluster
       Master Node:
       Series: N2
       Machine Type – n2-highmem-4 (4 vCPU and 32 GB)

       Worker Node:
       Series: N2
       Machine Type: n2-highmem-8 (8 vCPU and 64 GB)

22. If the Dataproc cluster is in a different region, then under compute metadata VmDnsSetting, set the value as GlobalDefault.

23. For a non-SSH based cluster,  If you use an existing Dataproc cluster and an existing bucket, you must execute the dataproc.sh script (available in the GCP Installation Files folder) on the master node of Dataproc after changing the values of DEPLOYMENT_BUCKET, WORK_DIR, COPY_LIB, and DATAPROC_VERSION to the name of the existing bucket.

24. To store repository credentials and other confidential credentials on the Secret Manager, you need to create a Secret.

25. To deploy the Kyvos cluster using  password-based authentication  for service nodes, ensure that the permissions listed here are available on all the VM instances for Linux user deploying the cluster.

26. To deploy the Kyvos cluster using  custom hostnames  for resources, ensure that the steps listed here are completed on the resources created for use in the Kyvos cluster.

27. If using shared VPC, the VPC must be shared with the project that you want to access.

    1. Navigate to the VPC network.

    2. Click the Shared VPC.

    3. Go to the ATTACHED PROJECTS tab and attach the project.
       NOTE: This should be performed from the project where the shared VPC network originally resides.

       Open

       

Creating a service account from Google Cloud Console

1. Click Roles > Create new role. Provide a name like Kyvos- role for storage service, and assign the following permissions.

2. Go to IAM & Admin > Service Account. Create a service account for Kyvos.

3. Click Edit to add roles in the service account and add the following roles.

   • Kyvos-role (created in step 1)

   • BigQuery data viewer

   • Workload Identity User

   • BigQuery user

   • Dataproc Worker

   • Cloud Functions Invoker

   • Cloud Scheduler Admin

   • Cloud Scheduler Service Agent

   • Service Account User

   • Logs Writer

4. Permissions for Cross-Project Datasets Access with BigQuery:

   1. Use the same service account that is being used by Kyvos VMs.

   2. Give the following roles to the above-created service account on the BigQuery Project.

      • BigQuery Data Viewer

      • BigQuery User

5. Prerequisites for Cross-Project BigQuery setup and Kyvos VMs.

   1. Use the same service account that is being used by Kyvos VMs.

   2. To the service account used by Kyvos VMs, give the following roles on the BigQuery Project:

      • BigQuery Data Viewer

      • BigQuery User

6. For accessing BigQuery Views, add the following permissions to the Kyvos custom role (created above).

   • bigquery.tables.create

   • bigquery.tables.delete

   • bigquery.tables.update

   • bigquery.tables.updateData

7. Permissions to generate Temporary Views in Separate Dataset when performing the validation/preview operation from Kyvos on Google BigQuery.

   • bigquery.tables.create = permissions to create a new table  

   • bigquery.tables.updateData = to write data to a new table, overwrite a table, or append data to a table  

Additional permission required to run Auto scaling for GCP Enterprise

Apart from existing permissions mentioned in the Creating a service account from Google Cloud Console section, you must need the following permissions for GCP Enterprise:

Permissions required in GCP

• compute.instanceGroups.get

• compute.instances.create

• compute.disks.create

• compute.disks.use

• compute.subnetworks.use

• compute.instances.setServiceAccount

• compute.instances.delete

• compute.instanceGroups.update

• compute.instances.use

• compute.instances.detachDisk

• compute.disks.delete

• compute.instances.attachDisk

Conditional permission needed if using Shared Network

• compute.subnetworks.use (on the Kyvos service account in the project where your network resides)

Prerequisites to deploy Kyvos using Kubernetes

Before deploying the Kubernetes cluster, it is recommended that you refer to the Prerequisites to deploy Kyvos using Dataproc section for the complete set of permissions required for deploying Kyvos.

Additionally, for creating a GKE cluster, you must complete the following prerequisites.

Create a GKE cluster

• Ensure that the GKE service agent’s default service account (service-PROJECT_NUMBER@container-engine-robot.iam.gserviceaccount.com) has the Kubernetes Engine Service Agent role attached to it.

• Existing Virtual Network

  • If using an existing Virtual Network for creating a GKE Cluster requires two secondary IPV4 addresses in the subnet. Additionally, if using a shared Virtual Network, following roles and permissions are required for by Default service account of Kubernetes (service-PROJECT_NUMBER@container-engine-robot.iam.gserviceaccount.com) on the project of Shared Virtual Network.

    • Compute Network User

    • kubernetes_role: You must create a custom role. To do this, click Roles > Create new role. Provide a name like kubernetes_role; assign the following permissions, and then attach to the service account:

      • compute.firewalls.create

      • compute.firewalls.delete

      • compute.firewalls.get

      • compute.firewalls.list

      • compute.firewalls.update

      • compute.networks.updatePolicy

      • compute.subnetworks.get

      • container.hostServiceAgent.use

  • The subnet must have NAT Gateway attached to it. For more details refer to Google documentation.

  • The 2181,45460,6903 ports must be allowed in the Firewall inbound rules for all internal communication between the Kubernetes cluster and Kyvos.

•   Existing (IAM) Service account

  1. Add the following predefined roles to the existing IAM service account:

     1. Service Account Token Creator

     2. Kubernetes Engine Developer

     3. Kubernetes Engine Cluster Admin

  2. Add the following permissions to the kubernetes_role custom role that you created above.

     1. compute.instanceGroupManagers.update

     2. Compute.instanceGroupManagers.get