sfc-gh-vsekar

Just The Gist : Snowflake Dashboard on data sharing usage

This gist is used for developing building a streamlit based dashboard app on the various data usage views provided by Snowflake.

https://docs.snowflake.com/en/sql-reference/data-sharing-usage/

These offers telemetry insights on how consumers are using and adopting the data product or app. The views are available to the marketplace provider, using which they can gather insights and improve the product they are offering.

Instead of sharing code base; i am adopting the pattern of sharing the project requirement document (PRD); which can be used by AI coding tools like Cortex Code, to generate the executing code. This also gives the user the oppurtunity to make changes as per thier criteria.

sfc-gh-vsekar

Native App : Shareback functionality

This markdown demonstrates the key implementation code for share-back data functionality offered via Snowflake Native App.

Doc: Request data sharing with app specifications

The approach demonstrated here as follows:

• The Native App as part of its install, creates a database (app_shareback_db).
• The app then creates a table (pos_transactions) in this database
• The app then creates a share (app_shareback_share) and adds the table to this share.

sfc-gh-vsekar

sfc-gh-vsekar

sfc-gh-vsekar

sfc-gh-vsekar

sfc-gh-vsekar

sfc-gh-vsekar

sfc-gh-vsekar

sfc-gh-vsekar

/*
    Block : #STAGE
    DDL for defining the external stage
*/
-- Step 1 : Create a database and schema for the experiment
create database ccrawl;
create schema ccrawl.raw;
use schema ccrawl.raw;