When using BigQuery in a sovereign cloud CMEK encryption is mandatory.
So when connecting to Biq Query I must add the KMS key for accessing the data.
In Python my working configuration looks like that:
BIGQUERY_CONFIG = {
'project_id': 'xxxx-cloud-prod',
'dataset_id': 'testme',
'table_id': 'test',
'credentials_file': 'test.json',
'kms_key_name': 'projects/kms-project-xxxx-sov'
}
Unfortunately it is not possible to add the kms_key_name to the JDBC string in the Metabase connection settings. Is there a way to add this key to the connection? Are there any plans to add that to the BigQuery driver in Metabase?
Thanks in advance
Johannes