The row limit for all query results is set to 10,000 rows by default. You may specify a row limit up to 50,000 in query parameters for an individual query. If more rows are needed, we recommend using pagination in your application to request more rows.
Yes. Cube Cloud provides free development instances and a set of paid tiers (opens in a new tab). Each tier comes with additional features, however, you're welcome to use development instances indefinitely if they satisfy your needs.
CUBEJS_CONCURRENCY specifies the maximum number of queries that can be
executed concurrently on your source database. This variable should reflect the
limitations of your database, and will help limit the number of queries that are
sent from cube.
CUBEJS_DB_MAX_POOL allows you to set a maximum number of connection pools to
your database. This only applies to databases that use connection pooling
(Postgresql, Redshift, Clickhouse) and is not applicable to databases without it
(BigQuery, Snowflake). The concurrency limit specified in
will supersede the number of connections if it is lower.
For example, if your database has a hard concurrency limit of 10 that cannot be
changed, but you wish to raise the concurrency limit to 50 you would first set
CUBEJS_DB_MAX_POOL=5 or higher. Note that some
data warehouses (BigQuery, Snowflake) do not use connection pooling so this
parameter is not applicable.