PageInfo
The page info object used for pagination.String
Points to the first item returned in the results. Used when paginating backward.
String
Points to the last item returned in the results. Used when paginating forward.
Boolean
required
A boolean that indicates whether a next page of results exists. Can be used to display a “next page” button in user interfaces, for example.
Boolean
required
A boolean that indicates whether a previous page of results exists. Can be used to display a “previous page” button in user interfaces, for example.
MetricReportConnection
The Metric Report connection object. It includesheaders and rows for a single page of a report. It also allows paging forward and backward to other
pages of the report.
PageInfo
required
The report connection’s page info.
Show PageInfo
Show PageInfo
The page info object used for pagination.
String
Points to the first item returned in the results. Used when paginating backward.
String
Points to the last item returned in the results. Used when paginating forward.
Boolean
required
A boolean that indicates whether a next page of results exists. Can be used to display a “next page” button in user interfaces, for example.
Boolean
required
A boolean that indicates whether a previous page of results exists. Can be used to display a “previous page” button in user interfaces, for example.
[MetricReportEdge!]
required
The report connection’s edges.
Show MetricReportEdge
Show MetricReportEdge
The Metric Report edge object.
MetricReportNode
required
The edge’s node.
Show MetricReportNode
Show MetricReportNode
The Metric Report node object.This type represents a single row of a report.
[String]
required
An ordered array of display names for your dimensions and Metrics, as defined in the report input. Use this to display your table’s header.
[String]
required
An ordered array of columns. Each column contains the dimension and Metric values for a single row, as defined in the report input. Use this to display a single row within your table.
String
required
The edge’s cursor.
[MetricReportNode!]
required
The report connection’s nodes.
Show MetricReportNode
Show MetricReportNode
The Metric Report node object.This type represents a single row of a report.
[String]
required
An ordered array of display names for your dimensions and Metrics, as defined in the report input. Use this to display your table’s header.
[String]
required
An ordered array of columns. Each column contains the dimension and Metric values for a single row, as defined in the report input. Use this to display a single row within your table.
[String]
required
An ordered array of display names for your dimensions and Metrics, as defined in the report input. Use this to display your table’s header.
[[String]!]
required
An ordered array of rows. Each row contains dimension and Metric values, as defined in the report input. Use these to display the rows of your table.
QueryInfo
required
The Query statistics and metadata.
Show QueryInfo
Show QueryInfo
The Query Info object. It contains metadata and statistics about a Query performed.
ID
required
The Query’s unique identifier.
DateTime
required
The date and time in UTC when the Query was created.
String
required
The unique identifier of the actor that performed the Query.
DateTime
required
The date and time in UTC when the Query was last modified.
String
required
The unique identifier of the actor that modified the Query.
String
required
The bytes processed by the Query.
Int
required
The duration of the Query in milliseconds.
String
required
The number of records processed by the Query.
Int
required
The bytes returned by the Query.
Int
required
The number of records returned by the Query.
Propeller
The Propeller used for this query.
Show Propeller
Show Propeller
A Propeller determines your Application’s query processing power. The larger the Propeller, the faster the queries and the higher the cost. Every Propel Application (and therefore every set of API credentials) has a Propeller that determines the speed and cost of queries.
P1_X_SMALL: Max records per second: 5,000,000 records per secondP1_SMALL: Max records per second: 25,000,000 records per secondP1_MEDIUM: Max records per second: 100,000,000 records per secondP1_LARGE: Max records per second: 250,000,000 records per secondP1_X_LARGE: Max records per second: 500,000,000 records per second
QueryStatus
required
The Query status.
Show QueryStatus
Show QueryStatus
The Query status.
COMPLETED: The Query was completed succesfully.ERROR: The Query experienced an error.TIMED_OUT: The Query timed out.
QueryType
required
The Query type.
Show QueryType
Show QueryType
The Query type.
METRIC: Indicates a Metric Query.STATS: Indicates a Dimension Stats Query.REPORT: Indicates a Report Query.RECORDS: Indicates a Record Table Query.RECORDS_BY_UNIQUE_ID: Indicates records queried by unique ID.SQL: Indicates a SQL Query.TOP_VALUES: Indicates a Top Values Query.
QuerySubtype
The Query subtype.
Show QuerySubtype
Show QuerySubtype
The Query subtype.
COUNTER: Indicates a Metric counter Query.TIME_SERIES: Indicates a Metric time series Query.LEADERBOARD: Indicates a Metric leaderboard Query.
String
required
The SQL the query executed.
MetricReportEdge
The Metric Report edge object.MetricReportNode
required
The edge’s node.
Show MetricReportNode
Show MetricReportNode
The Metric Report node object.This type represents a single row of a report.
[String]
required
An ordered array of display names for your dimensions and Metrics, as defined in the report input. Use this to display your table’s header.
[String]
required
An ordered array of columns. Each column contains the dimension and Metric values for a single row, as defined in the report input. Use this to display a single row within your table.
String
required
The edge’s cursor.
MetricReportNode
The Metric Report node object. This type represents a single row of a report.[String]
required
An ordered array of display names for your dimensions and Metrics, as defined in the report input. Use this to display your table’s header.
[String]
required
An ordered array of columns. Each column contains the dimension and Metric values for a single row, as defined in the report input. Use this to display a single row within your table.
TimeSeriesResponse
The time series response object. It contains an array of time series labels and an array of Metric values for the given time range and Query Filters.[String!]
required
The time series labels.
[String]
required
The time series values.
[TimeSeriesResponseGroup!]
The time series values for each group in
groupBy, if specified.Show TimeSeriesResponseGroup
Show TimeSeriesResponseGroup
The time series response object for a group specified in
groupBy. It contains an array of time series labels and an array of Metric values for a particular group.[String]
required
The time series group’s columns.
[String!]
required
The time series group’s labels.
[String]
required
The time series group’s values.
QueryInfo
required
The Query statistics and metadata.
Show QueryInfo
Show QueryInfo
The Query Info object. It contains metadata and statistics about a Query performed.
ID
required
The Query’s unique identifier.
DateTime
required
The date and time in UTC when the Query was created.
String
required
The unique identifier of the actor that performed the Query.
DateTime
required
The date and time in UTC when the Query was last modified.
String
required
The unique identifier of the actor that modified the Query.
String
required
The bytes processed by the Query.
Int
required
The duration of the Query in milliseconds.
String
required
The number of records processed by the Query.
Int
required
The bytes returned by the Query.
Int
required
The number of records returned by the Query.
Propeller
The Propeller used for this query.
Show Propeller
Show Propeller
A Propeller determines your Application’s query processing power. The larger the Propeller, the faster the queries and the higher the cost. Every Propel Application (and therefore every set of API credentials) has a Propeller that determines the speed and cost of queries.
P1_X_SMALL: Max records per second: 5,000,000 records per secondP1_SMALL: Max records per second: 25,000,000 records per secondP1_MEDIUM: Max records per second: 100,000,000 records per secondP1_LARGE: Max records per second: 250,000,000 records per secondP1_X_LARGE: Max records per second: 500,000,000 records per second
QueryStatus
required
The Query status.
Show QueryStatus
Show QueryStatus
The Query status.
COMPLETED: The Query was completed succesfully.ERROR: The Query experienced an error.TIMED_OUT: The Query timed out.
QueryType
required
The Query type.
Show QueryType
Show QueryType
The Query type.
METRIC: Indicates a Metric Query.STATS: Indicates a Dimension Stats Query.REPORT: Indicates a Report Query.RECORDS: Indicates a Record Table Query.RECORDS_BY_UNIQUE_ID: Indicates records queried by unique ID.SQL: Indicates a SQL Query.TOP_VALUES: Indicates a Top Values Query.
QuerySubtype
The Query subtype.
Show QuerySubtype
Show QuerySubtype
The Query subtype.
COUNTER: Indicates a Metric counter Query.TIME_SERIES: Indicates a Metric time series Query.LEADERBOARD: Indicates a Metric leaderboard Query.
String
required
The SQL the query executed.
TimeSeriesResponseGroup
The time series response object for a group specified ingroupBy. It contains an array of time series labels and an array of Metric values for a particular group.
[String]
required
The time series group’s columns.
[String!]
required
The time series group’s labels.
[String]
required
The time series group’s values.
CounterResponse
The counter response object. It contains a single Metric value for the given time range and Query Filters.String
The value of the counter.
QueryInfo
required
The Query statistics and metadata.
Show QueryInfo
Show QueryInfo
The Query Info object. It contains metadata and statistics about a Query performed.
ID
required
The Query’s unique identifier.
DateTime
required
The date and time in UTC when the Query was created.
String
required
The unique identifier of the actor that performed the Query.
DateTime
required
The date and time in UTC when the Query was last modified.
String
required
The unique identifier of the actor that modified the Query.
String
required
The bytes processed by the Query.
Int
required
The duration of the Query in milliseconds.
String
required
The number of records processed by the Query.
Int
required
The bytes returned by the Query.
Int
required
The number of records returned by the Query.
Propeller
The Propeller used for this query.
Show Propeller
Show Propeller
A Propeller determines your Application’s query processing power. The larger the Propeller, the faster the queries and the higher the cost. Every Propel Application (and therefore every set of API credentials) has a Propeller that determines the speed and cost of queries.
P1_X_SMALL: Max records per second: 5,000,000 records per secondP1_SMALL: Max records per second: 25,000,000 records per secondP1_MEDIUM: Max records per second: 100,000,000 records per secondP1_LARGE: Max records per second: 250,000,000 records per secondP1_X_LARGE: Max records per second: 500,000,000 records per second
QueryStatus
required
The Query status.
Show QueryStatus
Show QueryStatus
The Query status.
COMPLETED: The Query was completed succesfully.ERROR: The Query experienced an error.TIMED_OUT: The Query timed out.
QueryType
required
The Query type.
Show QueryType
Show QueryType
The Query type.
METRIC: Indicates a Metric Query.STATS: Indicates a Dimension Stats Query.REPORT: Indicates a Report Query.RECORDS: Indicates a Record Table Query.RECORDS_BY_UNIQUE_ID: Indicates records queried by unique ID.SQL: Indicates a SQL Query.TOP_VALUES: Indicates a Top Values Query.
QuerySubtype
The Query subtype.
Show QuerySubtype
Show QuerySubtype
The Query subtype.
COUNTER: Indicates a Metric counter Query.TIME_SERIES: Indicates a Metric time series Query.LEADERBOARD: Indicates a Metric leaderboard Query.
String
required
The SQL the query executed.
LeaderboardResponse
The leaderboard response object. It contains an array of headers and a table (array of rows) with the selected Dimensions and corresponding Metric values for the given time range and Query Filters.[String!]
required
The table headers. It contains the Dimension and Metric names.
[[String]!]
required
An ordered array of rows. Each row contains the Dimension values and the corresponding Metric value. A Dimension value can be empty. A Metric value will never be empty.
QueryInfo
required
The Query statistics and metadata.
Show QueryInfo
Show QueryInfo
The Query Info object. It contains metadata and statistics about a Query performed.
ID
required
The Query’s unique identifier.
DateTime
required
The date and time in UTC when the Query was created.
String
required
The unique identifier of the actor that performed the Query.
DateTime
required
The date and time in UTC when the Query was last modified.
String
required
The unique identifier of the actor that modified the Query.
String
required
The bytes processed by the Query.
Int
required
The duration of the Query in milliseconds.
String
required
The number of records processed by the Query.
Int
required
The bytes returned by the Query.
Int
required
The number of records returned by the Query.
Propeller
The Propeller used for this query.
Show Propeller
Show Propeller
A Propeller determines your Application’s query processing power. The larger the Propeller, the faster the queries and the higher the cost. Every Propel Application (and therefore every set of API credentials) has a Propeller that determines the speed and cost of queries.
P1_X_SMALL: Max records per second: 5,000,000 records per secondP1_SMALL: Max records per second: 25,000,000 records per secondP1_MEDIUM: Max records per second: 100,000,000 records per secondP1_LARGE: Max records per second: 250,000,000 records per secondP1_X_LARGE: Max records per second: 500,000,000 records per second
QueryStatus
required
The Query status.
Show QueryStatus
Show QueryStatus
The Query status.
COMPLETED: The Query was completed succesfully.ERROR: The Query experienced an error.TIMED_OUT: The Query timed out.
QueryType
required
The Query type.
Show QueryType
Show QueryType
The Query type.
METRIC: Indicates a Metric Query.STATS: Indicates a Dimension Stats Query.REPORT: Indicates a Report Query.RECORDS: Indicates a Record Table Query.RECORDS_BY_UNIQUE_ID: Indicates records queried by unique ID.SQL: Indicates a SQL Query.TOP_VALUES: Indicates a Top Values Query.
QuerySubtype
The Query subtype.
Show QuerySubtype
Show QuerySubtype
The Query subtype.
COUNTER: Indicates a Metric counter Query.TIME_SERIES: Indicates a Metric time series Query.LEADERBOARD: Indicates a Metric leaderboard Query.
String
required
The SQL the query executed.
QueryInfo
The Query Info object. It contains metadata and statistics about a Query performed.ID
required
The Query’s unique identifier.
DateTime
required
The date and time in UTC when the Query was created.
String
required
The unique identifier of the actor that performed the Query.
DateTime
required
The date and time in UTC when the Query was last modified.
String
required
The unique identifier of the actor that modified the Query.
String
required
The bytes processed by the Query.
Int
required
The duration of the Query in milliseconds.
String
required
The number of records processed by the Query.
Int
required
The bytes returned by the Query.
Int
required
The number of records returned by the Query.
Propeller
The Propeller used for this query.
Show Propeller
Show Propeller
A Propeller determines your Application’s query processing power. The larger the Propeller, the faster the queries and the higher the cost. Every Propel Application (and therefore every set of API credentials) has a Propeller that determines the speed and cost of queries.
P1_X_SMALL: Max records per second: 5,000,000 records per secondP1_SMALL: Max records per second: 25,000,000 records per secondP1_MEDIUM: Max records per second: 100,000,000 records per secondP1_LARGE: Max records per second: 250,000,000 records per secondP1_X_LARGE: Max records per second: 500,000,000 records per second
QueryStatus
required
The Query status.
Show QueryStatus
Show QueryStatus
The Query status.
COMPLETED: The Query was completed succesfully.ERROR: The Query experienced an error.TIMED_OUT: The Query timed out.
QueryType
required
The Query type.
Show QueryType
Show QueryType
The Query type.
METRIC: Indicates a Metric Query.STATS: Indicates a Dimension Stats Query.REPORT: Indicates a Report Query.RECORDS: Indicates a Record Table Query.RECORDS_BY_UNIQUE_ID: Indicates records queried by unique ID.SQL: Indicates a SQL Query.TOP_VALUES: Indicates a Top Values Query.
QuerySubtype
The Query subtype.
Show QuerySubtype
Show QuerySubtype
The Query subtype.
COUNTER: Indicates a Metric counter Query.TIME_SERIES: Indicates a Metric time series Query.LEADERBOARD: Indicates a Metric leaderboard Query.
String
required
The SQL the query executed.
SqlColumnResponse
String
required
The name of the returned column.
ColumnType
required
The returned column’s type.
Show ColumnType
Show ColumnType
The Propel data types.
BOOLEAN: True or false.STRING: A variable-length string.FLOAT: A 32-bit signed double-precision floating point number.DOUBLE: A 64-bit signed double-precision floating point number.INT8: An 8-bit signed integer, with a minimum value of -2⁷ and a maximum value of 2⁷-1.INT16: A 16-bit signed integer, with a minimum value of -2¹⁵ and a maximum value of 2¹⁵-1.INT32: A 32-bit signed integer, with a minimum value of -2³¹ and a maximum value of 2³¹-1.INT64: A 64-bit signed integer, with a minimum value of -2⁶³ and a maximum value of 2⁶³-1.DATE: A date without a timestamp. For example, “YYYY-MM-DD”.TIMESTAMP: A date with a timestamp. For example, “yyy-MM-dd HH:mm:ss”.JSON: A JavaScript Object Notation (JSON) document.CLICKHOUSE: A ClickHouse-specific type.
Boolean
required
Whether the column is nullable, meaning whether it accepts a null value.
SqlResponse
Response from the SQL API.[SqlColumnResponse!]
required
The column names in the same order as present in the
data field.Show SqlColumnResponse
Show SqlColumnResponse
String
required
The name of the returned column.
ColumnType
required
The returned column’s type.
Show ColumnType
Show ColumnType
The Propel data types.
BOOLEAN: True or false.STRING: A variable-length string.FLOAT: A 32-bit signed double-precision floating point number.DOUBLE: A 64-bit signed double-precision floating point number.INT8: An 8-bit signed integer, with a minimum value of -2⁷ and a maximum value of 2⁷-1.INT16: A 16-bit signed integer, with a minimum value of -2¹⁵ and a maximum value of 2¹⁵-1.INT32: A 32-bit signed integer, with a minimum value of -2³¹ and a maximum value of 2³¹-1.INT64: A 64-bit signed integer, with a minimum value of -2⁶³ and a maximum value of 2⁶³-1.DATE: A date without a timestamp. For example, “YYYY-MM-DD”.TIMESTAMP: A date with a timestamp. For example, “yyy-MM-dd HH:mm:ss”.JSON: A JavaScript Object Notation (JSON) document.CLICKHOUSE: A ClickHouse-specific type.
Boolean
required
Whether the column is nullable, meaning whether it accepts a null value.
[[String]!]
required
The data gathered by the SQL query. The data is returned in an N x M matrix format, where the
first dimension are the rows retrieved, and the second dimension are the columns. Each cell
can be either a string or null, and the string can represent a number, text, date or boolean value.
QueryInfo
required
The Query statistics and metadata.
Show QueryInfo
Show QueryInfo
The Query Info object. It contains metadata and statistics about a Query performed.
ID
required
The Query’s unique identifier.
DateTime
required
The date and time in UTC when the Query was created.
String
required
The unique identifier of the actor that performed the Query.
DateTime
required
The date and time in UTC when the Query was last modified.
String
required
The unique identifier of the actor that modified the Query.
String
required
The bytes processed by the Query.
Int
required
The duration of the Query in milliseconds.
String
required
The number of records processed by the Query.
Int
required
The bytes returned by the Query.
Int
required
The number of records returned by the Query.
Propeller
The Propeller used for this query.
Show Propeller
Show Propeller
A Propeller determines your Application’s query processing power. The larger the Propeller, the faster the queries and the higher the cost. Every Propel Application (and therefore every set of API credentials) has a Propeller that determines the speed and cost of queries.
P1_X_SMALL: Max records per second: 5,000,000 records per secondP1_SMALL: Max records per second: 25,000,000 records per secondP1_MEDIUM: Max records per second: 100,000,000 records per secondP1_LARGE: Max records per second: 250,000,000 records per secondP1_X_LARGE: Max records per second: 500,000,000 records per second
QueryStatus
required
The Query status.
Show QueryStatus
Show QueryStatus
The Query status.
COMPLETED: The Query was completed succesfully.ERROR: The Query experienced an error.TIMED_OUT: The Query timed out.
QueryType
required
The Query type.
Show QueryType
Show QueryType
The Query type.
METRIC: Indicates a Metric Query.STATS: Indicates a Dimension Stats Query.REPORT: Indicates a Report Query.RECORDS: Indicates a Record Table Query.RECORDS_BY_UNIQUE_ID: Indicates records queried by unique ID.SQL: Indicates a SQL Query.TOP_VALUES: Indicates a Top Values Query.
QuerySubtype
The Query subtype.
Show QuerySubtype
Show QuerySubtype
The Query subtype.
COUNTER: Indicates a Metric counter Query.TIME_SERIES: Indicates a Metric time series Query.LEADERBOARD: Indicates a Metric leaderboard Query.
String
required
The SQL the query executed.
DescribeSqlResponse
Response from the describe SQL API.[SqlColumnResponse!]
required
The columns that the query would return.
Show SqlColumnResponse
Show SqlColumnResponse
String
required
The name of the returned column.
ColumnType
required
The returned column’s type.
Show ColumnType
Show ColumnType
The Propel data types.
BOOLEAN: True or false.STRING: A variable-length string.FLOAT: A 32-bit signed double-precision floating point number.DOUBLE: A 64-bit signed double-precision floating point number.INT8: An 8-bit signed integer, with a minimum value of -2⁷ and a maximum value of 2⁷-1.INT16: A 16-bit signed integer, with a minimum value of -2¹⁵ and a maximum value of 2¹⁵-1.INT32: A 32-bit signed integer, with a minimum value of -2³¹ and a maximum value of 2³¹-1.INT64: A 64-bit signed integer, with a minimum value of -2⁶³ and a maximum value of 2⁶³-1.DATE: A date without a timestamp. For example, “YYYY-MM-DD”.TIMESTAMP: A date with a timestamp. For example, “yyy-MM-dd HH:mm:ss”.JSON: A JavaScript Object Notation (JSON) document.CLICKHOUSE: A ClickHouse-specific type.
Boolean
required
Whether the column is nullable, meaning whether it accepts a null value.
DataGridConnection
The Data Grid connection. It includesheaders and rows for a single page of a Data Grid table. It also allows paging forward and backward to other
pages of the Data Grid table.
[String!]
required
The Data Grid table’s headers.
[[String]!]
required
An array of arrays containing the values of the Data Grid table’s rows.
QueryInfo
required
The Query statistics and metadata.
Show QueryInfo
Show QueryInfo
The Query Info object. It contains metadata and statistics about a Query performed.
ID
required
The Query’s unique identifier.
DateTime
required
The date and time in UTC when the Query was created.
String
required
The unique identifier of the actor that performed the Query.
DateTime
required
The date and time in UTC when the Query was last modified.
String
required
The unique identifier of the actor that modified the Query.
String
required
The bytes processed by the Query.
Int
required
The duration of the Query in milliseconds.
String
required
The number of records processed by the Query.
Int
required
The bytes returned by the Query.
Int
required
The number of records returned by the Query.
Propeller
The Propeller used for this query.
Show Propeller
Show Propeller
A Propeller determines your Application’s query processing power. The larger the Propeller, the faster the queries and the higher the cost. Every Propel Application (and therefore every set of API credentials) has a Propeller that determines the speed and cost of queries.
P1_X_SMALL: Max records per second: 5,000,000 records per secondP1_SMALL: Max records per second: 25,000,000 records per secondP1_MEDIUM: Max records per second: 100,000,000 records per secondP1_LARGE: Max records per second: 250,000,000 records per secondP1_X_LARGE: Max records per second: 500,000,000 records per second
QueryStatus
required
The Query status.
Show QueryStatus
Show QueryStatus
The Query status.
COMPLETED: The Query was completed succesfully.ERROR: The Query experienced an error.TIMED_OUT: The Query timed out.
QueryType
required
The Query type.
Show QueryType
Show QueryType
The Query type.
METRIC: Indicates a Metric Query.STATS: Indicates a Dimension Stats Query.REPORT: Indicates a Report Query.RECORDS: Indicates a Record Table Query.RECORDS_BY_UNIQUE_ID: Indicates records queried by unique ID.SQL: Indicates a SQL Query.TOP_VALUES: Indicates a Top Values Query.
QuerySubtype
The Query subtype.
Show QuerySubtype
Show QuerySubtype
The Query subtype.
COUNTER: Indicates a Metric counter Query.TIME_SERIES: Indicates a Metric time series Query.LEADERBOARD: Indicates a Metric leaderboard Query.
String
required
The SQL the query executed.
PageInfo
required
The Data Grid table’s page info.
Show PageInfo
Show PageInfo
The page info object used for pagination.
String
Points to the first item returned in the results. Used when paginating backward.
String
Points to the last item returned in the results. Used when paginating forward.
Boolean
required
A boolean that indicates whether a next page of results exists. Can be used to display a “next page” button in user interfaces, for example.
Boolean
required
A boolean that indicates whether a previous page of results exists. Can be used to display a “previous page” button in user interfaces, for example.
[DataGridEdge!]
required
The Data Grid table’s edges.
Show DataGridEdge
Show DataGridEdge
[DataGridNode!]
required
DataGridEdge
The Data Grid edge object.DataGridNode
required
String
required
The edge’s cursor.
DataGridNode
The Data Grid table’s node. This type represents a single row of a Data Grid table.[String!]
required
The Data Grid table’s headers.
[String]
required
An array of the values for the row.
RecordsByUniqueIdResponse
[String!]
required
The Data Pool columns for the record.
[[String]!]
required
An array of values for the record.
QueryInfo
required
The Query statistics and metadata.
Show QueryInfo
Show QueryInfo
The Query Info object. It contains metadata and statistics about a Query performed.
ID
required
The Query’s unique identifier.
DateTime
required
The date and time in UTC when the Query was created.
String
required
The unique identifier of the actor that performed the Query.
DateTime
required
The date and time in UTC when the Query was last modified.
String
required
The unique identifier of the actor that modified the Query.
String
required
The bytes processed by the Query.
Int
required
The duration of the Query in milliseconds.
String
required
The number of records processed by the Query.
Int
required
The bytes returned by the Query.
Int
required
The number of records returned by the Query.
Propeller
The Propeller used for this query.
Show Propeller
Show Propeller
A Propeller determines your Application’s query processing power. The larger the Propeller, the faster the queries and the higher the cost. Every Propel Application (and therefore every set of API credentials) has a Propeller that determines the speed and cost of queries.
P1_X_SMALL: Max records per second: 5,000,000 records per secondP1_SMALL: Max records per second: 25,000,000 records per secondP1_MEDIUM: Max records per second: 100,000,000 records per secondP1_LARGE: Max records per second: 250,000,000 records per secondP1_X_LARGE: Max records per second: 500,000,000 records per second
QueryStatus
required
The Query status.
Show QueryStatus
Show QueryStatus
The Query status.
COMPLETED: The Query was completed succesfully.ERROR: The Query experienced an error.TIMED_OUT: The Query timed out.
QueryType
required
The Query type.
Show QueryType
Show QueryType
The Query type.
METRIC: Indicates a Metric Query.STATS: Indicates a Dimension Stats Query.REPORT: Indicates a Report Query.RECORDS: Indicates a Record Table Query.RECORDS_BY_UNIQUE_ID: Indicates records queried by unique ID.SQL: Indicates a SQL Query.TOP_VALUES: Indicates a Top Values Query.
QuerySubtype
The Query subtype.
Show QuerySubtype
Show QuerySubtype
The Query subtype.
COUNTER: Indicates a Metric counter Query.TIME_SERIES: Indicates a Metric time series Query.LEADERBOARD: Indicates a Metric leaderboard Query.
String
required
The SQL the query executed.
TopValuesResponse
[String!]
required
An array with the list of values.
MetricReportConnection
Build a report, or table, consisting of multiple Metrics broken down by one-or-more dimensions.The first few columns of the report are the dimensions you choose to break down by. The subsequent columns are the
Metrics you choose to query. By default, the report sorts on the first Metric in descending order, but you can
configure this with the
orderByMetric and sort inputs.Finally, reports use cursor-based pagination. You can control page size with the first and
last inputs.Arguments
MetricReportInput
required
Show MetricReportInput
Show MetricReportInput
The fields for querying a Metric Report.A Metric Report is a table whose columns include dimensions and Metric values, calculated over a given time range.
TimeRangeInput
The time range for calculating the Metric Report.
Show TimeRangeInput
Show TimeRangeInput
The fields required to specify the time range for a time series, counter, or leaderboard Metric query.If no relative or absolute time ranges are provided, Propel defaults to an absolute time range beginning with the earliest record in the Metric’s Data Pool and ending with the latest record.If both relative and absolute time ranges are provided, the relative time range will take precedence.If a
LAST_N relative time period is selected, an n ≥ 1 must be provided. If no n is provided or n < 1, a BAD_REQUEST error will be returned.String
The timestamp field to use when querying. Defaults to the timestamp configured on the Data Pool or Metric, if any.
Set this to filter on an alternative timestamp field.
RelativeTimeRange
The relative time period.See RelativeTimeRange
Int
The number of time units for the
LAST_N relative periods.DateTime
The optional start timestamp (inclusive). Defaults to the timestamp of the earliest record in the Data Pool.
DateTime
The optional end timestamp (exclusive). Defaults to the timestamp of the latest record in the Data Pool.
String
The time zone to use. Dates and times are always returned in UTC, but setting the time zone influences relative time ranges and granularities.You can set this to “America/Los_Angeles”, “Europe/Berlin”, or any other value in the IANA time zone database. Defaults to “UTC”.
[MetricReportDimensionInput!]
required
One or many dimensions to group the Metric values by. Typically, dimensions in a report are what you want to compare and rank.
Show MetricReportDimensionInput
Show MetricReportDimensionInput
The fields for specifying a dimension to include in a Metric Report.
String
required
The column name of the dimension to include in a Metric Report. This must match the name of a Data Pool column.
String
The name to display in the
headers array when displaying the report. This defaults to the column name if unspecified.[MetricReportMetricInput!]
required
One or more Metrics to include in the Metric Report. These will be broken down by
dimensions.Show MetricReportMetricInput
Show MetricReportMetricInput
The fields for specifying a Metric to include in a Metric Report.
MetricInput
The Metric to query. You can query a pre-configured Metric by ID or name, or you can query an ad hoc Metric that you define inline.See MetricInput
String
The name to display in the
headers array when displaying the report. This defaults to the Metric’s unique name if unspecified.String
The Query Filters to apply when calculating the Metric, in the form of SQL.
Sort
The sort order for the Metric. It can be ascending (
ASC) or descending (DESC) order. Defaults to descending (DESC) order when not provided.See SortShow Deprecated Fields
Show Deprecated Fields
String
deprecated
The Metric’s unique name. If not specified, Propel will lookup the Metric by ID.deprecated: Use
metricID
deprecated
The Metric’s ID. If not specified, Propel will lookup the Metric by unique name.deprecated: Use
metric[FilterInput!]
deprecated
The Query Filters to apply when calculating the Metric.deprecated: Use
filterSql insteadSee FilterInputString
The Query Filters to apply when building the Metric Report, in the form of SQL. These can be used to filter out rows.
Int
The index of the column to order the Metric Report by. The index is 1-based and defaults to the first Metric column. In other words, by default, reports are ordered by the first Metric; however, you can order by the second Metric, third Metric, etc., by overriding the
orderByColumn input. You can also order by dimensions this way.Int
The number of rows to be returned when paging forward. It can be a number between 1 and 1,000.
String
The cursor to use when paging forward.
Int
The number of rows to be returned when paging forward. It can be a number between 1 and 1,000.
String
The cursor to use when paging backward.
Show Deprecated Fields
Show Deprecated Fields
[FilterInput!]
deprecated
The Query Filters to apply when building the Metric Report. These can be used to filter out rows.deprecated: Use
filterSql insteadShow FilterInput
Show FilterInput
The fields of a filter.You can construct more complex filters using you could writeNote that
and and or. For example, to construct a filter equivalent to(value > 0 AND value <= 100) OR status = "confirmed"
{
"column": "value",
"operator": "GREATER_THAN",
"value": "0",
"and": [{
"column": "value",
"operator": "LESS_THAN_OR_EQUAL_TO",
"value": "0"
}],
"or": [{
"column": "status",
"operator": "EQUALS",
"value": "confirmed"
}]
}
and takes precedence over or.String
required
The name of the column to filter on.
FilterOperator
required
The operation to perform when comparing the column and filter values.See FilterOperator
String
The value to compare the column to.
[FilterInput!]
Additional filters to AND with this one. AND takes precedence over OR.
[FilterInput!]
Additional filters to OR with this one. AND takes precedence over OR.
Show MetricReportConnection
Show MetricReportConnection
The Metric Report connection object.It includes
headers and rows for a single page of a report. It also allows paging forward and backward to other
pages of the report.PageInfo
required
The report connection’s page info.
Show PageInfo
Show PageInfo
The page info object used for pagination.
String
Points to the first item returned in the results. Used when paginating backward.
String
Points to the last item returned in the results. Used when paginating forward.
Boolean
required
A boolean that indicates whether a next page of results exists. Can be used to display a “next page” button in user interfaces, for example.
Boolean
required
A boolean that indicates whether a previous page of results exists. Can be used to display a “previous page” button in user interfaces, for example.
[MetricReportEdge!]
required
The report connection’s edges.
Show MetricReportEdge
Show MetricReportEdge
The Metric Report edge object.
MetricReportNode
required
The edge’s node.See MetricReportNode
String
required
The edge’s cursor.
[MetricReportNode!]
required
The report connection’s nodes.
Show MetricReportNode
Show MetricReportNode
The Metric Report node object.This type represents a single row of a report.
[String]
required
An ordered array of display names for your dimensions and Metrics, as defined in the report input. Use this to display your table’s header.
[String]
required
An ordered array of columns. Each column contains the dimension and Metric values for a single row, as defined in the report input. Use this to display a single row within your table.
[String]
required
An ordered array of display names for your dimensions and Metrics, as defined in the report input. Use this to display your table’s header.
[[String]!]
required
An ordered array of rows. Each row contains dimension and Metric values, as defined in the report input. Use these to display the rows of your table.
QueryInfo
required
The Query statistics and metadata.
Show QueryInfo
Show QueryInfo
The Query Info object. It contains metadata and statistics about a Query performed.
ID
required
The Query’s unique identifier.
DateTime
required
The date and time in UTC when the Query was created.
String
required
The unique identifier of the actor that performed the Query.
DateTime
required
The date and time in UTC when the Query was last modified.
String
required
The unique identifier of the actor that modified the Query.
String
required
The bytes processed by the Query.
Int
required
The duration of the Query in milliseconds.
String
required
The number of records processed by the Query.
Int
required
The bytes returned by the Query.
Int
required
The number of records returned by the Query.
QueryStatus
required
The Query status.See QueryStatus
QuerySubtype
The Query subtype.See QuerySubtype
String
required
The SQL the query executed.
SqlResponse
required
Query Data Pools using SQL.
Arguments
SqlV1Input
required
Show SqlV1Input
Show SqlV1Input
Input to the SqlV1 api.
String
required
The SQL query.
Show SqlResponse
Show SqlResponse
Response from the SQL API.
[SqlColumnResponse!]
required
The column names in the same order as present in the
data field.Show SqlColumnResponse
Show SqlColumnResponse
String
required
The name of the returned column.
ColumnType
required
The returned column’s type.See ColumnType
Boolean
required
Whether the column is nullable, meaning whether it accepts a null value.
[[String]!]
required
The data gathered by the SQL query. The data is returned in an N x M matrix format, where the
first dimension are the rows retrieved, and the second dimension are the columns. Each cell
can be either a string or null, and the string can represent a number, text, date or boolean value.
QueryInfo
required
The Query statistics and metadata.
Show QueryInfo
Show QueryInfo
The Query Info object. It contains metadata and statistics about a Query performed.
ID
required
The Query’s unique identifier.
DateTime
required
The date and time in UTC when the Query was created.
String
required
The unique identifier of the actor that performed the Query.
DateTime
required
The date and time in UTC when the Query was last modified.
String
required
The unique identifier of the actor that modified the Query.
String
required
The bytes processed by the Query.
Int
required
The duration of the Query in milliseconds.
String
required
The number of records processed by the Query.
Int
required
The bytes returned by the Query.
Int
required
The number of records returned by the Query.
QueryStatus
required
The Query status.See QueryStatus
QuerySubtype
The Query subtype.See QuerySubtype
String
required
The SQL the query executed.
DescribeSqlResponse
required
Describe SQL statements Data Pools.
Arguments
DescribeSqlV1Input
required
Show DescribeSqlV1Input
Show DescribeSqlV1Input
Input for describing SqlV1 inputs.
String
required
The SQL query.
Show DescribeSqlResponse
Show DescribeSqlResponse
Response from the describe SQL API.
[SqlColumnResponse!]
required
The columns that the query would return.
Show SqlColumnResponse
Show SqlColumnResponse
String
required
The name of the returned column.
ColumnType
required
The returned column’s type.See ColumnType
Boolean
required
Whether the column is nullable, meaning whether it accepts a null value.
DataGridConnection
required
Returns the individual records of a Data Pool with the convenience of built-in pagination, filtering, and sorting.
Arguments
DataGridInput
required
Show DataGridInput
Show DataGridInput
The fields for querying Data Grid records.
DataPoolInput
required
TimeRangeInput
The time range for retrieving the records.
Show TimeRangeInput
Show TimeRangeInput
The fields required to specify the time range for a time series, counter, or leaderboard Metric query.If no relative or absolute time ranges are provided, Propel defaults to an absolute time range beginning with the earliest record in the Metric’s Data Pool and ending with the latest record.If both relative and absolute time ranges are provided, the relative time range will take precedence.If a
LAST_N relative time period is selected, an n ≥ 1 must be provided. If no n is provided or n < 1, a BAD_REQUEST error will be returned.String
The timestamp field to use when querying. Defaults to the timestamp configured on the Data Pool or Metric, if any.
Set this to filter on an alternative timestamp field.
RelativeTimeRange
The relative time period.See RelativeTimeRange
Int
The number of time units for the
LAST_N relative periods.DateTime
The optional start timestamp (inclusive). Defaults to the timestamp of the earliest record in the Data Pool.
DateTime
The optional end timestamp (exclusive). Defaults to the timestamp of the latest record in the Data Pool.
String
The time zone to use. Dates and times are always returned in UTC, but setting the time zone influences relative time ranges and granularities.You can set this to “America/Los_Angeles”, “Europe/Berlin”, or any other value in the IANA time zone database. Defaults to “UTC”.
[String!]
required
The columns to retrieve.
Int
The index of the column to order the table by. The index is 1-based. If not provided, records will be ordered by their timestamp by default.
Sort
The sort order of the rows. It can be ascending (
ASC) or descending (DESC) order. Defaults to descending (DESC) order when not provided.Show Sort
Show Sort
The available sort orders.
ASC: Sort in ascending order.DESC: Sort in descending order.
String
The filters to apply to the records, in the form of SQL. You may only filter on columns included in the
columns array input.Int
The number of rows to be returned when paging forward. It can be a number between 1 and 1,000.
String
The cursor to use when paging forward.
Int
The number of rows to be returned when paging forward. It can be a number between 1 and 1,000.
String
The cursor to use when paging backward.
Show Deprecated Fields
Show Deprecated Fields
[FilterInput!]
deprecated
The filters to apply to the records. You may only filter on columns included in the
columns array input.deprecated: Use filterSql insteadShow FilterInput
Show FilterInput
The fields of a filter.You can construct more complex filters using you could writeNote that
and and or. For example, to construct a filter equivalent to(value > 0 AND value <= 100) OR status = "confirmed"
{
"column": "value",
"operator": "GREATER_THAN",
"value": "0",
"and": [{
"column": "value",
"operator": "LESS_THAN_OR_EQUAL_TO",
"value": "0"
}],
"or": [{
"column": "status",
"operator": "EQUALS",
"value": "confirmed"
}]
}
and takes precedence over or.String
required
The name of the column to filter on.
FilterOperator
required
The operation to perform when comparing the column and filter values.See FilterOperator
String
The value to compare the column to.
[FilterInput!]
Additional filters to AND with this one. AND takes precedence over OR.
[FilterInput!]
Additional filters to OR with this one. AND takes precedence over OR.
Show DataGridConnection
Show DataGridConnection
The Data Grid connection.It includes
headers and rows for a single page of a Data Grid table. It also allows paging forward and backward to other
pages of the Data Grid table.[String!]
required
The Data Grid table’s headers.
[[String]!]
required
An array of arrays containing the values of the Data Grid table’s rows.
QueryInfo
required
The Query statistics and metadata.
Show QueryInfo
Show QueryInfo
The Query Info object. It contains metadata and statistics about a Query performed.
ID
required
The Query’s unique identifier.
DateTime
required
The date and time in UTC when the Query was created.
String
required
The unique identifier of the actor that performed the Query.
DateTime
required
The date and time in UTC when the Query was last modified.
String
required
The unique identifier of the actor that modified the Query.
String
required
The bytes processed by the Query.
Int
required
The duration of the Query in milliseconds.
String
required
The number of records processed by the Query.
Int
required
The bytes returned by the Query.
Int
required
The number of records returned by the Query.
QueryStatus
required
The Query status.See QueryStatus
QuerySubtype
The Query subtype.See QuerySubtype
String
required
The SQL the query executed.
PageInfo
required
The Data Grid table’s page info.
Show PageInfo
Show PageInfo
The page info object used for pagination.
String
Points to the first item returned in the results. Used when paginating backward.
String
Points to the last item returned in the results. Used when paginating forward.
Boolean
required
A boolean that indicates whether a next page of results exists. Can be used to display a “next page” button in user interfaces, for example.
Boolean
required
A boolean that indicates whether a previous page of results exists. Can be used to display a “previous page” button in user interfaces, for example.
[DataGridEdge!]
required
The Data Grid table’s edges.
Show DataGridEdge
Show DataGridEdge
The Data Grid edge object.
DataGridNode
required
The edge’s node.See DataGridNode
String
required
The edge’s cursor.
RecordsByUniqueIdResponse
required
Returns records by the given unique IDs.
Arguments
RecordsByUniqueIdInput
required
Show RecordsByUniqueIdInput
Show RecordsByUniqueIdInput
The fields for querying records by unique ID.
DataPoolInput
required
[String!]
required
The columns to retrieve.
[String!]
required
The unique IDs of the records to retrieve.
Show RecordsByUniqueIdResponse
Show RecordsByUniqueIdResponse
[String!]
required
The Data Pool columns for the record.
[[String]!]
required
An array of values for the record.
QueryInfo
required
The Query statistics and metadata.
Show QueryInfo
Show QueryInfo
The Query Info object. It contains metadata and statistics about a Query performed.
ID
required
The Query’s unique identifier.
DateTime
required
The date and time in UTC when the Query was created.
String
required
The unique identifier of the actor that performed the Query.
DateTime
required
The date and time in UTC when the Query was last modified.
String
required
The unique identifier of the actor that modified the Query.
String
required
The bytes processed by the Query.
Int
required
The duration of the Query in milliseconds.
String
required
The number of records processed by the Query.
Int
required
The bytes returned by the Query.
Int
required
The number of records returned by the Query.
QueryStatus
required
The Query status.See QueryStatus
QuerySubtype
The Query subtype.See QuerySubtype
String
required
The SQL the query executed.
TopValuesResponse
required
Returns an array of the most frequent values in a given column. The resulting array is sorted in descending order of approximate frequency of values.
Arguments
TopValuesInput
required
Show TopValuesInput
Show TopValuesInput
The fields for querying the top values in a given column.
DataPoolInput
required
String
required
The column to fetch the unique values from.
TimeRangeInput
The time range for calculating the top values.
Show TimeRangeInput
Show TimeRangeInput
The fields required to specify the time range for a time series, counter, or leaderboard Metric query.If no relative or absolute time ranges are provided, Propel defaults to an absolute time range beginning with the earliest record in the Metric’s Data Pool and ending with the latest record.If both relative and absolute time ranges are provided, the relative time range will take precedence.If a
LAST_N relative time period is selected, an n ≥ 1 must be provided. If no n is provided or n < 1, a BAD_REQUEST error will be returned.String
The timestamp field to use when querying. Defaults to the timestamp configured on the Data Pool or Metric, if any.
Set this to filter on an alternative timestamp field.
RelativeTimeRange
The relative time period.See RelativeTimeRange
Int
The number of time units for the
LAST_N relative periods.DateTime
The optional start timestamp (inclusive). Defaults to the timestamp of the earliest record in the Data Pool.
DateTime
The optional end timestamp (exclusive). Defaults to the timestamp of the latest record in the Data Pool.
String
The time zone to use. Dates and times are always returned in UTC, but setting the time zone influences relative time ranges and granularities.You can set this to “America/Los_Angeles”, “Europe/Berlin”, or any other value in the IANA time zone database. Defaults to “UTC”.
Int
The maximum number of values to return. It can be a number between 1 and 1,000. If the parameter is omitted, default value 10 is used.
Show TopValuesResponse
Show TopValuesResponse
[String!]
required
An array with the list of values.
CounterResponse
Query a metric in counter format. Returns a single metric value for the given time range and filters.
Arguments
CounterInput
required
Show CounterInput
Show CounterInput
The fields for querying a Metric in counter format.A Metric’s counter query returns a single value over a given time range.
MetricInput
The Metric to query. You can query a pre-configured Metric by ID or name, or you can query an ad hoc Metric that you define inline.
Show MetricInput
Show MetricInput
ID
The ID of a pre-configured Metric.
String
The name of a pre-configured Metric.
CustomMetricQueryInput
An ad hoc Custom Metric.See CustomMetricQueryInput
CountMetricQueryInput
An ad hoc Count Metric.See CountMetricQueryInput
SumMetricQueryInput
An ad hoc Sum Metric.See SumMetricQueryInput
AverageMetricQueryInput
An ad hoc Average Metric.See AverageMetricQueryInput
MinMetricQueryInput
An ad hoc Min Metric.See MinMetricQueryInput
MaxMetricQueryInput
An ad hoc Max Metric.See MaxMetricQueryInput
CountDistinctMetricQueryInput
An ad hoc Count Distinct Metric.See CountDistinctMetricQueryInput
TimeRangeInput
The time range for calculating the counter.
Show TimeRangeInput
Show TimeRangeInput
The fields required to specify the time range for a time series, counter, or leaderboard Metric query.If no relative or absolute time ranges are provided, Propel defaults to an absolute time range beginning with the earliest record in the Metric’s Data Pool and ending with the latest record.If both relative and absolute time ranges are provided, the relative time range will take precedence.If a
LAST_N relative time period is selected, an n ≥ 1 must be provided. If no n is provided or n < 1, a BAD_REQUEST error will be returned.String
The timestamp field to use when querying. Defaults to the timestamp configured on the Data Pool or Metric, if any.
Set this to filter on an alternative timestamp field.
RelativeTimeRange
The relative time period.See RelativeTimeRange
Int
The number of time units for the
LAST_N relative periods.DateTime
The optional start timestamp (inclusive). Defaults to the timestamp of the earliest record in the Data Pool.
DateTime
The optional end timestamp (exclusive). Defaults to the timestamp of the latest record in the Data Pool.
String
The time zone to use. Dates and times are always returned in UTC, but setting the time zone influences relative time ranges and granularities.You can set this to “America/Los_Angeles”, “Europe/Berlin”, or any other value in the IANA time zone database. Defaults to “UTC”.
String
The Query Filters to apply before retrieving the counter data, in the form of SQL. If no Query Filters are provided, all data is included.
Show Deprecated Fields
Show Deprecated Fields
ID
deprecated
The ID of the Metric to query.Required if
metricName is not specified.deprecated: Use metricString
deprecated
The name of the Metric to query.Required if
metricId is not specified.deprecated: Use metric[FilterInput!]
deprecated
The Query Filters to apply before retrieving the counter data. If no Query Filters are provided, all data is included.deprecated: Use
filterSql insteadShow FilterInput
Show FilterInput
The fields of a filter.You can construct more complex filters using you could writeNote that
and and or. For example, to construct a filter equivalent to(value > 0 AND value <= 100) OR status = "confirmed"
{
"column": "value",
"operator": "GREATER_THAN",
"value": "0",
"and": [{
"column": "value",
"operator": "LESS_THAN_OR_EQUAL_TO",
"value": "0"
}],
"or": [{
"column": "status",
"operator": "EQUALS",
"value": "confirmed"
}]
}
and takes precedence over or.String
required
The name of the column to filter on.
FilterOperator
required
The operation to perform when comparing the column and filter values.See FilterOperator
String
The value to compare the column to.
[FilterInput!]
Additional filters to AND with this one. AND takes precedence over OR.
[FilterInput!]
Additional filters to OR with this one. AND takes precedence over OR.
Show CounterResponse
Show CounterResponse
The counter response object. It contains a single Metric value for the given time range and Query Filters.
String
The value of the counter.
QueryInfo
required
The Query statistics and metadata.
Show QueryInfo
Show QueryInfo
The Query Info object. It contains metadata and statistics about a Query performed.
ID
required
The Query’s unique identifier.
DateTime
required
The date and time in UTC when the Query was created.
String
required
The unique identifier of the actor that performed the Query.
DateTime
required
The date and time in UTC when the Query was last modified.
String
required
The unique identifier of the actor that modified the Query.
String
required
The bytes processed by the Query.
Int
required
The duration of the Query in milliseconds.
String
required
The number of records processed by the Query.
Int
required
The bytes returned by the Query.
Int
required
The number of records returned by the Query.
QueryStatus
required
The Query status.See QueryStatus
QuerySubtype
The Query subtype.See QuerySubtype
String
required
The SQL the query executed.
[CounterResponse]
required
Query metrics in counter format. Returns a metric value for each input in the array of inputs.
Arguments
[CounterInput!]
required
Show [CounterInput!]
Show [CounterInput!]
The fields for querying a Metric in counter format.A Metric’s counter query returns a single value over a given time range.
MetricInput
The Metric to query. You can query a pre-configured Metric by ID or name, or you can query an ad hoc Metric that you define inline.
Show MetricInput
Show MetricInput
ID
The ID of a pre-configured Metric.
String
The name of a pre-configured Metric.
CustomMetricQueryInput
An ad hoc Custom Metric.See CustomMetricQueryInput
CountMetricQueryInput
An ad hoc Count Metric.See CountMetricQueryInput
SumMetricQueryInput
An ad hoc Sum Metric.See SumMetricQueryInput
AverageMetricQueryInput
An ad hoc Average Metric.See AverageMetricQueryInput
MinMetricQueryInput
An ad hoc Min Metric.See MinMetricQueryInput
MaxMetricQueryInput
An ad hoc Max Metric.See MaxMetricQueryInput
CountDistinctMetricQueryInput
An ad hoc Count Distinct Metric.See CountDistinctMetricQueryInput
TimeRangeInput
The time range for calculating the counter.
Show TimeRangeInput
Show TimeRangeInput
The fields required to specify the time range for a time series, counter, or leaderboard Metric query.If no relative or absolute time ranges are provided, Propel defaults to an absolute time range beginning with the earliest record in the Metric’s Data Pool and ending with the latest record.If both relative and absolute time ranges are provided, the relative time range will take precedence.If a
LAST_N relative time period is selected, an n ≥ 1 must be provided. If no n is provided or n < 1, a BAD_REQUEST error will be returned.String
The timestamp field to use when querying. Defaults to the timestamp configured on the Data Pool or Metric, if any.
Set this to filter on an alternative timestamp field.
RelativeTimeRange
The relative time period.See RelativeTimeRange
Int
The number of time units for the
LAST_N relative periods.DateTime
The optional start timestamp (inclusive). Defaults to the timestamp of the earliest record in the Data Pool.
DateTime
The optional end timestamp (exclusive). Defaults to the timestamp of the latest record in the Data Pool.
String
The time zone to use. Dates and times are always returned in UTC, but setting the time zone influences relative time ranges and granularities.You can set this to “America/Los_Angeles”, “Europe/Berlin”, or any other value in the IANA time zone database. Defaults to “UTC”.
String
The Query Filters to apply before retrieving the counter data, in the form of SQL. If no Query Filters are provided, all data is included.
Show Deprecated Fields
Show Deprecated Fields
ID
deprecated
The ID of the Metric to query.Required if
metricName is not specified.deprecated: Use metricString
deprecated
The name of the Metric to query.Required if
metricId is not specified.deprecated: Use metric[FilterInput!]
deprecated
The Query Filters to apply before retrieving the counter data. If no Query Filters are provided, all data is included.deprecated: Use
filterSql insteadShow FilterInput
Show FilterInput
The fields of a filter.You can construct more complex filters using you could writeNote that
and and or. For example, to construct a filter equivalent to(value > 0 AND value <= 100) OR status = "confirmed"
{
"column": "value",
"operator": "GREATER_THAN",
"value": "0",
"and": [{
"column": "value",
"operator": "LESS_THAN_OR_EQUAL_TO",
"value": "0"
}],
"or": [{
"column": "status",
"operator": "EQUALS",
"value": "confirmed"
}]
}
and takes precedence over or.String
required
The name of the column to filter on.
FilterOperator
required
The operation to perform when comparing the column and filter values.See FilterOperator
String
The value to compare the column to.
[FilterInput!]
Additional filters to AND with this one. AND takes precedence over OR.
[FilterInput!]
Additional filters to OR with this one. AND takes precedence over OR.
Show CounterResponse
Show CounterResponse
The counter response object. It contains a single Metric value for the given time range and Query Filters.
String
The value of the counter.
QueryInfo
required
The Query statistics and metadata.
Show QueryInfo
Show QueryInfo
The Query Info object. It contains metadata and statistics about a Query performed.
ID
required
The Query’s unique identifier.
DateTime
required
The date and time in UTC when the Query was created.
String
required
The unique identifier of the actor that performed the Query.
DateTime
required
The date and time in UTC when the Query was last modified.
String
required
The unique identifier of the actor that modified the Query.
String
required
The bytes processed by the Query.
Int
required
The duration of the Query in milliseconds.
String
required
The number of records processed by the Query.
Int
required
The bytes returned by the Query.
Int
required
The number of records returned by the Query.
QueryStatus
required
The Query status.See QueryStatus
QuerySubtype
The Query subtype.See QuerySubtype
String
required
The SQL the query executed.
TimeSeriesResponse
Query a metric in time series format. Returns arrays of timestamps and metric values for the given time range and filters.
Arguments
TimeSeriesInput
required
Show TimeSeriesInput
Show TimeSeriesInput
The fields for querying a Metric in time series format.A Metric’s time series query returns the values over a given time range aggregated by a given time granularity; day, month, or year, for example.
MetricInput
The Metric to Query. It can be a pre-created one or it can be inlined here.
Show MetricInput
Show MetricInput
ID
The ID of a pre-configured Metric.
String
The name of a pre-configured Metric.
CustomMetricQueryInput
An ad hoc Custom Metric.See CustomMetricQueryInput
CountMetricQueryInput
An ad hoc Count Metric.See CountMetricQueryInput
SumMetricQueryInput
An ad hoc Sum Metric.See SumMetricQueryInput
AverageMetricQueryInput
An ad hoc Average Metric.See AverageMetricQueryInput
MinMetricQueryInput
An ad hoc Min Metric.See MinMetricQueryInput
MaxMetricQueryInput
An ad hoc Max Metric.See MaxMetricQueryInput
CountDistinctMetricQueryInput
An ad hoc Count Distinct Metric.See CountDistinctMetricQueryInput
TimeRangeInput
The time range for calculating the time series.
Show TimeRangeInput
Show TimeRangeInput
The fields required to specify the time range for a time series, counter, or leaderboard Metric query.If no relative or absolute time ranges are provided, Propel defaults to an absolute time range beginning with the earliest record in the Metric’s Data Pool and ending with the latest record.If both relative and absolute time ranges are provided, the relative time range will take precedence.If a
LAST_N relative time period is selected, an n ≥ 1 must be provided. If no n is provided or n < 1, a BAD_REQUEST error will be returned.String
The timestamp field to use when querying. Defaults to the timestamp configured on the Data Pool or Metric, if any.
Set this to filter on an alternative timestamp field.
RelativeTimeRange
The relative time period.See RelativeTimeRange
Int
The number of time units for the
LAST_N relative periods.DateTime
The optional start timestamp (inclusive). Defaults to the timestamp of the earliest record in the Data Pool.
DateTime
The optional end timestamp (exclusive). Defaults to the timestamp of the latest record in the Data Pool.
String
The time zone to use. Dates and times are always returned in UTC, but setting the time zone influences relative time ranges and granularities.You can set this to “America/Los_Angeles”, “Europe/Berlin”, or any other value in the IANA time zone database. Defaults to “UTC”.
TimeSeriesGranularity
required
The time granularity (hour, day, month, etc.) to aggregate the Metric values by.
Show TimeSeriesGranularity
Show TimeSeriesGranularity
The available time series granularities. Granularities define the unit of time to aggregate the Metric data for a time series query.For example, if the granularity is set to
DAY, then the the time series query will return a label and a value for each day.If there are no records for a given time series granularity, Propel will return the label and a value of “0” so that the time series can be properly visualized.MINUTE: Aggregates values by minute intervals.FIVE_MINUTES: Aggregates values by 5-minute intervals.TEN_MINUTES: Aggregates values by 10-minute intervals.FIFTEEN_MINUTES: Aggregates values by 15-minute intervals.HOUR: Aggregates values by hourly intervals.DAY: Aggregates values by daily intervals.WEEK: Aggregates values by weekly intervals.MONTH: Aggregates values by monthly intervals.YEAR: Aggregates values by yearly intervals.
String
The Query Filters to apply before retrieving the time series data, in the form of SQL. If no Query Filters are provided, all data is included.
[String!]
Columns to group by.
Show Deprecated Fields
Show Deprecated Fields
ID
deprecated
The ID of the Metric to query.Required if
metricName is not specified.deprecated: Use metricString
deprecated
The name of the Metric to query.Required if
metricId is not specified.deprecated: Use metric[FilterInput!]
deprecated
The Query Filters to apply before retrieving the time series data. If no Query Filters are provided, all data is included.deprecated: Use
filterSql insteadShow FilterInput
Show FilterInput
The fields of a filter.You can construct more complex filters using you could writeNote that
and and or. For example, to construct a filter equivalent to(value > 0 AND value <= 100) OR status = "confirmed"
{
"column": "value",
"operator": "GREATER_THAN",
"value": "0",
"and": [{
"column": "value",
"operator": "LESS_THAN_OR_EQUAL_TO",
"value": "0"
}],
"or": [{
"column": "status",
"operator": "EQUALS",
"value": "confirmed"
}]
}
and takes precedence over or.String
required
The name of the column to filter on.
FilterOperator
required
The operation to perform when comparing the column and filter values.See FilterOperator
String
The value to compare the column to.
[FilterInput!]
Additional filters to AND with this one. AND takes precedence over OR.
[FilterInput!]
Additional filters to OR with this one. AND takes precedence over OR.
Show TimeSeriesResponse
Show TimeSeriesResponse
The time series response object. It contains an array of time series labels and an array of Metric values for the given time range and Query Filters.
[String!]
required
The time series labels.
[String]
required
The time series values.
[TimeSeriesResponseGroup!]
The time series values for each group in
groupBy, if specified.Show TimeSeriesResponseGroup
Show TimeSeriesResponseGroup
The time series response object for a group specified in
groupBy. It contains an array of time series labels and an array of Metric values for a particular group.[String]
required
The time series group’s columns.
[String!]
required
The time series group’s labels.
[String]
required
The time series group’s values.
QueryInfo
required
The Query statistics and metadata.
Show QueryInfo
Show QueryInfo
The Query Info object. It contains metadata and statistics about a Query performed.
ID
required
The Query’s unique identifier.
DateTime
required
The date and time in UTC when the Query was created.
String
required
The unique identifier of the actor that performed the Query.
DateTime
required
The date and time in UTC when the Query was last modified.
String
required
The unique identifier of the actor that modified the Query.
String
required
The bytes processed by the Query.
Int
required
The duration of the Query in milliseconds.
String
required
The number of records processed by the Query.
Int
required
The bytes returned by the Query.
Int
required
The number of records returned by the Query.
QueryStatus
required
The Query status.See QueryStatus
QuerySubtype
The Query subtype.See QuerySubtype
String
required
The SQL the query executed.
LeaderboardResponse
Query a metric in leaderboard format. Returns a table (array of rows) with the selected dimensions and the metric’s corresponding values for the given time range and filters.
Arguments
LeaderboardInput
required
Show LeaderboardInput
Show LeaderboardInput
The fields for querying a Metric in leaderboard format.A Metric’s leaderboard query returns an ordered table of Dimension and Metric values over a given time range.
MetricInput
The Metric to query. You can query a pre-configured Metric by ID or name, or you can query an ad hoc Metric that you define inline.
Show MetricInput
Show MetricInput
ID
The ID of a pre-configured Metric.
String
The name of a pre-configured Metric.
CustomMetricQueryInput
An ad hoc Custom Metric.See CustomMetricQueryInput
CountMetricQueryInput
An ad hoc Count Metric.See CountMetricQueryInput
SumMetricQueryInput
An ad hoc Sum Metric.See SumMetricQueryInput
AverageMetricQueryInput
An ad hoc Average Metric.See AverageMetricQueryInput
MinMetricQueryInput
An ad hoc Min Metric.See MinMetricQueryInput
MaxMetricQueryInput
An ad hoc Max Metric.See MaxMetricQueryInput
CountDistinctMetricQueryInput
An ad hoc Count Distinct Metric.See CountDistinctMetricQueryInput
TimeRangeInput
The time range for calculating the leaderboard.
Show TimeRangeInput
Show TimeRangeInput
The fields required to specify the time range for a time series, counter, or leaderboard Metric query.If no relative or absolute time ranges are provided, Propel defaults to an absolute time range beginning with the earliest record in the Metric’s Data Pool and ending with the latest record.If both relative and absolute time ranges are provided, the relative time range will take precedence.If a
LAST_N relative time period is selected, an n ≥ 1 must be provided. If no n is provided or n < 1, a BAD_REQUEST error will be returned.String
The timestamp field to use when querying. Defaults to the timestamp configured on the Data Pool or Metric, if any.
Set this to filter on an alternative timestamp field.
RelativeTimeRange
The relative time period.See RelativeTimeRange
Int
The number of time units for the
LAST_N relative periods.DateTime
The optional start timestamp (inclusive). Defaults to the timestamp of the earliest record in the Data Pool.
DateTime
The optional end timestamp (exclusive). Defaults to the timestamp of the latest record in the Data Pool.
String
The time zone to use. Dates and times are always returned in UTC, but setting the time zone influences relative time ranges and granularities.You can set this to “America/Los_Angeles”, “Europe/Berlin”, or any other value in the IANA time zone database. Defaults to “UTC”.
[DimensionInput!]
required
One or many Dimensions to group the Metric values by. Typically, Dimensions in a leaderboard are what you want to compare and rank.
Show DimensionInput
Show DimensionInput
The fields for creating or modifying a Dimension.
String
required
The name of the column to create the Dimension from.
Sort
The sort order of the rows. It can be ascending (
ASC) or descending (DESC) order. Defaults to descending (DESC) order when not provided.Show Sort
Show Sort
The available sort orders.
ASC: Sort in ascending order.DESC: Sort in descending order.
Int
required
The number of rows to be returned. It can be a number between 1 and 1,000.
String
The Query Filters to apply before retrieving the leaderboard data, in the form of SQL. If no Query Filters are provided, all data is included.
Show Deprecated Fields
Show Deprecated Fields
ID
deprecated
The ID of the Metric to query.Required if
metricName is not specified.deprecated: Use metricString
deprecated
The name of the Metric to query.Required if
metricId is not specified.deprecated: Use metric[FilterInput!]
deprecated
The Query Filters to apply before retrieving the leaderboard data. If no Query Filters are provided, all data is included.deprecated: Use
filterSql insteadShow FilterInput
Show FilterInput
The fields of a filter.You can construct more complex filters using you could writeNote that
and and or. For example, to construct a filter equivalent to(value > 0 AND value <= 100) OR status = "confirmed"
{
"column": "value",
"operator": "GREATER_THAN",
"value": "0",
"and": [{
"column": "value",
"operator": "LESS_THAN_OR_EQUAL_TO",
"value": "0"
}],
"or": [{
"column": "status",
"operator": "EQUALS",
"value": "confirmed"
}]
}
and takes precedence over or.String
required
The name of the column to filter on.
FilterOperator
required
The operation to perform when comparing the column and filter values.See FilterOperator
String
The value to compare the column to.
[FilterInput!]
Additional filters to AND with this one. AND takes precedence over OR.
[FilterInput!]
Additional filters to OR with this one. AND takes precedence over OR.
Show LeaderboardResponse
Show LeaderboardResponse
The leaderboard response object. It contains an array of headers and a table (array of rows) with the selected Dimensions and corresponding Metric values for the given time range and Query Filters.
[String!]
required
The table headers. It contains the Dimension and Metric names.
[[String]!]
required
An ordered array of rows. Each row contains the Dimension values and the corresponding Metric value. A Dimension value can be empty. A Metric value will never be empty.
QueryInfo
required
The Query statistics and metadata.
Show QueryInfo
Show QueryInfo
The Query Info object. It contains metadata and statistics about a Query performed.
ID
required
The Query’s unique identifier.
DateTime
required
The date and time in UTC when the Query was created.
String
required
The unique identifier of the actor that performed the Query.
DateTime
required
The date and time in UTC when the Query was last modified.
String
required
The unique identifier of the actor that modified the Query.
String
required
The bytes processed by the Query.
Int
required
The duration of the Query in milliseconds.
String
required
The number of records processed by the Query.
Int
required
The bytes returned by the Query.
Int
required
The number of records returned by the Query.
QueryStatus
required
The Query status.See QueryStatus
QuerySubtype
The Query subtype.See QuerySubtype
String
required
The SQL the query executed.