athena t queryString' failed to satisfy constraint: Member must have length less than or equal to 262144
chenglinli0 opened this issue · 5 comments
chenglinli0 commented
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
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
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.
not works
b-per commented
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).
github-actions commented
This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.
github-actions commented
Although we are closing this issue as stale, it's not gone forever. Issues can be reopened if there is renewed community interest. Just add a comment to notify the maintainers.