AtScale's semantic layer platform simplifies the access to data through a unified, business-friendly interface, allowing users with varying levels of technical expertise to understand and analyze data without needing to know complex query languages or database structures. This accessibility leads to better, faster decision-making across all levels of an organization. Moreover, by standardizing definitions and metrics, a semantic layer ensures consistency and accuracy in reporting and analytics, reducing errors and misinterpretations.
This repository contains a variety of semantic models encoded in the Semantic Modeling Language (SML).
- Internet Sales - a simple, single-fact model derived from the fictitious AdventureWorks retail dataset.
- World Wide Importers - a more complex, multi-fact model representing a fictional wholesale and distribution company.
- TPC-DS - a complex, multi-fact model that encodes the TPC-DS benchmark model in SML.
- Snowplow Digital Analytics Model - Snowplow empowers organizations to create a scalable, first-party data foundation so marketing and data teams can effectively analyze and tackle Customer 360 use cases.
- CRISP CPG Retail and Distributor Data Model - Crisp connects to over 40 leading U.S. retailers and distributors.
Download the AtScale Developer Community Edition and follow the installation instructions
When you download and install the AtScale Developer Edition, a PostgresSQL database container with the data for all three models will be installed and configured automatically in the AtScale Design Center.
To explore and query the tutorial models, in the AtScale Design Center:
- Deploy your Catalog: Click on the "Repo Browser" icon in the Activity bar (left side) and Press the "Deploy" button.
- (Optional) Enable Token-based Access for Excel & Power BI: In order to connect Excel and Power BI without AtScale's imbedded directory service, generate an XMLA token by clicking on the user profile icon (upper right) and clicking on the "Generate Token" button.
- Connect your BI Tool: Click on the "Deployed Catalogs: icon in the Activity bar (left side) and click on your deployed catalog. Instructions for connecting your BI tools will appear on the right side.
The tutorial data for the sample models is available for free in the Snowflake Marketplace. To get access to the tutorial data in the Snowflake Marketplace:
- Go to the Snowflake Marketplace: In the Snowflake console, click on "Data Products" and then click on the "Marketplace" link.
- Find the "AtScale Tutorials" data product: In the search bar, type in "AtScale" and select the "AtScale Tutorials" data product.
- Connect to the AtScale Tutorials Data Product: On the right side of the screen, click on the "Get" button.
- Name Your Database: Click on the down arrow on the "Options" accordion control and enter
atscale_tutorial_datain the "Database" field and assign the proper access role. Click the "Get" button.
The tutorial data for the sample models is available for free in the Databricks Marketplace. To get access to the tutorial data in the Databricks Marketplace:
- Go to the Databricks Marketplace: In the Databricks workspace console, Click on "Data Products" and then click on the "Marketplace" link.
- Find the "AtScale Tutorials" data product: In the search bar, type in "AtScale" and select the "AtScale Tutorials" data product.
- Connect to the AtScale Tutorials Data Product: On the right side of the screen, click on the "Get instant access" button.
- Accept the Terms and Conditions: Check the terms and conditions box and click on the "Get instance access" button.
- View your data: Click on the "Open" button to see your shared data.
- Rename your catalog: Click on the
atscale_inc_atscale_tutorialscatalog in the "Shared" section, click on the vertical "..." menu on the righthand side of the screen and choose the "Rename" menu option. Type inatscale_tutorial_datain the edit box and click on the "Save" button.
- Create a project named
atscale-tutorial-datain BigQuery - In the BigQuery console for the
atscale-tutorial-dataproject, run the following DDL scripts in this directory:
- Go to AtScale Settings: In AtScale Design Center, click on the "Settings" dropdown by clicking on the AtScale logo icon (upper left).
- Create a Data Warehouse: In Settings, click on the "Data Warehouse" option (top left) and click on the icon (right) for the data platform you wish to connect (i.e. BigQuery, Snowflake, Databricks, etc.).
- Enter Data Warehouse Information: In the Data Warehouse property panel, enter your information and click on the "Apply" button. Note that you may need to create a new database and schema to hold AtScale's aggregate tables.
- Create a Data Warehouse Connection: After creating the data warehouse, create a connection by clicking on the down arrow on the data warehouse your just created and click on the "Add Connection +" button.
- Enter Data Warehouse Connection Information: In the Data Warehouse Connection property panel, enter your information and click on the "Test" button to make sure that the connection information is valid. Then click on the "Apply" button.
SPECIAL NOTE for a Databricks: Fill in the "Extra JDBC Flags" field with the folowing information you can get from your data wareouse/cluster's "Connection Details" tab in the Databricks console: transportMode=http;ssl=1;AuthMech=3;httpPath=<YOUR HTTP PATH>. Also, for the "Username" field enter a value of "token" and enter your Databricks Personal Access Token into the "Password" field.
- Change your SML Connection: Go back to the Repo Browser by clicking on the AtScale icon (upper left corner) and update each model's connection YML file's
as_connectionproperty to to same string (i.e. "Snowflake") you entered into "External connection ID" field in the Data Warehouse Connection property panel in step 3. Make sure to click on the "Save File" button at the bottom of the text editor.
SPECIAL NOTE for BigQuery: You may also need to change the database property to atscale-tutorial-data (note the dashes rather than underscores).
- Deploy your catalog (see above).
How to connect to Snowflake Video