Connecting to Materialize

🚧

The Materialize connector currently does not work with dashboards or dashboard presentation links

Creating a New Materialize Connection

1. Open the connections page in preferences, see managing connections for more information.
2. Click the Add new Connection button at the top of the connections page.
   
3. Select Materialize from the list.

4. Give a Connection name for your own internal reference.
5. For Hostname, enter the hostname of your database server.
6. For Port, enter the default 6875, or the port used by your server.
7. For Database, enter the name of your database.
8. Enter your Username and Password.

Note: you'll need to create an app password from the Connect page in Materialize specifically for PopSQL to connect.

4. Toggle connection type for direct or cloud.
5. Share the connection with your team.
6. Toggle Per-user credentials to ON if you want to share the connection, but still require each user to login with their own username and password.
7. Toggle Connect through bridge if you want to set up a cloud connection that needs to access a private network.
8. Configure SSH and SSL settings. These are optional.
9. Hit Connect and you're all set!

Happy querying! 🍭