Tanzu Greenplum Database Management in VS Code

Connecting

To connect to Greenplum, follow these general steps:

1. Open the DBCode Extension: Launch Visual Studio Code and open the DBCode extension.
2. Add a New Connection: Click on the “Add Connection” icon.
3. Complete new connection form: Choose Greenplum as the type, and enter the required information.
4. Connect: Click save to connect to your Greenplum database.
5. Start Managing Your Databases: Once connected, you can start managing your databases directly from Visual Studio Code.

For detailed instructions on connecting to Greenplum, refer to the Connect article.

Kerberos / GSSAPI Authentication

DBCode exposes Integrated (Kerberos) for Greenplum connections when the server is configured to accept PostgreSQL GSSAPI or SSPI authentication.

• Select Integrated (Kerberos) and enter the Greenplum username that the Kerberos identity maps to.
• On Windows, DBCode uses the current signed-in identity. On macOS and Linux, it uses an existing Kerberos ticket cache.
• Integrated authentication requires a host/TCP connection. DBCode does not accept or manage keytabs.
• The default Kerberos Service Name is postgres. Change it only when the server administrator registered another service name.

By using Greenplum with DBCode, you can connect to your Greenplum databases, query and manage your data, and visualize your results, all directly from Visual Studio Code.

For more information about Greenplum, check out Greenplum.