最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

Is there a way to add column descriptions to a declaration in dataform? - Stack Overflow

programmeradmin0浏览0评论

I am building a pipeline to combine the order data from a variety of ERPs. Currently the repos are setup as such:

erp1_repo
└── definitions
    ├── sources
    │   ├── order_table_1.sqlx (declaration)
    │   └── customer_table_1.sqlx (declaration)
    └── staging
        └── erp1_order_staging.sqlx (view)

erp2_repo
└── definitions
    ├── sources
    │   ├── order_table_2.sqlx (declaration)
    │   └── customer_table_2.sqlx (declaration)
    └── staging
        └── erp2_order_staging.sqlx (view)

order_repo
└── definitions
    ├── sources
    │   ├── erp1_order_staging.sqlx (declaration)
    │   └── erp2_order_staging.sqlx (declaration)
    └── fact_order.sqlx (incremental table)

I have tried adding the column descriptions to the order_table_1.sqlx declaration as such and executed the upstream erp1_order_staging.sqxl view with all three execution options checked, but the descriptions in order_table_1 did not get updated in BigQuery.

config {
  type: "declaration",
  database: "database_name",
  schema: "schema",
  name: "order_table_1",
  description: "order_table_1 description",
  columns: {
    ORDERNO: "Order Number",
    CUSTNO: "Customer Number",
    AMOUNT: "Order Amount",
    QTYORD: "Order Quantity"
  }
}
发布评论

评论列表(0)

  1. 暂无评论