Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@kovid-r
Last active November 25, 2021 11:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kovid-r/d50019cab9332a9cdf78a0b4e2825fdf to your computer and use it in GitHub Desktop.
Save kovid-r/d50019cab9332a9cdf78a0b4e2825fdf to your computer and use it in GitHub Desktop.
Amundsen Lineage + dbt catalog.json databuilder/example/sample_data/dbt/catalog.json
{
"metadata": {
"dbt_schema_version": "https://schemas.getdbt.com/dbt/catalog/v1.json",
"dbt_version": "0.19.1",
"generated_at": "2021-04-20T19:44:44.998264Z",
"invocation_id": "2c6e4c85-3912-40cc-b613-0a50c65e32bc",
"env": {}
},
"nodes": {
"model.dbt_amundsen_demo.fact_catalog_returns": {
"metadata": {
"type": "VIEW",
"schema": "DBT_AMUNDSEN",
"name": "FACT_CATALOG_RETURNS",
"database": "DBT_AMUNDSEN_DEMO",
"comment": null,
"owner": "ACCOUNTADMIN"
},
"columns": {
"CR_ITEM_SK": {
"type": "NUMBER",
"index": 1,
"name": "CR_ITEM_SK",
"comment": null
},
"CR_CALL_CENTER_SK": {
"type": "NUMBER",
"index": 2,
"name": "CR_CALL_CENTER_SK",
"comment": null
},
"ITEM_CALL_CENTER_LOSS": {
"type": "NUMBER",
"index": 3,
"name": "ITEM_CALL_CENTER_LOSS",
"comment": null
},
"ITEM_CALL_CENTER_CNT": {
"type": "NUMBER",
"index": 4,
"name": "ITEM_CALL_CENTER_CNT",
"comment": null
}
},
"stats": {
"has_stats": {
"id": "has_stats",
"label": "Has Stats?",
"value": false,
"include": false,
"description": "Indicates whether there are statistics for this table"
}
},
"unique_id": "model.dbt_amundsen_demo.fact_catalog_returns"
},
"model.dbt_amundsen_demo.fact_third_party_performance": {
"metadata": {
"type": "VIEW",
"schema": "DBT_AMUNDSEN",
"name": "FACT_THIRD_PARTY_PERFORMANCE",
"database": "DBT_AMUNDSEN_DEMO",
"comment": null,
"owner": "ACCOUNTADMIN"
},
"columns": {
"COMPANY_ID": {
"type": "NUMBER",
"index": 1,
"name": "COMPANY_ID",
"comment": null
},
"COMPANY_NAME": {
"type": "TEXT",
"index": 2,
"name": "COMPANY_NAME",
"comment": null
},
"TOTAL_LOSS": {
"type": "NUMBER",
"index": 3,
"name": "TOTAL_LOSS",
"comment": null
},
"AVG_ITEM_LOSS": {
"type": "NUMBER",
"index": 4,
"name": "AVG_ITEM_LOSS",
"comment": null
}
},
"stats": {
"has_stats": {
"id": "has_stats",
"label": "Has Stats?",
"value": false,
"include": false,
"description": "Indicates whether there are statistics for this table"
}
},
"unique_id": "model.dbt_amundsen_demo.fact_third_party_performance"
},
"model.dbt_amundsen_demo.fact_warehouse_inventory": {
"metadata": {
"type": "VIEW",
"schema": "DBT_AMUNDSEN",
"name": "FACT_WAREHOUSE_INVENTORY",
"database": "DBT_AMUNDSEN_DEMO",
"comment": null,
"owner": "ACCOUNTADMIN"
},
"columns": {
"DT": {
"type": "NUMBER",
"index": 1,
"name": "DT",
"comment": null
},
"W_WAREHOUSE_ID": {
"type": "TEXT",
"index": 2,
"name": "W_WAREHOUSE_ID",
"comment": null
},
"INVENTORY_VALUE": {
"type": "NUMBER",
"index": 3,
"name": "INVENTORY_VALUE",
"comment": null
},
"INVENTORY_COST": {
"type": "NUMBER",
"index": 4,
"name": "INVENTORY_COST",
"comment": null
}
},
"stats": {
"has_stats": {
"id": "has_stats",
"label": "Has Stats?",
"value": false,
"include": false,
"description": "Indicates whether there are statistics for this table"
}
},
"unique_id": "model.dbt_amundsen_demo.fact_warehouse_inventory"
},
"model.dbt_amundsen_demo.raw_inventory_item_warehouse": {
"metadata": {
"type": "VIEW",
"schema": "DBT_AMUNDSEN",
"name": "RAW_INVENTORY_ITEM_WAREHOUSE",
"database": "DBT_AMUNDSEN_DEMO",
"comment": null,
"owner": "ACCOUNTADMIN"
},
"columns": {
"DT": {
"type": "NUMBER",
"index": 1,
"name": "DT",
"comment": null
},
"W_WAREHOUSE_ID": {
"type": "TEXT",
"index": 2,
"name": "W_WAREHOUSE_ID",
"comment": null
},
"ITEM_ID": {
"type": "NUMBER",
"index": 3,
"name": "ITEM_ID",
"comment": null
},
"QUANTITY": {
"type": "NUMBER",
"index": 4,
"name": "QUANTITY",
"comment": null
},
"ITEM_PRICE": {
"type": "NUMBER",
"index": 5,
"name": "ITEM_PRICE",
"comment": null
},
"ITEM_COST": {
"type": "NUMBER",
"index": 6,
"name": "ITEM_COST",
"comment": null
},
"INVENTORY_VALUE": {
"type": "NUMBER",
"index": 7,
"name": "INVENTORY_VALUE",
"comment": null
},
"INVENTORY_COST": {
"type": "NUMBER",
"index": 8,
"name": "INVENTORY_COST",
"comment": null
}
},
"stats": {
"has_stats": {
"id": "has_stats",
"label": "Has Stats?",
"value": false,
"include": false,
"description": "Indicates whether there are statistics for this table"
}
},
"unique_id": "model.dbt_amundsen_demo.raw_inventory_item_warehouse"
},
"model.dbt_amundsen_demo.raw_inventory_value": {
"metadata": {
"type": "VIEW",
"schema": "DBT_AMUNDSEN",
"name": "RAW_INVENTORY_VALUE",
"database": "DBT_AMUNDSEN_DEMO",
"comment": null,
"owner": "ACCOUNTADMIN"
},
"columns": {
"DT": {
"type": "NUMBER",
"index": 1,
"name": "DT",
"comment": null
},
"QUANTITY": {
"type": "NUMBER",
"index": 2,
"name": "QUANTITY",
"comment": null
},
"ITEM_PRICE": {
"type": "NUMBER",
"index": 3,
"name": "ITEM_PRICE",
"comment": null
},
"ITEM_COST": {
"type": "NUMBER",
"index": 4,
"name": "ITEM_COST",
"comment": null
},
"INVENTORY_VALUE": {
"type": "NUMBER",
"index": 5,
"name": "INVENTORY_VALUE",
"comment": null
},
"INVENTORY_COST": {
"type": "NUMBER",
"index": 6,
"name": "INVENTORY_COST",
"comment": null
}
},
"stats": {
"has_stats": {
"id": "has_stats",
"label": "Has Stats?",
"value": false,
"include": false,
"description": "Indicates whether there are statistics for this table"
}
},
"unique_id": "model.dbt_amundsen_demo.raw_inventory_value"
},
"model.dbt_amundsen_demo.fact_daily_expenses": {
"metadata": {
"type": "VIEW",
"schema": "DBT_AMUNDSEN",
"name": "COST_SUMMARY",
"database": "DBT_AMUNDSEN_DEMO",
"comment": null,
"owner": "ACCOUNTADMIN"
},
"columns": {
"DT": {
"type": "NUMBER",
"index": 1,
"name": "DT",
"comment": null
},
"INVENTORY_COST": {
"type": "NUMBER",
"index": 2,
"name": "INVENTORY_COST",
"comment": null
}
},
"stats": {
"has_stats": {
"id": "has_stats",
"label": "Has Stats?",
"value": false,
"include": false,
"description": "Indicates whether there are statistics for this table"
}
},
"unique_id": "model.dbt_amundsen_demo.fact_daily_expenses"
}
},
"sources": {},
"errors": null
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment