Hi.. Can someone help me on this issue?.. I got re...
# replication-troubleshooting
a
Hi.. Can someone help me on this issue?.. I got really stuck on this issue for more than a week? When I run the full sync, its perfectly working working POSTGRES - SNOWFLAKE sync. But when I changed to INCREMENTAL+ DEPUDED HISTORY sync its failing with Insufficnet privileges issue in Snowflake. BUt I have all required access.
Copy code
Insufficient privileges to operate on database 'SANDBOX',externalMessage=Normalization failed during the dbt run. This may indicate a problem with the data itself.,metadata=io.airbyte.config.Metadata@475585c[additionalProperties={attemptNumber=0, jobId=69, from_trace_message=true}],stacktrace=Encountered an error:
Database Error
** 003001 (42501): SQL access control error:**
** Insufficient privileges to operate on database 'SANDBOX',retryable=,timestamp=1660936001968], io.airbyte.config.FailureReason@6769c101[failureOrigin=normalization,failureType=system_error,internalMessage=Encountered an error:**
Database Error
** 003001 (42501): SQL access control error:**
** Insufficient privileges to operate on database 'SANDBOX',externalMessage=Normalization failed during the dbt run. This may indicate a problem with the data itself.,metadata=io.airbyte.config.Metadata@5a05d4b3[additionalProperties={attemptNumber=0, jobId=69, from_trace_message=true}],stacktrace=Encountered an error:**
Database Error
** 003001 (42501): SQL access control error:**
** Insufficient privileges to operate on database 'SANDBOX',retryable=,timestamp=1660936001968]]]**