https://linen.dev logo
#plugins-general
Title
# plugins-general
m

michael_cooper

08/28/2020, 2:08 PM
Working with the built-in
target-snowflake
and noticed an error when not defining
SF_SCHEMA
in my
.env
file. If undefined, I get this critical error:
Copy code
target-snowflake | ERROR Exception in schema_apply() while processing:
target-snowflake | {"type": "SCHEMA", "stream": "issue_labels", "schema": {"type": ["null", "object"], "properties": {"_sdc_repository": {"type": ["null", "string"]}, "id": {"type": ["null", "number"]}, "node_id": {"type": ["null", "string"]}, "url": {"type": ["null", "string"]}, "name": {"type": ["null", "string"]}, "description": {"type": ["null", "string"]}, "color": {"type": ["null", "string"]}, "default": {"type": ["null", "boolean"]}}}, "key_properties": ["id"]}
target-snowflake | 
target-snowflake | CRITICAL (snowflake.connector.errors.ProgrammingError) 002003 (02000): SQL compilation error:
target-snowflake | CRITICAL Schema 'COOPER_DB."tap_github"' does not exist or not authorized.
target-snowflake | CRITICAL [SQL: GRANT USAGE ON SCHEMA "COOPER_DB"."tap_github" TO ROLE SYSADMIN;]
target-snowflake | CRITICAL (Background on this error at: <http://sqlalche.me/e/13/f405>)
When I look at my database, it does create a schama called
TAP_GITHUB
, but it still fails. When I define
SF_SCHEMA
as
TAP_GITHUB
the error does not occur.