felipe_souto_campelo
01/10/2024, 7:14 PMRun invocation could not be completed as block failed: Cannot start plugin tap-spreadsheets-anywhere--facebook: Catalog discovery failed: command ['/home/fcampelo/Documents/Repositories/-----/------/.meltano/extractors/tap-spreadsheets-anywhere/venv/bin/tap-spreadsheets-anywhere', '--config', '/home/fcampelo/Documents/Repositories/-----/-----_aws_meltano/.meltano/run/tap-spreadsheets-anywhere--facebook/tap.299f5811-7850-4a3b-bc4e-930e71288f1a.config.json', '--state', '/home/fcampelo/Documents/Repositories/-----/-----_aws_meltano/.meltano/run/tap-spreadsheets-anywhere--facebook/state.json', '--discover'] returned 1 with stderr:
INFO Found credentials in environment variables.
INFO Found 26 files.
INFO Checking 26 resolved objects for any that match regular expression "social_media/facebook/overview_social_data/facebook_overview.*.xlsx" and were modified since 2000-01-01 00:00:00+00:00
INFO Processing 1 resolved objects that met our criteria. Enable debug verbosity logging for more details.
INFO Sampling social_media/facebook/overview_social_data/facebook_overview_2021-01-01_to_2023-11-30.xlsx (2000 records, every 10th record).
ERROR Unable to write Catalog entry for 'facebook_overview' - it will be skipped due to error [Errno 2] No such file or directory: 'social_media/facebook/overview_social_data/facebook_overview_2021-01-01_to_2023-11-30.xlsx'
CRITICAL [Errno 2] No such file or directory: 'social_media/facebook/overview_social_data/facebook_overview_2021-01-01_to_2023-11-30.xlsx'
My tap configuration:
extractors:
- name: tap-spreadsheets-anywhere--facebook
inherit_from: tap-spreadsheets-anywhere
config:
tables:
- path: s3://<my-bucket>
name: facebook_overview
pattern: social_media/facebook/overview_social_data/facebook_overview.*.xlsx
start_date: '2000-01-01T00:00:00+00'
key_properties: [Post ID]
format: excel
worksheet_name: "FB - Posts Table"
sample_rate: 10
max_sampling_read: 2000
max_sampled_files: 3
prefer_number_vs_integer: true
Andy Carter
01/10/2024, 7:30 PMfelipe_souto_campelo
01/11/2024, 1:06 PM