Dekart Snowpark Application
Dekart enables you to create powerful Kepler.gl visualizations directly from SQL queries in Snowflake, simplifying the process of visualizing and sharing location data without ETL pipelines.
Get it instantly in Snowflake Marketplace
💡 How Dekart Works
Single Docker Container: Dekart runs efficiently as a single container within the Snowpark Container Service, requiring minimal setup.
State Management: All Dekart’s state is securely stored on
dekart.app_public.app_state_stage, which includes 7 days of backups. When the application is uninstalled, the associated stage is also deleted.Data Warehouse: Dekart uses a dedicated
dw_dekartdata warehouse for executing and storing SQL queries.Query Results: Query data is loaded from Snowflake’s persisted query results. If the query results expire, Dekart will automatically rerun the query to refresh the map data.
Recommended limits:
- Maximum result size: 100 MB
- Maximum number of rows: 1 million rows
🛡️ Accessing Datasets
To use datasets in your visualizations, Dekart needs access to the relevant databases. For instance, to grant Dekart access to the OpenStreetMap New York dataset, run the following SQL command:
-- Grant access to a dataset (e.g., OpenStreetMap New York)
GRANT IMPORTED PRIVILEGES ON DATABASE OPENSTREETMAP_NEW_YORK TO application DEKART__WEBGL_MAPS_FOR_SNOWFLAKE;
💡 Please note that app name could be changed during the installation process.
👫 Granting Access to Other Users
To allow other users access to the Dekart application, assign them the appropriate role with the following SQL command:
-- Grant access to a user role
GRANT application role DEKART__WEBGL_MAPS_FOR_SNOWFLAKE.app_public.app_user TO role user_role;
💡 Please note that app name could be changed during the installation process.
🎁 Getting access to free Overture Maps
Dekart offers great way to explore Overture Maps datasets and enrich your visualizations with Places, Roads, and other map data.
Go to Snowflake Marketplace and search for Overture Maps
Get Datasets you need, for example Places. They are instantly available in your Snowflake account.
Give Dekart access to the dataset:
-- as ACCOUNTADMIN
GRANT IMPORTED PRIVILEGES ON DATABASE OVERTURE_MAPS__PLACES TO APPLICATION DEKART__WEBGL_MAPS_FOR_SNOWFLAKE;
- Go to Dekart application, create a new report click Start with sample query to test it.
💡 Please note that app name could be changed during the installation process.
💾 Backup and Restore
Dekart stores its state on Snowflake Stage every 5 minutes and keeps 7 days of history. This section explains how to backup and restore this state.
Backing Up State
To backup the Dekart application state, follow these steps:
-- as ACCOUNTADMIN
-- List backup files to verify they exist
LIST @DEKART.APP_PUBLIC.APP_STATE_STAGE;
-- Create example database for copying backup
CREATE DATABASE DEKART_MIGRATE;
CREATE SCHEMA DEKART_MIGRATE.APP_PUBLIC;
CREATE STAGE DEKART_MIGRATE.APP_PUBLIC.APP_STATE_STAGE;
-- Copy backup files
COPY FILES
INTO @DEKART_MIGRATE.APP_PUBLIC.APP_STATE_STAGE
FROM @DEKART.APP_PUBLIC.APP_STATE_STAGE;
-- Verify backup was saved
LIST @DEKART_MIGRATE.APP_PUBLIC.APP_STATE_STAGE;
Restoring State
To restore the state to a new Dekart installation:
- Uninstall the old app
- Install the marketplace app version (do not activate it yet)
- Grant permissions so the activate button becomes visible, then run:
-- Copy backup files back to the new app stage
COPY FILES
INTO @DEKART.APP_PUBLIC.APP_STATE_STAGE
FROM @DEKART_MIGRATE.APP_PUBLIC.APP_STATE_STAGE;
-- Verify files were copied
LIST @DEKART.APP_PUBLIC.APP_STATE_STAGE;
- Press Activate button
- Grant permissions to the new app (example):
GRANT IMPORTED PRIVILEGES ON DATABASE OVERTURE_MAPS__PLACES TO APPLICATION DEKART;
All maps should now be migrated to the new instance.
💡 Note: Depending on share type, the app name can be DEKART or DEKART__WEBGL_MAPS_FOR_SNOWFLAKE. Adjust the commands accordingly.