Machine Credentials

Machine credentials (also known as SQL credentials or API keys) allow you to programmatically access Splitgraph from SQL clients or your applications. They consist of an API key and an API secret. When connecting to the DDN, you use these as the PostgreSQL username/password. When querying HTTP services (like the DDN HTTP API), you will exchange these for an temporary access token that needs to be passed in the HTTP header.

Creating credentials

Click on your profile icon in the top left and then on "SQL Credentials" or go here. On this screen, you can create and revoke SQL credentials.

Using the sgr CLI

When you run sgr cloud login, this automatically creates a pair of machine credentials that are stored in your .sgconfig file. You can then run sgr cloud sql to output a SQL connection string that will contain the credentials.