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:

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.