![]() Password: Enter the password for the Stitch Google CloudSQL PostgreSQL user.Username: Enter the Stitch Google CloudSQL PostgreSQL user’s username.Port: Enter the Google CloudSQL PostgreSQL port on your server.Note that this must be the actual address - entering localhost into this field will cause connection issues. Host: In general, this will be 127.0.0.1 (localhost), but could also be some other network address (ex: 192.68.0.1) or your server’s public IP address. ![]() Fill in the connection info for the database:.This schema is where all the tables for this integration will be stored. This is the name that will display on the for the integration it’ll also be used to create the schema in your data warehouse.įor example, the name “Stitch Google CloudSQL PostgreSQL” would create a schema called stitch_cloudsql-postgres in the data warehouse. On the Stitch Dashboard page, click the Add an Integration button.Įnter a name for the integration. To wrap things up, you need to enter the database connection and user info into Stitch. If you want to connect multiple databases or schemas, repeat this process as necessary. Additionally, make sure you replace and with the appropriate names in your database. Replace with a secure password, which can be different than the SSH password. GRANT SELECT ON ALL TABLES IN SCHEMA TO ĪLTER DEFAULT PRIVILEGES IN SCHEMA GRANT SELECT ON TABLES TO This user should also own the schema that Stitch is being granted access to. Your organization may require a different process, but the simplest way to create this user is to execute the following query when logged into the Google CloudSQL PostgreSQL database as a user with the right to grant privileges. In the next step, you’ll create a database user for Stitch. To finish creating the user, alter the permissions on the /home/ directory to allow access via SSH: chown -R : /home/Ĭhmod -R 700 /home//.ssh Copy the entire key into the authorized_keys file as follows: touch /home//.ssh/authorized_keys To ensure the user has access to the database, we need to import the Public Key into authorized_keys. To create the new user, run the following commands as root on your Linux server: adduser -p Note that anything inside square brackets - is something you need to define when running the commands yourself. ![]() In these cases, it’s necessary to run a command like AllowUsers to allow the Stitch user access to the server. Important: If the sshd_config file associated with the server is not set to the default option, only certain users will have server access - this will prevent a successful connection to Stitch. The Public Key will display, along with the other SSH fields.When the credentials page displays, click the Encryption Type menu and select the SSH Tunnel option. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |