Azure SQL Database,
Azure Synapse Analytics,
Azure SQL Managed Instance,
SQL Server 2019,
SQL Server 2017,
SQL Server 2016,
SQL Server 2014,
SQL Server 2012,
PDW 2008R2 AU34.
updated_at), CDC allows you to sync your table incrementally.
SELECTpermission on the captured columns of the source table. We suggest putting a value here so you can use this role in the next step but you can also set the value of @role_name to
NULLto allow only sysadmin and db_owner to have access. Be sure that the credentials used to connect to the source in Airbyte align with this role so that Airbyte can access the cdc tables.
SELECTaccess on the cdc schema:
SSH Tunnel Method.
SSH Tunnel Methoddefaults to
No Tunnel(meaning a direct connection). If you want to use an
SSH Key Authenticationor
Key Authenticationif you will be using an RSA private key as your secret for
Password Authenticationif you will be using a password as your secret for establishing
SSH Tunnel Jump Server Hostrefers to the intermediate (bastion) server that Airbyte will connect to. This should
SSH Connection Portis the port on the bastion server with which to make the SSH connection. The default port for
22, so unless you have explicitly changed something, go with the default.
SSH Login Usernameis the username that Airbyte should use when connection to the bastion server. This is NOT the
Password Authentication, then
SSH Login Usernameshould be set to the
SSH Key Authenticationleave this
SSH Key Authentication, then
SSH Private Keyshould be set to the RSA
-----BEGIN RSA PRIVATE KEY-----and ending
-----END RSA PRIVATE KEY-----.
authorized_keysfile on your bastion host. The public key should be added to your bastion host to whichever user you want to use with Airbyte. The private key is provided via copy-and-paste to the Airbyte connector configuration screen, so it may log in to the bastion.