Skip to content

Getting Started

1. Request Invite

Balto is currently in private beta, to request an invite please email us at support@baltodatatool.com.

2. Install the Balto Snowflake Native App

  1. Sign in to Snowsight.
  2. In the navigation menu, select Data Products ยป Apps.
  3. In Recently shared with you, select the tile for Balto.
  4. Select the warehouse that you want to use to install the app.
  5. Select Get.

3. Grant Permissions

After installing the Balto Orchestrator you must grant it permissions that allow it to manage database and schema objects for your projects. The database permissions can be granted by any role that can manage grants on the database you want to use. Whenever you use a new database in your projects your must grant the Balto Orchestrator permission to use it.

Database Permissions

Execute the following grants for any databases/schemas you want to use in your projects. 

1
2
3
4
CREATE DATABASE IF NOT EXISTS jaffle;
CREATE SCHEMA IF NOT EXISTS jaffle.test;
GRANT ALL ON DATABASE jaffle TO APPLICATION balto;
GRANT ALL ON SCHEMA jaffle.test TO APPLICATION balto;

4. Enable Deploys

Call the following procedure to enable deploys: 

1
CALL balto.config.enable_deploys();

And you should be able to start deploying your projects using our Github integration or manually using our stored procedure: 

create or replace table manifest (manifest variant);
create temporary stage manifests;
PUT file://test_project/target/manifest.json @manifests;
copy into manifest from @manifests FILE_FORMAT = (TYPE = 'JSON');

CALL balto.dbt.deploy((select manifest from jaffle.ops.manifest limit 1));