Our main use case for Stitch is several integrations, such as Zuora, Salesforce, Airflow metadata, and a few more pipelines.
We use OAuth authentication to connect Stitch, then set up the pipeline using an API key or some other authentication method, and then put all the data inside Snowflake, as we use only Snowflake as a target.
We try to gather and ingest all data possible in the raw schema or raw database, then later we will process it. We try to do everything at once and load the data we need.