embucket-labs
embucket-labs copied to clipboard
Embucket
Experimental version. A BYOC option for Snowflake workloads
https://docs.snowflake.com/en/sql-reference/functions/dateadd Valid dbt sql ```sql SELECT DATEADD('s', 100.0, '1970-01-01')::TIMESTAMP ``` Initial sql is (_uploaded_at is has `real` type, values like 101.82, 621.14, etc.) ```sql SELECT DATEADD('s', _uploaded_at, '1970-01-01')::TIMESTAMP FROM embucket.tap_postgres.customers_db_license_versions...
The original issue is #1118 ✅ **Goal** We want the projection column names to look like `SYSTEM$TYPEOF(2 / 3)` and not the auto-generated internal form like `arrow_typeof(Int64(2) / Int64(3))`. This...
Currently, embucket relies on datafusion style naming schema for queries which is not aligned with Snowflake. Example (note case and naming): ``` > select system$typeof(2 / 3), 2 / 3;...
# [EPIC] Implement MERGE INTO statement Google doc: https://docs.google.com/document/d/1bVWg_mV7Ipte3IhdEQMffHaYz5sVjzwWHV9JsMrXgwE/edit?usp=sharing Generally the implementation of the MERGE INTO statement can be composed into 2 parts. 1. Generate RecordBatches in the desired format...
Snowflake supports [Hybrid Tables](https://docs.snowflake.com/en/user-guide/tables-hybrid) for smaller and medium amounts of data. These are used by dbt pipelines to store metadata about the pipelines. These tables are typically interacted with using...
Improvment to automatically change the functions list and generated_functions_list.rs on build. So, contributors shouldn't worry about it and the implementation path becomes smoother.
## Proposal In Snowflake (you can see the id is listed in this with description: https://docs.snowflake.com/en/sql-reference/account-usage/query_history) and pretty much all databases, the ids were always just numbers like in an...
Add search support into /ui/worksheets handler search by name & sql text if `search` param is specified Related: https://github.com/Embucket/embucket/issues/472
This is a sub-issue of main issue #428 , for adding Sql Text Filter into `/ui/queries` handler. * GET `/ui/queries` request have `sqlText` parameter * `/ui/queries` response contains results with...
## Add filters support into a Query History handlers * Handler supports adding multiple filters in single request * Applying multiple filters has a cumulative effect - filters combined. Also...