The problem I’m having
I have a source table orders . The table has a timestamp column timestamp1. I define the source table as shown below.
version: 2
sources:
- name: source1
database: source_database
schema: source_schema
tables:
- name: orders
freshness:
warn_after:
count: 3
period: day
loaded_at_field: timestamp1
When I run dbt source freshness --select source:source1.orders, dbt will check the data freshness in the table orders.
In the file target/sources.json, I can see a result with unique_id as source.projectname.sourename.tablename.
I want to add more specific name as the unique_id for the source freshness. For example, I want to use we-should-have-new-order.
The context of why I’m trying to do this
I want to be able to convert the results in target/sources.json to a report. And on the report I want to show more meaningful name of each source data freshness check.
What I’ve already tried
(1) I tried to add alias to the freshness block, but it does not work.
(2) I tried to add tags to the freshness block, but it does not work.