Skip to main content

Add Your Tutorial Data to Your Data Warehouse

Now that you have run queries through AtScale and leveraged the tutorial data found in the local tutorial PostgreSQL database, you can connect to your cloud database using the same tutorial data model.

  1. Load the AtScale Tutorial Data to your data warehouse platform. For instructions, refer to AtScale's Internet Sales Model on GitHub.

  2. In Design Center, in the left-side navigation, click Datasources. The Datasources panel opens.

  3. Add your data warehouse. For instructions, see Adding Data Warehouses.

  4. In the left-side navigation, click Workspace. The Workspace panel opens.

  5. In the Repo field, select the AtScale Tutorial - Internet Sales repository.

  6. In the Branch field, select the branch associated with your data platform.

  7. Under the connections/ folder, open the file Connection - Internet Sales.yml. The file opens in the Code Editor.

    Connection - Internet Sales.yml file in the connections/ folder.

  8. Edit the file as follows:

    1. as_connection: Set this to the name of your datasource.
    2. database: Set this to the database you loaded the tutorial data into.
    3. schema: Set this to as_adventure.

    The Connection - Internet Sales.yml file being edited in the Code Editor.

  9. Click Save File.

You can now deploy your model and connect to it from BI tools: