Introduction to AtScale

AtScale is the leading semantic layer solution designed for modern business intelligence and data science teams. It simplifies the interaction with complex raw data by providing a business-oriented data model and virtualizing queries to leverage the capabilities of Snowflake. An AtScale model, once published, serves as an interactive, single source of truth for key metrics and analytical dimensions for data consumers.

AtScale delivers the dimensional analysis and performance traditionally seen in OLAP tools like SSAS, without any limitations on the size or location of the data. With connections optimized for BI clients (including native DAX integration for Power BI) and AI-powered query orchestration, users experience unparalleled query performance on live cloud data.

Integration between AtScale and NGrok

Domains and Endpoints

We provide two external domains to allow access to your AtScale instance. These are created automatically based on your internal Snowflake account information.

Setting Up a Snowpark Native App

After installing the AtScale App via Snowsight from the Marketplace or Private Listing through Data Products > Marketplace or Private Sharing > Selecting AtScale > Click Get, you need to follow these steps to ensure the application will run properly:

1. Grant Required Access: First, you must grant the specific access required by the application. For detailed instructions, please refer to the Granting Privileges Documentation.

2. Connect the endpoints required: Then you'll have to connect to AtScale external access integration and Snowflake external access integration both are required to our app to work properly.

3. Update Snowflake external access integration: Next, you have to update the network rule field
VALUE_LIST to have in it the <account-url>.snowflakecomputing.com instead of your-snowflake-account.snowflakecomputing.com. In order to do it, you'll have to find the name of the network rule by clicking in the Connections tab in the AtScale app and clicking in Details of the Snowflake external access integrations. After that, you can execute the following SQL command

ALTER NETWORK RULE <network-rule-name> SET VALUE_LIST = ('<account-url>.snowflakecomputing.com');

4. Start Services: Finally, start the services via the ATSCALE_CONFIGURATOR tab by providing a name to the Compute pool , providing the AtScale License key and clicking Start Services.
Make sure to follow these steps carefully to ensure a smooth setup of your AtScale Native App.

Managing your Native App services

The ATSCALE_CONFIGURATOR Streamlit app provides an intuitive interface for managing your AtScale Native App services without needing to run SQL commands directly. Through this app, users can:

1. View Service Logs: Access comprehensive logs by navigating to the Service Logs
section and applying the necessary filters to review operational details.
2. Manage Services: Use the Service Management section to suspend, resume, or update services. Simply select the appropriate options through the provided filters and commands. This streamlined approach ensures efficient oversight and control over your services, simplifying management tasks for smoother operations.

Configuration Demo

Follow along as we walk through how to configure and deploy your AtScale Instance via the Snowflake Marketplace!