Skip to main content

certificates

Creates, updates, deletes, gets or lists a certificates resource.

Overview​

Namecertificates
TypeResource
Idfivetran.certificates.certificates

Fields​

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
approveexecencoded_cert, hashApproves a certificate for a connection/destination, so Fivetran trusts this certificate for a source/destination database. The connection/destination setup tests will fail if a non-approved certificate is provided.

Parameters​

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription

Lifecycle Methods​

EXEC variables use wire (API) names.

Approves a certificate for a connection/destination, so Fivetran trusts this certificate for a source/destination database. The connection/destination setup tests will fail if a non-approved certificate is provided.

EXEC fivetran.certificates.certificates.approve
@@json=
'{
"hash": "{{ hash }}",
"encoded_cert": "{{ encoded_cert }}",
"connection_id": "{{ connection_id }}",
"destination_id": "{{ destination_id }}"
}'
;