root@new-airflow-dbt:~/airflow/dags/SALES_ORDERS_MANAGEMENT/snapshots# dbt --debug snapshot 08:44:16.405459 [info ] [MainThread]: oracle adapter: Running in cx mode ============================== 2022-12-25 08:44:16.465535 | 6807e2cd-b57c-41ad-b869-6314e64a287f ============================== 08:44:16.465540 [info ] [MainThread]: Running with dbt=1.3.1 08:44:16.465753 [debug] [MainThread]: running dbt with arguments {'debug': True, 'write_json': True, 'use_colors': True, 'printer_width': 80, 'version_check': True, 'partial_parse': True, 'static_parser': True, 'profiles_dir': '/root/.dbt', 'send_anonymous_usage_stats': True, 'event_buffer_size': 100000, 'quiet': False, 'no_print': False, 'which': 'snapshot', 'rpc_method': 'snapshot', 'indirect_selection': 'eager'} 08:44:16.465890 [debug] [MainThread]: Tracking: tracking 08:44:16.479264 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'start', 'context': [, , ]} 08:44:16.513366 [info ] [MainThread]: Unable to do partial parsing because of a dbt version mismatch. Saved manifest version: 1.3.0. Current version: 1.3.1. 08:44:16.513531 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'partial_parser', 'label': '6807e2cd-b57c-41ad-b869-6314e64a287f', 'context': []} 08:44:16.532678 [debug] [MainThread]: Parsing macros/adapters.sql 08:44:16.569678 [debug] [MainThread]: Parsing macros/apply_grants.sql 08:44:16.571254 [debug] [MainThread]: Parsing macros/catalog.sql 08:44:16.575003 [debug] [MainThread]: Parsing macros/columns.sql 08:44:16.579854 [debug] [MainThread]: Parsing macros/schema_tests.sql 08:44:16.582485 [debug] [MainThread]: Parsing macros/materializations/incremental/incremental.sql 08:44:16.590917 [debug] [MainThread]: Parsing macros/materializations/incremental/strategies.sql 08:44:16.612770 [debug] [MainThread]: Parsing macros/materializations/seed/seed.sql 08:44:16.616777 [debug] [MainThread]: Parsing macros/materializations/snapshot/snapshot.sql 08:44:16.653293 [debug] [MainThread]: Parsing macros/materializations/snapshot/snapshot_merge.sql 08:44:16.655344 [debug] [MainThread]: Parsing macros/materializations/snapshot/strategies.sql 08:44:16.666153 [debug] [MainThread]: Parsing macros/materializations/table/table.sql 08:44:16.674693 [debug] [MainThread]: Parsing macros/materializations/tests/helpers.sql 08:44:16.676461 [debug] [MainThread]: Parsing macros/materializations/view/view.sql 08:44:16.681984 [debug] [MainThread]: Parsing macros/utils/cast_bool_to_text.sql 08:44:16.682528 [debug] [MainThread]: Parsing macros/utils/data_types.sql 08:44:16.683371 [debug] [MainThread]: Parsing macros/utils/dateadd.sql 08:44:16.685864 [debug] [MainThread]: Parsing macros/utils/datediff.sql 08:44:16.689566 [debug] [MainThread]: Parsing macros/utils/datetrunc.sql 08:44:16.690992 [debug] [MainThread]: Parsing macros/utils/except.sql 08:44:16.691434 [debug] [MainThread]: Parsing macros/utils/hash.sql 08:44:16.692207 [debug] [MainThread]: Parsing macros/utils/last_day.sql 08:44:16.693103 [debug] [MainThread]: Parsing macros/utils/position.sql 08:44:16.693697 [debug] [MainThread]: Parsing macros/utils/right.sql 08:44:16.694429 [debug] [MainThread]: Parsing macros/utils/timestamps.sql 08:44:16.695369 [debug] [MainThread]: Parsing macros/adapters/apply_grants.sql 08:44:16.708539 [debug] [MainThread]: Parsing macros/adapters/columns.sql 08:44:16.717393 [debug] [MainThread]: Parsing macros/adapters/freshness.sql 08:44:16.719372 [debug] [MainThread]: Parsing macros/adapters/indexes.sql 08:44:16.721976 [debug] [MainThread]: Parsing macros/adapters/metadata.sql 08:44:16.728699 [debug] [MainThread]: Parsing macros/adapters/persist_docs.sql 08:44:16.732931 [debug] [MainThread]: Parsing macros/adapters/relation.sql 08:44:16.746429 [debug] [MainThread]: Parsing macros/adapters/schema.sql 08:44:16.748487 [debug] [MainThread]: Parsing macros/adapters/timestamps.sql 08:44:16.751636 [debug] [MainThread]: Parsing macros/etc/datetime.sql 08:44:16.759495 [debug] [MainThread]: Parsing macros/etc/statement.sql 08:44:16.764423 [debug] [MainThread]: Parsing macros/generic_test_sql/accepted_values.sql 08:44:16.765763 [debug] [MainThread]: Parsing macros/generic_test_sql/not_null.sql 08:44:16.766573 [debug] [MainThread]: Parsing macros/generic_test_sql/relationships.sql 08:44:16.767427 [debug] [MainThread]: Parsing macros/generic_test_sql/unique.sql 08:44:16.768121 [debug] [MainThread]: Parsing macros/get_custom_name/get_custom_alias.sql 08:44:16.769533 [debug] [MainThread]: Parsing macros/get_custom_name/get_custom_database.sql 08:44:16.771068 [debug] [MainThread]: Parsing macros/get_custom_name/get_custom_schema.sql 08:44:16.773574 [debug] [MainThread]: Parsing macros/materializations/configs.sql 08:44:16.775828 [debug] [MainThread]: Parsing macros/materializations/hooks.sql 08:44:16.779760 [debug] [MainThread]: Parsing macros/materializations/models/incremental/column_helpers.sql 08:44:16.787216 [debug] [MainThread]: Parsing macros/materializations/models/incremental/incremental.sql 08:44:16.796905 [debug] [MainThread]: Parsing macros/materializations/models/incremental/is_incremental.sql 08:44:16.798363 [debug] [MainThread]: Parsing macros/materializations/models/incremental/merge.sql 08:44:16.812899 [debug] [MainThread]: Parsing macros/materializations/models/incremental/on_schema_change.sql 08:44:16.828375 [debug] [MainThread]: Parsing macros/materializations/models/incremental/strategies.sql 08:44:16.834911 [debug] [MainThread]: Parsing macros/materializations/models/table/create_table_as.sql 08:44:16.838377 [debug] [MainThread]: Parsing macros/materializations/models/table/table.sql 08:44:16.843705 [debug] [MainThread]: Parsing macros/materializations/models/view/create_or_replace_view.sql 08:44:16.846956 [debug] [MainThread]: Parsing macros/materializations/models/view/create_view_as.sql 08:44:16.849280 [debug] [MainThread]: Parsing macros/materializations/models/view/helpers.sql 08:44:16.850557 [debug] [MainThread]: Parsing macros/materializations/models/view/view.sql 08:44:16.855622 [debug] [MainThread]: Parsing macros/materializations/seeds/helpers.sql 08:44:16.873335 [debug] [MainThread]: Parsing macros/materializations/seeds/seed.sql 08:44:16.879900 [debug] [MainThread]: Parsing macros/materializations/snapshots/helpers.sql 08:44:16.891835 [debug] [MainThread]: Parsing macros/materializations/snapshots/snapshot.sql 08:44:16.902876 [debug] [MainThread]: Parsing macros/materializations/snapshots/snapshot_merge.sql 08:44:16.904563 [debug] [MainThread]: Parsing macros/materializations/snapshots/strategies.sql 08:44:16.919736 [debug] [MainThread]: Parsing macros/materializations/tests/helpers.sql 08:44:16.921571 [debug] [MainThread]: Parsing macros/materializations/tests/test.sql 08:44:16.925792 [debug] [MainThread]: Parsing macros/materializations/tests/where_subquery.sql 08:44:16.927546 [debug] [MainThread]: Parsing macros/python_model/python.sql 08:44:16.933232 [debug] [MainThread]: Parsing macros/utils/any_value.sql 08:44:16.934194 [debug] [MainThread]: Parsing macros/utils/array_append.sql 08:44:16.935263 [debug] [MainThread]: Parsing macros/utils/array_concat.sql 08:44:16.936315 [debug] [MainThread]: Parsing macros/utils/array_construct.sql 08:44:16.937922 [debug] [MainThread]: Parsing macros/utils/bool_or.sql 08:44:16.938880 [debug] [MainThread]: Parsing macros/utils/cast_bool_to_text.sql 08:44:16.940346 [debug] [MainThread]: Parsing macros/utils/concat.sql 08:44:16.941360 [debug] [MainThread]: Parsing macros/utils/data_types.sql 08:44:16.947679 [debug] [MainThread]: Parsing macros/utils/date_trunc.sql 08:44:16.948761 [debug] [MainThread]: Parsing macros/utils/dateadd.sql 08:44:16.950003 [debug] [MainThread]: Parsing macros/utils/datediff.sql 08:44:16.951387 [debug] [MainThread]: Parsing macros/utils/escape_single_quotes.sql 08:44:16.952490 [debug] [MainThread]: Parsing macros/utils/except.sql 08:44:16.953337 [debug] [MainThread]: Parsing macros/utils/hash.sql 08:44:16.954421 [debug] [MainThread]: Parsing macros/utils/intersect.sql 08:44:16.955306 [debug] [MainThread]: Parsing macros/utils/last_day.sql 08:44:16.957072 [debug] [MainThread]: Parsing macros/utils/length.sql 08:44:16.958032 [debug] [MainThread]: Parsing macros/utils/listagg.sql 08:44:16.960209 [debug] [MainThread]: Parsing macros/utils/literal.sql 08:44:16.961197 [debug] [MainThread]: Parsing macros/utils/position.sql 08:44:16.962283 [debug] [MainThread]: Parsing macros/utils/replace.sql 08:44:16.963526 [debug] [MainThread]: Parsing macros/utils/right.sql 08:44:16.964784 [debug] [MainThread]: Parsing macros/utils/safe_cast.sql 08:44:16.965894 [debug] [MainThread]: Parsing macros/utils/split_part.sql 08:44:16.967875 [debug] [MainThread]: Parsing tests/generic/builtin.sql 08:44:17.275075 [debug] [MainThread]: 1699: static parser successfully parsed uniters_orders_z.sql 08:44:17.395585 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'load_project', 'label': '6807e2cd-b57c-41ad-b869-6314e64a287f', 'context': []} 08:44:17.405656 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'resource_counts', 'label': '6807e2cd-b57c-41ad-b869-6314e64a287f', 'context': []} 08:44:17.406087 [info ] [MainThread]: Found 1 model, 0 tests, 3 snapshots, 0 analyses, 325 macros, 2 operations, 0 seed files, 15 sources, 0 exposures, 0 metrics 08:44:17.406261 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'runnable_timing', 'label': '6807e2cd-b57c-41ad-b869-6314e64a287f', 'context': []} 08:44:17.407947 [info ] [MainThread]: 08:44:17.408654 [debug] [MainThread]: Acquiring new oracle connection "master" 08:44:17.409883 [debug] [ThreadPool]: Acquiring new oracle connection "list_psdb" 08:44:17.420620 [debug] [ThreadPool]: oracle adapter: Using oracle connection "list_psdb". 08:44:17.420870 [debug] [ThreadPool]: oracle adapter: On list_psdb: f/* {"app": "dbt", "dbt_version": "1.3.1", "profile_name": "dbt_oracle_psdb_prod", "target_name": "prod", "connection_name": "list_psdb"} */ select username as "name" from sys.all_users order by username 08:44:17.421107 [debug] [ThreadPool]: Opening a new connection, currently in state init 08:44:17.421322 [debug] [ThreadPool]: oracle adapter: Attempting to connect using Oracle method: 'OracleConnectionMethod.HOST' and dsn: 'tcp://172.16.3.32:1521/psdb?retry_count=1&retry_delay=3' 08:44:17.492141 [debug] [ThreadPool]: oracle adapter: SQL status: OK in 0.07079339027404785 seconds 08:44:17.497210 [debug] [ThreadPool]: On list_psdb: Close 08:44:17.502837 [debug] [ThreadPool]: Acquiring new oracle connection "list_psdb_psofa" 08:44:17.577756 [debug] [ThreadPool]: Opening a new connection, currently in state closed 08:44:17.577933 [debug] [ThreadPool]: oracle adapter: Attempting to connect using Oracle method: 'OracleConnectionMethod.HOST' and dsn: 'tcp://172.16.3.32:1521/psdb?retry_count=1&retry_delay=3' 08:44:17.601497 [debug] [ThreadPool]: oracle adapter: Using oracle connection "list_psdb_psofa". 08:44:17.601655 [debug] [ThreadPool]: oracle adapter: On list_psdb_psofa: f/* {"app": "dbt", "dbt_version": "1.3.1", "profile_name": "dbt_oracle_psdb_prod", "target_name": "prod", "connection_name": "list_psdb_psofa"} */ with tables as (select SYS_CONTEXT('userenv', 'DB_NAME') table_catalog, owner table_schema, table_name, case when iot_type = 'Y' then 'IOT' when temporary = 'Y' then 'TEMP' else 'BASE TABLE' end table_type from sys.all_tables union all select SYS_CONTEXT('userenv', 'DB_NAME'), owner, view_name, 'VIEW' from sys.all_views ) select table_catalog as "database_name" ,table_name as "name" ,table_schema as "schema_name" ,case table_type when 'BASE TABLE' then 'table' when 'VIEW' then 'view' end as "kind" from tables where table_type in ('BASE TABLE', 'VIEW') and upper(table_schema) = upper('psofa') 08:44:18.160765 [debug] [ThreadPool]: oracle adapter: SQL status: OK in 0.5587255954742432 seconds 08:44:18.264392 [debug] [ThreadPool]: On list_psdb_psofa: ROLLBACK 08:44:18.264839 [debug] [ThreadPool]: On list_psdb_psofa: Close 08:44:18.325558 [debug] [MainThread]: Sending event: {'category': 'dbt', 'action': 'runnable_timing', 'label': '6807e2cd-b57c-41ad-b869-6314e64a287f', 'context': []} 08:44:18.326008 [debug] [MainThread]: Opening a new connection, currently in state init 08:44:18.326200 [debug] [MainThread]: oracle adapter: Attempting to connect using Oracle method: 'OracleConnectionMethod.HOST' and dsn: 'tcp://172.16.3.32:1521/psdb?retry_count=1&retry_delay=3' 08:44:18.348834 [debug] [MainThread]: On master: COMMIT 08:44:18.349027 [debug] [MainThread]: oracle adapter: Using oracle connection "master". 08:44:18.349168 [debug] [MainThread]: oracle adapter: On master: fCOMMIT 08:44:18.349705 [debug] [MainThread]: oracle adapter: SQL status: OK in 0.0003650188446044922 seconds 08:44:18.349888 [info ] [MainThread]: 08:44:18.350030 [info ] [MainThread]: Running 1 on-run-start hook 08:44:18.350196 [debug] [MainThread]: Compiling operation.dbt_project.dbt_project-on-run-start-0 08:44:18.352364 [debug] [MainThread]: Writing injected SQL for node "operation.dbt_project.dbt_project-on-run-start-0" 08:44:18.354007 [info ] [MainThread]: 1 of 1 START hook: dbt_project.on-run-start.0 .................................. [RUN] 08:44:18.354187 [debug] [MainThread]: oracle adapter: Using oracle connection "master". 08:44:18.354341 [debug] [MainThread]: oracle adapter: On master: f/* {"app": "dbt", "dbt_version": "1.3.1", "profile_name": "dbt_oracle_psdb_prod", "target_name": "prod", "connection_name": "master"} */ select 'hook start' from dual 08:44:18.354988 [debug] [MainThread]: oracle adapter: SQL status: OK in 0.0004277229309082031 seconds 08:44:18.355815 [info ] [MainThread]: 1 of 1 OK hook: dbt_project.on-run-start.0 ..................................... [OK in 0.00s] 08:44:18.355966 [info ] [MainThread]: 08:44:18.356181 [debug] [MainThread]: On master: Close 08:44:18.357955 [info ] [MainThread]: Concurrency: 8 threads (target='prod') 08:44:18.358083 [info ] [MainThread]: 08:44:18.364119 [debug] [Thread-1 ]: Began running node snapshot.dbt_project.sales_orders 08:44:18.364242 [debug] [Thread-2 ]: Began running node snapshot.dbt_project.sales_orders_appog 08:44:18.364622 [debug] [Thread-3 ]: Began running node snapshot.dbt_project.uniters_orders 08:44:18.364953 [info ] [Thread-1 ]: 1 of 3 START snapshot psofa.sales_orders ....................................... [RUN] 08:44:18.365248 [info ] [Thread-2 ]: 2 of 3 START snapshot psofa.sales_orders_appog ................................. [RUN] 08:44:18.365895 [info ] [Thread-3 ]: 3 of 3 START snapshot psofa.uniters_orders ..................................... [RUN] 08:44:18.366944 [debug] [Thread-1 ]: Acquiring new oracle connection "snapshot.dbt_project.sales_orders" 08:44:18.367064 [debug] [Thread-2 ]: Acquiring new oracle connection "snapshot.dbt_project.sales_orders_appog" 08:44:18.368754 [debug] [Thread-3 ]: Acquiring new oracle connection "snapshot.dbt_project.uniters_orders" 08:44:18.368994 [debug] [Thread-1 ]: Began compiling node snapshot.dbt_project.sales_orders 08:44:18.369109 [debug] [Thread-2 ]: Began compiling node snapshot.dbt_project.sales_orders_appog 08:44:18.369420 [debug] [Thread-3 ]: Began compiling node snapshot.dbt_project.uniters_orders 08:44:18.369640 [debug] [Thread-1 ]: Compiling snapshot.dbt_project.sales_orders 08:44:18.369842 [debug] [Thread-2 ]: Compiling snapshot.dbt_project.sales_orders_appog 08:44:18.374192 [debug] [Thread-3 ]: Compiling snapshot.dbt_project.uniters_orders 08:44:18.382693 [debug] [Thread-1 ]: finished collecting timing info 08:44:18.382916 [debug] [Thread-2 ]: finished collecting timing info 08:44:18.383141 [debug] [Thread-3 ]: finished collecting timing info 08:44:18.383321 [debug] [Thread-1 ]: Began executing node snapshot.dbt_project.sales_orders 08:44:18.393578 [debug] [Thread-2 ]: Began executing node snapshot.dbt_project.sales_orders_appog 08:44:18.414641 [debug] [Thread-3 ]: Began executing node snapshot.dbt_project.uniters_orders 08:44:18.436833 [debug] [Thread-1 ]: oracle adapter: Using oracle connection "snapshot.dbt_project.sales_orders". 08:44:18.439165 [debug] [Thread-3 ]: oracle adapter: Using oracle connection "snapshot.dbt_project.uniters_orders". 08:44:18.439333 [debug] [Thread-2 ]: oracle adapter: Using oracle connection "snapshot.dbt_project.sales_orders_appog". 08:44:18.439552 [debug] [Thread-1 ]: oracle adapter: On snapshot.dbt_project.sales_orders: f/* {"app": "dbt", "dbt_version": "1.3.1", "profile_name": "dbt_oracle_psdb_prod", "target_name": "prod", "node_id": "snapshot.dbt_project.sales_orders"} */ select count(*) from sys.all_users where username = upper('psofa') 08:44:18.439753 [debug] [Thread-3 ]: oracle adapter: On snapshot.dbt_project.uniters_orders: f/* {"app": "dbt", "dbt_version": "1.3.1", "profile_name": "dbt_oracle_psdb_prod", "target_name": "prod", "node_id": "snapshot.dbt_project.uniters_orders"} */ select count(*) from sys.all_users where username = upper('psofa') 08:44:18.439919 [debug] [Thread-2 ]: oracle adapter: On snapshot.dbt_project.sales_orders_appog: f/* {"app": "dbt", "dbt_version": "1.3.1", "profile_name": "dbt_oracle_psdb_prod", "target_name": "prod", "node_id": "snapshot.dbt_project.sales_orders_appog"} */ select count(*) from sys.all_users where username = upper('psofa') 08:44:18.440110 [debug] [Thread-1 ]: Opening a new connection, currently in state closed 08:44:18.440310 [debug] [Thread-3 ]: Opening a new connection, currently in state init 08:44:18.440479 [debug] [Thread-2 ]: Opening a new connection, currently in state init 08:44:18.440678 [debug] [Thread-1 ]: oracle adapter: Attempting to connect using Oracle method: 'OracleConnectionMethod.HOST' and dsn: 'tcp://172.16.3.32:1521/psdb?retry_count=1&retry_delay=3' 08:44:18.440823 [debug] [Thread-3 ]: oracle adapter: Attempting to connect using Oracle method: 'OracleConnectionMethod.HOST' and dsn: 'tcp://172.16.3.32:1521/psdb?retry_count=1&retry_delay=3' 08:44:18.440987 [debug] [Thread-2 ]: oracle adapter: Attempting to connect using Oracle method: 'OracleConnectionMethod.HOST' and dsn: 'tcp://172.16.3.32:1521/psdb?retry_count=1&retry_delay=3' 08:44:18.466177 [debug] [Thread-2 ]: oracle adapter: SQL status: OK in 0.025987625122070312 seconds 08:44:18.487988 [debug] [Thread-1 ]: oracle adapter: SQL status: OK in 0.0430605411529541 seconds 08:44:18.518763 [debug] [Thread-3 ]: oracle adapter: SQL status: OK in 0.04823732376098633 seconds 08:44:18.612575 [debug] [Thread-2 ]: oracle adapter: Using oracle connection "snapshot.dbt_project.sales_orders_appog". 08:44:18.612770 [debug] [Thread-3 ]: oracle adapter: Using oracle connection "snapshot.dbt_project.uniters_orders". 08:44:18.612999 [debug] [Thread-1 ]: oracle adapter: Using oracle connection "snapshot.dbt_project.sales_orders". 08:44:18.613232 [debug] [Thread-2 ]: oracle adapter: On snapshot.dbt_project.sales_orders_appog: f/* {"app": "dbt", "dbt_version": "1.3.1", "profile_name": "dbt_oracle_psdb_prod", "target_name": "prod", "node_id": "snapshot.dbt_project.sales_orders_appog"} */ select SYS_EXTRACT_UTC(current_timestamp) FROM dual 08:44:18.613430 [debug] [Thread-3 ]: oracle adapter: On snapshot.dbt_project.uniters_orders: f/* {"app": "dbt", "dbt_version": "1.3.1", "profile_name": "dbt_oracle_psdb_prod", "target_name": "prod", "node_id": "snapshot.dbt_project.uniters_orders"} */ select SYS_EXTRACT_UTC(current_timestamp) FROM dual 08:44:18.613598 [debug] [Thread-1 ]: oracle adapter: On snapshot.dbt_project.sales_orders: f/* {"app": "dbt", "dbt_version": "1.3.1", "profile_name": "dbt_oracle_psdb_prod", "target_name": "prod", "node_id": "snapshot.dbt_project.sales_orders"} */ select SYS_EXTRACT_UTC(current_timestamp) FROM dual 08:44:18.614436 [debug] [Thread-2 ]: oracle adapter: SQL status: OK in 0.00069427490234375 seconds 08:44:18.620626 [debug] [Thread-3 ]: oracle adapter: SQL status: OK in 0.0006420612335205078 seconds 08:44:18.630290 [debug] [Thread-1 ]: oracle adapter: SQL status: OK in 0.0008885860443115234 seconds 08:44:18.630466 [debug] [Thread-2 ]: oracle adapter: Using oracle connection "snapshot.dbt_project.sales_orders_appog". 08:44:18.632090 [debug] [Thread-3 ]: oracle adapter: Using oracle connection "snapshot.dbt_project.uniters_orders". 08:44:18.632251 [debug] [Thread-1 ]: oracle adapter: Using oracle connection "snapshot.dbt_project.sales_orders". 08:44:18.632448 [debug] [Thread-2 ]: oracle adapter: On snapshot.dbt_project.sales_orders_appog: f/* {"app": "dbt", "dbt_version": "1.3.1", "profile_name": "dbt_oracle_psdb_prod", "target_name": "prod", "node_id": "snapshot.dbt_project.sales_orders_appog"} */ select * from ( SELECT to_char(voct.ANNO_ORD) || '/' || voct.TIPO_ORD || '/' || to_char(voct.NRO_ORD) ID, pan1.NEGOZIO NEGOZIO_VENDITA, voct.anno_ord, voct.tipo_ord, voct.nro_ord, voct.TXT_A_DISP_2, pan2.NEGOZIO NEGOZIO_APPOGGIATO, pan2.EMAIL_AREA_MANAGER, voct.COD_STATO_DOC, voctf.NOME_CL_FIN, voctf.INDIRIZZO, voctf.CAP, voctf.CITTA, voctf.PV, voctf.COD_STATO, voctf.NRO_TELEFONO_1, voctf.ALTRO_RIF_1, voctf.E_MAIL_1, (SELECT max(VBT.DATA_INS) FROM VEW_BOLLA_TEST VBT, VEW_BOLLA_RIGA VBR WHERE VBT.ANNO_BOLLA = VBR.ANNO_BOLLA AND VBT.TIPO_BOLLA = VBR.TIPO_BOLLA AND VBT.NRO_BOLLA = VBR.NRO_BOLLA AND VBT.TIPO_BOLLA in ('DF', 'DP') AND VBR.rif_ns_anno_ord = voct.ANNO_ORD and VBR.rif_ns_tipo_ord = voct.TIPO_ORD and VBR.rif_ns_nro_ord = voct.NRO_ORD) DATA_ULT_SPED_A_NEGOZ FROM psofa.VEW_ORD_CL_TEST voct JOIN psofa.VEW_ORD_CL_TEST_FIN voctf ON (voct.anno_ord = voctf.anno_ord AND voct.tipo_ord = voctf.tipo_ord AND voct.nro_ord = voctf.nro_ord) join psofa.PSO_V_AREE_NEGOZI pan1 on (voct.tipo_ord = pan1.tipo_ord) join psofa.PSO_V_AREE_NEGOZI pan2 on (voct.TXT_A_DISP_2 = pan2.tipo_ord) WHERE voct.TXT_A_DISP_2 IS NOT NULL AND VOCT.TIPO_ORD NOT IN ('DA', 'PS', 'AS', 'AX') AND voct.NRO_ORD < 100000 AND voct.DATA_INS >= to_date('2021-11-01', 'yyyy-mm-dd') AND voct.COD_STATO_DOC = '02' AND VOCT.DATA_SOSP IS NULL AND VOCT.DATA_ANN IS NULL ) dbt_sbq_tmp where 1 = 0 and rownum < 1 08:44:18.632549 [debug] [Thread-3 ]: oracle adapter: On snapshot.dbt_project.uniters_orders: f/* {"app": "dbt", "dbt_version": "1.3.1", "profile_name": "dbt_oracle_psdb_prod", "target_name": "prod", "node_id": "snapshot.dbt_project.uniters_orders"} */ select * from ( SELECT to_char(voct.ANNO_ORD) || '/' || voct.TIPO_ORD || '/' || to_char(voct.NRO_ORD) || '-' || to_char(vocr.RIGA_ORD) ID, voct.ANNO_ORD, voct.TIPO_ORD, voct.NRO_ORD, vocr.RIGA_ORD, voct.DATA_INS, voct.COD_STATO_DOC, voctf.DESCRIZIONE_1, voctf.DESCRIZIONE_2, voctf.e_Mail_1, vocr.TIPO_ART, vocr.COD_ART, vocr.QTA_ORDINATA, vocr.PREZZO, pocta.UNITERS_CODE FROM psofa.VEW_ORD_CL_TEST voct JOIN psofa.VEW_ORD_CL_TEST_FIN voctf ON (voct.anno_ord = voctf.anno_ord AND voct.tipo_ord = voctf.tipo_ord AND voct.nro_ord = voctf.nro_ord) JOIN psofa.VEW_ORD_CL_RIGA vocr ON (voct.anno_ord = vocr.anno_ord AND voct.tipo_ord = vocr.tipo_ord AND voct.nro_ord = vocr.nro_ord) JOIN psofa.PSO_ORD_CL_TEST_ALTRO pocta ON (voct.anno_ord = pocta.anno_ord AND voct.tipo_ord = pocta.tipo_ord AND voct.nro_ord = pocta.nro_ord) JOIN psofa.uniters_orders_z z ON (voct.anno_ord = z.anno_ord AND voct.tipo_ord = z.tipo_ord AND voct.nro_ord = z.nro_ord) where voct.DATA_INS >= To_date('2022-10-01', 'yyyy-mm-dd') and voct.NRO_ORD < 50000 ) dbt_sbq_tmp where 1 = 0 and rownum < 1 08:44:18.632660 [debug] [Thread-1 ]: oracle adapter: On snapshot.dbt_project.sales_orders: f/* {"app": "dbt", "dbt_version": "1.3.1", "profile_name": "dbt_oracle_psdb_prod", "target_name": "prod", "node_id": "snapshot.dbt_project.sales_orders"} */ select * from ( SELECT to_char(voct.ANNO_ORD) || '/' || voct.TIPO_ORD || '/' || to_char(voct.NRO_ORD) ID, voct.ANNO_ORD, voct.TIPO_ORD, voct.NRO_ORD, voct.DATA_INS, voct.COD_STATO_DOC, voct.MASTRO, voct.PARTIT, voctf.DESCRIZIONE_1, voctf.DESCRIZIONE_2, voctf.e_Mail_1 FROM psofa.VEW_ORD_CL_TEST voct JOIN psofa.VEW_ORD_CL_TEST_FIN voctf ON (voct.anno_ord = voctf.anno_ord AND voct.tipo_ord = voctf.tipo_ord AND voct.nro_ord = voctf.nro_ord) WHERE voct.DATA_INS >= To_date('2021-11-01', 'yyyy-mm-dd') and voct.COD_STATO_DOC = '01' ) dbt_sbq_tmp where 1 = 0 and rownum < 1 08:44:18.640498 [debug] [Thread-1 ]: oracle adapter: SQL status: OK in 0.007516145706176758 seconds 08:44:18.643610 [debug] [Thread-1 ]: oracle adapter: Using oracle connection "snapshot.dbt_project.sales_orders". 08:44:18.643740 [debug] [Thread-1 ]: oracle adapter: On snapshot.dbt_project.sales_orders: f/* {"app": "dbt", "dbt_version": "1.3.1", "profile_name": "dbt_oracle_psdb_prod", "target_name": "prod", "node_id": "snapshot.dbt_project.sales_orders"} */ select SYS_CONTEXT('userenv', 'DB_NAME') FROM DUAL 08:44:18.644267 [debug] [Thread-1 ]: oracle adapter: SQL status: OK in 0.0003705024719238281 seconds 08:44:18.666255 [debug] [Thread-3 ]: oracle adapter: SQL status: OK in 0.028235197067260742 seconds 08:44:18.678421 [debug] [Thread-3 ]: oracle adapter: Using oracle connection "snapshot.dbt_project.uniters_orders". 08:44:18.678647 [debug] [Thread-1 ]: oracle adapter: Using oracle connection "snapshot.dbt_project.sales_orders". 08:44:18.678887 [debug] [Thread-3 ]: oracle adapter: On snapshot.dbt_project.uniters_orders: f/* {"app": "dbt", "dbt_version": "1.3.1", "profile_name": "dbt_oracle_psdb_prod", "target_name": "prod", "node_id": "snapshot.dbt_project.uniters_orders"} */ select SYS_CONTEXT('userenv', 'DB_NAME') FROM DUAL 08:44:18.679089 [debug] [Thread-1 ]: oracle adapter: On snapshot.dbt_project.sales_orders: f/* {"app": "dbt", "dbt_version": "1.3.1", "profile_name": "dbt_oracle_psdb_prod", "target_name": "prod", "node_id": "snapshot.dbt_project.sales_orders"} */ select * from ( select * from PSOFA.SALES_ORDERS ) dbt_sbq_tmp where 1 = 0 and rownum < 1 08:44:18.680089 [debug] [Thread-3 ]: oracle adapter: SQL status: OK in 0.0007750988006591797 seconds 08:44:18.680218 [debug] [Thread-1 ]: oracle adapter: SQL status: OK in 0.000751495361328125 seconds 08:44:18.716309 [debug] [Thread-1 ]: oracle adapter: Using oracle connection "snapshot.dbt_project.sales_orders". 08:44:18.724432 [debug] [Thread-1 ]: oracle adapter: On snapshot.dbt_project.sales_orders: f/* {"app": "dbt", "dbt_version": "1.3.1", "profile_name": "dbt_oracle_psdb_prod", "target_name": "prod", "node_id": "snapshot.dbt_project.sales_orders"} */ with columns as ( select SYS_CONTEXT('userenv', 'DB_NAME') table_catalog, owner table_schema, table_name, column_name, data_type, data_type_mod, decode(data_type_owner, null, TO_CHAR(null), SYS_CONTEXT('userenv', 'DB_NAME')) domain_catalog, data_type_owner domain_schema, data_length character_maximum_length, data_length character_octet_length, data_length, data_precision numeric_precision, data_scale numeric_scale, nullable is_nullable, column_id ordinal_position, default_length, data_default column_default, num_distinct, low_value, high_value, density, num_nulls, num_buckets, last_analyzed, sample_size, SYS_CONTEXT('userenv', 'DB_NAME') character_set_catalog, 'SYS' character_set_schema, SYS_CONTEXT('userenv', 'DB_NAME') collation_catalog, 'SYS' collation_schema, character_set_name, char_col_decl_length, global_stats, user_stats, avg_col_len, char_length, char_used, v80_fmt_image, data_upgraded, histogram from sys.all_tab_columns ) select column_name as "name", data_type as "type", char_length as "character_maximum_length", numeric_precision as "numeric_precision", numeric_scale as "numeric_scale" from columns where upper(table_name) = upper('SALES_ORDERS') and upper(table_schema) = upper('PSOFA') order by ordinal_position 08:44:18.724562 [debug] [Thread-3 ]: oracle adapter: Using oracle connection "snapshot.dbt_project.uniters_orders". 08:44:18.724895 [debug] [Thread-3 ]: oracle adapter: On snapshot.dbt_project.uniters_orders: f/* {"app": "dbt", "dbt_version": "1.3.1", "profile_name": "dbt_oracle_psdb_prod", "target_name": "prod", "node_id": "snapshot.dbt_project.uniters_orders"} */ select * from ( select * from PSOFA.UNITERS_ORDERS ) dbt_sbq_tmp where 1 = 0 and rownum < 1 08:44:18.725801 [debug] [Thread-3 ]: oracle adapter: SQL status: OK in 0.0006756782531738281 seconds 08:44:18.729293 [debug] [Thread-3 ]: oracle adapter: Using oracle connection "snapshot.dbt_project.uniters_orders". 08:44:18.729443 [debug] [Thread-3 ]: oracle adapter: On snapshot.dbt_project.uniters_orders: f/* {"app": "dbt", "dbt_version": "1.3.1", "profile_name": "dbt_oracle_psdb_prod", "target_name": "prod", "node_id": "snapshot.dbt_project.uniters_orders"} */ with columns as ( select SYS_CONTEXT('userenv', 'DB_NAME') table_catalog, owner table_schema, table_name, column_name, data_type, data_type_mod, decode(data_type_owner, null, TO_CHAR(null), SYS_CONTEXT('userenv', 'DB_NAME')) domain_catalog, data_type_owner domain_schema, data_length character_maximum_length, data_length character_octet_length, data_length, data_precision numeric_precision, data_scale numeric_scale, nullable is_nullable, column_id ordinal_position, default_length, data_default column_default, num_distinct, low_value, high_value, density, num_nulls, num_buckets, last_analyzed, sample_size, SYS_CONTEXT('userenv', 'DB_NAME') character_set_catalog, 'SYS' character_set_schema, SYS_CONTEXT('userenv', 'DB_NAME') collation_catalog, 'SYS' collation_schema, character_set_name, char_col_decl_length, global_stats, user_stats, avg_col_len, char_length, char_used, v80_fmt_image, data_upgraded, histogram from sys.all_tab_columns ) select column_name as "name", data_type as "type", char_length as "character_maximum_length", numeric_precision as "numeric_precision", numeric_scale as "numeric_scale" from columns where upper(table_name) = upper('UNITERS_ORDERS') and upper(table_schema) = upper('PSOFA') order by ordinal_position 08:44:18.802242 [debug] [Thread-3 ]: oracle adapter: SQL status: OK in 0.07250761985778809 seconds 08:44:18.823601 [debug] [Thread-3 ]: oracle adapter: Using oracle connection "snapshot.dbt_project.uniters_orders". 08:44:18.823844 [debug] [Thread-3 ]: oracle adapter: On snapshot.dbt_project.uniters_orders: f/* {"app": "dbt", "dbt_version": "1.3.1", "profile_name": "dbt_oracle_psdb_prod", "target_name": "prod", "node_id": "snapshot.dbt_project.uniters_orders"} */ create global temporary table o$pt_UNITERS_ORDERS094418812937 on commit preserve rows as with snapshot_query as ( SELECT to_char(voct.ANNO_ORD) || '/' || voct.TIPO_ORD || '/' || to_char(voct.NRO_ORD) || '-' || to_char(vocr.RIGA_ORD) ID, voct.ANNO_ORD, voct.TIPO_ORD, voct.NRO_ORD, vocr.RIGA_ORD, voct.DATA_INS, voct.COD_STATO_DOC, voctf.DESCRIZIONE_1, voctf.DESCRIZIONE_2, voctf.e_Mail_1, vocr.TIPO_ART, vocr.COD_ART, vocr.QTA_ORDINATA, vocr.PREZZO, pocta.UNITERS_CODE FROM psofa.VEW_ORD_CL_TEST voct JOIN psofa.VEW_ORD_CL_TEST_FIN voctf ON (voct.anno_ord = voctf.anno_ord AND voct.tipo_ord = voctf.tipo_ord AND voct.nro_ord = voctf.nro_ord) JOIN psofa.VEW_ORD_CL_RIGA vocr ON (voct.anno_ord = vocr.anno_ord AND voct.tipo_ord = vocr.tipo_ord AND voct.nro_ord = vocr.nro_ord) JOIN psofa.PSO_ORD_CL_TEST_ALTRO pocta ON (voct.anno_ord = pocta.anno_ord AND voct.tipo_ord = pocta.tipo_ord AND voct.nro_ord = pocta.nro_ord) JOIN psofa.uniters_orders_z z ON (voct.anno_ord = z.anno_ord AND voct.tipo_ord = z.tipo_ord AND voct.nro_ord = z.nro_ord) where voct.DATA_INS >= To_date('2022-10-01', 'yyyy-mm-dd') and voct.NRO_ORD < 50000 ), snapshotted_data as ( select PSOFA.UNITERS_ORDERS.*, ID as dbt_unique_key from PSOFA.UNITERS_ORDERS where dbt_valid_to is null ), insertions_source_data as ( select snapshot_query.*, ID as dbt_unique_key, TO_TIMESTAMP('2022-12-25 08:45:21.562931','yyyy/mm/dd hh24:mi:ss.FF') as dbt_updated_at, TO_TIMESTAMP('2022-12-25 08:45:21.562931','yyyy/mm/dd hh24:mi:ss.FF') as dbt_valid_from, nullif(TO_TIMESTAMP('2022-12-25 08:45:21.562931','yyyy/mm/dd hh24:mi:ss.FF'), TO_TIMESTAMP('2022-12-25 08:45:21.562931','yyyy/mm/dd hh24:mi:ss.FF')) as dbt_valid_to, ORA_HASH(coalesce(cast(ID as varchar(50) ), '') || '|' || coalesce(cast(TO_TIMESTAMP('2022-12-25 08:45:21.562931','yyyy/mm/dd hh24:mi:ss.FF') as varchar(50) ), '') ) as dbt_scd_id from snapshot_query ), updates_source_data as ( select snapshot_query.*, ID as dbt_unique_key, TO_TIMESTAMP('2022-12-25 08:45:21.562931','yyyy/mm/dd hh24:mi:ss.FF') as dbt_updated_at, TO_TIMESTAMP('2022-12-25 08:45:21.562931','yyyy/mm/dd hh24:mi:ss.FF') as dbt_valid_from, TO_TIMESTAMP('2022-12-25 08:45:21.562931','yyyy/mm/dd hh24:mi:ss.FF') as dbt_valid_to from snapshot_query ), deletes_source_data as ( select snapshot_query.*, ID as dbt_unique_key from snapshot_query ), insertions as ( select 'insert' as dbt_change_type, source_data.* from insertions_source_data source_data left outer join snapshotted_data on snapshotted_data.dbt_unique_key = source_data.dbt_unique_key where snapshotted_data.dbt_unique_key is null or ( snapshotted_data.dbt_unique_key is not null and ( (snapshotted_data.ID != source_data.ID or ( ((snapshotted_data.ID is null) and not (source_data.ID is null)) or ((not snapshotted_data.ID is null) and (source_data.ID is null)) ) or snapshotted_data.ANNO_ORD != source_data.ANNO_ORD or ( ((snapshotted_data.ANNO_ORD is null) and not (source_data.ANNO_ORD is null)) or ((not snapshotted_data.ANNO_ORD is null) and (source_data.ANNO_ORD is null)) ) or snapshotted_data.TIPO_ORD != source_data.TIPO_ORD or ( ((snapshotted_data.TIPO_ORD is null) and not (source_data.TIPO_ORD is null)) or ((not snapshotted_data.TIPO_ORD is null) and (source_data.TIPO_ORD is null)) ) or snapshotted_data.NRO_ORD != source_data.NRO_ORD or ( ((snapshotted_data.NRO_ORD is null) and not (source_data.NRO_ORD is null)) or ((not snapshotted_data.NRO_ORD is null) and (source_data.NRO_ORD is null)) ) or snapshotted_data.RIGA_ORD != source_data.RIGA_ORD or ( ((snapshotted_data.RIGA_ORD is null) and not (source_data.RIGA_ORD is null)) or ((not snapshotted_data.RIGA_ORD is null) and (source_data.RIGA_ORD is null)) ) or snapshotted_data.DATA_INS != source_data.DATA_INS or ( ((snapshotted_data.DATA_INS is null) and not (source_data.DATA_INS is null)) or ((not snapshotted_data.DATA_INS is null) and (source_data.DATA_INS is null)) ) or snapshotted_data.COD_STATO_DOC != source_data.COD_STATO_DOC or ( ((snapshotted_data.COD_STATO_DOC is null) and not (source_data.COD_STATO_DOC is null)) or ((not snapshotted_data.COD_STATO_DOC is null) and (source_data.COD_STATO_DOC is null)) ) or snapshotted_data.DESCRIZIONE_1 != source_data.DESCRIZIONE_1 or ( ((snapshotted_data.DESCRIZIONE_1 is null) and not (source_data.DESCRIZIONE_1 is null)) or ((not snapshotted_data.DESCRIZIONE_1 is null) and (source_data.DESCRIZIONE_1 is null)) ) or snapshotted_data.DESCRIZIONE_2 != source_data.DESCRIZIONE_2 or ( ((snapshotted_data.DESCRIZIONE_2 is null) and not (source_data.DESCRIZIONE_2 is null)) or ((not snapshotted_data.DESCRIZIONE_2 is null) and (source_data.DESCRIZIONE_2 is null)) ) or snapshotted_data.E_MAIL_1 != source_data.E_MAIL_1 or ( ((snapshotted_data.E_MAIL_1 is null) and not (source_data.E_MAIL_1 is null)) or ((not snapshotted_data.E_MAIL_1 is null) and (source_data.E_MAIL_1 is null)) ) or snapshotted_data.TIPO_ART != source_data.TIPO_ART or ( ((snapshotted_data.TIPO_ART is null) and not (source_data.TIPO_ART is null)) or ((not snapshotted_data.TIPO_ART is null) and (source_data.TIPO_ART is null)) ) or snapshotted_data.COD_ART != source_data.COD_ART or ( ((snapshotted_data.COD_ART is null) and not (source_data.COD_ART is null)) or ((not snapshotted_data.COD_ART is null) and (source_data.COD_ART is null)) ) or snapshotted_data.QTA_ORDINATA != source_data.QTA_ORDINATA or ( ((snapshotted_data.QTA_ORDINATA is null) and not (source_data.QTA_ORDINATA is null)) or ((not snapshotted_data.QTA_ORDINATA is null) and (source_data.QTA_ORDINATA is null)) ) or snapshotted_data.PREZZO != source_data.PREZZO or ( ((snapshotted_data.PREZZO is null) and not (source_data.PREZZO is null)) or ((not snapshotted_data.PREZZO is null) and (source_data.PREZZO is null)) ) or snapshotted_data.UNITERS_CODE != source_data.UNITERS_CODE or ( ((snapshotted_data.UNITERS_CODE is null) and not (source_data.UNITERS_CODE is null)) or ((not snapshotted_data.UNITERS_CODE is null) and (source_data.UNITERS_CODE is null)) )) ) ) ), updates as ( select 'update' as dbt_change_type, source_data.*, snapshotted_data.dbt_scd_id from updates_source_data source_data join snapshotted_data on snapshotted_data.dbt_unique_key = source_data.dbt_unique_key where ( (snapshotted_data.ID != source_data.ID or ( ((snapshotted_data.ID is null) and not (source_data.ID is null)) or ((not snapshotted_data.ID is null) and (source_data.ID is null)) ) or snapshotted_data.ANNO_ORD != source_data.ANNO_ORD or ( ((snapshotted_data.ANNO_ORD is null) and not (source_data.ANNO_ORD is null)) or ((not snapshotted_data.ANNO_ORD is null) and (source_data.ANNO_ORD is null)) ) or snapshotted_data.TIPO_ORD != source_data.TIPO_ORD or ( ((snapshotted_data.TIPO_ORD is null) and not (source_data.TIPO_ORD is null)) or ((not snapshotted_data.TIPO_ORD is null) and (source_data.TIPO_ORD is null)) ) or snapshotted_data.NRO_ORD != source_data.NRO_ORD or ( ((snapshotted_data.NRO_ORD is null) and not (source_data.NRO_ORD is null)) or ((not snapshotted_data.NRO_ORD is null) and (source_data.NRO_ORD is null)) ) or snapshotted_data.RIGA_ORD != source_data.RIGA_ORD or ( ((snapshotted_data.RIGA_ORD is null) and not (source_data.RIGA_ORD is null)) or ((not snapshotted_data.RIGA_ORD is null) and (source_data.RIGA_ORD is null)) ) or snapshotted_data.DATA_INS != source_data.DATA_INS or ( ((snapshotted_data.DATA_INS is null) and not (source_data.DATA_INS is null)) or ((not snapshotted_data.DATA_INS is null) and (source_data.DATA_INS is null)) ) or snapshotted_data.COD_STATO_DOC != source_data.COD_STATO_DOC or ( ((snapshotted_data.COD_STATO_DOC is null) and not (source_data.COD_STATO_DOC is null)) or ((not snapshotted_data.COD_STATO_DOC is null) and (source_data.COD_STATO_DOC is null)) ) or snapshotted_data.DESCRIZIONE_1 != source_data.DESCRIZIONE_1 or ( ((snapshotted_data.DESCRIZIONE_1 is null) and not (source_data.DESCRIZIONE_1 is null)) or ((not snapshotted_data.DESCRIZIONE_1 is null) and (source_data.DESCRIZIONE_1 is null)) ) or snapshotted_data.DESCRIZIONE_2 != source_data.DESCRIZIONE_2 or ( ((snapshotted_data.DESCRIZIONE_2 is null) and not (source_data.DESCRIZIONE_2 is null)) or ((not snapshotted_data.DESCRIZIONE_2 is null) and (source_data.DESCRIZIONE_2 is null)) ) or snapshotted_data.E_MAIL_1 != source_data.E_MAIL_1 or ( ((snapshotted_data.E_MAIL_1 is null) and not (source_data.E_MAIL_1 is null)) or ((not snapshotted_data.E_MAIL_1 is null) and (source_data.E_MAIL_1 is null)) ) or snapshotted_data.TIPO_ART != source_data.TIPO_ART or ( ((snapshotted_data.TIPO_ART is null) and not (source_data.TIPO_ART is null)) or ((not snapshotted_data.TIPO_ART is null) and (source_data.TIPO_ART is null)) ) or snapshotted_data.COD_ART != source_data.COD_ART or ( ((snapshotted_data.COD_ART is null) and not (source_data.COD_ART is null)) or ((not snapshotted_data.COD_ART is null) and (source_data.COD_ART is null)) ) or snapshotted_data.QTA_ORDINATA != source_data.QTA_ORDINATA or ( ((snapshotted_data.QTA_ORDINATA is null) and not (source_data.QTA_ORDINATA is null)) or ((not snapshotted_data.QTA_ORDINATA is null) and (source_data.QTA_ORDINATA is null)) ) or snapshotted_data.PREZZO != source_data.PREZZO or ( ((snapshotted_data.PREZZO is null) and not (source_data.PREZZO is null)) or ((not snapshotted_data.PREZZO is null) and (source_data.PREZZO is null)) ) or snapshotted_data.UNITERS_CODE != source_data.UNITERS_CODE or ( ((snapshotted_data.UNITERS_CODE is null) and not (source_data.UNITERS_CODE is null)) or ((not snapshotted_data.UNITERS_CODE is null) and (source_data.UNITERS_CODE is null)) )) ) ), deletes as ( select 'delete' as dbt_change_type, source_data.*, SYS_EXTRACT_UTC(current_timestamp) as dbt_valid_from, SYS_EXTRACT_UTC(current_timestamp) as dbt_updated_at, SYS_EXTRACT_UTC(current_timestamp) as dbt_valid_to, snapshotted_data.dbt_scd_id from snapshotted_data left join deletes_source_data source_data on snapshotted_data.dbt_unique_key = source_data.dbt_unique_key where source_data.dbt_unique_key is null ) select * from insertions union all select * from updates union all select * from deletes 08:44:18.824897 [info ] [Thread-3 ]: oracle adapter: Oracle error: ORA-00972: identificativo troppo lungo 08:44:18.825048 [debug] [Thread-3 ]: On snapshot.dbt_project.uniters_orders: ROLLBACK 08:44:18.825362 [debug] [Thread-3 ]: On snapshot.dbt_project.uniters_orders: Close 08:44:18.827192 [debug] [Thread-3 ]: finished collecting timing info 08:44:18.827787 [debug] [Thread-3 ]: Database Error in snapshot uniters_orders (snapshots/uniters_orders.sql) ORA-00972: identificativo troppo lungo Traceback (most recent call last): File "/root/dbt/lib/python3.8/site-packages/dbt/adapters/oracle/connections.py", line 227, in exception_handler yield File "/root/dbt/lib/python3.8/site-packages/dbt/adapters/oracle/connections.py", line 279, in add_query cursor.execute(sql, bindings) cx_Oracle.DatabaseError: ORA-00972: identificativo troppo lungo The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/root/dbt/lib/python3.8/site-packages/dbt/task/base.py", line 385, in safe_run result = self.compile_and_execute(manifest, ctx) File "/root/dbt/lib/python3.8/site-packages/dbt/task/base.py", line 338, in compile_and_execute result = self.run(ctx.node, manifest) File "/root/dbt/lib/python3.8/site-packages/dbt/task/base.py", line 429, in run return self.execute(compiled_node, manifest) File "/root/dbt/lib/python3.8/site-packages/dbt/task/run.py", line 281, in execute result = MacroGenerator( File "/root/dbt/lib/python3.8/site-packages/dbt/clients/jinja.py", line 326, in __call__ return self.call_macro(*args, **kwargs) File "/root/dbt/lib/python3.8/site-packages/dbt/clients/jinja.py", line 253, in call_macro return macro(*args, **kwargs) File "/root/dbt/lib/python3.8/site-packages/jinja2/runtime.py", line 763, in __call__ return self._invoke(arguments, autoescape) File "/root/dbt/lib/python3.8/site-packages/jinja2/runtime.py", line 777, in _invoke rv = self._func(*arguments) File "