Google sheets

With this connector Trino can connect to Google Sheets. It needs a service-user to access the Google APIs. Please consult the official documentation on how to use the Google Sheets connector.

Example Google sheets catalog configuration

apiVersion: trino.stackable.tech/v1alpha1
kind: TrinoCatalog
metadata:
  name: gsheet
  labels:
    trino: trino
spec:
  connector:
    googleSheet:
      credentialsSecret: gsheet-credentials
      metadataSheetId: 1dT4dRWo9tAKBk5GdH-a54dcizuoxOTn98X8igZcnYr8
      cache: # optional
        sheetsDataMaxCacheSize: 1000 # optional, defaults to 1000
        sheetsDataExpireAfterWrite: 5m # optional, defaults to 5m
---
apiVersion: v1
kind: Secret
metadata:
  name: gsheet-credentials
stringData:
  credentials: |+
    {
      "type": "service_account",
      "project_id": "neat-bricolage-231015",
      "private_key_id": "XXX",
      "private_key": "-----BEGIN PRIVATE KEY-----\nXXX=\n-----END PRIVATE KEY-----\n",
      "client_email": "trino-550@neat-bricolage-231015.iam.gserviceaccount.com",
      "client_id": "XXX",
      "auth_uri": "https://accounts.google.com/o/oauth2/auth",
      "token_uri": "https://oauth2.googleapis.com/token",
      "auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
      "client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/trino-550%40neat-bricolage-231015.iam.gserviceaccount.com"
    }