FAQ
Turning frequently asked questions into easily found answers
-
Can I set "Allow access to all users" to default to OFF/Unchecked?
It is possible to disable "Allow all-access" by default. This can be done by setting Default Project/Cube Security. (Admin->Organizations->Features)
-
How do I find which cube a particular aggregate belongs to?
The aggregate Instances page features a "FILTERS" that allows you to search for details of an aggregate. You can put the name of the aggregate in and filter if that is known. ...
-
What Format are AtScale Aggregate Instances Stored as in HDFS?
By default, the AtScale engine will always choose to create aggregates in Parquet format for all aggregates, which use a highly compressed format to keep file sizes small and colum...
-
Can customers use Log4j to ship logs to their log platform?
AtScale does not support modifying our logs. The installer would overwrite the changes during upgrades, and those Log4j files are internal to the application only and not expos...
-
Does AtScale purge aggregates from time to time?
An Aggregate Maintenance routine runs periodically (Default = 1hr), which cleans up unused and excess aggregates.We can set the aggregate limit by setting 'Aggregate Retention Li...
-
Can aggregate trigger files be placed in GCS instead of HDFS?
When the Google BigQuery environment is used, Aggregate trigger files can be placed in the GCS path using the following steps: 1. Log into Design Center as an Admin user 2. Navig...
-
If queries go over number of connection pools, do they get cancelled if queued for a long time?
Queries will be canceled if they are not completed within the time specified by the setting of "query.timeout" which is set to a default of 60 minutes.Queries are queued in AtSca...
-
Can the password for username "Admin" be changed through an API?
No API is available to update the Admin password in the Postgres database. Changing passwords through SQL injection in Postgres is also not supported. The username "Admin" pass...
-
When do old aggregates get deleted?
If the AtScale administrator deactivates an aggregate, the aggregate will still be shown in the AtScale Hive database. This is the expected behavior because if the end-user runs...
-
Why do BI queries execute multiple times against the raw tables instead of aggregate tables?
The following reasons can cause the BI query to execute against the raw tables instead of aggregate tables: 1. "Aggregate usage" setting has been disabled. Check Summary Zip ...
-
Why does the system use predictive aggregates after predictive aggregates were disabled?
Users can still see queries that go against predictive aggregates after predictive aggregates are disabled.The system will stop building new aggregates by disabling predictive de...
-
What is the difference between connection.pool.group.maxConnections and connection.pool.user.maxConnections?
The 'connection.pool.group.maxConnections' determines the maximum connections to a Data Warehouse (i.e., the total connections to all SQL Engines in the warehouse). The 'connecti...
-
What access is needed in Sentry for Impala if UDF schema override is setup in AtScale?
To restrict access, the administrator might choose the UDF schema to override the feature in AtScale, where AtScale can use the needed UDF function from a single database. When ...
-
When having multiple country fields (billing country, shipping country, customer country) in a physical fact table, is there a need to duplicate the Geography Dimension to link to each of these country fields?
The Role Playing Dimension feature can be used to implement this scenario. There should be one Geography dimension, and all the different country keys (Billing / Customer / Ship...
-
Do I need to synchronize individual users from Active Directory or LDAP?
No, AtScale has a feature where you can map a group from Active Directory to a specific role. Users of the AD group will be able to access Runtime privileges assigned to this rol...
-
What should be the size of the Connection Pool when AtScale is used with Impala and Admission control?
When the AtScale pool size is larger than the available connection in Admission Control, some queries might be unable to run due to an unavailable connection.To resolve this, set...
-
Why does a BI query return no data only for a particular user?
If a BI query returns no data, check the engine log. com.atscale.engine.core.Executor - Using fake mode: not actually running query Note: - Though all Query engine types are set to...