Piperider

Released on 02-02-2023
PipeRider version 0.18.0 is out now, with a comparison summary and custom database support.


:rocket: Comparison summary for dbt-defined metrics
You can now compare the difference in [dbt-defined metrics](https://docs.getdbt.com/docs/build/metrics) in the HTML report, but also in a Markdown summary.

piperider compare-reports [options]



Both the HTML reports and the Markdown summary is stored in `.piperider/comparisons/<timestamp>`


[Read the docs](https://docs.piperider.io/cli/dbt-integration/metrics) for how to integrate dbt defined Metrics into PipeRider

:wrench: Support for dbt custom databases
Support for [dbt custom database](https://docs.getdbt.com/docs/build/custom-databases). Rather than skipping custom databases, PipeRider now automatically detects custom databases.

Get in touch :heart:

We'd love your feedback! Send us a message via Intercom on [piperider.io](https://piperider.io), join our [Discord](https://discord.gg/xKxsdPx4d5), report an issue on [GitHub](https://github.com/InfuseAI/piperider/issues), or send us a good old-fashioned [email](mailto:productinfuseai.io)



----


<details>
<summary>All changes</summary>


What's Changed
* [Release] Bump version 0.18.0 by wcchang1115 in https://github.com/InfuseAI/piperider/pull/567
* [Feature] Support business metric comparison in the comparison summary by wcchang1115 in https://github.com/InfuseAI/piperider/pull/564
* [Feature] Make cloud and config command visible and remove beta message by wcchang1115 in https://github.com/InfuseAI/piperider/pull/565
* [Feature] Append zero when a count metric or a sum metric result is null by wcchang1115 in https://github.com/InfuseAI/piperider/pull/569
* [Feature] Append zero if derived metrics had null value by wcchang1115 in https://github.com/InfuseAI/piperider/pull/570
* [Feature] support dbt with multiple databases by popcornylu in https://github.com/InfuseAI/piperider/pull/572
* [Feature] Verify connection without table reflection by wcchang1115 in https://github.com/InfuseAI/piperider/pull/573
* [Feature] Cast timestamp column of metrics to date type by wcchang1115 in https://github.com/InfuseAI/piperider/pull/574
* [Chore] Move the table filter logic from profiler to runner by popcornylu in https://github.com/InfuseAI/piperider/pull/579
* [Bug] dataadd not working in duckdb by popcornylu in https://github.com/InfuseAI/piperider/pull/568
* [Bug] Fix bigquery to_database_url() param name by popcornylu in https://github.com/InfuseAI/piperider/pull/576
* [Bug] Return zero length for column width of progress bar when no subjects by wcchang1115 in https://github.com/InfuseAI/piperider/pull/580


**Full Changelog**: https://github.com/InfuseAI/piperider/compare/v0.17.0...v0.18.0


</details>

What's Changed
* [Release] Bump version 0.18.0 by wcchang1115 in https://github.com/InfuseAI/piperider/pull/567
* [Feature] Support business metric comparison in the comparison summary by wcchang1115 in https://github.com/InfuseAI/piperider/pull/564
* [Feature] Make cloud and config command visible and remove beta message by wcchang1115 in https://github.com/InfuseAI/piperider/pull/565
* [Feature] Append zero when a count metric or a sum metric result is null by wcchang1115 in https://github.com/InfuseAI/piperider/pull/569
* [Feature] Append zero if derived metrics had null value by wcchang1115 in https://github.com/InfuseAI/piperider/pull/570
* [Feature] support dbt with multiple databases by popcornylu in https://github.com/InfuseAI/piperider/pull/572
* [Feature] Verify connection without table reflection by wcchang1115 in https://github.com/InfuseAI/piperider/pull/573
* [Feature] Cast timestamp column of metrics to date type by wcchang1115 in https://github.com/InfuseAI/piperider/pull/574
* [Chore] Move the table filter logic from profiler to runner by popcornylu in https://github.com/InfuseAI/piperider/pull/579
* [Bug] dataadd not working in duckdb by popcornylu in https://github.com/InfuseAI/piperider/pull/568
* [Bug] Fix bigquery to_database_url() param name by popcornylu in https://github.com/InfuseAI/piperider/pull/576
* [Bug] Return zero length for column width of progress bar when no subjects by wcchang1115 in https://github.com/InfuseAI/piperider/pull/580

**Full Changelog**: https://github.com/InfuseAI/piperider/compare/v0.17.0...v0.18.0-rc.2

What's Changed
* [Release] Bump version 0.18.0 by wcchang1115 in https://github.com/InfuseAI/piperider/pull/567
* [Feature] Support business metric comparison in the comparison summary by wcchang1115 in https://github.com/InfuseAI/piperider/pull/564
* [Feature] Make cloud and config command visible and remove beta message by wcchang1115 in https://github.com/InfuseAI/piperider/pull/565
* [Feature] Append zero when a count metric or a sum metric result is null by wcchang1115 in https://github.com/InfuseAI/piperider/pull/569
* [Feature] Append zero if derived metrics had null value by wcchang1115 in https://github.com/InfuseAI/piperider/pull/570
* [Feature] support dbt with multiple databases by popcornylu in https://github.com/InfuseAI/piperider/pull/572
* [Feature] Verify connection without table reflection by wcchang1115 in https://github.com/InfuseAI/piperider/pull/573
* [Feature] Cast timestamp column of metrics to date type by wcchang1115 in https://github.com/InfuseAI/piperider/pull/574
* [Chore] Move the table filter logic from profiler to runner by popcornylu in https://github.com/InfuseAI/piperider/pull/579
* [Bug] dataadd not working in duckdb by popcornylu in https://github.com/InfuseAI/piperider/pull/568
* [Bug] Fix bigquery to_database_url() param name by popcornylu in https://github.com/InfuseAI/piperider/pull/576


**Full Changelog**: https://github.com/InfuseAI/piperider/compare/v0.17.0...v0.18.0-rc.1

Fixes the metric query errors in bigquery, postgresql, and duckdb

**Full Changelog**: https://github.com/InfuseAI/piperider/compare/v0.17.0...v0.17.1

Released on 01-12-2023
PipeRider version 0.17.0 is out now, with a new section dedicated for dbt metrics.


:rocket: A new section to view your dbt-defined metrics
Along side profiling metrics, you can now see the metrics as defined in [dbt metrics](https://docs.getdbt.com/docs/build/metrics) in our HTML reports.


You can configure the inclusion of dbt metrics in your dbt settings, adding `tags: [piperider]` to your yml files:




models/marts/schema.yml

version: 2
metrics:
- name: active_users
label: Active Users
model: ref('events')
calculation_method: count_distinct
expression: user_id
timestamp: evetn_time
time_grains: [day, week]
tags: [piperider]




Get in touch :heart:

We'd love your feedback! Send us a message via Intercom on [piperider.io](https://piperider.io), join our [Discord](https://discord.gg/xKxsdPx4d5), report an issue on [GitHub](https://github.com/InfuseAI/piperider/issues), or send us a good old-fashioned [email](mailto:productinfuseai.io)



----


<details>
<summary>All changes</summary>


* [Release] Bump version 0.17.0 by wcchang1115 in https://github.com/InfuseAI/piperider/pull/555
* [Feature] Support dbt metric query by wcchang1115 in https://github.com/InfuseAI/piperider/pull/553
* [Feature] : sc 30090 - UI time series metrics by jonycfu in https://github.com/InfuseAI/piperider/pull/561
* [Chore] : use Array.from notation instead of spread of Map iterables by jonycfu in https://github.com/InfuseAI/piperider/pull/563
* [Bug] issues:541 fix overflow issue by david-k-johnson in https://github.com/InfuseAI/piperider/pull/557
* [Bug] Validate with views as well as tables(if applicable) by david-k-johnson in https://github.com/InfuseAI/piperider/pull/559
* [Bug] Fix business metric query statement by wcchang1115 in https://github.com/InfuseAI/piperider/pull/562
* [Bug] Skip querying dbt metrics with the window property by wcchang1115 in https://github.com/InfuseAI/piperider/pull/566

New Contributors
* david-k-johnson made their first contribution in https://github.com/InfuseAI/piperider/pull/557

**Full Changelog**: https://github.com/InfuseAI/piperider/compare/v0.16.0...v0.17.0


</details>

What's Changed
* [Release] Bump version 0.17.0 by wcchang1115 in https://github.com/InfuseAI/piperider/pull/555
* [Feature] Support dbt metric query by wcchang1115 in https://github.com/InfuseAI/piperider/pull/553
* [Feature] : sc 30090 - UI time series metrics by jonycfu in https://github.com/InfuseAI/piperider/pull/561
* [Chore] : use Array.from notation instead of spread of Map iterables by jonycfu in https://github.com/InfuseAI/piperider/pull/563
* [Bug] issues:541 fix overflow issue by david-k-johnson in https://github.com/InfuseAI/piperider/pull/557
* [Bug] Validate with views as well as tables(if applicable) by david-k-johnson in https://github.com/InfuseAI/piperider/pull/559
* [Bug] Fix business metric query statement by wcchang1115 in https://github.com/InfuseAI/piperider/pull/562
* [Bug] Skip querying dbt metrics with the window property by wcchang1115 in https://github.com/InfuseAI/piperider/pull/566

New Contributors
* david-k-johnson made their first contribution in https://github.com/InfuseAI/piperider/pull/557

**Full Changelog**: https://github.com/InfuseAI/piperider/compare/v0.16.0...v0.17.0-rc.1