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