Adding 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.

You can add the following data warehouses:

• Databricks
• Google BigQuery
• Setting Up Impersonation For Google BigQuery
• InterSystems IRIS
• InterSystems IRIS: Customer-Managed UDAF Installation
• Snowflake
• PostgreSQL

For customer-managed UDAF installations, additional data warehouse preparation may be required. For more information, see Data Warehouse Preparation before adding your data warehouse.

To learn about how data warehouse security works in AtScale, see About Data Warehouse Security

Once you have added data warehouses and connections, you can configure which types of queries are permitted per connection. For more information, see Configuring Query Mapping.