📄️ About Data Warehouses
A data warehouse is a data source that contains the tables and views that you import as fact datasets and dimension datasets into AtScale models. It also contains aggregate-table instances that either you or the AtScale engine creates in a schema that you specify.
📄️ About Data Warehouse Security
You can configure which users and groups have access to each of your data warehouses. These permissions apply across AtScale. If a user has access to a data warehouse, they can do the following:
📄️ Data Warehouse Preparation
Complete the following data warehouse configuration steps before connecting AtScale to your data warehouse.
📄️ Adding Databricks Data Warehouses
A Databricks data warehouse contains the tables and views that you want to import as fact datasets and dimension datasets into AtScale models. It also contains aggregate table instances that either you or the AtScale engine creates in a database that you specify.
📄️ Adding Google BigQuery Data Warehouses
A Google BigQuery data warehouse is an instance of Google BigQuery that contains the tables and views that you want to access as model facts and dimensions. It also contains aggregate table instances that either you or the AtScale engine creates in a BigQuery dataset that you specify.
📄️ Adding InterSystems IRIS Data Warehouses
An InterSystems IRIS data warehouse contains the tables and views that you want to import as fact datasets and dimension datasets into AtScale models. It also contains aggregate table instances that either you or the AtScale engine creates in a database that you specify.
📄️ InterSystems IRIS: Customer-Managed UDAF Installation
When configuring an InterSystems IRIS data warehouse, you must choose Customer managed as the Custom function installation mode, and you must manually install the AtScale UDAFs.
📄️ Adding Snowflake Data Warehouses
A Snowflake data warehouse is a cloud-based data warehouse that contains the tables and views that you want to access as model facts and dimensions. It also contains aggregate-table instances that either you or the AtScale engine creates in a schema that you specify.
📄️ Adding PostgreSQL Data Warehouses
A PostgreSQL data warehouse contains the tables and views that you want to import as fact datasets and dimension datasets into AtScale models. It also contains aggregate table instances that either you or the AtScale engine creates in a database that you specify.
📄️ Adding Amazon Redshift Data Warehouses
An Amazon Redshift data warehouse is an Amazon Redshift cluster and database that contains the tables and views that you want to access as model facts and dimensions. It also contains aggregate table instances that either you or the AtScale engine creates in a schema that you specify.