![]() The key must be all on one line, so make sure that you don't introduce any line breaks when cutting and pasting. In the destination setup form, select the Connect via an SSH tunnel option.Īdd the public key to the authorized_keys file of your SSH server. You must connect through SSH if your data warehouse is contained within an inaccessible subnet. You must then configure your tunnel server's security group to allow Fivetran access and configure the instance's security to allow access from the tunnel. If you connect using an SSH tunnel, Fivetran connects to a separate server in your network that provides an SSH tunnel to your Redshift data warehouse. If you connect directly, you must create a rule in a security group that allows Fivetran access to your Redshift instance and port.Ĭonfigure your firewall and/or other access control systems to allow incoming connections to your host and port from Fivetran's IPs for your region. NOTE: You must connect through SSH if your Redshift cluster is not publicly accessible. For more information, see our destination connection options documentation. Redshift provisioned data warehouse - Setup instructions link Choose connection method linkĭecide whether to connect to your Redshift data warehouse directly or using an SSH tunnel. CREATE permissions for Redshift limited user.Fivetran role with the Create Destinations or Manage Destinations permissions.Redshift user accounts can only be created and removed by a database superuser. Access to the AWS console to safelist Fivetran's IP address. ![]() To connect Redshift to Fivetran, you need the following: Follow our setup guide to connect your Redshift data warehouse to Fivetran.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |