Add BigQuery Service account credentials to the BQ Endpoint (target) of QLIK Replicate/Enterprise Manager via API
Hi,
I have a very specific query regarding importing the BQ endpoint in QLIK Replicate server or Enterprise Manager. I have exported the current BigQuery target endpoint which was created via UI.
A sample json is as shown below-
{
"name": "Endpoints_creation_w_API",
"cmd.replication_definition": {
"databases": [
{
"name": "BQ_target_API",
"role": "TARGET",
"is_licensed": true,
"type_id": "BIGQUERY_COMPONENT_TYPE",
"db_settings": {
"$type": "BigquerySettings",
"additionalConnectionProperties": "timeout=900",
"maxFileSize": 2000,
"jsonCredentials": "",
"defaultSchemaRadio": "SKIP_CREATION"
},
"override_properties": {
}
}
]
},
"_version": {
"version": "2023.11.0.547",
"version_major": 2023,
"version_minor": 11,
"version_revision": 547
},
"description": "Host name:"
}
Now using the json as a template, I want to modify it, add a new BQ target endpoint for a different project.
If I import it as is, the endpoint gets created but it will not have any credentials and I have to manually add the service account json to the endpoints manually via UI.
I want to add the credentials via API and just adding the contents of the SA's json file in the jsonCredentials field is not working and throwing error.
Has anyone tried to add the credentials via API or is there another way to do it via scripts or cli.
I don't think we have an option to add the credentails via API. So, I would suggest you submit a feature request so project management can evaluate your request.
You can try patch endpoint but this is an API endpoint for existing endpoints. As to the validity of if you will be able to update credentials, i do not know
I don't think we have an option to add the credentails via API. So, I would suggest you submit a feature request so project management can evaluate your request.
You can try patch endpoint but this is an API endpoint for existing endpoints. As to the validity of if you will be able to update credentials, i do not know
