do we need CREATE schema access for Snowflake dest...
# replication-troubleshootinga
Arun
08/08/2022, 10:43 PMdo we need CREATE schema access for Snowflake destination?.. Incremental load failing but full load completed successfully
Copy code
2022-08-08 22:34:20 normalization > 22:34:13.474910 [debug] [ThreadPool]: Using snowflake connection "create_SANDBOX__AIRBYTE_ORACLE_BASE_TABLES"
2022-08-08 22:34:20 normalization > 22:34:13.475389 [debug] [ThreadPool]: On create_SANDBOX__AIRBYTE_ORACLE_BASE_TABLES: /* {"app": "dbt", "dbt_version": "1.0.0", "profile_name": "normalize", "target_name": "prod", "connection_name": "create_SANDBOX__AIRBYTE_ORACLE_BASE_TABLES"} */
2022-08-08 22:34:20 normalization > create schema if not exists "SANDBOX"._AIRBYTE_ORACLE_BASE_TABLES
2022-08-08 22:34:20 normalization > 22:34:13.475609 [debug] [ThreadPool]: Opening a new connection, currently in state closed
2022-08-08 22:34:20 normalization > 22:34:14.739019 [debug] [ThreadPool]: Snowflake adapter: Snowflake query id: 01a628ca-0604-9a8e-0000-19c1191bfdd2
2022-08-08 22:34:20 normalization > 22:34:14.739374 [debug] [ThreadPool]: Snowflake adapter: Snowflake error: 003001 (42501): SQL access control error:
2022-08-08 22:34:20 normalization > Insufficient privileges to operate on database 'SANDBOX'a
Abba
08/09/2022, 5:00 AMDid you check the required permissions for snowflake?
a
Arun
08/09/2022, 5:04 AMyes full load working fine
Arun
08/09/2022, 5:04 AMis there any special case for incremental sync?
a
Abba
08/09/2022, 7:28 AMFrom the docs i think its the same