Snowflake Native App

​

Introduction

Honeydew enables deep integration in Snowflake with a snowflake native application.

It can be installed from the Snowflake Marketplace Listing.

When the native app is installed, Honeydew API can be accessed directly from a Snowflake connection or the web interface.

​

Usage Examples

1. List all workspaces:

select * from table(HONEYDEW_APP.API.LIST_WORKSPACES());

2. List all entities in the “tpch” workspace:

select * from table(HONEYDEW_APP.API.LIST_ENTITIES('tpch'));

3. List all entities relations in the “tpch” workspace:

select * from table(HONEYDEW_APP.API.LIST_RELATIONS('tpch'));

4. List all fields in the “tpch” workspace:

select * from table(HONEYDEW_APP.API.LIST_FIELDS('tpch'));

5. List all global parameters in the “tpch” workspace:

select * from table(HONEYDEW_APP.API.LIST_GLOBAL_PARAMETERS('tpch'));

6. Get the SQL query for a dynamic dataset:

select HONEYDEW_APP.API.GET_DYNAMIC_DATASET_SQL('tpch', 'my_dynamic_dataset');

7. List all dynamic datasets in the “tpch” workspace:

select * from table(HONEYDEW_APP.API.LIST_DYNAMIC_DATASETS('tpch'));

8. Translate an SQL query on top of the Honeydew Semantic Layer into a Snowflake SQL query:

select HONEYDEW_APP.API.GET_SQL('tpch', 'select "orders.order_month", "customers.count" from world.world');

9. Run an SQL query on top of the Honeydew Semantic Layer and store the results into a transient table:

call HONEYDEW_APP.API.RUN_SQL('tpch', 'select "orders.order_month", "customers.count" from world.world', 'customers_by_month');
select * from HONEYDEW_APP.QUERY_RESULTS.customers_by_month;

The parameters are: workspace name, SQL query, and table name.