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());
  1. List all entities in the “tpch” workspace:
select * from table(HONEYDEW_APP.API.LIST_ENTITIES('tpch'));
  1. List all entities relations in the “tpch” workspace:
select * from table(HONEYDEW_APP.API.LIST_RELATIONS('tpch'));
  1. List all fields in the “tpch” workspace:
select * from table(HONEYDEW_APP.API.LIST_FIELDS('tpch'));
  1. List all global parameters in the “tpch” workspace:
select * from table(HONEYDEW_APP.API.LIST_GLOBAL_PARAMETERS('tpch'));
  1. Get the SQL query for a dynamic dataset:
select HONEYDEW_APP.API.GET_DYNAMIC_DATASET_SQL('tpch', 'my_dynamic_dataset');
  1. List all dynamic datasets in the “tpch” workspace:
select * from table(HONEYDEW_APP.API.LIST_DYNAMIC_DATASETS('tpch'));
  1. 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');
  1. 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.