search

dbt-labs / dbt-project-evaluator

This package contains macros and models to find DAG issues automatically
https://dbt-labs.github.io/dbt-project-evaluator/latest/
Apache License 2.0
436 stars 64 forks source link

athena t queryString' failed to satisfy constraint: Member must have length less than or equal to 262144 #457

Open chenglinli0 opened 4 months ago

chenglinli0 commented 4 months ago

Athena

When I run dbt run --select package:dbt_project_evaluator

I got cast(False as boolean));' at 'queryString' failed to satisfy constraint: Member must have length less than or equal to 262144

Seems caused by too much model, the sql generated by package is too long.

here is the log , it's too long and fill up my screen and I don't know what model caused it.

      '["macro.dbt.is_incremental"]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_commerce__get_vendor_sales_report_manufacturing_business'

  ,

      'stg_commerce__get_vendor_sales_report_manufacturing_business'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_commerce__get_vendor_sales_report_manufacturing_business.sql'

  ,
  cast(True as boolean),

      'incremental'

  ,

      'append_new_columns'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_commerce__get_vendor_sales_report_manufacturing_business'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  134,
  25.7,

      '["macro.dbt.is_incremental"]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_commerce__get_vendor_sales_report_manufacturing_fresh'

  ,

      'stg_commerce__get_vendor_sales_report_manufacturing_fresh'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_commerce__get_vendor_sales_report_manufacturing_fresh.sql'

  ,
  cast(True as boolean),

      'incremental'

  ,

      'append_new_columns'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_commerce__get_vendor_sales_report_manufacturing_fresh'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  114,
  25.7,

      '["macro.dbt.is_incremental"]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_commerce__get_vendor_sales_report_manufacturing_retail'

  ,

      'stg_commerce__get_vendor_sales_report_manufacturing_retail'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_commerce__get_vendor_sales_report_manufacturing_retail.sql'

  ,
  cast(True as boolean),

      'incremental'

  ,

      'append_new_columns'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  7,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_commerce__get_vendor_sales_report_manufacturing_retail'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  126,
  26.7,

      '["macro.dbt.is_incremental"]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_commerce__get_vendor_sales_report_sourcing_retail'

  ,

      'stg_commerce__get_vendor_sales_report_sourcing_retail'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_commerce__get_vendor_sales_report_sourcing_retail.sql'

  ,
  cast(True as boolean),

      'incremental'

  ,

      'append_new_columns'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_commerce__get_vendor_sales_report_sourcing_retail'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  123,
  26.7,

      '["macro.dbt.is_incremental"]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_commerce__get_vendor_traffic_report'

  ,

      'stg_commerce__get_vendor_traffic_report'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_commerce__get_vendor_traffic_report.sql'

  ,
  cast(True as boolean),

      'incremental'

  ,

      'append_new_columns'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  8,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_commerce__get_vendor_traffic_report'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  74,
  25.7,

      '["macro.dbt.is_incremental"]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_commerce__inc_get_vendor_inventory_report_manufacturing_retail'

  ,

      'stg_commerce__inc_get_vendor_inventory_report_manufacturing_retail'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_commerce__inc_get_vendor_inventory_report_manufacturing_retail.sql'

  ,
  cast(True as boolean),

      'ephemeral'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_commerce__inc_get_vendor_inventory_report_manufacturing_retail'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  15,
  2.1,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_commerce__inventory_report_manufacturing_retail'

  ,

      'stg_commerce__inventory_report_manufacturing_retail'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_commerce__inventory_report_manufacturing_retail.sql'

  ,
  cast(True as boolean),

      'incremental'

  ,

      'append_new_columns'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_commerce__inventory_report_manufacturing_retail'

  ,
  cast(True as boolean),
  '',

      '{}'

  ,

      ''

  ,
  78,
  12.0,

      '["macro.dbt.is_incremental", "macro.dbt_pacvue.dev_vendor_month"]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_commerce__inventory_report_manufacturing_retail_daily'

  ,

      'stg_commerce__inventory_report_manufacturing_retail_daily'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_commerce__inventory_report_manufacturing_retail_daily.sql'

  ,
  cast(True as boolean),

      'incremental'

  ,

      'append_new_columns'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  7,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_commerce__inventory_report_manufacturing_retail_daily'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  180,
  26.7,

      '["macro.dbt.is_incremental"]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_commerce__order_report'

  ,

      'stg_commerce__order_report'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_commerce__order_report.sql'

  ,
  cast(True as boolean),

      'view'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_commerce__order_report'

  ,
  cast(True as boolean),
  '',

      '{}'

  ,

      ''

  ,
  6,
  2.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_commerce__platformsetting'

  ,

      'stg_commerce__platformsetting'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_commerce__platformsetting.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_commerce__platformsetting'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  6,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_commerce__seller_asin_info_view'

  ,

      'stg_commerce__seller_asin_info_view'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_commerce__seller_asin_info_view.sql'

  ,
  cast(True as boolean),

      'view'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR), 
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_commerce__seller_asin_info_view'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  15,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_commerce__seller_inventory_summary_view'

  ,

      'stg_commerce__seller_inventory_summary_view'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_commerce__seller_inventory_summary_view.sql'

  ,
  cast(True as boolean),

      'view'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_commerce__seller_inventory_summary_view'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  25,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_commerce__vendor_inventory_report_manufacturing_retail_daily'

  ,

      'stg_commerce__vendor_inventory_report_manufacturing_retail_daily'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_commerce__vendor_inventory_report_manufacturing_retail_daily.sql'

  ,
  cast(True as boolean),

      'view'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_commerce__vendor_inventory_report_manufacturing_retail_daily'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  11,
  3.1,

      '["macro.dbt_pacvue.dev_vendor_id", "macro.dbt_pacvue.dev_vendor_month"]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_h10__system_amzproductdetails'

  ,

      'stg_h10__system_amzproductdetails'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_h10__system_amzproductdetails.sql'

  ,
  cast(True as boolean),

      'incremental'

  ,

      'append_new_columns'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_h10__system_amzproductdetails'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  75,
  9.1,

      '["macro.dbt_pacvue.get_region", "macro.dbt.is_incremental"]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_h10__system_amzproduct_review_history'

  ,

      'stg_h10__system_amzproduct_review_history'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_h10__system_amzproduct_review_history.sql'

  ,
  cast(True as boolean),

      'incremental'

  ,

      'append_new_columns'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_h10__system_amzproduct_review_history'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  45,
  9.1,

      '["macro.dbt_pacvue.get_region", "macro.dbt.is_incremental"]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_h10__system_amzproduct_review_summary'

  ,

      'stg_h10__system_amzproduct_review_summary'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_h10__system_amzproduct_review_summary.sql'

  ,
  cast(True as boolean),

      'incremental'

  ,

      'append_new_columns'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_h10__system_amzproduct_review_summary'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  52,
  9.1,

      '["macro.dbt_pacvue.get_region", "macro.dbt.is_incremental"]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_h10__system_fba_fulfillment_customer_returns_data'

  ,

      'stg_h10__system_fba_fulfillment_customer_returns_data'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_h10__system_fba_fulfillment_customer_returns_data.sql'

  ,
  cast(True as boolean),

      'incremental'

  ,

      'append_new_columns'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_h10__system_fba_fulfillment_customer_returns_data'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  44,
  9.0,

      '["macro.dbt.is_incremental"]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_h10__system_fba_fulfillment_customer_shipment_replacement_data'

  ,

      'stg_h10__system_fba_fulfillment_customer_shipment_replacement_data'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_h10__system_fba_fulfillment_customer_shipment_replacement_data.sql'

  ,
  cast(True as boolean),

      'incremental'

  ,

      'append_new_columns'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_h10__system_fba_fulfillment_customer_shipment_replacement_data'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  42,
  9.0,

      '["macro.dbt.is_incremental"]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_h10__system_fba_inventory_planning_data'

  ,

      'stg_h10__system_fba_inventory_planning_data'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_h10__system_fba_inventory_planning_data.sql'

  ,
  cast(True as boolean),

      'incremental'

  ,

      'append_new_columns'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_h10__system_fba_inventory_planning_data'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  107,
  9.0,

      '["macro.dbt.is_incremental"]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_h10__system_fba_reimbursements_data'

  ,

      'stg_h10__system_fba_reimbursements_data'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_h10__system_fba_reimbursements_data.sql'

  ,
  cast(True as boolean),

      'incremental'

  ,

      'append_new_columns'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_h10__system_fba_reimbursements_data'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  50,
  9.0,

      '["macro.dbt.is_incremental"]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_h10__system_get_custom_sync_fba_inbound_items'

  ,

      'stg_h10__system_get_custom_sync_fba_inbound_items'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_h10__system_get_custom_sync_fba_inbound_items.sql'

  ,
  cast(True as boolean),

      'incremental'

  ,

      'append_new_columns'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_h10__system_get_custom_sync_fba_inbound_items'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  58,
  9.0,

      '["macro.dbt.is_incremental"]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_h10__system_get_custom_sync_financial_events_list'

  ,

      'stg_h10__system_get_custom_sync_financial_events_list'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_h10__system_get_custom_sync_financial_events_list.sql'

  ,
  cast(True as boolean),

      'incremental'

  ,

      'append_new_columns'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_h10__system_get_custom_sync_financial_events_list'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  32,
  9.0,

      '["macro.dbt.is_incremental"]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_h10__system_ledger_detail_view_data'

  ,

      'stg_h10__system_ledger_detail_view_data'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_h10__system_ledger_detail_view_data.sql'

  ,
  cast(True as boolean),

      'incremental'

  ,

      'append_new_columns'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_h10__system_ledger_detail_view_data'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  46,
  9.0,

      '["macro.dbt.is_incremental"]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_h10__system_ledger_detail_view_data_adjustments'

  ,

      'stg_h10__system_ledger_detail_view_data_adjustments'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_h10__system_ledger_detail_view_data_adjustments.sql'

  ,
  cast(True as boolean),

      'incremental'

  ,

      'append_new_columns'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_h10__system_ledger_detail_view_data_adjustments'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  46,
  9.0,

      '["macro.dbt.is_incremental"]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_h10__system_xml_all_orders_data_by_last_update_general'

  ,

      'stg_h10__system_xml_all_orders_data_by_last_update_general'

  ,

      'model'

  ,

      'models\\common\\staging\\amazon\\s3\\stg_h10__system_xml_all_orders_data_by_last_update_general.sql'

  ,
  cast(True as boolean),

      'incremental'

  ,

      'append_new_columns'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_h10__system_xml_all_orders_data_by_last_update_general'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  64,
  9.0,

      '["macro.dbt.is_incremental"]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_bol__campaign'

  ,

      'stg_bol__campaign'

  ,

      'model'

  ,

      'models\\common\\staging\\bol\\jdbc\\stg_bol__campaign.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_bol__campaign'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_bol__campaigntag'

  ,

      'stg_bol__campaigntag'

  ,

      'model'

  ,

      'models\\common\\staging\\bol\\jdbc\\stg_bol__campaigntag.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_bol__campaigntag'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_bol__dayreportcampaign'

  ,

      'stg_bol__dayreportcampaign'

  ,

      'model'

  ,

      'models\\common\\staging\\bol\\jdbc\\stg_bol__dayreportcampaign.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_bol__dayreportcampaign'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_bol__dayreportkeyword'

  ,

      'stg_bol__dayreportkeyword'

  ,

      'model'

  ,

      'models\\common\\staging\\bol\\jdbc\\stg_bol__dayreportkeyword.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_bol__dayreportkeyword'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_bol__dayreportproduct'

  ,

      'stg_bol__dayreportproduct'

  ,

      'model'

  ,

      'models\\common\\staging\\bol\\jdbc\\stg_bol__dayreportproduct.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_bol__dayreportproduct'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_bol__product'

  ,

      'stg_bol__product'

  ,

      'model'

  ,

      'models\\common\\staging\\bol\\jdbc\\stg_bol__product.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR), 
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_bol__product'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_bol__productcatalog'

  ,

      'stg_bol__productcatalog'

  ,

      'model'

  ,

      'models\\common\\staging\\bol\\jdbc\\stg_bol__productcatalog.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_bol__productcatalog'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_bol__profile'

  ,

      'stg_bol__profile'

  ,

      'model'

  ,

      'models\\common\\staging\\bol\\jdbc\\stg_bol__profile.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_bol__profile'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_bol__tagcampaign'

  ,

      'stg_bol__tagcampaign'

  ,

      'model'

  ,

      'models\\common\\staging\\bol\\jdbc\\stg_bol__tagcampaign.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_bol__tagcampaign'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_bol__user'

  ,

      'stg_bol__user'

  ,

      'model'

  ,

      'models\\common\\staging\\bol\\jdbc\\stg_bol__user.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_bol__user'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_bol__userprofile'

  ,

      'stg_bol__userprofile'

  ,

      'model'

  ,

      'models\\common\\staging\\bol\\jdbc\\stg_bol__userprofile.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_bol__userprofile'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_chewy__campaign'

  ,

      'stg_chewy__campaign'

  ,

      'model'

  ,

      'models\\common\\staging\\chewy\\jdbc\\stg_chewy__campaign.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_chewy__campaign'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_chewy__campaigntag'

  ,

      'stg_chewy__campaigntag'

  ,

      'model'

  ,

      'models\\common\\staging\\chewy\\jdbc\\stg_chewy__campaigntag.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_chewy__campaigntag'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_chewy__campaign_content_rel'

  ,

      'stg_chewy__campaign_content_rel'

  ,

      'model'

  ,

      'models\\common\\staging\\chewy\\jdbc\\stg_chewy__campaign_content_rel.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_chewy__campaign_content_rel'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_chewy__content'

  ,

      'stg_chewy__content'

  ,

      'model'

  ,

      'models\\common\\staging\\chewy\\jdbc\\stg_chewy__content.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_chewy__content'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_chewy__dayreportcampaign'

  ,

      'stg_chewy__dayreportcampaign'

  ,

      'model'

  ,

      'models\\common\\staging\\chewy\\jdbc\\stg_chewy__dayreportcampaign.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_chewy__dayreportcampaign'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_chewy__dayreportkeyword'

  ,

      'stg_chewy__dayreportkeyword'

  ,

      'model'

  ,

      'models\\common\\staging\\chewy\\jdbc\\stg_chewy__dayreportkeyword.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_chewy__dayreportkeyword'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_chewy__dayreportproduct'

  ,

      'stg_chewy__dayreportproduct'

  ,

      'model'

  ,

      'models\\common\\staging\\chewy\\jdbc\\stg_chewy__dayreportproduct.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_chewy__dayreportproduct'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_chewy__profile'

  ,

      'stg_chewy__profile'

  ,

      'model'

  ,

      'models\\common\\staging\\chewy\\jdbc\\stg_chewy__profile.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_chewy__profile'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_chewy__tagcampaign'

  ,

      'stg_chewy__tagcampaign'

  ,

      'model'

  ,

      'models\\common\\staging\\chewy\\jdbc\\stg_chewy__tagcampaign.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_chewy__tagcampaign'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0, 

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_chewy__user'

  ,

      'stg_chewy__user'

  ,

      'model'

  ,

      'models\\common\\staging\\chewy\\jdbc\\stg_chewy__user.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_chewy__user'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_chewy__userprofile'

  ,

      'stg_chewy__userprofile'

  ,

      'model'

  ,

      'models\\common\\staging\\chewy\\jdbc\\stg_chewy__userprofile.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_chewy__userprofile'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_citrus_day_report_search_term_product'

  ,

      'stg_citrus_day_report_search_term_product'

  ,

      'model'

  ,

      'models\\common\\staging\\citrus\\jdbc\\stg_citrus_day_report_search_term_product.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_citrus_day_report_search_term_product'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_citrus_user_profile'

  ,

      'stg_citrus_user_profile'

  ,

      'model'

  ,

      'models\\common\\staging\\citrus\\jdbc\\stg_citrus_user_profile.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_citrus_user_profile'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_citrus__campaigntag'

  ,

      'stg_citrus__campaigntag'

  ,

      'model'

  ,

      'models\\common\\staging\\citrus\\jdbc\\stg_citrus__campaigntag.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_citrus__campaigntag'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_citrus__portfolio'

  ,

      'stg_citrus__portfolio'

  ,

      'model'

  ,

      'models\\common\\staging\\citrus\\jdbc\\stg_citrus__portfolio.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  11,
  11,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_citrus__portfolio'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_citrus__portfolioadgroup'

  ,

      'stg_citrus__portfolioadgroup'

  ,

      'model'

  ,

      'models\\common\\staging\\citrus\\jdbc\\stg_citrus__portfolioadgroup.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  4,
  4,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_citrus__portfolioadgroup'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_citrus__tagcampaign'

  ,

      'stg_citrus__tagcampaign'

  ,

      'model'

  ,

      'models\\common\\staging\\citrus\\jdbc\\stg_citrus__tagcampaign.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_citrus__tagcampaign'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_citrus__wallet'

  ,

      'stg_citrus__wallet'

  ,

      'model'

  ,

      'models\\common\\staging\\citrus\\jdbc\\stg_citrus__wallet.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  0,
  0,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_citrus__wallet'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  6,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_citrus__campaign'

  ,

      'stg_citrus__campaign'

  ,

      'model'

  ,

      'models\\common\\staging\\citrus\\s3\\stg_citrus__campaign.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  45,
  45,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_citrus__campaign'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_citrus__campaignproduct'

  ,

      'stg_citrus__campaignproduct'

  ,

      'model'

  ,

      'models\\common\\staging\\citrus\\s3\\stg_citrus__campaignproduct.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  9,
  9,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_citrus__campaignproduct'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_citrus__dayreportcampaign'

  ,

      'stg_citrus__dayreportcampaign'

  ,

      'model'

  ,

      'models\\common\\staging\\citrus\\s3\\stg_citrus__dayreportcampaign.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  16,
  16,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_citrus__dayreportcampaign'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  3,
  2.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_citrus__dayreportproductad'

  ,

      'stg_citrus__dayreportproductad'

  ,

      'model'

  ,

      'models\\common\\staging\\citrus\\s3\\stg_citrus__dayreportproductad.sql'

  ,
  cast(True as boolean),

      'view'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  21,
  21,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_citrus__dayreportproductad'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean)),

  (

      'model.dbt_pacvue.stg_citrus__product'

  ,

      'stg_citrus__product'

  ,

      'model'

  ,

      'models\\common\\staging\\citrus\\s3\\stg_citrus__product.sql'

  ,
  cast(True as boolean),

      'table'

  ,

      'ignore'

  ,
  cast(NULL as VARCHAR),

      'protected'

  ,
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(NULL as VARCHAR),
  cast(False as boolean),
  33,
  33,

      'awsdatacatalog'

  ,

      'dbt_licl'

  ,

      'dbt_pacvue'

  ,

      'stg_citrus__product'

  ,
  cast(False as boolean),
  '',

      '{}'

  ,

      ''

  ,
  5,
  1.0,

      '[]'

  ,
  cast(False as boolean),
  cast(False as boolean));' at 'queryString' failed to satisfy constraint: Member must have length less than or equal to 262144
b-per commented 4 months ago

Can you try setting the insert_batch_size var to a lower value?

For athena, I believe that it is set to 500 by default.

chenglinli0 commented 4 months ago

Can you try setting the insert_batch_size var to a lower value?

For athena, I believe that it is set to 500 by default. image

not works

b-per commented 4 months ago

Did you set it to 500?

What I meant was that it is 500 for athena by default, so you could try to set it lower (maybe 100).