Skip to main content

TV Scientific

Introduction​

The TV Scientific source connector syncs reporting files delivered by TV Scientific into an Amazon S3 bucket. The connector discovers report files under a configured folder prefix, validates and parses them, and loads the resulting records into the reports stream.

Prerequisites​

  • An S3 bucket that receives TV Scientific report exports.
  • AWS credentials (access key ID and secret access key) with permission to list and read objects in that bucket/prefix.
  • The S3 bucket name and the TV Scientific folder name (used to build the S3 prefix the connector scans).

Setup​

  1. Confirm with TV Scientific (or your internal team) which S3 bucket and folder contain the exported reports.
  2. Create or obtain an IAM user (or access keys) that can read from that location.
  3. Add the connector in Extract and provide the configuration values listed below.

Authentication​

This connector authenticates to AWS using an Access Key ID and Secret Access Key.

Required S3 permissions typically include:

  • s3:ListBucket on the bucket
  • s3:GetObject on the objects under the configured prefix

Configuration​

FieldTypeRequiredDescription
access_key_idstringYesAWS access key ID used to access the S3 bucket.
secret_access_keystringYesAWS secret access key used to access the S3 bucket.
bucketstringYesName of the S3 bucket that contains TV Scientific report files.
folder_namestringYesFolder name used to build the S3 prefix scanned for reports. This should match the folder TV Scientific delivers reports into.

Sync behavior​

Streams​

  • reports: TV Scientific report records parsed from the files found in S3.

Incremental / partition behavior​

The reports stream is designed to be used with date-partition replacement semantics.

Important notes:

  • The connector requires the date field to remain selected. It is used to support partition replacement.
  • The connector does not support diff-based incremental mode for this stream.

Cursor overrides (optional)​

You can optionally bound a run to a specific date range using these parameters:

  • starting_cursor: Start date (inclusive)
  • ending_cursor: End date (inclusive)

If both are provided, starting_cursor must be less than or equal to ending_cursor.

Data model​

Reports​

The reports stream contains daily performance metrics exported by TV Scientific. Metrics commonly include:

  • impressions
  • clicks
  • installs
  • in-app purchases
  • signups
  • spend

(Exact fields may vary based on the report contents delivered to your bucket.)

Troubleshooting​

  • Login timed out after 60 seconds: Verify the bucket name, credentials, and that the bucket’s region can be resolved and reached from your network.
  • Access denied / unable to list reports: Ensure the IAM policy allows s3:ListBucket on the bucket and s3:GetObject for the prefix that contains the reports.
  • “Requires the date field to remain selected”: Re-enable/select the date field in the stream configuration; it is required for partition replacement.
  • Start date must not follow end date: Fix the starting_cursor / ending_cursor values so the start is not after the end.