Propel Applications give your app credentials to access Propel via SQL or the API. Scopes control what the Application can do, and Propellers control the speed and cost of the queries.

Scopes

Scopes determine what an Application can do in Propel. You can create an Application with the following scopes:

ScopeDescription
ADMINCan query and manage all resources (except other Applications).
METRIC_QUERYCan list and query Metrics.
DATA_POOL_QUERYCan list and query Data Pools.
APPLICATION_ADMINCan create another Application.
ENVIRONMENT_ADMINCan create other Environments within the same Account.

Propellers

Propellers determine the speed of queries on a per-query basis. They control the number of rows per second that an individual query can read from a Data Pool.

PropellerMax records read per secondPrice per GB read
P1_X_SMALL1,000,000$0.03 / GB
P1_SMALL10,000,000$0.05 / GB
P1_MEDIUM100,000,000$0.06 / GB
P1_LARGE250,000,000$0.07 / GB
P1_X_LARGE500,000,000$0.08 / GB

By adjusting the Propeller size, you can optimize the balance between query performance and cost based on your specific needs.

For guidance on selecting the most appropriate Propeller for your use case, refer to our Choosing a Propeller guide.

Creating an Application

Follow these steps to create an Application:

1

Go to the "Applications" section

Log into the Propel Console, navigate to the “Applications” section, and click on “New Application” .

Navigate to Applications section

2

Name your Application

Give your Application a unique name. It should represent the app that will be using the SQL or API credentials.

Name your Application

3

Select scopes

Scopes determine what the credentials will be allowed to do. To just query data, select the DATAPOOL_QUERY scope. Learn more about scopes.

Select scopes

4

Select Propeller size

Propellers determine the speed and cost of your queries. A P1_X_SMALL is a good to start with. You can change it later if you need to. Learn more about Propellers.

Select Propeller size

5

Create theApplication

Lastly, click “Create Application”.

Using credentials

Now that you have your Application created, you can find your credentials on the Applications details page.

Application credentials

With SQL

You can use the client ID and secret as the user and password when connecting to Propel via SQL.

With the API

To use your Application credentials with the Propel API, follow these steps:

  1. Obtain an Access Token: Use your client ID and secret to request an access token. This token will be used to authenticate your API requests.

    curl -X POST https://auth.us-east-2.propeldata.com/oauth2/token \
      -d "grant_type=client_credentials" \
      -d "client_id=YOUR_CLIENT_ID" \
      -d "client_secret=YOUR_CLIENT_SECRET"
    

    This request will return a JSON response containing your access token.

  2. Use the Access Token: Include the access token in the Authorization header of your API requests.

    curl -X POST https://api.us-east-2.propeldata.com/graphql \
      -H "Authorization: Bearer YOUR_ACCESS_TOKEN"
    

Remember to keep your client credentials secure and never expose them in client-side code.

For a complete guide on API authentication, refer to our API authentication guide.