Adam Roderick
05/03/2022, 11:09 PMCharlie Shou
05/05/2022, 12:03 AMPunith B M
05/16/2022, 7:17 AMChance Barkley
06/14/2022, 6:32 PMSawyer Waugh
06/17/2022, 3:27 PMstep 3 of 4 START incremental model
2022-06-17 15:14:51 normalization > 15:14:51
2022-06-17 15:14:52 normalization > 15:14:52 1 of 4 START view model _<http://airbyte_airbyte.my|airbyte_airbyte.my>_model_ab2........................................... [RUN]
2022-06-17 15:14:55 normalization > 15:14:55 1 of 4 OK created view model _<http://airbyte_airbyte.my|airbyte_airbyte.my>_model_ab2...................................... [CREATE VIEW in 2.84s]
2022-06-17 15:14:55 normalization > 15:14:55 2 of 4 START incremental model _<http://airbyte_airbyte.my|airbyte_airbyte.my>_model_ab2.................................... [RUN]
2022-06-17 15:15:24 normalization > 15:15:24 2 of 4 OK created incremental model _<http://airbyte_airbyte.my|airbyte_airbyte.my>_model_stg............................... [INSERT 0 1769 in 29.17s]
2022-06-17 15:15:24 normalization > 15:15:24 3 of 4 START incremental model <http://airbyte.my|airbyte.my>_model_scd............................................. [RUN]
The below query is the issue.
/*{"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "node_id": "model.airbyte_utils.my_model_scd"} */
alter table "my_db"."airbyte_schema"."my_model_scd" add column "my_col1__dbt_alter" text;
update "my_db"."airbyte_schema"."my_model_scd" set "my_col1__dbt_alter" = "my_col1";
alter table "my_db"."airbyte_schema"."my_model_scd" drop column "my_col1" cascade;
alter table "my_db"."airbyte_schema"."my_model_scd" rename column "my_col1__dbt_alter" to "my_col1"
suman
07/04/2022, 10:35 AMError checking connection, status: Optional.empty, exit code: 1
getting this error while setting up gsheets as source.