To retrieve users who subscribed to the Fitness Newsletter from email accounts, the correct query to use is:
* SELECT * FROM fullAccounts WHERE subscriptions.<Fitness>.email.isSubscribed=true This query filters the fullAccounts table to find users who are subscribed to the Fitness Newsletter. It specifically checks theisSubscribedstatus within thesubscriptionsobject for the Fitness newsletter.
References
* SAP Customer Data Cloud Query Documentation

When creating a dataflow to synchronize existing users' subscriptions from the marketing system to SAP Customer Data Cloud with the given requirements, you need to perform the following actions:
* File Decrypt and Compress Components: Add a file decrypt.pgp component to decrypt the PGP-encrypted file provided by the marketing system and a file compress.zip component to compress the failed records before sending them back to the S3 bucket.
* file.decrypt.pgp: Decrypts the incoming PGP-encrypted file.
* file.compress.zip: Compresses the records that failed to update.
* Error Handling Step: Add an error handling step after the datasource.write.gigya.account component to manage records that fail to update in the SAP Customer Data Cloud.
* Error Handling: This step ensures that any records that fail to update are processed and handled appropriately, including being zipped and sent back to the S3 bucket.
These actions ensure that the dataflow handles encryption, compression, and error management effectively.
References
* SAP Customer Data Cloud Dataflow Documentation