Getting Started Guide

This guide will walk you through implementing your first DataPancake pipeline.

First Steps

1

Install & Setup DataPancake (Account Admin Required)

1. Install DataPancake from the Snowflake marketplace

2. Upgrade DataPancake from the free trial to use all of its features

3. Build a script to grant account level privileges to DataPancake.

4. Configure available warehouses for DataPancake

5. Grant role access as needed to DataPancake

DataPancake is now ready for use!

2

Create, Scan, & Generate Code for your First Data Source

1. Load your data into Snowflake or access your data via iceberg tables.

2. Use the single data source script builder to create and scan your first data source.

3. Monitor the progress of the scan on the "Scans in Process" page. The scanning process will often take several minutes depending on the size of your data and the warehouse used.

DataPancake recursively scans your entire data source unless you specifically limit the amount of data scanned.

3

Deploy Dynamic Tables and Views (if generated)

1. Navigate to the "Generated SQL" page and select your data source.

2. Copy the generated SQL DDL.

3. In a new Snowflake worksheet or workspace, paste and execute all of the statements to deploy your dynamic tables and views (if generated).

You're now ready to start selecting data from your deployed objects!