Power School
10/27/2024, 8:09 AMuser
10/27/2024, 8:09 AMssh-keygen -t rsa -m PEM -f dataline-key-airbyte
This command will generate two files: 1. dataline-key-airbyte
(the private key) 2. dataline-key-airbyte.pub
(the public key) The private key file dataline-key-airbyte
will be in PEM format, which is the format expected by Airbyte connectors for SSH tunneling. Here are the key points to remember: 1. The public key should be added to the authorized_keys
file on your bastion host for the user you want to use with Airbyte. 2. The private key (dataline-key-airbyte
) is what you'll provide to Airbyte via copy-and-paste in the connector configuration screen. This process is consistent across various Airbyte connectors that support SSH tunneling, such as SingleStore, MySQL, Oracle, and PostgreSQL [Source: [SingleStore](https://docs.airbyte.com/integrations/sources/singlestore#generating-a-private-key-for-ssh-tunneling), [MySQL](https://docs.airbyte.com/integrations/sources/mysql#generating-a-private-key-for-ssh-tunneling), [Oracle](https://docs.airbyte.com/integrations/sources/oracle#generating-an-ssh-key-pair), [PostgreSQL](https://docs.airbyte.com/integrations/sources/postgres#generating-a-private-key-for-ssh-tunneling)]. Remember to store your private key securely, as it will be used to authenticate the SSH connection.