Hello!
I'm trying to run a pipeline that will down...
# troubleshootingm
mateusz_garbacz
09/28/2023, 1:43 PMHello!
I'm trying to run a pipeline that will download data from S3 and add it to snowflake.
tap-s3-extractor is configured and the tests pass successfully, it looks like there is an error somewhere in the target-snowflake configuration - is there anyone here who has gone through such a configuration and would be able to guide me to the correct solution?
Below is a fragment of the log with an error:
Copy code
2023-09-28T13:29:59.553077Z [error] Loader failed
2023-09-28T13:29:59.553463Z [error] Block run completed. block_type=ExtractLoadBlocks err=RunnerError('Loader failed') exit_codes={<PluginType.LOADERS: 'loaders'>: 1} set_number=0 success=Falsee
edgar_ramirez_mondragon
09/28/2023, 2:25 PMHi @mateusz_garbacz! Which variant of target-snowflake are you using?
m
mateusz_garbacz
09/29/2023, 4:11 AMHi @edgar_ramirez_mondragon! I'm using meltanolabs variant
m
maciej_gierada
09/29/2023, 7:58 AMerror.txt
maciej_gierada
09/29/2023, 8:02 AMThis is a full stack trace with debug on
export MELTANO_CLI_LOG_LEVEL=debugmaciej_gierada
09/29/2023, 8:05 AMwe are trying to access snowflake using private key, not sure if this is relevant for this error
maciej_gierada
09/29/2023, 9:24 AMOkay we solved that error but that was far from straightforward. The issue was in the config where we set
dbnamedatabasee
edgar_ramirez_mondragon
09/29/2023, 1:41 PMThanks for letting us know you solved it. I can't see a
dbname